Areas to be covered in Form 3 Area Secondary ( ICT Area Secondary Schools Syllabus ECDL Start)

1. ECDL Module 2 – Using the computer and managing files – Skills module

1.1. MF3

1.1.1. Basic directory and folder structure (tree) on a computer – viewing directories/folders and files, creating further directories/folders, renaming directories/folders, directory/folder attributes (name, size, date last update), deleting a directory/folder

1.1.2. File handling – selecting one or more files, moving, copying, pasting, deleting files within folders, restoring files, backup on floppy disk

1.1.3. Using Windows Help

Suggested Tasks:

(Preferably use this module in relation to other school subjects or projects to enhance/integrate ICT across the curriculum Please remember that you can also merge modules to tackle a single project.)

· Producing a diagram showing the tree structure of folders/subfolders implemented on the computer’s HDD and used by the student.

· Treasure hunt for simple paths (C:/My Documents/English) and longer paths

· Prepare a table having missing file attributes (file name, extension, type, modified, size etc) for a specific folder. Set it out as a fill-in exercise where students have to look for missing information after being given the path of the folder.

· Create a folder and subfolders on a diskette and backup particular file/s.

· Provide a particular topic (keyword) and search in Windows “Help”.

· Other practical tasks are integrated within the module specifications.

2. ECDL Module 3 – Word Processing – Skills module

2.3 WP3

2.3.1 Modify preferences in application such as user name, default directory

2.3.2 Open several documents - move, copy, paste between active documents

2.3.3 Display/hide non-printing characters

2.3.4 Inserting special characters, symbols, page breaks

2.3.5 Applying existing styles

2.3.6 Choosing and using a template for a specific task

2.3.7 Inserting tables – rows, columns, cells, cell attributes (formatting, size, colour/shading), insertion/deletion of rows/columns, borders

2.3.8 Printing – use of basic print options

Suggested Tasks:

· Open any two documents (one from HDD, other from FDD) and transfer text/graphics between them

· Apply different styles to a supplied unformatted document.

· Prepare a CV/Report/Fax/Memo/etc using a template.

· Create a simple pattern by colouring the cells of a table

· Create a table for a class timetable, edit and format the table.

· Other practical tasks are integrated within the module specifications.

3. ECDL Module 4 – Spreadsheets – Skills module

3.3 SS3

3.3.1 Selecting adjacent row/s or column/s, selecting non adjacent cells, rows or columns,

3.3.2 Open several workbooks - move, copy, paste between open workbooks.

3.3.3 Worksheets: rename, duplicate, move, delete, insert worksheets, navigate within workbook

3.3.4 Search (find only) and replace cell contents

3.3.5 Sorting – numerical or alphabetical ascending or descending

3.3.6 Further formatting – different date styles, numbers as percentages, text orientation, alignment top and bottom , text wrapping, centre over a cell range

3.3.7 Further basic functions (count) – recognise error messages with formulas

3.3.8 AutoFill (also incremental data entries) and replicate

3.3.9 Printing - fit on one page, print range of cells, automatic row printing on each sheet

Suggested Tasks:

· Create a sheet with student names and their half yearly marks in different subjects.

· Copy student names into another sheet for annual marks

· Search for a particular name/mark

· Duplicate one sheet and sort by name, subject or order of merit (total marks).

· Count number of occurrences of a particular mark

· Use incremental data entry for indexing students

· Other practical tasks are integrated within the module specifications.

4. ECDL Module 7 – Information and Communication – Skills module

4.3 INT3

4.3.1 Understand structure of web address, http, URL

4.3.2 Basic settings: to display images on page, not to load images onto page

4.3.3 Browser history, delete history

4.3.4 Favourites /Bookmarks – add a web page to favourites, opening a page from favourites, organising favourites folder.

4.3.5 Saving a webpage, downloading files & saving

4.3.6 Pasting text & images from website into documents

4.3.7 Printing a search report

4.3.8 E-mail – structure of email address, netiquette, spam, risk of viruses, digital signatures, add attachments, delete attachment, open and save an attachment, forward a message, reply using distribution list, cc, bcc

Suggested Tasks:

· Download a page without images.

· View history for the last couple of days.

· Add new websites to the favourites folder.

· Download a file into a particular folder.

· Create a personal folder in favourites and add a current affairs web site (BBC etc).

· Copy a news item (image and text) into a document.

· Send the document as an attachment to multiple recipients using the Cc and Bcc functions.

· Other practical tasks are integrated within the module specifications.

5. Graphics (Paint and Presentation)

5.3 GR3 (Presentation – as a drawing tool)

5.3.1 Open application, the application interface, exit

5.3.2 Presentation toolbars

5.3.3 Drawing objects – different types of lines, modify line width, changing line colour – adding other shapes (boxes, circles, freeform), outline type

5.3.4 Inserting and resizing images/clipart

5.3.5 Inserting a text box and formatting – line weights, line style, line colour, formatting text

5.3.6 Setting up for printing – landscape/portrait

Suggested Tasks (Use of a blank single slide as a drawing canvas):

· Create a slide with an imported clipart and label its various components using textboxes.

· Build a slide using text boxes containing different fonts, having different styles, sizes and colour.

· Produce a slide consisting of a list of the top ten famous personalities (singers, actors, bands, etc)

· Other practical tasks are integrated within the module specifications.

Print this page

Download this document