Be able to format numeric data appropriately including to display the number of decimal places, different currency symbols, percentages

Topic 20 – Spreadsheets (Cambridge IGCSE ICT)

Know and understand characteristics, uses, advantages and disadvantages of video-conferencing, audio-conferencing, web-conferencing

Topic 4: Networks and the Effects of Using Them

Be able to save and export in the file format of an application package including .docx, .doc, .xlsx, .xls, .sdb, .sdc, .accdb, .odb, .rtf, .pptx, .ppt

Topic 11 – File Management

Know and understand the characteristics, uses and issues relating to cloud computing

Cambridge IGCSE ICT 0417 – Topic 4: Networks and the Effects of Using Them

Be able to set display format of date/time data

Cambridge IGCSE ICT (0417) – Topic 18: Databases

Be able to set line spacing including single, 1.5 times, double, multiple, spacing before and after paragraphs

Topic 17 – Document Production: Line & Paragraph Spacing

Know and understand evaluating a solution including the efficiency of the solution, the ease of use of the solution, and the appropriateness of the solution

Cambridge IGCSE / A‑Level ICT – Complete Syllabus Notes

Be able to 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)

Topic 17 – Document Production: Page Layout (IGCSE ICT 0417)

Know and understand characteristics of ROM and RAM

1. Types and Components of Computer Systems

Be able to identify and correct data entry errors including transposed numbers, incorrect spelling, inconsistent character spacing, inconsistent case

Topic 15 – Proofing

Be able to perform searches using wildcards

18 Databases – Overview

Be able to select subsets of data using a single criterion, or multiple criteria

Spreadsheets – Selecting Subsets of Data (Cambridge IGCSE ICT 0417)

Know and understand 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

ICT Applications – Electronic Funds Transfer at Point of Sale (EFTPOS)

Know and understand the difference between a formula and a function

20 Spreadsheets – Formula vs Function (Cambridge IGCSE ICT 0417)

Be able to display either formulae or values

Topic 20 – Spreadsheets

Know and understand phishing, pharming, smishing, vishing including the methods that can be used to help prevent them

8 Safety and Security

Know and understand importance, characteristics and uses of verification including visual checking and double data entry to reduce data entry errors

15 Proofing (Verification)

Be able to use a single criterion, or multiple criteria to select subsets of data using a query

Topic 18 – Databases

Be able to create or edit headers and footers

Topic 13 – Layout

Know and understand characteristics, uses, advantages and disadvantages of Near Field Communication (NFC) including payment using a smartphone

6 ICT Applications – Near Field Communication (NFC)

Be able to adjust the maximum and minimum values of an axis scale and set incremental values

Topic 16 – Graphs and Charts

Be able to produce different output layouts including controlling the display of data, labels, tabular or columnar format

Topic 18 – Databases: Producing Different Output Layouts

Know and understand two-factor authentication including its purpose and function

Safety and Security – Overview

Know and understand examples of system software including compilers, linkers, device drivers, operating systems and utilities

System Software – Definition, Types and Functions

Know and understand the uses of wi-fi and Bluetooth

4 Networks and the Effects of Using Them

Know and understand the methods that software producers employ to prevent software copyright legislation being broken

Topic 9 – Audience

Know and understand the order in which mathematical operations are performed including the use brackets to make sure that formulae work

Topic 20 – Spreadsheets: Order of Operations (BODMAS/PEMDAS) and Formula Essentials

Be able to format numerical values to display currency symbols

Topic 16 – Graphs and Charts

Know and understand school management systems are used to record learner performance including computer aided learning

6 ICT Applications – Overview of the Cambridge IGCSE ICT Syllabus

Know and understand characteristics and methods of protecting data including biometrics, digital certificate, secure socket layer (SSL), encryption, firewall, two-factor authentication, user id and password

Safety and Security – ICT 0417

Be able to set appropriate data types to fields including text, numeric (integer, decimal, currency), date/time, Boolean/logical

Cambridge IGCSE ICT 0417 – Databases: Data Types & Related Skills

Know and understand connecting a device to a network using wi-fi

4. Networks and the Effects of Using Them

Know and understand point of sale (POS) terminals including updating stock files automatically and ordering new stock automatically

6 ICT Applications – Point of Sale (POS) Terminals in the Retail Industry

Know and understand optical drives including CD, DVD, Blu-ray

Storage Devices and Media – Optical Drives

Know and understand characteristics of operating systems including Command Line Interface (CLI), Graphical User Interface (GUI), dialogue based and gesture based interface

1. Types and Components of Computer Systems

Know and understand user id and password including how they are used to increase the security of data

Safety and Security – User ID and Password

Know and understand other authentication methods including zero login, biometric methods, magnetic stripes, smart cards, physical tokens, electronic tokens

1 Types of Computer Systems, Hardware & Software

Know and understand the causes of these health issues and strategies for preventing them

Topic 5 – The Effects of Using IT

Be able to place appropriate content in the body section of a web page

Website Authoring – Placing Content in the  Section (ICT 0417)

Know and understand characteristics of a style and a class including the difference between them

21. Website Authoring – Styles and Classes

Know and understand similarities and differences between Bluetooth and wi-fi

4 Networks and the Effects of Using Them

Know and understand the function of a hyperlink

Website Authoring – The Function of a Hyperlink (ICT 0417)

Know and understand characteristics of mobile computers including laptop computers, smartphones, tablet and phablet computers

1. Types and Components of Computer Systems

