THE MINISTRY OF EDUCATION AND TRAINING

0417 IGCSE INFORMATION AND COMMUNICATION TECHNOLOGY

SCHEMES AND RECORDS

FOR EXAMINATIONS FROM 2026 – 2028 EXAMINATIONS

YEAR: ______ TO ________

NAME OF TEACHER: _________________________________________________

NAME OF SCHOOL: _______________________________________________________________

Contents
RECORD OF TEACHER.................................................................................................................................................3
INSTRUCTIONS............................................................................................................................................................3
PERSONAL TIME TABLE...............................................................................................................................................4
MEMORANDUM.........................................................................................................................................................5
Aims............................................................................................................................................................................ 6
Assessment overview.................................................................................................................................................6
FORM 4 - TERM 1........................................................................................................................................................7
FORM 4 – TERM 2.....................................................................................................................................................14
FORM 4 – TERM 3.....................................................................................................................................................19
FORM 5 – TERM 1.....................................................................................................................................................24
FORM 5 – TERM 2.....................................................................................................................................................29
TEST AND EXAMINATIONS MARKS...........................................................................................................................34

RECORD OF TEACHER
NAME QUALIFICATIONS PERIOD OF TEACHING
STUDY EXPERIENCE

INSTRUCTIONS
1. The purpose
The main purpose of this scheme and record document is to ensure continuity in teaching
whether or not there are staff changes.

2. Usage
 This document should be printed and be available at the school at all times.
 Enter target dates for all topics and dates when tests and examinations will be
administered.

3. Time table
 The teacher time timetable must be entered in the space provided. This may be written in
pencil in case of changes.

4. Memorandum
 This page may be used by the teacher to explain any deviation from the scheme, reasons
for uncompleted work, any particular difficulties, etc.
 The space may also be used by the Headteacher or by visiting officials.

5. Tests and Examination results

 These must be entered each term on the pages at the back of the document.

6. Supervision by the Head teacher

 Headteachers should examine scheme books as frequently as possible during the year.
When they do so they should sign on the memorandum page.
FRIDAY THURSDAY WEDNESDAY TUESDAY MONDAY

TIME
PERSONAL TIME TABLE
MEMORANDUM
Aims
The aims describe the purposes of a course based on this syllabus. The aims are to enable students to
develop:
 an understanding of the basic components, use and application of different ICT systems and
networks
 the skills to analyse, design, implement, test and evaluate ICT systems
 the skills to understand the impact of current and new technologies on methods of working in
the outside world
 the ability to recognise potential risks when using ICT, and use safe, secure and responsible
practices.

Assessment overview
All candidates take three papers. Candidates will be eligible for grades A* to G.

Paper 1 Paper 2 Paper 3

1 hour 30 minutes 2 hours 15 minutes 2 hours 15 minutes
Theory Document Production, Spreadsheets and Website Authoring
40% Databases and Presentations 30%
30%
80 marks 70 marks 70 marks
This test assesses the practical This test assesses the practical skills
skills needed to use the needed to use the applications covered
applications covered in in sections 20 and 21 of the subject
Questions will be based on sections 17, 18 and 19 of the
content Candidates must demonstrate
sections 1–21 of the subject subject content Candidates
the practical skills relevant to sections
content must demonstrate the 11–16 All tasks are compulsory.
All questions are compulsory practical skills relevant to
sections 11–16 All tasks are Externally assessed
Externally assessed
compulsory
Externally assessed
 FORM 4 - TERM 1
Time Chapter Reference Course content Actual
completion
Expected
date
completion date
4 hours Chapter 1 Types and components of computer systems
1 hour 1.1 Hardware and Hardware:
Software
 Define hardware consists of the physical components of a computer system
 Identify internal components including Central Processing Unit (CPU), Processor,
motherboard
 Internal memory including random access memory (RAM), read-only memory (ROM)
 Identify hardware components including graphics card, sound card, Network Interface
Card (NIC), camera, internal/external storage devices, input and output devices
Software
 Define software as programs for controlling the operation of a computer or processing
of electronic data
 Identify two types of software – Application software and system software
 Define Applications software.
