SYLLABUS BREAKDOWN
Long-term Plan (LTP), Year 11 (IG-III)
Cambridge Wing, PISQ
Session 2025-2026
1- Cambridge IGCSE and O Level (second Edition) – HODDER EDUCATION TOTAL DAYS OF TEACHING
2- Lawrey, S., Scott, D., (2018) Cambridge IGCSE® Computer Science Course book second Edition
Resource Books
3- Course workbook of IGCSE and O Level – HODDER EDUCATION 1st Term:
Reference Books Cambridge IGCSE® Computer Science - David Watson Helen Williams 2nd Term:
https://www.isaaccomputerscience.org
https://craigndave.org/
https://www.w3schools.com/
Helpful Websites
https://www.igcseict.info
http://computer.howstuffworks.com/
https://learnlearn.uk/gcsece https://revisecomputerscience.com/courses/ocr-gcse-complete
IDLE/ Thonny / VS Code/notepad ++ for HTML
Simulators/Programming
Cisco packet tracer (Network Simulator)
Languages/Software
Scratch (for Programming Logic)
Cambridge Wing, PISQ
SYLLABUS BREAKDOWN
Long-term Plan (LTP), Year 11 (IG-III)
Cambridge Wing, PISQ
Subject: Computer Science 0478 Session: 2025-2026 Class/Year: IG-III (Year 11)
1st term (Sept. 2025 to Dec. 2025) nd
2 term (Jan. 2026 to June 2026)
Block 1 Block 2 Block 3 Block 4 Block 5 Block 6
★ Boolean Logic: (Unit 10) methods used to design Trace tables, Validation,
2nd Mock Examination - the identification, definition, and construct solutions to Verification
September 2025 symbols and functions of the problems (structure validation checks when
standard logic gates: NOT, AND, diagrams, flowcharts, data is input
★ Databases: (Unit 9) OR, NAND, NOR & XOR pseudocode) verification checks when
the design and use of single Creating logic circuits from: the purpose of an data is input
table databases – fields– a given problem, a logic algorithm and the use of different types of
records– validation expression, a truth table processes involved in it test data including:
the use of basic data types– completing truth tables from: standard methods of documentation of a dry run
text/alphanumeric– a given problem, a logic solution: using a trace table
character– Boolean– integer– expression, a logic circuit Searching: linear search writing, amending,
Revision P1, P2 and
real– date/time Writing a logic expression from: Sorting: bubble sort identifying, and correcting Revision & Past
Past Paper Practice
the identification, purpose given problem & logic circuit totalling errors in: flowcharts, papers Practice
and use of primary keys a truth table. counting programs, pseudocode.
SQL scripts, used to query ★ Algorithm design and problem finding average, maximum,
data stored in a single table solving (Unit 7) minimum
Database. stages in the program
development cycle: analysis,
design, coding, testing
computer systems and sub-
systems
problem decomposition into
component parts
Cambridge Wing, PISQ