Be able to perform searches using a variety of operators including AND, OR, NOT, LIKE, >, <, =, >=, <=

18 Databases – Performing Searches with Operators

Be able to place text and automated objects in headers and footers including file information, page numbering, total number of pages, date, time

ICT 0417 – Cambridge IGCSE/A‑Level Syllabus Notes

Be able to enhance a spreadsheet including text colour, cell colour, bold, underline, italic, shading

Topic 20 – Spreadsheets: Enhancing a Spreadsheet

Know and understand characteristics, uses, advantages and disadvantages of Optical Character Recognition (OCR) including automated number plate recognition (ANPR) systems

ICT 0417 – Recognition Systems: OCR, ANPR and Related Technologies

Know and understand computer controlled systems including robotics in manufacture, production line control, autonomous vehicles

6 ICT Applications – Computer‑Controlled Systems

Know and understand software as programs for controlling the operation of a computer or processing of electronic data

1. Types and Components of Computer Systems

Be able to place text or objects in a table

Layout – Placing Text or Objects in a Table (IGCSE ICT 0417)

Know and understand the purpose of headers and footers

Topic 13 – Layout

Be able to adjust row height, column width and cell sizes so that all data, labels, and formulae is fully visible

20 Spreadsheets – Adjusting Row Height, Column Width and Cell Size

Be able to group and layer images including grouping and ungrouping, moving to the front or back

Topic 12 – Working with Images

Be able to use validation routines to minimise data entry errors

Proof‑reading and Data Validation – Reducing Data‑Entry Errors (Cambridge IGCSE 0417 ICT)

Be able to add and delete bookmarks/hyperlinks

Document Production – Adding and Deleting Bookmarks & Hyperlinks

Know and understand the need for eSafety when using the internet, email, social media, online gaming

Topic 8 – Safety and Security

Know and understand advantages and disadvantages of the different types of operating systems

1 Types and Components of Computer Systems

Be able to use appropriate headers and footers within a database report including report header, report footer, page header, page footer

Topic 18 – Databases

Be able to align the contents of the header and footer consistently within a document including to left margin, right margin and centred within margins

IGCSE ICT 0417 – Layout: Aligning Header and Footer Content Consistently

Be able to set the orientation to portrait or landscape

Topic 20 – Spreadsheets (Cambridge IGCSE 0417)

Know and understand characteristics of personal and sensitive data including personal name, address, date of birth, a photograph in school uniform, medical history

Topic 8 – Safety and Security

Know and understand test designs including the testing of data structures, file structures, input formats, output formats and validation routines

Cambridge IGCSE ICT – Test Designs and Related Syllabus Topics

Know and understand the need for copyright legislation and the principles of copyright relating to computer software (e.g. software piracy)

Topic 9 – Audience & Copyright Legislation

Be able to create a new presentation using a text file

Topic 19 – Presentations

Be able to save and export in a generic file format including .csv, .txt, .rtf, .pdf, .css, .htm, .jpg, .png

File Management – Saving and Exporting in Generic Formats

Be able to use functions including sum, average, maximum, minimum, integer, rounding, counting, LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, IF

Topic 20 – Spreadsheets: Functions, Data Manipulation & Presentation

Know and understand how an expert system is used to produce possible solutions for different scenarios

6 ICT Applications – Expert Systems

Be able to set tabulation including left, right, centred and decimal tabs, indented paragraphs and hanging paragraphs

Document Production – Tabulation, Paragraph Formatting, Tables, Layout, Styles & Proof‑reading (Cambridge IGCSE ICT 0417)

Know and understand differences between analogue and digital data

Analogue and Digital Data

Be able to enhance the appearance of a graph or chart including extracting a pie chart sector, changing the colour scheme or fill patterns

Topic 16 – Graphs and Charts

Be able to apply text alignment including left, right, centre, fully justified

Topic 14 – Styles (ICT 0417)

Know and understand school management systems are used to manage learner registration and attendance

ICT 0417 – School Management Systems (SMS): Learner Registration & Attendance

Know and understand characteristics of backing storage

Backing (Secondary) Storage – Cambridge IGCSE 0417

Know and understand the differences and similarities between an extranet, intranet and the internet

4. Networks and the Effects of Using Them

Be able to edit a table and its contents including insert row(s) and column(s), delete row(s) and column(s), merge cells

ICT 0417 – Layout: Editing Tables

Know and understand internal components including Central Processing Unit (CPU), processor, motherboard

Topic 1 – Types and Components of Computer Systems (IGCSE ICT 0417)

Know and understand characteristics, uses, advantages and disadvantages of Radio Frequency Identification Device (RFID) including tracking stock, passports, automobiles, contactless payment

6 ICT Applications – Radio Frequency Identification (RFID)

Be able to save and print files in a variety of formats including a document, screenshots, database reports, data tables, graphs/charts, a web page in browser view, a web page in HTML view

File Management – Saving, Printing & Compressing in Different Formats

Know and understand firewall including its purpose

Safety and Security – Firewalls

Be able to create external styles to be tagged in a web page including h1, h2, h3, p, li

Topic 21 – Website Authoring: External Stylesheets

Know and understand characteristics and use of absolute and relative cell referencing

Spreadsheets – Cell Referencing (Absolute, Relative & Mixed)

Know and understand applications software provides the services that the user requires to solve a task

ICT 0417 – Types and Components of Computer Systems

Be able to save files using appropriate file names

File Management – Saving Files Using Appropriate File Names