Examples of applications software including word processing, spreadsheet, database
management systems, control, measurement, applets and apps, video editing,
graphics editing, audio editing, computer aided design (CAD)
 Define System software.
Examples of system software including compilers, linkers, device drivers, operating
systems and utilities
Analogue and digital data
 Characteristics of analogue and digital data
 Differences between analogue and digital data
½ hour 1.2 The main Central Processing Unit (CPU)
components of
 Describe the role of the CPU including its role Internal memory
computer systems
 Characteristics of ROM and RAM
 Differences between ROM and RAM
Input and output devices
 Characteristics of input and output devices
 Differences between input and output devices
Backing storage
 Characteristics of backing storage
 Differences between backing storage and internal memory
½ hour 1.3 Operating systems Characteristics of operating systems including: Command Line Interface (CLI), Graphical
User Interface (GUI), dialogue based and gesture-based interface
Differences between types of operating systems
Advantages and disadvantages of the different types of operating systems
1 hour 1.4 Types of Desktop computer
computers
 Characteristics of a desktop computer
 Uses of a desktop computer including office and business management, education,
gaming and entertainment
Mobile computers
 Characteristics of mobile computers including laptop computers, smartphones, tablet
and phablet computers
 Uses of mobile computers including office and business management, education,
gaming, entertainment and remotely controlled devices
 Advantages and disadvantages of the different types of computers including portability
and expandability
1.5 Emerging Impact on everyday life including Artificial Intelligence (AI), extended reality (virtual and
1 hour
technologies augmented)
Time Chapter Course content Actual
Reference completion
Expected
date
completion date
3 hours Chapter 2 Input and output devices
2.1 Input devices Characteristics, uses, advantages and disadvantages of input devices including: keyboard,
1 hour and their uses numeric keypad, pointing devices, remote control, joystick/driving
wheel, touch screen (as an input device), scanners, camera, microphone, sensors, light pen
2.2 Direct data Characteristics, uses, advantages and disadvantages of direct data entry devices including:
entry and magnetic stripe reader, chip and PIN reader, Radio Frequency Identification (RFID) reader,
1 hour
associated Optical Mark Recognition/Reader (OMR), Optical Character Recognition/Reader (OCR), bar code
devices reader, QR scanner
2.3 Output Characteristics, uses, advantages and disadvantages of output devices including: monitors,
devices and their touch screen
1 hour
uses (as an output device), multimedia projector, laser printer, inkjet printer, dot matrix printer,
plotter, 3D printers, speaker, actuator

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
3 hours Chapter 3 Storage devices and media
3.1 Storage Characteristics, uses, media, advantages and disadvantages of storage devices including
devices magnetic, optical and solid-state
 Magnetic drives including fixed and portable magnetic hard drives, magnetic tape drives
2 hours
 Optical drives including CD, DVD, Blu-ray
 Fixed and portable solid-state drive (SSD) including
SSD, pen drive, flash drive
1 hour 3.2 Storage Characteristics, uses, advantages and disadvantages of storage media including magnetic,
media optical and solid-state
 Magnetic drives including magnetic hard disks, magnetic tape
  Optical discs including CD, DVD, Blu-ray
 Solid-state media including memory cards (SD, xD, CFast)

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
1 hour Chapter 11 File management
11.1 Manage files Locate stored files
effectively
Open and import files of different types
Save files in a planned hierarchical directory/folder structure
Save files using appropriate file names
Save and print files in a variety of formats including a document, screenshots, database reports,
½ hour data tables, graphs/charts, a web page in browser view, a web page in HTML view Save and
export in the file format of an application package
including .docx, .doc, .xlsx, .xls, .sdb, .sdc, .accdb .odb, .rtf, .pptx, .ppt
Save and export in a generic file format including .csv, .txt, .rtf, .pdf, .css, .htm, .jpg, .png
Know and understand the characteristics and uses of file formats including css, csv, gif, htm, jpg,
pdf, png, rtf, txt, zip, rar
Know and understand the need for generic file formats
11.2 Reduce file Reduce file sizes for storage or transmission where necessary using file compression
½ hour sizes for storage including .zip, .rar
or transmission

