UNIT 2
Level 1 EDSQ
Unit 2 – Create and Edit
Creating and editing documents
Google Docs online tutorial including short videos covering text basics, formatting text, using headers & footers and inserting tables and text boxes.
Microsoft Word (7)
Guide to tables in Word (includes adding borders and styles. There is a useful practice document at the bottom of the page)
Microsoft Word (10)
Insert a text box; there is an option on the page to choose the software- choose Word or PowerPoint depending on document being created
How to insert a text box in PowerPoint – there is an option on the page to choose the software – choose PowerPoint
Creating and editing digital media
Enhancing an image in Microsoft Office (1)
Inserting and editing images in Word, includes video tutorial and practice activities
Enhancing an image in Microsoft Office (3)
Crop and add a border to an image in Word
Enhancing an image in Microsoft Office (5)
Change brightness, contrast or sharpness of an image
Enhancing an image in Microsoft Office (7)
Add a caption to an image in Office software
Enhancing an image in Google Docs (1)
Inserting and editing images in Google Docs- includes practice activities
Enhancing an image in Google Docs (2)
Insert and edit images in documents and presentations
Enhancing an image in Google Docs (3)
Crop and adjust images including filters, colour, add a border
Enhancing an image on Apple devices (4)
Add images and descriptions in Pages on Mac
Enhancing an image on Apple devices (5)
Edit an image in Pages on Mac, includes crop, colour and saturation
General guide to image editing (3)
For tutors- How to teach EDS creating and editing
General guide to image editing (4)
Editing a photo using the Windows photo app
Processing numerical data
Learn My Way: Creating Spreadsheets is an interactive and user-friendly online course that teaches you how to use a spreadsheet to process numerical data. The course shows you how to enter text and numbers and record information to make a home budget.
Excel
Creating Spreadsheets is an interactive and user-friendly online course that teaches you how to use a spreadsheet to process numerical data. The course shows you how to enter text and numbers and record information to make a home budget.
The Beginner’s Guide to Excel video provides an overview of how to create a spreadsheet and enter data. It also includes tips on how to make spreadsheets look good and easy to read.
Please note that this video is approx. 20 minutes long.
Easy Excel Basics for Beginners features a number of short videos that shows you how to use Excel to create and navigate a spreadsheet and include formulae.
Getting started with Google Sheets is the official guide which covers the main features and functions and uses screenshots to show you how each of them work.
Spreadsheet for beginners to introduce learners to the concept of spreadsheets in paper-based form.
Opening a spreadsheet and entering data
Changing column widths
Formatting Data
Number Formats
Inserting rows and columns
Modifying Cells
Formulae
There is a useful interactive activity for learners to practise entering formulae into a spreadsheet.
Please note this resource uses $ instead of £.
Using Functions
Functions are predefined formulae that can be used to quickly perform calculations on data, such as totalling and averaging.