Be able to use arithmetic operators in formulae including add, subtract, multiply, divide, indices

Spreadsheets – Using Arithmetic Operators, Functions & Data Tools (IGCSE ICT 0417)

Be able to reflect (flip) an image horizontally or vertically

ICT 0417 – Topic 12: Images – Reflecting (Flipping) an Image

Be able to sort data using a single criterion, or multiple criteria into ascending or descending order

Topic 20 – Spreadsheets

Know and understand the operation of removing/quarantining viruses using up to date software

Networks and Virus Management – Cambridge IGCSE ICT 0417 (2026‑2028)

Know and understand biometrics including the use of biometric data

Safety and Security – Recognition Systems (Biometrics)

Be able to set report titles

Cambridge IGCSE ICT 0417 – Databases: Presenting Data – Setting Report Titles

Be able to locate stored files

File Management – Locating Stored Files (IGCSE ICT 0417)

Be able to align data and labels appropriately including right aligning numeric data and decimal alignment

Cambridge IGCSE ICT 0417 – Complete Syllabus Notes

Be able to insert a new slide

Cambridge IGCSE ICT 0417 – Topic 19: Presentations – Full Guide

Know and understand characteristics, uses, advantages and disadvantages of input devices including keyboard, numeric keypad, pointing devices, remote control, joystick/driving wheel, touch screen (as an input device), scanners, camera, microphone, se

2 Input and Output Devices – Input Devices

Know and understand health issues including repetitive strain injury (RSI), back problems, eye problems, headaches

The Effects of Using IT – Health Issues (IGCSE 0417 Section 5.2)

Be able to place objects into the document from a variety of sources including text, image, screenshot, shapes, table, graph or chart, spreadsheet extract, database extract

ICT 0417 – Layout – Placing Objects in a Document

Know and understand the content layer is used to enter the content and create the structure of a web page

Website Authoring – The Content Layer

Know and understand fixed and portable solid-state drive (SSD) including SSD, pen drive, flash drive

Topic: Storage Devices and Media (Cambridge IGCSE ICT 0417)

Know and understand internet protocols including HyperText Transfer Protocol (HTTP), HyperText Transfer Protocol secure variant (HTTPS), File Transfer Protocol (FTP), Secure Socket Layer (SSL)

ICT 0417 – Complete Syllabus Notes (Cambridge IGCSE / A‑Level)

Be able to control the page layout to print including specified number of pages, print area, display or hide gridlines, display or hide row and column headings

Spreadsheets – Controlling Page Layout for Printing (Cambridge IGCSE 0417)

Know and understand the positive and negative effects of microprocessors/smart devices in monitoring and controlling devices in the home including the impact on lifestyle, leisure time, physical fitness, security of data, the degree of social interac

5. The Effects of Using IT

Know and understand the presentation layer is used to display and format elements within a web page

ICT 0417 – Website Authoring: The Presentation Layer

Know and understand scanning the storage media used to transfer data

4 – Networks and the Effects of Using Them

Know and understand the behaviour layer is for a scripting language to control elements within a web page

Topic 21 – Website Authoring: The Three Web‑Development Layers

Know and understand 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)

1. Computer Systems – Overview

Know and understand characteristics, uses, advantages and disadvantages of the four methods of implementation, direct changeover, parallel running, pilot running, phased implementation

7.4 Implementation (life‑cycle stage) – AO2

Know and understand safety issues including electrocution from spilling drinks near electrical equipment and touching live cables, fire from sockets being overloaded or equipment overheating, tripping over trailing cables, heavy equipment falling and

Safety and Security (ICT 0417 – Topic 8)

Be able to select the graph or chart type

Topic 16 – Graphs and Charts (IGCSE 0417)

Be able to hide slides within a presentation

Cambridge IGCSE ICT 0417 – Presentations: Hiding Slides (and Related Skills)

Know and understand purpose and uses of a corporate house style

Topic 14 – Corporate House Style (and related ICT concepts)

Know and understand internal memory including random access memory (RAM), read-only memory (ROM)

Topic: Types and Components of Computer Systems – Internal Memory (RAM & ROM)

Know and understand viruses and malware including how to take preventative action to avoid the danger of infecting a computer from a downloaded file

Topic 8 – Safety and Security

Know and understand characteristics, uses, advantages and disadvantages of storage media including magnetic, optical and solid-state

3 Storage Devices and Media

Know and understand characteristics, uses, advantages and disadvantages of Electronic Funds Transfer (EFT), credit/debit card transactions, cheques, internet banking

ICT 0417 – ICT Applications: Banking & Wider Syllabus Overview (2026‑2028)

Be able to perform searches using a variety of operators including AND, OR, NOT, >, <, =, >=, <=, <>

Topic 20 – Spreadsheets: Searching with Operators

Know and understand avoiding password interception by using up to date anti-spyware and regularly changing passwords

Networks – Avoiding Password Interception and Maintaining Security

Be able to control the display format of numeric data including number of decimal places, currency symbol, percentage

ICT 0417 – Databases

Be able to use nested functions

Cambridge IGCSE ICT (0417) – Complete Syllabus Overview & Spreadsheets: Using Nested Functions

Know and understand medical applications including printing of prosthetics, tissue engineering, artificial blood vessels, customised medicines

6 ICT Applications – Medical Applications

Know and understand characteristics and uses of file formats including css, csv, gif, htm, .jpg, .pdf, .png, .rtf, .txt, .zip, .rar

11. File Management – Characteristics and Uses of Common File Formats