Time Chapter Course content Actual

Reference completion
Expected date
completion date
3 hours Chapter 14 Styles
Styles Create, edit and apply styles
 Create, modify, update and apply styles to ensure consistency of presentation
 Font including font face, type (serif, sans-serif), point size, colour
 Text alignment including left, right, centre, fully justified
3 hours
 Text enhancement including bold, underline, italic
 Spacing including paragraph (before and after) and line Bullets including shape,
alignment, line spacing and indent
Know and understand the purpose and uses of a corporate house style

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
4 hours Chapter 13 Layout
13.1 Create or Create a new document, or edit an existing document
edit a document
 Enter and modify text and numbers with total accuracy
 Use editing techniques to manipulate text and numbers including highlight, delete, move,
1½ hours cut, copy, paste, drag and drop
 Place objects into the document from a variety of sources including text, image, screenshot,
shapes, table, graph or chart, spreadsheet extract, database extract
 Wrap text around a table, chart or image including above, below, square and tight
1½ hours 13.2 Tables Work with tables within documents
 Create a table with a specified number of rows and columns
 Place text or objects in a table
  Edit a table and its contents including insert row(s) and column(s), delete row(s) and
column(s), merge cells
 Format a table including to set horizontal cell alignment (left, right, centre, fully
justified), set vertical cell alignment (top, middle, bottom), show gridlines, hide gridlines,
wrap text within a cell, shading/colouring cells, adjust row height, adjust column width
13.3 Headers Use headers and footers appropriately within a range of software packages
and footers
 Create or edit headers and footers
 Align the contents of the header and footer consistently within a document including to
1 hour left margin, right margin and centred within margins
 Place text and automated objects in headers and footers including file information,
page numbering, total number of pages, date, time
Explain the purpose of headers and footers

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
6 hours Chapter 17 Document production
6 hours 17.1 Document Organise page layout
production
 Edit page layout including page size, page orientation, page margins, number of
columns, column width, spacing between columns, set and remove breaks (page,
section and column breaks)
Format text
 Set line spacing including: single, 1.5 times, double, multiple, spacing before and after
paragraphs
 Set tabulation including: left, right, centred and decimal tabs, indented paragraphs and
hanging paragraphs
 Text enhancement including bold, underline, italic, superscript and subscript, changes in
case Create or edit lists including bulleted, numbered
Find and replace text including matching case, whole words
Use document navigation including adding and deleting bookmarks/hyperlinks
Know and understand why it is necessary to use setting page, section and column breaks to
adjust pagination and to avoid windows and orphans
Know and understand the purpose of setting gutter margins
 FORM 4 – TERM 2
Time Chapter Course content Actual
Reference completion
Expected
date
completion date
2 hours Chapter 5 The effects of using IT
Microprocessor- The positive and negative effects of microprocessors/ smart devices in monitoring and
controlled controlling devices in the home including the impact on lifestyle, leisure time, physical fitness,
1 hours devices security of data, the degree of social interaction
The positive and negative effects of microprocessors/smart devices in monitoring and
controlling transport including security of data, autonomous vehicles, transport safety
Potential health The causes of health issues and strategies for preventing them-Including: repetitive strain injury
problems related (RSI), back problems, eye problems, headaches
1 hours to the prolonged
use of IT
equipment

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
8 hours Chapter 4 Networks and the effects of using them
4 hours 4.1 Networks The operation and purpose of a router including:
• connecting networks and devices to the internet
• storing computer addresses in a router
• routing data packets
Common network devices including: network interface cards (NIC), hubs, bridges, switches
Similarities and differences between Bluetooth and wi-fi
Cloud computing
 The characteristics, uses and issues relating to cloud computing
  How data is stored, managed and shared using cloud computing
Common network environments
 Characteristics, uses and purpose of an extranet, intranet and the internet
 The differences and similarities between an extranet, intranet and the internet
Network types
 Local Area Network (LAN), Wireless Local Area Network (WLAN), Wide Area Network (WAN)
