1.3 BC3
1.1.1. Types of computers mainframe, mini, network computer, desktop, laptop, PDA differentiate in terms of capacity, speed, cost, users.
1.1.2. CPU function of (calculations, logic control, IAS), speed (MHz, GHz)
1.1.3. Computer performance factors such as CPU speed, Ram size, HDD speed and capacity
1.1.4. Computers in business such as airline bookings, online banking & others
1.1.5. Computers and government such as census, vehicle registration & others
1.1.6. Computers in health such as patient records, diagnostic equipment & others
1.1.7. Computers in education timetabling, student registrations, homework, computer based training CBT inc. advantages & disadvantages & others
1.1.8. Situations where computer system is more appropriate than person and where not.
1.1.9. Teleworking advantages & disadvantages
Suggested Tasks:
Search for different types of computers and their uses
Production of chart /diagram of CPU and its functions
Project on use of computers in the at places of work
Production of chart/project book showing different input and output
devices
2.3 MF3
2.1.1. Using Find searching for a file or folder. Search for a file by name, date created or type. Use wildcards.
2.1.2. Computers basic system information viewing the OS, processor type, Ram available
2.1.3. File attributes viewing (name, size, file type, date last modified, read only), recognise WP, SS, DB, PPT, RTF, PDF, image files, audio files, compressed files, temporary files. Renaming files. Sorting files
2.1.4. Use of print screen
2.1.5. File compression and extraction
2.1.6. Printing install new printer, changing default printer, view and control a print job
Suggested Tasks:
Create an advert using the word processor to list the hardware and
software specifications of a computer.
Collect and compare computer system advertising brochures.
3.
Module 3 Word Processing Skills module
3.1.1. Open several documents - move, copy, paste between active documents
3.1.2. Display/hide non-printing characters
3.1.3. Inserting special characters, symbols, page breaks
3.1.4. Applying existing styles
3.1.5. Choosing and using a template for a specific task
3.1.6. Inserting tables rows, columns, cells, cell attributes (formatting, size, colour/shading), insertion/deletion of rows/columns, borders
3.1.7. Mail merging creating a mailing list in a spreadsheet and merging the mailing list with a letter document or label
3.1.8. Save document under another file format TXT, RTF, template, software version number.
3.1.9. Printing use of basic print options
Suggested Tasks:
Use one of existing word processor templates
Create a simple design by colouring
different cells in a table
Use a table to produce a class timetable
Use mail merge to produce personalised invitations by merging a form letter in word with source data in a spreadsheet
Other practical tasks are integrated within the module specifications
4.3 SS3
4.1.1. Further formatting different date styles, numbers as percentages, text orientation, alignment top and bottom , text wrapping, centre over a cell range
4.1.2. AutoFill (also incremental data entries) and replicate
4.1.3. Use of relative, mixed and absolute cell references
4.1.4. The IF function
4.1.5. Charts (graphs) produce charts to analyse data, types of, modify, labelling, scaling, modify colours, move, delete
4.1.6. Save workbook under another file format TXT, template, software version number and for posting to a web site
Suggested Tasks:
Calculate VAT on a set rate in an invoice (use absolute referencing)
Produce charts (graphs) on previous exercises set in SS2
Include an image as a logo (e.g. in Invoice)
Other practical tasks are integrated within the module specifications
6.
Module 6
Graphics (Paint and Presentation) Skills module
6.2 GR2 (Presentation)
6.2.1 Open application, the application interface, exit
6.2.2 Open an existing presentation, demonstration, simple modifications, saving to hard disk and floppy disk, slide magnification, close the presentation
6.2.3 Show/Hide Toolbars
6.2.4 Display modes slide, outline, sorter, notes, slide show and their uses
6.2.5 Create new presentation using templates/designs, slide layouts (choosing and modifying), adding text, adding and resizing images/clipart
6.2.6 Use of cut, copy, paste for deleting/moving text, images
6.2.7 Formatting text in text boxes font type, font size, italics, bold, underlining, changing case, shadow, colour, alignment, line spacing, bullets, numbering, moving and resizing text boxes, spell checking
6.2.8 Text boxes line weights, line style, line colour
6.2.9 Setting up for printing landscape/portrait, printing a selected slide/s
Suggested Tasks:
Select a template to produce one slide on a specific subject such as
My hobby
Create a slide with an imported clipart, ungroup and label its
various components using textboxes
Build a slide using text boxes containing different fonts, having
different styles, sizes and colour. Give a shadow to
the title and fill the text box with colour.
Produce a slide consisting of a list of the top ten famous
personalities such as singers, actors, sports men/women, etc.
Make up a slide of four text boxes using different line weights,
line style and colour
Other practical tasks are
integrated within the module specifications
7.
Module 7
Information and Communication Skills module
7.3 INT3
7.3.1 Understand structure of web address, http, URL
7.3.2 Cookies, cache, secure websites, digital certificates, encryption & uses, firewalls
7.3.3 Using common logical operators in searches
7.3.4 Fill in web based forms
7.3.5 Saving a webpage, downloading files & saving
7.3.6 Pasting text & images from website into documents
7.3.7 Printing a search report
7.3.8 E-mail spam, risk of viruses, digital signatures, add attachments, delete attachment, open and save an attachment, sending low/high priority messages, inserting text from another source, forward a message, reply using distribution list, cc, bcc
7.3.9 Organising messages search for a message, create new mail folder, delete, moving messages to a new mail folder, sort messages by name, subject, date, printing
Suggested Tasks:
Create mailbox (mail folder) in SchoolNet
mail
Copy and move messages to different mailboxes (mail folders)
Send a file as an attachment
Send e-mail to multiple recipients using Cc and Bcc functions
Use of e-mail as a collaborative tool for inter-school projects
Other practical tasks are integrated within the module specifications