Be able to 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 att

Placing the Correct Elements in the <head> Section

Know and understand the need to reduce file sizes for storage or transmission

11 File Management

Know and understand characteristics of a desktop computer

1. Types and Components of Computer Systems

Be able to enter and modify text and numbers with total accuracy

13 Layout – Entering and Modifying Text and Numbers

Know and understand card fraud including shoulder surfing, card cloning, key logging

Safety and Security – Card Fraud and Wider e‑Safety Threats

Be able to use automated software tools (spell check, grammar check) and make appropriate changes to ensure all work produced contains as few errors as possible

Topic 15 – Proofing

Be able to print the presentation in a variety of layouts including full page slides, presenter notes, handouts

Topic 19 – Presentations (Cambridge IGCSE ICT 0417)

Know and understand the operation and purpose of a router including connecting networks and devices to the internet, storing computer addresses in a router, routing data packets

4. Networks and the Effects of Using Them

Know and understand the function of an anchor

Website Authoring – The <a> (Anchor) Element

Know and understand the need for personal data to be kept confidential and protected to avoid inappropriate disclosure

Safety and Security – Personal Data Confidentiality

Be able to hide and display rows and columns

Spreadsheets – Hiding and Displaying Rows and Columns (Cambridge IGCSE ICT 0417)

Be able to insert cell(s), row(s) and column(s), delete cell(s), row(s) and column(s), merge cells

20 Spreadsheets – Inserting, Deleting, Merging & Manipulating Data

Be able to use external data sources within functions

Topic 20 – Spreadsheets: Using External Data Sources in Functions

Be able to import data from existing files (including .csv, .txt) using specified field names to create tables

ICT 0417 – Databases: Importing Data (and Related Core Concepts)

Know and understand 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

7 – The Systems Life Cycle (SLC)

Know and understand the principles of a typical data protection act and why data protection legislation is required

Safety and Security – Data Protection

Know and understand solid-state media including memory cards (SD, xD, CFast)

3. Storage Devices and Media

Know and understand how data is stored, managed and shared using cloud computing

Networks and Cloud Computing

Know and understand use of search engine including speed of searching, amount of information, the speed of finding relevant information, ease of finding reliable information

10 Communication – Using Search Engines

Be able to create the content layer of a web page

ICT 0417 – Website Authoring: Creating the Content Layer

Be able to save files in a planned hierarchical directory/folder structure

ICT 0417 – Cambridge IGCSE/A‑Level Syllabus Notes

Be able to resize an image as specified to maintain or adjust the aspect ratio of an image

Topic 12 – Images (Cambridge IGCSE ICT 0417)

Know and understand the need to convert digital data to analogue data so it can be used to control devices

1. Types and Components of Computer Systems

Know and understand characteristics, uses and constraints of email communication including acceptable language, guidelines set by an employer, the need for security, netiquette, email groups, carbon copy (cc), blind carbon copy (bcc), forward, attach

Communication – Email (Cambridge IGCSE/A‑Level ICT 0417)

Know and understand magnetic drives including magnetic hard disks, magnetic tape

Storage Devices and Media – Magnetic, Optical & Solid‑State Drives

Be able to move or delete a slide

Cambridge IGCSE ICT 0417 – Topic 19: Presentations – Moving, Deleting & Managing Slides

Be able to insert and edit a hyperlink including linking text or objects to a slide within the presentation, an external file or an email address

Topic 19‑20 – Cambridge IGCSE 0417 Presentations (Full Syllabus Overview)

Know and understand optical discs including CD, DVD, Blu-ray

Storage Devices and Media – Optical Discs

Know and understand hardware as the physical components of a computer system

1. Syllabus Map – What Is Covered?

Know and understand characteristics, advantages and disadvantages of internet shopping

6 ICT Applications – Internet Shopping (Syllabus 6.9)

Know and understand impact of emerging technologies on everyday life including Artificial Intelligence (AI), extended reality (virtual and augmented)

1. Types and Components of Computer Systems

Be able to insert and edit objects consistently including images, text, shapes, logos, slide headers and footers, placeholder position, automated slide numbering

Topic 19 – Presentations (Cambridge IGCSE 0417)

Know and understand that automated suggestions given by spell check software do not always give the correct response

Proofing – Automated Spell‑Check and Its Limitations

Know and understand characteristics and uses of communication media including newsletters, posters, websites, multimedia presentations, audio, video, media streaming and ePublications

ICT 0417 – Cambridge IGCSE ICT – Complete Lecture Notes

Know and understand functionality including Internet Service Provider (ISP), structure of a web address, Uniform Resource Locator (URL), hyperlink, web browser

10 Communication

Know and understand characteristics and uses of computers in the retail industry including point of sale (POS) terminals and electronic funds transfer at point of sale (EFTPOS) terminals

ICT Applications – Retail Industry (POS & EFTPOS)

Know and understand the need for generic file formats

File Management – Generic File Formats (ICT 0417 – Section 11)

Be able to rotate an image

Topic 12 – Images

Know and understand characteristics and uses of patient records, pharmacy records

6 ICT Applications – Patient Records and Pharmacy Records

Be able to add a second axis

Topic 16 – Graphs and Charts (ICT 0417)

Know and understand the purpose of setting page, section and column breaks

Document Production – Page, Section and Column Breaks (Cambridge IGCSE ICT 0417, Section 13 Layout)

Know and understand characteristics, uses and purpose of an extranet, intranet and the internet