and the differences between these networks
4.2 Network Security issues regarding data transfer
issues and
 Privacy and confidentiality of data transfer
communication
Passwords
 Avoiding password interception by using up to date anti-spyware and regularly changing
passwords
 The differences between strong and weak passwords
Other authentication methods including: zero login, biometric methods, magnetic stripes, smart
cards, physical tokens, electronic tokens
Anti-malware software
4 hours
 Including the use of anti-malware and anti-virus
software
 operation of removing/quarantining viruses using up to date software
 Methods of avoiding viruses -scanning the storage media used to transfer data and scanning
the data/software when downloading
Electronic conferencing
 Characteristics, uses, advantages and disadvantages of video-conferencing, audio-
conferencing, web-conferencing
 The hardware, software and network connection required to set up each type of electronic
conference

Time Chapter Course content Actual

Expected Reference completion
completion date date
3 hours Chapter 12 Images
Images Place and edit an image
 Place an image with precision
 Resize an image as specified to maintain or adjust the aspect ratio of an image
 Crop an image
 Rotate an image
3 hours  Reflect (flip) an image horizontally or vertically
 Adjust the brightness of an image
 Adjust the contrast of an image
 Group and layer images including grouping and ungrouping, moving to the front or back
Recognise that reducing the file size can be achieved by reducing the image resolution or colour
depth

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
3 hours Chapter 15 Proofing
15.1 Software Use automated software tools (spell check, grammar check) and make appropriate changes to
tools ensure all work produced contains as few errors as possible
Use validation routines to minimise data entry errors
2 hours Know and understand why automated suggestions given by spell check software do not always
give the correct response
Know and understand the importance, characteristics and uses of appropriate validation
including range check, character check, length check, type check, format check, presence check
 15.2 Proofing Perform visual verification to Identify and correct data entry errors including transposed
techniques numbers, incorrect spelling, inconsistent character spacing, inconsistent case
Proofread documents to Identify and correct inconsistent line spacing, remove blank
pages/slides, remove widows/orphans, inconsistent or incorrect application of styles, ensure
that tables and lists are not split over columns or pages/slides
1 hour
Know and understand the importance, characteristics and uses of verification including visual
checking and double data entry to reduce data entry errors
Know and understand the need for validation as well as verification

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
4 hours Chapter 13 Presentations
4 hours Presentations Create a new presentation using a text file
Use a master slide
 Insert and edit objects consistently including images, text, shapes, logos, slide headers
and footers, placeholder position, automated slide numbering
 Format master slide objects including headings, subheadings, bullets, background colour
Edit a presentation
 Apply slide layout
 Insert a new slide
 Move or delete a slide
 Insert and edit objects on a slide including text (headings, subheadings, bulleted lists),
images (still images, video clips, animated images), charts, tables, audio clips (sound),
symbols, lines, arrows, call out boxes and shapes
 Add presenter notes
 Insert and edit a hyperlink including linking text or objects to a slide within the
 presentation, an external file or an email address
 Insert an action button including modifying settings to navigate to a specified slide or file
 Add alternative text/screentip to an object
 Apply consistent transitions between slides
 Apply consistent animation effects on text, images and other objects
 Hide slides within a presentation
 FORM 4 – TERM 3
Time Chapter Course content Actual
Reference completion
Expected
date
completion date
5 hours Chapter 8 Safety and security
8.1 Physical  Physical safety issues Including: electrocution from spilling drinks near electrical equipment
safety and touching live cables, fire from sockets being overloaded or equipment overheating,
1 hours tripping over trailing cables, heavy equipment falling and injuring people
 The causes of these safety issues and strategies for preventing them
1 hours 8.2 eSafety Data protection
 The principles of a typical data protection act and why data protection legislation is required
Personal data
 Characteristics of personal and sensitive data including personal name, address, date of
birth, a
photograph in school uniform, medical history
 The need for personal data to be kept confidential and protected to avoid inappropriate
disclosure
eSafety
 The need for eSafety when using the internet, email,
social media, online gaming
 Minimise the potential danger of using:
