Computer Science

Computer Science lessons

Cambridge IGCSE Computer Science (0478), topic by topic: clear explanations, our own diagrams and pseudocode, real exam questions with the official mark scheme and a quiz in every lesson.

98 lessons · KS3 · IGCSE 0478

Lessons

98 lessons

  1. 01

    KS3 · Chapter 1 · Digital skills

    Files, folders and the cloud

    What files and extensions are, how folders and paths organise your work, how to name and move files quickly with keyboard shortcuts, why you must save often, and how local storage, cloud storage, backups and sharing keep your work safe.

    19 min

  2. 02

    KS3 · Chapter 1 · Digital skills

    Writing a serious email

    How an email address works, who goes in To, Cc and Bcc, how to write a clear subject and a polite, well-built email, how to attach a file, when to use Reply, Reply all or Forward, how to spot a fake email, and the shortcuts that make email faster.

    10 min

  3. 03

    KS3 · Chapter 2 · Search and check

    Searching well, reliable sources

    How a search engine finds pages, how to choose 2 to 4 good key words, how to use quotes, the minus sign and site: to sharpen a search, how to read a results page and skip the adverts, how to judge a source with 4 questions, how to write down your sources, and the browser shortcuts that make research faster.

    9 min

  4. 04

    KS3 · Chapter 2 · Search and check

    Fake news and edited images

    What fake news, misinformation, disinformation and satire are, the red flags that give a fake post away, how to check a story by reading sideways and using fact-checkers, how pictures are edited or made by AI, how a reverse image search finds where a picture comes from, and how to keep evidence with screenshots.

    9 min

  5. 05

    KS3 · Chapter 3 · How a computer works

    Hardware and software

    The difference between hardware and software, the main parts inside a computer (CPU, RAM, storage, graphics card, power supply, motherboard), the jobs of the operating system, application and utility software, what happens when a computer starts, how to choose an upgrade, and the system shortcuts.

    9 min

  6. 06

    KS3 · Chapter 3 · How a computer works

    Input, process, output

    How every computer system takes in data, processes it and gives out a result, the main input, output and storage devices, why a touchscreen is both, what sensors measure, how a control system follows rules such as IF temperature is above 28 THEN fan ON, and the zoom and print shortcuts.

    7 min

  7. 07

    KS3 · Chapter 4 · Algorithms

    Decompose and abstract

    What computational thinking is, how to break a big problem into smaller sub-problems (decomposition), how to spot patterns, how to keep only the details that matter (abstraction), and how to move the cursor with the keyboard instead of the mouse.

    7 min

  8. 08

    KS3 · Chapter 4 · Algorithms

    Flowcharts

    What an algorithm is, the three building blocks sequence, selection and iteration, the four flowchart shapes (Start and End, input and output, process, decision), how to trace a flowchart with real values including decisions with > and ≥ and loops, and how to select text with the keyboard.

    7 min

  9. 08

    KS3 · Chapter 5 · From Scratch to Python

    Scratch basics

    A catch-up lesson before Python: what Scratch is, sprites, the stage and scripts, hat blocks and the colours of blocks, how move, turn and say work, loops with repeat and forever, if blocks inside forever, and variables with set and change.

    8 min

  10. 09

    KS3 · Chapter 5 · From Scratch to Python

    From blocks to text

    What a program and a programming language are, the difference between block-based Scratch and text-based Python, how say, repeat and if blocks become print, for and if lines, why indentation matters, what syntax errors and logic bugs are, how to debug, and where the code symbols are on the keyboard.

    6 min

  11. 10

    KS3 · Chapter 5 · From Scratch to Python

    print and text

    How print shows output on the screen, what strings are, the difference between text in quotes and numbers the computer works out, joining strings with + and commas, repeating with *, maths operators, comments, empty lines, common error messages, and the editing keys Backspace, Delete, Home and End.

    6 min

  12. 11

    KS3 · Chapter 5 · From Scratch to Python

    Variables

    What a variable is, how to store a value with =, how to use and change a variable (score = score + 1), the difference between print(name) and print("name"), the rules for naming variables, the data types string, integer and float, and how to trace a program by following the values in the boxes.

    6 min

  13. 12

    KS3 · Chapter 5 · From Scratch to Python

    input

    How input( ) lets the user type an answer while a program runs, why input always gives a string, how int( ) and float( ) turn the answer into a number, the 53 bug, ValueError and TypeError, testing a program with different answers, and how to stop a program with Ctrl + C.

    6 min

  14. 13

    KS3 · Chapter 6 · Safe and well online

    Staying safe online

    How to make strong passwords with three random words, why each account needs its own password, what 2-step verification does, how to spot phishing from the sender, the link and the message, what personal information to keep private, what to do when something online worries you, and how to lock your screen.

    7 min

  15. 14

    KS3 · Chapter 6 · Safe and well online

    Digital wellbeing

    How screens affect sleep, eyes and body, the 20-20-20 rule, good posture, how apps use notifications, streaks, autoplay and endless scroll to pull you back, how to stay focused, THINK before you post, your digital footprint, edited posts, and being kind online.

    6 min

  16. 15

    KS3 · Office skills (Year 7)

    Word processing

    How to make a clear document in Microsoft Word or Google Docs: select then format, bold, italic and underline used with care, alignment, Heading 1 and Heading 2, bullet points and numbering, where the tools live on the ribbon (Home, Insert, Layout, Review), spelling check, word count, saving as PDF and sharing.

    8 min

  17. 16

    KS3 · Office skills (Year 7)

    Presentations

    How to make clear slides in PowerPoint or Google Slides and present them with confidence: one idea per slide, short bullet points and bullet levels, big text and good contrast, matching pictures with sources, one design, few animations, layouts, speaker notes, and the slide show keys to start, move, jump, black the screen and end.

    7 min

  18. 17

    KS3 · Office skills (Year 7)

    Spreadsheets

    First steps in Excel and Google Sheets: cells, rows, columns and cell names like B3, entering data with Tab and Enter, headings and one record per row, numbers without units, AutoFill with the fill handle (days, months, Week 1, steps, copies), AutoSum, sorting and filtering a table.

    6 min

  19. 18

    KS3 · Chapter 7 · Spreadsheets

    Cells and formulas

    What a spreadsheet is, cells, rows, columns and cell references, the Name Box and the formula bar, moving and entering data with the keyboard, writing formulas with + - * / and brackets, why formulas use cell references, and the most common formula mistakes.

    7 min

  20. 19

    KS3 · Chapter 7 · Spreadsheets

    Functions and ranges

    What a range is and how to write and select one, the functions SUM, AVERAGE, MAX, MIN and COUNT, how COUNT and AVERAGE treat text and empty cells, Fill Down with Ctrl + D and how references move when a formula is copied, and the most common mistakes with ranges.

    6 min

  21. 20

    KS3 · Chapter 7 · Spreadsheets

    IF and charts

    How the IF function lets a spreadsheet make decisions, the comparison signs, text in quotes, filling an IF down a column, fixing common IF errors, and how to choose and check a chart: column, line or pie, with a title, labelled axes and an honest scale.

    5 min

  22. 21

    KS3 · Chapter 8 · Data in binary

    Bits and bytes

    Why computers store everything as 0s and 1s, what a bit is, how many patterns a number of bits can make, the units of storage from bit to terabyte, converting between units, and working out how many files fit on a device.

    5 min

  23. 22

    KS3 · Chapter 8 · Data in binary

    Binary numbers

    Binary place values, changing binary numbers to denary and denary numbers to binary, counting in binary, the biggest number a number of bits can hold, and adding two binary numbers with carries.

    6 min

  24. 23

    KS3 · Chapter 8 · Data in binary

    Text and images in binary

    How text is stored as character codes (ASCII and Unicode), how bitmap images are stored as pixels, colour depth, resolution, and how to work out the size of an image file.

    6 min

  25. 24

    KS3 · Chapter 9 · Python decisions and loops

    Hello Python

    A fresh start in Python: what a program is, the editor, print, text and numbers, comments, variables and the types int, float and str, input() and int(), and how to read SyntaxError, NameError, TypeError and ValueError.

    8 min

  26. 25

    KS3 · Chapter 9 · Python decisions and loops

    if and else

    Conditions and comparison operators in Python, = versus ==, if, else and elif blocks with colons and indentation, turning input into a number with int(), combining conditions with and, or and not, and testing edge values.

    6 min

  27. 26

    KS3 · Chapter 9 · Python decisions and loops

    Loops

    Iteration in Python: for loops with range(), start, stop and step, while loops that repeat while a condition is True, running totals, loops that keep asking for input, infinite loops and break.

    6 min

  28. 27

    KS3 · Chapter 9 · Python decisions and loops

    Quiz game project

    A first Python project: plan a quiz game, build it step by step with variables, if and loops, use the right data types, and test it with a test plan using normal, boundary and erroneous data.

    8 min

  29. 28

    KS3 · Chapter 10 · Networks and the internet

    How data travels

    Networks and the internet: LAN and WAN, switches, routers, wireless access points and NICs, wired and wireless connections, packets and packet switching, IP addresses, bandwidth and transfer time.

    7 min

  30. 29

    KS3 · Chapter 10 · Networks and the internet

    The web and social media

    The internet and the World Wide Web, parts of a URL, how DNS and web servers deliver a page, HTTPS and the padlock, spotting fake links, digital footprint, posting safely and checking whether information is reliable.

    7 min

  31. 30

    KS3 · Chapter 11 · Web pages

    HTML

    Writing web pages in HTML: tags and elements, headings, paragraphs, bold and italic, lists, links and images with attributes (href, src, alt), the structure of a whole page with head and body, nesting, and finding bugs in HTML.

    6 min

  32. 31

    KS3 · Chapter 11 · Web pages

    CSS

    Styling web pages with CSS: rules, selectors, properties and values, colours by name and hex code, fonts and sizes, alignment, borders, padding and margin, class and id selectors, and linking an external stylesheet.

    5 min

  33. 32

    KS3 · Chapter 12 · Boolean logic

    Logic gates

    Boolean logic: 1 and 0 as True and False, the AND, OR and NOT gates with their symbols and truth tables, logic expressions from real rules, and circuits that join two gates.

    6 min

  34. 33

    KS3 · Office skills (Year 8)

    Reports in Word

    Long documents in Word and Google Docs: Title and heading styles, the navigation pane, an automatic table of contents and how to update it, page breaks, headers, footers and page numbers, captions, footnotes and sources, and Find and Replace with Match case and Find whole words only.

    8 min

  35. 34

    KS3 · Office skills (Year 8)

    Teamwork and sharing

    Working as a team on a presentation in the cloud: editing at the same time, comments, resolving and @mentions, version history, sharing access (Viewer, Commenter, Editor), access requests, and sending work by email with an attachment or a link, To and Cc and a clear subject.

    6 min

  36. 35

    KS3 · Python restart (Year 9)

    Hello Python

    A fresh start in Python: what a program is, the editor, print, text and numbers, comments, variables and the types int, float and str, input() and int(), and how to read SyntaxError, NameError, TypeError and ValueError.

    8 min

  37. 36

    KS3 · Python restart (Year 9)

    Decisions

    Selection in Python: conditions that are True or False, the comparison operators, = versus ==, if, elif and else with colons and indentation, only the first True branch runs, and combining conditions with and, or and not.

    5 min

  38. 37

    KS3 · Python restart (Year 9)

    Loops

    Iteration in Python: for loops with range(), which numbers range gives, while loops that repeat while a condition is True, infinite loops and how to avoid them, counters and running totals.

    6 min

  39. 38

    KS3 · Chapter 13 · Python: lists, strings, functions

    Lists

    Python lists: storing many values in one variable, indexes from 0, negative indexes, len, IndexError, append, insert, remove, pop, changing an item, looping through a list with for, in, sum, max, min and sorted.

    5 min

  40. 39

    KS3 · Chapter 13 · Python: lists, strings, functions

    Strings

    Python strings: characters and indexes, negative indexes, len, slicing with [a:b], [:b] and [a:], string methods upper, lower, strip, replace and count, the in operator, joining strings with + and str(), looping through the characters, and why a string cannot be changed in place.

    5 min

  41. 40

    KS3 · Chapter 13 · Python: lists, strings, functions

    Functions

    Python functions: defining a function with def, parameters and arguments, calling a function, return compared with print, None, the order in which Python runs the lines, local variables, functions that call other functions, and testing a function.

    5 min

  42. 41

    KS3 · Chapter 13 · Python: lists, strings, functions

    Mini project

    A Python mini project: understanding a problem as input, process and output, decomposition into functions, good function names, building and testing one function at a time with a test table, error messages (SyntaxError, NameError, IndexError, TypeError), logic errors, expected and actual output, and debugging step by step.

    7 min

  43. 42

    KS3 · Chapter 14 · Searching and sorting

    Searching

    Searching algorithms: linear search on any list, binary search on a sorted list with low, high and mid, worst-case number of checks, not found and -1, linear and binary search in Python, and trace tables for both searches.

    7 min

  44. 43

    KS3 · Chapter 14 · Searching and sorting

    Sorting

    Sorting algorithms: bubble sort with passes, swaps and stopping after a pass with no swaps, insertion sort, merge sort by splitting and merging, comparing their speed, bubble sort in Python, and Python's sorted() and .sort().

    7 min

  45. 44

    KS3 · Chapter 15 · Databases

    Databases

    Databases: tables, records and fields, data types (text, integer, real, Boolean, date), primary keys, why databases beat paper and spreadsheets for big data, SQL queries with SELECT, FROM, WHERE, ORDER BY, AND and OR, and a first database in Python with sqlite3.

    8 min

  46. 45

    KS3 · Chapter 16 · Sound, images and compression

    Sound, images, compression

    How computers store images and sound in binary: pixels, colour depth, resolution and image file size; sampling, sample rate, sample resolution and sound file size; bits and bytes; lossy and lossless compression; run-length encoding.

    7 min

  47. 46

    KS3 · Chapter 17 · Inside the computer

    The CPU and memory

    What the CPU does and how it runs a program: the control unit, the ALU and the registers (PC, MAR, MDR, ACC); the fetch, decode, execute cycle; clock speed, cores and cache; RAM, ROM and cache; volatile and non-volatile memory; secondary storage: hard disk, SSD and optical.

    8 min

  48. 47

    KS3 · Chapter 17 · Inside the computer

    The operating system

    What an operating system does: managing processes and multitasking, memory, files, devices with drivers, security and the user interface; interrupts; GUI and command line with the commands ls, cd, pwd, cat, mkdir and mv; file paths; system, utility and application software.

    6 min

  49. 48

    KS3 · Chapter 18 · Cyber security

    Cyber threats

    The threats to computers and people online: malware (virus, worm, Trojan, ransomware, spyware, adware); social engineering, phishing and its red flags, pharming and shoulder surfing; brute force attacks, denial of service (DoS and DDoS), hacking and data interception.

    6 min

  50. 49

    KS3 · Chapter 18 · Cyber security

    Protecting systems

    How to protect people and computers: strong passwords and passphrases, why length beats complexity against brute force, password managers, two-factor authentication and biometrics; firewalls and their rules; anti-malware and quarantine; updates; encryption; backups and the 3-2-1 rule; access rights and physical security.

    6 min

  51. 50

    KS3 · Chapter 19 · AI and ethics

    AI and ethics

    What artificial intelligence and machine learning are: training data, labels, training and testing, accuracy; bias and garbage in, garbage out; generative AI, chatbots, hallucinations and deepfakes; using AI fairly at school; privacy, computer misuse and copyright laws.

    7 min

  52. 51

    KS3 · Chapter 20 · Bridge to IGCSE

    Pseudocode

    Writing algorithms in IGCSE-style pseudocode: assignment with the arrow, INPUT and OUTPUT, data types and DECLARE, IF THEN ELSE ENDIF, FOR TO NEXT, WHILE DO ENDWHILE, REPEAT UNTIL; turning Python into pseudocode; common exam mistakes and how to avoid them.

    5 min

  53. 52

    KS3 · Office skills (Year 9)

    Data analysis in Excel

    Analysing real data in a spreadsheet: COUNTIF, SUMIF and AVERAGEIF with text, number and comparison criteria; pivot tables with Rows, Values and Sum, Count or Average; conditional formatting, filters and sorting; drawing honest conclusions from a survey.

    6 min

  54. 53

    KS3 · Office skills (Year 9)

    Professional project

    Running a real project with Office tools: mail merge in Word from an Excel list (merge fields, preview, filter, finish and merge); choosing Word, Excel or PowerPoint for each job; sharing one online copy, exporting PDF, linking an Excel chart with Paste Link; plans with owners and deadlines, clear file names and professional emails.

    5 min

  55. 54

    IGCSE · 1 Data representation

    Number systems

    Why computers work in binary, how to convert between denary, binary and hexadecimal, where hexadecimal is used, binary addition and overflow, logical shifts and two’s complement for negative numbers.

    27 min · 6 IGCSE exam questions

  56. 55

    IGCSE · 1 Data representation

    Text, sound and images

    How a computer turns text, sound and pictures into binary: character sets (ASCII, extended ASCII and Unicode), sampling sound with a sample rate and sample resolution, and bitmap images with resolution and colour depth.

    21 min · 5 IGCSE exam questions

  57. 56

    IGCSE · 1 Data representation

    Data storage and file compression

    How data storage is measured from bits to exbibytes, how to calculate the size of image and sound files, why files are compressed, and how lossy and lossless compression (including run length encoding) work.

    21 min · 6 IGCSE exam questions

  58. 57

    IGCSE · 2 Data transmission

    Types and methods of data transmission

    How data is split into packets, what a packet contains, how packet switching works, the differences between serial and parallel and between simplex, half-duplex and full-duplex transmission, and how USB transmits data.

    22 min · 5 IGCSE exam questions

  59. 58

    IGCSE · 2 Data transmission

    Methods of error detection

    Why errors happen when data is transmitted and how they are detected: parity checks (odd and even, parity byte and parity block), checksums, echo checks, check digits for data entry (ISBN and barcodes) and automatic repeat queries (ARQ).

    24 min · 5 IGCSE exam questions

  60. 59

    IGCSE · 2 Data transmission

    Symmetric and asymmetric encryption

    Why data is encrypted before it travels across a network, what plaintext, ciphertext and keys are, how symmetric encryption works and why sharing its key is risky, and how asymmetric encryption solves this with a public key and a private key.

    20 min · 4 IGCSE exam questions

  61. 60

    IGCSE · 3 Hardware

    Computer architecture

    What the CPU does, the stored-program idea behind the Von Neumann architecture, the ALU, control unit, registers and buses, the fetch–decode–execute cycle, how cores, cache and the clock affect performance, instruction sets and embedded systems.

    29 min · 5 IGCSE exam questions

  62. 61

    IGCSE · 3 Hardware

    Input and output devices

    How the main input devices (barcode and QR code scanners, digital cameras, keyboards, microphones, optical mice, 2D and 3D scanners, touch screens) and output devices (actuators, DLP and LCD projectors, inkjet, laser and 3D printers, LED and LCD screens, speakers) work, and how sensors are used in monitoring and control.

    53 min · 5 IGCSE exam questions

  63. 62

    IGCSE · 3 Hardware

    Data storage

    Primary memory (RAM and ROM, DRAM and SRAM), secondary storage, how magnetic, optical and solid-state storage work, virtual memory and paging, and the pros and cons of cloud storage.

    37 min · 5 IGCSE exam questions

  64. 63

    IGCSE · 3 Hardware

    Network hardware

    How a device joins a network: the network interface card, the MAC address and its structure, IP addresses (IPv4 and IPv6, static and dynamic, public and private) and the role of a router.

    25 min · 4 IGCSE exam questions

  65. 64

    IGCSE · 4 Software

    Types of software and interrupts

    System software and application software, utility programs and device drivers, the role and functions of an operating system, how hardware, firmware and the operating system work together to run applications, and how interrupts are generated and handled.

    34 min · 5 IGCSE exam questions

  66. 65

    IGCSE · 4 Software

    Programming languages, translators and IDEs

    High-level and low-level languages and their pros and cons, assembly language and assemblers, how compilers and interpreters translate code and report errors, and the functions of an integrated development environment (IDE).

    23 min · 5 IGCSE exam questions

  67. 66

    IGCSE · 5 The internet and its uses

    The internet and the World Wide Web

    The difference between the internet and the web, the parts of a URL, HTTP and HTTPS, what a web browser does, how DNS helps a browser find and display a web page, and how session and persistent cookies are used.

    24 min · 4 IGCSE exam questions

  68. 67

    IGCSE · 5 The internet and its uses

    Digital currency

    What a digital currency is and how it is used, how centralised digital money differs from decentralised cryptocurrency, and how a blockchain uses hashes, time-stamps and proof-of-work to record transactions that cannot be altered.

    20 min · 4 IGCSE exam questions

  69. 68

    IGCSE · 5 The internet and its uses

    Cyber security

    The main cyber security threats (brute-force attacks, data interception, DDoS, hacking, malware, phishing, pharming and social engineering), what attackers aim to do, and the solutions that keep data safe, from access levels and authentication to firewalls, proxy servers and SSL.

    52 min · 6 IGCSE exam questions

  70. 69

    IGCSE · 6 Automated and emerging technologies

    Automated systems

    How sensors, microprocessors and actuators work together to make automated systems, and the advantages and disadvantages of automated systems in industry, transport, agriculture, weather, gaming, lighting and science.

    31 min · 4 IGCSE exam questions

  71. 70

    IGCSE · 6 Automated and emerging technologies

    Robotics

    What makes a machine a robot? The meaning of robotics, the three characteristics of a robot, independent and dependent robots, and the roles, advantages and disadvantages of robots in industry, transport, agriculture, medicine, the home and entertainment.

    30 min · 6 IGCSE exam questions

  72. 71

    IGCSE · 6 Automated and emerging technologies

    Artificial intelligence

    What is artificial intelligence and what makes a system intelligent? The characteristics of AI, examples in daily life, how an expert system works (interface, knowledge base, rule base, inference engine) and what machine learning is.

    24 min · 6 IGCSE exam questions

  73. 72

    IGCSE · 7 Algorithm design and problem-solving

    The program development life cycle

    How a program is created, step by step: the analysis, design, coding and testing stages of the program development life cycle, with abstraction, decomposition and iterative testing.

    10 min · 6 IGCSE exam questions

  74. 73

    IGCSE · 7 Algorithm design and problem-solving

    Computer systems, sub-systems and decomposition

    How big problems are broken down: computer systems and sub-systems, top-down design, decomposing a problem into inputs, processes, outputs and storage, and the three design methods: structure diagrams, flowcharts and pseudocode.

    19 min · 6 IGCSE exam questions

  75. 74

    IGCSE · 7 Algorithm design and problem-solving

    Explaining the purpose of an algorithm

    How to read a flowchart or pseudocode you have never seen before, state what it is for, and describe the processes it carries out.

    10 min · 3 IGCSE exam questions

  76. 75

    IGCSE · 7 Algorithm design and problem-solving

    Standard methods of solution

    The building blocks that appear in almost every exam algorithm: totalling, counting, finding the maximum, minimum and average, linear search and bubble sort, in pseudocode with worked examples.

    14 min · 5 IGCSE exam questions

  77. 76

    IGCSE · 7 Algorithm design and problem-solving

    Validation and verification

    Why input data must be checked: the validation checks (range, length, type, presence, format, check digit) with pseudocode, and the verification checks (double entry and visual check).

    16 min · 6 IGCSE exam questions

  78. 77

    IGCSE · 7 Algorithm design and problem-solving

    Test data

    How to test that an algorithm or program works: choosing normal, abnormal, extreme and boundary test data, with expected results.

    10 min · 5 IGCSE exam questions

  79. 78

    IGCSE · 7 Algorithm design and problem-solving

    Trace tables

    How to dry-run an algorithm and record every change of every variable, every output and every prompt in a trace table, from flowcharts and pseudocode.

    10 min · 3 IGCSE exam questions

  80. 79

    IGCSE · 7 Algorithm design and problem-solving

    Identifying errors in algorithms

    How to find and fix mistakes in flowcharts and pseudocode: using trace tables and test data, the common kinds of error, and how to write precise corrections.

    10 min · 6 IGCSE exam questions

  81. 80

    IGCSE · 7 Algorithm design and problem-solving

    Writing and amending algorithms

    How to go from a problem to an algorithm that works: the stages of writing an algorithm, precise pseudocode and flowcharts, choosing and using test data, trace tables, and finding and fixing errors in a given algorithm.

    31 min · 5 IGCSE exam questions

  82. 81

    IGCSE · 8 Programming

    Programming concepts

    The building blocks of every program: variables and constants, data types, input and output, sequence, selection, iteration, totalling and counting, string handling, operators, nested statements, procedures and functions, local and global variables, library routines and maintainable code.

    35 min · 6 IGCSE exam questions

  83. 82

    IGCSE · 8 Programming

    Arrays

    How to store many values under one name: declaring one-dimensional and two-dimensional arrays, using indexes and variables as indexes, and reading and writing whole arrays with loops and nested loops.

    16 min · 5 IGCSE exam questions

  84. 83

    IGCSE · 8 Programming

    File handling

    Why programs store data in files, and how to open, read from, write to and close a text file in pseudocode and in a real language, for single items of data and for lines of text.

    14 min · 6 IGCSE exam questions

  85. 84

    IGCSE · 9 Databases

    Databases

    What a single-table database is, how records and fields are organised, which data type suits each field, why every table needs a primary key, and how to read, write and complete SQL queries with SELECT, FROM, WHERE, ORDER BY, SUM and COUNT.

    29 min · 4 IGCSE exam questions

  86. 85

    IGCSE · 10 Boolean logic

    Standard logic gate symbols

    What logic gates and logic circuits are, how to recognise and draw the standard symbols for NOT, AND, OR, NAND, NOR and XOR, and how to set out every possible input of a truth table.

    13 min · 3 IGCSE exam questions

  87. 86

    IGCSE · 10 Boolean logic

    The function of the six logic gates

    What NOT, AND, OR, NAND, NOR and XOR each do: a definition, the full truth table, the logic expression and the optional Boolean algebra notation for every gate.

    15 min · 3 IGCSE exam questions

  88. 87

    IGCSE · 10 Boolean logic

    Logic circuits, logic expressions, truth tables and problem statements

    How to move between the four ways of describing logic: draw a circuit from a problem, an expression or a truth table; complete a truth table from a problem, an expression or a circuit; and write a logic expression from a problem, a circuit or a truth table.

    29 min · 5 IGCSE exam questions

  89. 88

    Beyond IGCSE · AI & Prompting

    How AI chatbots work

    What a large language model really does: tokens, next-token prediction, training, why chatbots make things up, how a chat ‘remembers’, and the difference between cloud AI and a local model like Qwen2.5-Coder.

    19 min

  90. 89

    Beyond IGCSE · AI & Prompting

    Your local AI coding assistant

    Install Ollama and a coding model on your own computer, ask it for Python code in the terminal, paste code into your prompts, choose a low temperature for code, and save your own coding assistant with a Modelfile.

    16 min

  91. 90

    Beyond IGCSE · AI & Prompting

    Prompting basics

    The five ingredients of a good prompt (role, task, context, format, examples), how to turn a vague request for code into a precise one, few-shot examples, and how to keep a prompt log.

    13 min

  92. 91

    Beyond IGCSE · AI & Prompting

    Better prompts for code: plan, context and debugging

    Prompting techniques for writing real programs with AI: ask for a plan before the code, give the assistant your code and rules, choose the shape of the answer, debug with a complete bug report, and never trust code you have not read, run and tested.

    12 min

  93. 92

    Beyond IGCSE · AI & Prompting

    Using AI responsibly

    Honesty at school and how to declare AI use, checking facts, bias and stereotypes, privacy and personal data, licences for code and game assets, energy use and safe content, applied to a game written with AI.

    14 min

  94. 93

    Beyond IGCSE · AI & Prompting

    Coding with AI: your first Pygame program

    Ask your assistant for your first Pygame programs, then understand what it wrote: the game loop (events, update, draw), screen coordinates, shapes and text, moving with the keyboard and collisions, with the step-by-step coding workflow you will use for the whole project.

    12 min

  95. 94

    Beyond IGCSE · AI & Prompting

    Managing a project from A to Z with GitHub

    The life cycle of a project, writing a brief and requirements, MoSCoW and user stories, planning in sprints on a Kanban board, and using Git and GitHub (repository, commits, push, Issues, Projects, milestones) for the Sky Lantern game, coded entirely with AI.

    18 min

  96. 95

    Beyond IGCSE · AI & Prompting

    Project sprint 1: the night sky

    First sprint of Sky Lantern, coded entirely with your AI assistant: plan the issues, prompt for the settings, the night sky and the lantern, move it smoothly with dt, understand the code you received, test, commit and hold a sprint review.

    15 min

  97. 96

    Beyond IGCSE · AI & Prompting

    Project sprint 2: the gameplay

    Second sprint of Sky Lantern, coded entirely with AI: falling stars and a score, rain and lives, levels that get faster, birds and lightning planned before they are coded, and power-ups, with the prompts for each step and the ideas you must understand in the code.

    16 min

  98. 97

    Beyond IGCSE · AI & Prompting

    Project sprint 3: a complete game

    Final sprint of Sky Lantern: plan the game states, prompt for the title, help, pause and game over screens, a saved best score and sound effects made by code, build your challenges from the menu, then test, playtest, balance and present the game and how you directed the AI.

    17 min

How these lessons work

Each lesson covers one topic of the 0478 syllabus (2026–2028). Facts, conversions, truth tables and algorithms are checked. The lessons are written in English, the language of the exam, and use the Cambridge pseudocode style.

Test yourself with the quiz