Topic: Networks and the Effects of Using Them

Know and understand characteristics, uses, advantages and disadvantages of satellite systems including Global Positioning Systems (GPS), satellite navigation, Geographic Information Systems (GIS), media communication systems (satellite television, sa

ICT 0417 – 6 ICT Applications: Satellite Systems (Deep‑Dive)

Know and understand minimising the potential danger of using 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

Topic 8 – Safety and Security: Email

Know and understand uses of mobile computers including office and business management, education, gaming, entertainment and remotely controlled devices

ICT 0417 – Mobile Computer Systems: Types, Components, Applications and Core Skills

Be able to create the presentation layer of a web page

21 Website Authoring – Presentation Layer

Know and understand differences between input and output devices

ICT 0417 – Cambridge IGCSE/A‑Level Syllabus Notes

Be able to create a bookmark within a web page using an id attribute

Website Authoring – Creating a Bookmark (Internal Link)

Be able to place an image with precision

IGCSE ICT (0417) – Complete Lecture Notes

Be able to create generic external styles and inline style attributes including background properties (colour, images), font properties, table, table row, table header and table data properties (size, background colour, horizontal and vertical alignm

21. Website Authoring

Know and understand minimising the potential danger of using 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 inapprop

Topic 8: Safety and Security (ICT 0417)

Know and understand the need to convert analogue to digital data so it can be processed by a computer

Analogue‑to‑Digital Conversion – Why It Is Needed and How It Works

Know and understand the hardware, software and network connection required to set up each type of electronic conference

ICT 0417 – Networks and Electronic Conferences

Know and understand differences between types of operating systems

1. Operating Systems – Definition and Core Functions

Know and understand characteristics of good form design

18 Databases

Know and understand input formats including data capture forms

Systems Life Cycle – Input Formats & Data Capture Forms

Know and understand analysing the needs of an audience when creating ICT solutions

ICT 0417 – Audience: Analysing Audience Needs

Be able to use formulae and functions to perform calculations at run time including addition, subtraction, multiplication, division, sum, average, maximum, minimum, count

Topic 18 – Databases (Cambridge IGCSE ICT 0417)

Know and understand magnetic drives including fixed and portable magnetic hard drives, magnetic tape drives

Storage Devices and Media – Magnetic, Optical and Solid‑State

Know and understand characteristics of input and output devices

Computer Systems – Cambridge IGCSE 0417

Be able to apply font styles including font face, type (serif, sans-serif), point size, colour

Topic 14 – Styles

Know and understand characteristics of primary key and foreign keys

ICT 0417 – Databases: Primary and Foreign Keys

Be able to create hyperlinks from text and images to bookmarks on the same page, other locally stored web pages, a website using the URL, send mail to a specified email address, to open in a specified location (the same window, a new window, with a w

Website Authoring – Hyperlinks (ICT 0417)

Know and understand the causes of these safety issues and strategies for preventing them

Safety and Security (Cambridge IGCSE 0417)

Know and understand advantages and disadvantages of using computer modelling rather than humans

ICT (0417) – Complete Syllabus Overview

Be able to use arithmetic operations or numeric functions to perform calculations including calculated fields, calculated controls

Topic 18 – Databases (Cambridge IGCSE 0417)

Be able to adjust the brightness of an image

Topic 12 – Images (ICT 0417)

Be able to add alternative text/screentip to an object

Presentations – Adding Alternative Text / ScreenTip (Cambridge IGCSE ICT 0417)

Be able to apply classes to elements within a web page

21. Website Authoring – Applying Classes to Elements

Know and understand uses of a desktop computer including office and business management, education, gaming and entertainment

1. Overview of Desktop Computers and Their Uses

Know and understand characteristics, uses, advantages and disadvantages of direct data entry devices including magnetic stripe reader, chip and PIN reader, Radio Frequency Identification (RFID) reader, Optical Mark Recognition/Reader (OMR), Optical C

ICT 0417 – Input and Output Devices: Direct Data‑Entry Devices

Know and understand file/data structures including field length, field name, data type, coding of data for example M for male, F for female

1. Computer Hardware

Know and understand characteristics, uses, media, advantages and disadvantages of storage devices including magnetic, optical and solid-state

Storage Devices and Media

Be able to apply text enhancement including bold, underline, italic

Topic 14 – Styles (IGCSE ICT 0417)

Know and understand showing a clear sense of audience and purpose

Topic 9 – Audience Appreciation

Know and understand advantages and disadvantages of using cloud storage compared to other methods

4. Networks and the Effects of Using Them – Cloud Storage vs. Other Methods

Know and understand the differences between strong and weak passwords

4 Networks and the Effects of Using Them – Password Security

Be able 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

ICT 0417 – Topic 15: Proofing

Know and understand characteristics, uses, advantages and disadvantages of Optical Mark Recognition (OMR) including school registers, multiple-choice examination papers, barcode, QR code

6 ICT Applications – Optical Mark Recognition (OMR)

Be able to apply spacing including paragraph (before and after) and line

Topic 14 – Styles (Cambridge IGCSE 0417 ICT)

Be able to format numerical values to a specified number of decimal places

Topic 16 – Graphs and Charts

Know and understand digital certificate including its purpose and contents

Safety and Security – Digital Certificates

Be able to reduce file sizes for storage or transmission where necessary using file compression including .zip, .rar

IGCSE ICT – File Management and Reducing File Sizes (Syllabus 11.1 & 11.2)

Know and understand the role of the CPU in processing instructions entered into the computer in order to produce an output

Learning Objective

Know and understand characteristics and effect of threats to data including hacking, phishing, pharming, smishing, vishing, viruses, malware, card fraud

Safety and Security – Threats to Data

Know and understand the reason tables are used to structure elements within a web page

21 Website Authoring – Using Tables for Layout

Be able to create or edit lists including bulleted, numbered

Cambridge IGCSE ICT 0417 – Topic 17: Document Production

Know and understand connecting a device to a network using Bluetooth

Connecting a Device to a Network Using Bluetooth

Know and understand importance, characteristics and uses of appropriate validation including range check, character check, length check, type check, format check, presence check

15 Proofing

Be able to select data to produce a graph or chart including using contiguous data, non-contiguous data and specified data ranges

Topic 16 – Graphs and Charts (IGCSE ICT 0417)

Know and understand secure socket layer (SSL) including encrypted links between the server and the client computer

ICT Syllabus – Quick Reference (IGCSE / A‑Level)

Be able to apply consistent transitions between slides

ICT 0417 – Presentations (Section 19)

Know and understand that reducing the file size can be achieved by reducing the image resolution or colour depth

Topic 12 – Images: Reducing File Size and Basic Image Editing

Be able to create formulae using cell references

Spreadsheets – Creating Formulae Using Cell References

Be able to use conditional formatting to change the display format depending on the contents of a cell

Spreadsheets – Conditional Formatting (Cambridge IGCSE ICT 0417)

Know and understand planning ICT solutions that are responsive to and respectful of the needs of an audience

ICT 0417 – Topic 9: Audience

Be able to open and import files of different types

File Management – Opening, Importing, Saving & Organising Files

Know and understand characteristics, uses and purpose of technical and user documentation

7 The Systems Life Cycle (SLC)

Know and understand output formats including screen layouts and report layouts

ICT 0417 – Output Formats: Screen & Report Layouts (Cambridge IGCSE ICT)

Know and understand system software provides the services that the computer requires to operate

ICT 0417 – Types and Components of Computer Systems

Be able to add a second data series

Topic 16 – Graphs and Charts

Know and understand components of an expert system: user interface, inference engine, knowledge base, rules base, explanation system

6 ICT Applications – Expert Systems

Know and understand the use of mobile devices for communication including SMS messaging, phone calls, voice over Internet Protocol (VoIP), video calls, accessing the internet

ICT Applications – Mobile Devices for Communication

Know and understand characteristics, uses, advantages and disadvantages of a flat file and a relational database

Topic 18 – Databases

Know and understand scanning the data/software when downloading

IGCSE ICT (0417) – Complete Syllabus Notes

Know and understand common network devices including network interface cards (NIC), hubs, bridges, switches

4. Networks and the Effects of Using Them

Be able to use named cells and named ranges

Spreadsheets – Named Cells, Named Ranges & Core Functions (Cambridge IGCSE ICT 0417)

Know and understand designing file/data structures, input formats, output formats and validation routines

1 Computer Systems – Hardware, Software and Operating Systems

Know and understand minimising the potential danger of using the internet including only using trusted websites recommended by teachers, using a search engine that only allows access to age appropriate websites

Topic 8 – Safety and Security (ICT 0417)

Be able to specify the font properties including font family, size, colour, alignment, bold, italic

21. Website Authoring

Be able to crop an image

Topic 12 – Images: Cropping an Image

Know and understand hacking including the measures that must be taken in order to protect data

Safety and Security – Topic 8

Be able to create, modify, update and apply styles to ensure consistency of presentation

Topic 14 – Styles

Be able to wrap text within cells so that all data is fully visible

ICT 0417 – Spreadsheets: Wrapping Text in Cells

Be able to save styles in cascading stylesheet format

Saving Styles in Cascading Stylesheet (CSS) Format

Know and understand 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, fil

Cambridge IGCSE ICT (0417) – Complete Core Content Notes (2026‑2028)

Be able to apply slide layout

Cambridge IGCSE ICT 0417 – Topic 19: Presentations – Applying Slide Layout

Know and understand test designs, test strategies, test plan (test data, expected outcomes, actual outcomes, remedial action) following testing

7. The Systems Life Cycle – Testing Phase

Be able to 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

IGCSE ICT (0417) – Complete Revision Notes

Know and understand differences between ROM and RAM

1 Types and Components of Computer Systems – Internal Memory (RAM & ROM)

Know and understand the use of anti-malware and anti-virus software

4 Networks and the Effects of Using Them

Know and understand the use of live data

7. The Systems Life Cycle – Use of Live Data

Be able to set display format of Boolean/logical field (yes/no, true/false, checkbox)

Cambridge IGCSE ICT 0417 – Databases

Know and understand validation routines including range check, character check, length check, type check, format check, presence check, check digit

ICT 0417 – The Systems Life Cycle and Core ICT Topics

Be able to 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

21 Website Authoring

Be able to set sub-types of numeric data including percentage, number of decimal places

Topic 18: Databases – Setting Numeric Sub‑types (Cambridge IGCSE ICT 0417)

Be able to create and edit primary and foreign keys

Cambridge IGCSE ICT 0417 – Databases: Primary and Foreign Keys

Know and understand the reason relative file paths must be used for attached stylesheets

ICT 0417 – Website Authoring: Using Relative File Paths for Stylesheets

Be able to 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 r

Layout – Formatting Tables (ICT 0417)

Be able to apply styles to elements within a web page including to a list (ordered list, unordered list)

21. Website Authoring – Presentation Layer (CSS) & Basic HTML

Be able to apply text enhancement including bold, underline, italic, superscript and subscript, changes in case

Document Production – Text Enhancement (Section 17)

Be able to insert an action button including modifying settings to navigate to a specified slide or file

Presentations – Inserting and Configuring Action Buttons (Cambridge IGCSE ICT 0417)

Be able to use a single criterion, or multiple criteria to sort data into ascending or descending order

18 Databases – Sorting Data

Know and understand advantages and disadvantages of using computer controlled systems rather than humans

6 ICT Applications – Computer‑Controlled Systems

Know and understand advantages and disadvantages of the different types of computer including portability and expandability

1. Computer Systems – Hardware, Software and the ICT Syllabus

Know and understand minimising the potential danger of using online gaming including not using real names, not giving out personal or financial data

Topic 8 – Safety and Security (IGCSE ICT 0417)

Know and understand characteristics, uses, advantages and disadvantages of the research methods of observation, interviews, questionnaires and examination of existing documents

Cambridge IGCSE ICT – Complete Syllabus Notes

Be able to insert a table including table header, table rows, table data

Inserting Tables – ICT 0417 (Website Authoring)

Know and understand characteristics, uses and purpose of expert systems including mineral prospecting, car engine fault diagnosis, medical diagnosis, chess games, financial planning, route scheduling for delivery vehicles, plant and animal identifica

6 ICT Applications – Expert Systems

Be able to wrap text around a table, chart or image including above, below, square and tight

ICT 0417 – Comprehensive Syllabus Notes (Cambridge IGCSE / A‑Level)

Be able to apply consistent animation effects on text, images and other objects

Presentations – Creating Consistent, Effective Slides (IGCSE ICT Section 19)

Know and understand 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 d

ICT 0417 – Complete Syllabus Notes (IGCSE / A‑Level)

Know and understand the concept of a bookmark including methods of creating a bookmark within a web page

21. Website Authoring – Bookmarks

Know and understand the purpose of setting gutter margins

Document Production – IGCSE ICT (0417)

Know and understand hardware components including graphics card, sound card, Network Interface Card (NIC), camera, internal/external storage devices, input and output devices

Topic: Hardware Components, Operating Systems, Networks and Emerging Technologies

Be able to create a table with a specified number of rows and columns

ICT 0417 – Layout: Creating Tables (and Related Layout Skills)

Be able to 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

18 Databases – Creating a Data‑Entry Form (IGCSE 0417)

Be able to use editing techniques to manipulate text and numbers including highlight, delete, move, cut, copy, paste, drag and drop

Topic 13: Layout – Cambridge IGCSE ICT 0417

Know and understand risks of using the internet including inappropriate and criminal material, restricting data through parental, educational and ISP control

Topic 10 – Communication and e‑Safety

Know and understand differences between backing storage and internal memory

Types and Components of Computer Systems (ICT 0417)

Be able to attach comments to an external stylesheet

ICT 0417 – Website Authoring

Know and understand the purpose of the head and body sections of a web page

21. Website Authoring

Know and understand identifying and justifying suitable hardware and software for the new system

ICT 0417 – Systems Life Cycle: Identifying and Justifying Suitable Hardware & Software

Be able to use the <div> tag including to apply styles and classes

Website Authoring – Using the <div> Tag (IGCSE ICT 0417)

Be able to replicate formulae using absolute and relative cell references where appropriate

Topic 20 – Spreadsheets (IGCSE 0417)

Know and understand encryption including its purpose for the protection of data on hard discs, email, cloud, HTTPS websites

Safety and Security – Encryption (ICT 0417)

Know and understand evaluating the information found on the internet including how up to date, reliable, biased and valid this information is

ICT 0417 – Communication (Cambridge IGCSE/A‑Level)

Be able to create relationships between tables

Topic 18 – Databases

Know and understand the need for validation as well as verification

Topic 15 – Proofing

Know and understand the definition, characteristics and use of test data using normal, abnormal and extreme data

7 The Systems Life Cycle (SLC)

Know and understand test strategies including to test each module, each function and the whole system

7. The Systems Life Cycle – Test Strategies

Know and understand privacy and confidentiality of data transfer

ICT 0417 – Networks: Privacy and Confidentiality of Data Transfer

Know and understand characteristics, uses, advantages and disadvantages of Automatic Teller Machines (ATM) including withdrawing cash, depositing cash or cheques, checking account balance, mini statements, bill paying, money transfers

ICT 0417 – Comprehensive Lecture Notes (Updated)

Know and understand the need to test the system before implementation

7. The Systems Life Cycle – Testing Before Implementation

Know and understand characteristics, uses, advantages and disadvantages of biometric recognition including face, iris, retina, finger, thumb, hand, voice

6 ICT Applications – Recognition Systems (Syllabus 6.10)

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

Website Authoring – Relative and Absolute File Paths

Be able to find and replace text including matching case, whole words

Document Production – Find & Replace

Know and understand characteristics and effects of spam email including the methods which can be used to help prevent spam

10 Communication – Spam Email

Be able to 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

IGCSE ICT (0417) – Topic 16: Graphs and Charts – Labelling the Chart

Know and understand characteristics, uses, advantages and disadvantages of online booking systems including travel industry, concerts, cinemas, sporting events

6 ICT Applications – Online Booking Systems

Be able to add presenter notes

Topic 19 – Presentations

Know and understand 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

ICT Applications – Electronic Funds Transfer at Point of Sale (EFTPOS)

Be able to create generic external styles and inline style attributes including background properties (colour, images), font properties, table, table row, table header and table data properties (size, background colour, horizontal and vertical alignm

21. Website Authoring – Styles and Tables (IGCSE 0417)

Know and understand characteristics, uses, advantages and disadvantages of satellite systems including Global Positioning Systems (GPS), satellite navigation, Geographic Information Systems (GIS), media communication systems (satellite television, sa

6 ICT Applications – Satellite Systems (IGCSE 0417 Section 6.11)

Know and understand safety issues including electrocution from spilling drinks near electrical equipment and touching live cables, fire from sockets being overloaded or equipment overheating, tripping over trailing cables, heavy equipment falling and

IGCSE ICT (0417) – Complete Syllabus Notes

Know and understand characteristics, uses, advantages and disadvantages of output devices including monitors, touch screen (as an output device), multimedia projector, laser printer, inkjet printer, dot matrix printer, plotter, 3D printers, speaker,

2 – Output Devices (Cambridge IGCSE ICT 0417)

Know and understand characteristics, uses and constraints of email communication including acceptable language, guidelines set by an employer, the need for security, netiquette, email groups, carbon copy (cc), blind carbon copy (bcc), forward, attach

Communication – Email

Know and understand characteristics, uses, advantages and disadvantages of using the internet including the differences between the internet, an intranet, an extranet and the World Wide Web (WWW), blog, forum, wiki, social networking

10 Communication – The Internet and Related Services

Be able to adjust the contrast of an image

Topic 12 – Images (Cambridge IGCSE ICT 0417)

Know and understand characteristics, uses, advantages and disadvantages of direct data entry devices including magnetic stripe reader, chip and PIN reader, Radio Frequency Identification (RFID) reader, Optical Mark Recognition/Reader (OMR), Optical C

Direct Data‑Entry Devices (ICT 0417 – Section 2.2)

Be able to display the presentation for a variety of purposes including looped on-screen carousel, presenter controlled

ICT 0417 – Presentations: Display Options (Topic 19)

Know and understand computer modelling including personal finance, bridge and building design, flood water management, traffic management, weather forecasting

ICT 0417 – Computer Modelling Applications

Be able to produce reports to display data including displaying all the required data and labels in full

Topic 18 – Databases (Cambridge IGCSE 0417)

Know and understand minimising the potential danger of using 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

Safety and Security – Email (IGCSE ICT 0417)

Know and understand the 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)

Website Authoring – Metatags (IGCSE 0417)

Know and understand characteristics, uses, advantages and disadvantages of input devices including keyboard, numeric keypad, pointing devices, remote control, joystick/driving wheel, touch screen (as an input device), scanners, camera, microphone, se

2 Input and Output Devices

Be able to format master slide objects including headings, subheadings, bullets, background colour

19 Presentations – Master Slide Formatting (Cambridge IGCSE ICT 0417)

Know and understand characteristics, uses and purpose of expert systems including mineral prospecting, car engine fault diagnosis, medical diagnosis, chess games, financial planning, route scheduling for delivery vehicles, plant and animal identifica

ICT Applications – Expert Systems

Be able to create classes including background properties (colour, images), font properties, table, table row and table data properties (size, background colour, horizontal and vertical alignment, spacing, padding, borders: including collapsed, colou

21 Website Authoring

Be able to 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 att

IGCSE ICT (0417) – Complete Revision Notes

Know and understand comparing the solution with the original task requirements, identifying any limitations and necessary improvements to the system, evaluating the users' responses to the results of testing the system

Systems Life Cycle – Evaluation Phase (ICT 0417)

Be able to create hyperlinks from text and images to bookmarks on the same page, other locally stored web pages, a website using the URL, send mail to a specified email address, to open in a specified location (the same window, a new window, with a w

21. Website Authoring – Hyperlinks

Know and understand Local Area Network (LAN), Wireless Local Area Network (WLAN), Wide Area Network (WAN) and the differences between these networks

4. Networks and the Effects of Using Them

Know and understand minimising the potential danger of using 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 inapprop

1. Hardware

Know and understand 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, fil

7. The Systems Life Cycle – Technical Documentation (ICT 0417)

Be able to apply tags to text within a web page to display predefined styles including h1, h2, h3, p, i

21. Website Authoring – Applying Text Tags

Know and understand the positive and negative effects of microprocessors/smart devices in monitoring and controlling devices in the home including the impact on lifestyle, leisure time, physical fitness, security of data, the degree of social interac

5 . The Effects of Using IT in the Home

Be able to 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 r

13 Layout – Teaching Notes (Cambridge IGCSE ICT 0417)

Know and understand characteristics of analogue and digital data

Computer Systems – IGCSE 0417 Syllabus Notes

Be able to 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

21. Website Authoring – Using Table Attributes (Syllabus 21.2)

Know and understand 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 d

Systems Life Cycle (SLC) – Documentation (Cambridge IGCSE/A‑Level)

Know and understand 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

21 Website Authoring – Cascading Style Sheets (CSS)

Be able to apply bullets including shape, alignment, line spacing and indent

14 Styles – Bullets, Alignment, Line Spacing, Indent, Font & Text Enhancements

Know and understand the positive and negative effects of microprocessors/smart devices in monitoring and controlling transport including security of data, autonomous vehicles, transport safety

Learning Objective