o The internet including only using trusted websites recommended by teachers, using a
search engine that only allows access to age-appropriate websites
o Email including an awareness of the potential dangers of opening or replying to an email
from an unknown person. An awareness of the risks associated with sending personal
identifiable data or images via email
o Social media including knowing how to block and report unwanted users, an awareness
of the potential dangers of meeting an online contact face to face, avoiding the
distribution of inappropriate images, avoiding the use of inappropriate language,
 respecting confidentiality of personal data of other
people
o Online gaming including not using real names, not giving out personal or financial data
8.3 Security of Threats to data
data
 Characteristics and effect of threats to data including hacking, phishing, pharming, smishing,
vishing, viruses, malware, card fraud
 Hacking including the measures that must be taken in order to protect data
Phishing, pharming, smishing, vishing including the methods that can be used to help
prevent them
 Viruses and malware including how to take preventative action to avoid the danger of
infecting a computer from a downloaded file
 Card fraud including shoulder surfing, card cloning, key logging
Protection of data
3 hours  Characteristics and methods of protecting data including biometrics, digital certificate,
secure socket layer (SSL), encryption, firewall, two-factor
authentication, user id and password
 Biometrics including the use of biometric data
 Digital certificate including its purpose and contents Secure socket layer (SSL) including
encrypted links between the server and the client computer
 Encryption including its purpose for the protection of data on hard discs, email, cloud, HTTPS
websites Firewall including its purpose
 Two-factor authentication including its purpose and function
 User id and password including how they are used to
increase the security of data

Time Chapter Course content Actual

Reference completion
Expected date
completion date
2 hours Chapter 10 Communication
10.1 Characteristics, uses and constraints of email communication including acceptable language,
Communication guidelines set by an employer, the need for security,
½ hours with other ICT netiquette, email groups, carbon copy (cc), blind carbon copy (bcc), forward, attachments
users using email
Characteristics and effects of spam email including the methods which can be used to help
prevent spam
10.2 Effective Characteristics, uses, advantages and disadvantages of using the internet including the
use of the differences between the internet, an intranet, an extranet and the World Wide Web (WWW),
internet blog, forum, wiki, social networking
Functionality including Internet Service Provider (ISP), structure of a web address, Uniform
Resource Locator (URL), hyperlink, web browser
Use of search engine including speed of searching, amount of information, the speed of finding
1 ½ hours relevant information, ease of finding reliable information
Evaluating the information found on the internet including how up to date, reliable, biased and
valid this information is
Internet protocols including HyperText Transfer Protocol (HTTP), HyperText Transfer Protocol
secure variant (HTTPS), File Transfer Protocol (FTP), Secure Socket Layer (SSL)
Risks of using the internet including inappropriate and criminal material, restricting data through
parental, educational and ISP control

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
15 hours Chapter 15 Databases
7 hours Create a Create an appropriate database structure
database
 Import data from existing files (including .csv, .txt) using specified field names to create
structure
tables
 Set appropriate data types to fields including text, numeric (integer, decimal, currency),
 date/time, Boolean/logical
 Set sub-types of numeric data including percentage, number of decimal places
 Set display format of Boolean/logical field (yes/no, true/false, checkbox)
 Set display format of date/time data
 Create and edit primary and foreign keys
 Create relationships between tables
Create a data entry form including specified fields, appropriate font styles and sizes, appropriate
spacing between fields, character spacing of individual fields, use of white space, radio buttons,
check boxes, drop down menus
Know and understand characteristics, uses, advantages and disadvantages of a flat file and a
relational database
Know and understand characteristics of primary key and foreign keys
Know and understand characteristics of good form design
Manipulate data Perform calculations
 Use arithmetic operations or numeric functions to perform calculations including
calculated fields, calculated controls
 Use formulae and functions to perform calculations at run time including addition,
subtraction, multiplication, division, sum, average, maximum, minimum, count
4 hours Use a single criterion, or multiple criteria to sort data into ascending or descending order
Search and select data
 Use a single criterion, or multiple criteria to select subsets of data using a query
 perform searches using a variety of operators including AND, OR, NOT, LIKE, >, =, <=, <>
 perform searches using wildcards
4 hours 18.3 Present Produce reports to display data including displaying all the required data and labels in full
data
Use appropriate headers and footers within a database report including report header, report
footer, page header, page footer
Set report titles
Produce different output layouts including controlling the display of data, labels, tabular or
columnar format
Align data and labels appropriately including right aligning numeric data and decimal alignment
Control the display format of numeric data including number of decimal places, currency
symbol, percentage
 FORM 5 – TERM 1
Time Chapter Course content Actual
Reference completion
Expected
date
completion date
8 hours Chapter 7 The systems life cycle
7.1 Analysis Analysis of the current system
 Characteristics, uses, advantages and disadvantages of the research methods of
observation, interviews, questionnaires and examination of existing documents
Record and analyse information about the current system
1 hours
 The need to identify the inputs, outputs and processing of the current system, problems
with the current system, the user and information requirements for the new system
System specification
 Identify and justify suitable hardware and software for the new system
7.2 Design Design file/data structures, input formats, output formats and validation routines
File/data structures including field length, field name, data type, coding of data for example M
for male, F for female
2 hours Validation routines including range check, character check, length check, type check, format
check, presence check, check digit
Input formats including data capture forms
Output formats including screen layouts and report layouts
2 hours 7.3 Development The need to test the system before implementation
and testing
Test designs, test strategies, test plan (test data, expected outcomes, actual outcomes,
remedial action) following testing
Test designs including the testing of data structures, file structures, input formats, output
formats and validation routines
Test strategies including to test each module, each function and the whole system
The definition, characteristics and use of test data using normal, abnormal and extreme data
 The use of live data
7.4 Characteristics, uses, advantages and disadvantages of the four methods of implementation,
1 hours
Implementation direct changeover, parallel running, pilot running, phased implementation
7.5 Characteristics, uses and purpose of technical and
Documentation user documentation
Components of technical documentation including: purpose of the system/program,
limitations of the system, program listing, program language, program flowcharts/algorithms,
system flowcharts, hardware and software requirements, file structures, list of variables, input
format, output format, sample
1 hours
runs/test runs, validation routines
Components of user documentation including: purpose of the system, limitations of the
system, hardware and software requirements, how to load/ run/install software, how to save
a file, how to print data, how to add records, how to delete/edit records, input format, output
format, sample runs, error messages, error handling, troubleshooting guide/ helpline,
frequently asked questions, glossary of terms
7.6 Evaluation Evaluate a solution including the efficiency of the solution, the ease of use of the solution, and
the appropriateness of the solution
1 hours Compare the solution with the original task requirements, identify any limitations and
necessary improvements to the system, evaluate the users’ responses to the results of testing
the system

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
2 hours Chapter 9 Audience
9.1 Audience Show a clear sense of audience and purpose
appreciation
1 hours Planning ICT solutions that are responsive to and respectful of the needs of an audience
Analyse the needs of an audience when creating ICT solutions
1 hours 9.2 Copyright The need for copyright legislation and the principles of copyright relating to computer software
 (e.g. software piracy)
The methods that software producers employ to prevent software copyright legislation being
broken

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
19 hours Chapter 21 Website authoring
Web Know and understand the three web development layers:
development
 Content layer is used to enter the content and create the structure of a web page
½ hour layers
 Presentation layer is used to display and format elements within a web page
 Behaviour layer is for a scripting language to control elements within a web page
12 hours 21.2 Create a Create the content layer of a web page
web page
Place appropriate elements in the head section of a web page including:
 insert a page title to display in the browser
 attach external stylesheets (with the correct hierarchy, using a relative file path)
 metatags to use the appropriate attributes including to define the charset, name
attributes (description, keywords, author, viewport), content attributes
 default target windows
Place appropriate content in the body section of a web page
Insert a table including table header, table rows, table data
Use appropriate table attributes to meet the needs of the audience including to adjust cells to
span more than one row or column, to set table and cell sizes in terms of pixels or % values, to
apply styles to tables
Insert appropriate objects into a web page including text, images, sound clips, video (display
controls, remove controls, autoplay), to adjust image or video size, aspect ratio and apply
alternate text
Use the <div> tag including to apply styles and classes
 Apply tags to text within a web page to display predefined styles including h1, h2, h3, p, li
Apply classes to elements within a web page
Apply styles to elements within a web page including to a list (ordered list, unordered list)
Create a bookmark within a web page using an id attribute
Create hyperlinks from text and images to:
o bookmarks on the same page
o other locally stored web pages
o a website using the URL
o send mail to a specified email address
o to open in a specified location (the same window, a new window, with a window
named as specified)
Know and understand the purpose of the head and body sections of a web page
Know and understand the reason tables are used to structure elements within a web page
Know and understand function of metatags including to define: the charset, keywords for search
engines, the author of the web page, a description of the web page, the viewport (to make your
web page display on all devices)
Know and understand function of a hyperlink
Know and understand concept of a bookmark including methods of creating a bookmark within
a web page
Know and understand function of an anchor
Know and understand relative file path and absolute file path including the reason absolute file
paths must not be used for hyperlinks to locally saved web pages/objects

6½ hours Use stylesheets Create the presentation layer of a web page using CSS
Create generic external styles and inline style attributes including:
o background properties including colour, images
o font properties
 o table, table row, table header and table data properties including size, background
colour, horizontal and vertical alignment, spacing, padding, borders: including
collapsed, colour, thickness, visible/invisible
Create classes including:
o background properties including colour, images
o font properties
o table, table row and table data properties including size, background colour,
horizontal and vertical alignment, spacing, padding, borders: including collapsed,
colour, thickness, visible/ invisible
Create external styles to be tagged in a web page including h1, h2, h3, p, li
Specify the font properties including font family, size, colour, alignment, bold, italic
Attach comments to an external stylesheet
Save styles in cascading stylesheet format
Know and understand the characteristics of cascading stylesheets including the difference
between attached stylesheets and inline style attributes, the hierarchy of multiple attached
stylesheets and inline styles within a web page
Know and understand characteristics of a style and a class including the difference between
them
Know and understand the reason relative file paths must be used for attached stylesheet
 FORM 5 – TERM 2
Time Chapter Course content Actual
Reference completion
Expected
date
completion date
14 hours Chapter 6 ICT applications
6.1 ICT Communication media
applications
 Characteristics and uses including newsletters,posters, websites, multimedia presentations,
audio, video, media streaming and ePublications
2 hours
Mobile communication
 The use of mobile devices for communication including: SMS messaging, phone calls, Voice
over Internet Protocol (VoIP), video calls, accessing the internet
6.2 Modelling Computer modelling Including: personal finance, bridge and building
1 hours applications design, flood water management, traffic management, weather forecasting
Advantages and disadvantages of using computer modelling rather than humans
6.3 Computer Computer controlled systems Including: robotics in manufacture, production line control,
1 hours controlled autonomous vehicles
systems
Advantages and disadvantages of using computer-controlled systems rather than humans
6.4 School Systems are used to manage learner registration and attendance
1 hours management
Systems are used to record learner performance including computer aided learning
systems
6.5 Booking Characteristics, uses, advantages and disadvantages of online booking systems including travel
1 hours
systems industry, concerts, cinemas, sporting events
6.6 Banking Characteristics, uses, advantages and disadvantages of Automatic Teller Machines (ATM)
applications including: withdrawing cash, depositing cash or cheques, checking account balance, mini
2 hours statements, bill paying, money transfers
Characteristics, uses, advantages and disadvantages of Electronic Funds Transfer (EFT),
credit/debit card transactions, cheques, internet banking
2 hours 6.7 Computers in Information systems in medicine
medicine
 Characteristics and uses of patient records, pharmacy
 records
3D printers
 Including printing of prosthetics, tissue engineering,
artificial blood vessels, customised medicines
6.8 Expert Characteristics, uses and purpose of expert systems including mineral prospecting, car engine
systems fault diagnosis, medical diagnosis, chess games, financial planning, route scheduling for delivery
vehicles, plant and animal identification
1 hours
Components of an expert system: user interface, inference engine, knowledge base, rules base,
explanation system
How an expert system is used to produce possible solutions for different scenarios
6.9 Computers in Computers in the retail industry
the retail
 Characteristics and uses of computers in the retail industry including point of sale (POS)
industry
terminals and electronic funds transfer at point of sale (EFTPOS)
terminals
 Point of sale (POS) terminals including updating stock files automatically and ordering new
stock automatically
1 hours
 Electronic funds transfer at point of sale (EFTPOS)
terminals including checking of the validity of cards, the use of chip and PIN, the use of
contactless cards, the use of Near Field Communication (NFC) payment, the communication
between the supermarket computer and the bank computer
Internet shopping
 Characteristics, advantages and disadvantages of internet shopping
1 hours 6.10 Recognition Characteristics, uses, advantages and disadvantages of:
systems
 Optical Mark Recognition (OMR) including school registers, multiple-choice examination
papers, barcode, QR code Optical Character
 Recognition (OCR) including automated number plate recognition (ANPR) systems
 Radio Frequency Identification Device (RFID) including tracking stock, passports,
automobiles, contactless payment
 Near Field Communication (NFC) including payment using a smartphone
  Biometric recognition including face, iris, retina, finger, thumb, hand, voice
6.11 Satellite Characteristics, uses, advantages and disadvantages of satellite systems including Global
1 hours systems Positioning Systems (GPS), satellite navigation, Geographic Information Systems (GIS), media
communication systems (satellite television, satellite phone)

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
12 hours Chapter 20 Spreadsheets
20.1 Create a Create and edit a spreadsheet model
data model
 Insert cell(s), row(s) and column(s), delete cell(s), row(s) and column(s), merge cells
 Create formulae using cell references
 Replicate formulae using absolute and relative cell references where appropriate
 Use arithmetic operators in formulae including add, subtract, multiply, divide, indices
 Use named cells and named ranges

7 hour  Use functions including sum, average, maximum, minimum, integer, rounding, counting,
LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, IF
 Use external data sources within functions
 Use nested functions
Know and understand the difference between a formula and a function
Know and understand the order in which mathematical operations are performed including the
use brackets to make sure that formulae work
Know and understand the characteristics and use of absolute and relative cell referencing
2 hours 20.2 Manipulate Sort data using a single criterion, or multiple criteria
data
Sort data into ascending or descending order
Search and select data Using a single criterion, or multiple criteria
Perform searches using a variety of operators including AND, OR, NOT, >, =, <=, <>
 Perform searches using wildcards
20.3 Present data Adjust the display features
 Display either formulae or values
 Adjust row height, column width and cell sizes so that all data, labels, and formulae is fully
visible
 Wrap text within cells so that all data is fully visible
 Hide and display rows and columns
Format a spreadsheet:
3 hours  Enhance a spreadsheet including text colour, cell colour, bold, underline, italic, shading
 Format numeric data appropriately including to display the number of decimal places,
different currency symbols, percentages
 Use conditional formatting to change the display format depending on the contents of a cell
Set page layout
 Set the orientation to portrait or landscape
 Control the page layout to print including specified number of pages, print area, display or
hide gridlines, display or hide row and column headings

Time Chapter Course content Actual

Reference completion
Expected
date
completion date
3 hours Chapter 16 Graphs and charts
3 hours Graphs and Create, label and edit a graph or chart
charts
 Select data to produce a graph or chart including using contiguous data, non-contiguous
data and specified data ranges
 Select the graph or chart type
 Label the graph or chart including chart title, legend, sector labels, sector values,
percentages, category axis title, value axis title, category axis labels, value axis labels, data
value labels
 Add a second data series
 Add a second axis
 Format numerical values to a specified number of decimal places Format numerical values
to display currency symbols
 Adjust the maximum and minimum values of an axis scale and set incremental values
 Enhance the appearance of a graph or chart including extracting a pie chart sector, changing
the colour scheme or fill patterns
 TEST AND EXAMINATIONS MARKS
NAME OF STUDENTS
NAME OF STUDENTS