# Cambridge IGCSE™ Computer Science (0478 / 0984) (CAMBRIDGE IGCSE 0478) > Study the Cambridge IGCSE syllabus through focused lessons, worked examples, structured checks and independent programming practice. Covers computer systems, problem-solving, databases and Boolean logic, with mixed reviews and guidance for written and diagram practice. - **Slug:** `igcse-0478` - **Total Modules:** 10 - **Total Lessons:** 109 - **URL:** https://csmasters.dev/tracks/igcse-0478 --- ## Syllabus Curriculum Modules ### Module 1: Section 1: Data Representation Binary data representation, number conversions (Denary, Binary, Hexadecimal), 8-bit addition & overflow, logical shifts, two's complement, ASCII/Unicode character sets, sound sampling, bitmap graphics calculation, storage measurement units (KiB/MiB), and lossy/lossless RLE compression. - **Lesson 1.1:** [1.0 Module Overview: Data Representation](https://csmasters.dev/learn/igcse-0478/data-representation-overview.md) - Estimated: 5 mins | XP Reward: 5 | Free Practice - **Lesson 1.2:** [Number Systems & Base Conversions](https://csmasters.dev/learn/igcse-0478/number-systems-and-conversions.md) - Estimated: 15 mins | XP Reward: 120 | Free Practice - **Lesson 1.3:** [Binary Addition & Overflow Errors](https://csmasters.dev/learn/igcse-0478/binary-addition-and-overflow.md) - Estimated: 15 mins | XP Reward: 90 | Free Practice - **Lesson 1.4:** [Logical Binary Shifts](https://csmasters.dev/learn/igcse-0478/logical-binary-shifts.md) - Estimated: 15 mins | XP Reward: 90 | Free Practice - **Lesson 1.5:** [Two's Complement Signed Integers](https://csmasters.dev/learn/igcse-0478/twos-complement-representation.md) - Estimated: 15 mins | XP Reward: 90 | Free Practice - **Lesson 1.6:** [Text Representation: ASCII & Unicode](https://csmasters.dev/learn/igcse-0478/text-representation-ascii-unicode.md) - Estimated: 15 mins | XP Reward: 95 | Free Practice - **Lesson 1.7:** [Storage Measurement Units (KiB, MiB, GiB)](https://csmasters.dev/learn/igcse-0478/data-storage-units-and-calculations.md) - Estimated: 15 mins | XP Reward: 90 | Free Practice - **Lesson 1.8:** [Sound Sampling & Representation](https://csmasters.dev/learn/igcse-0478/sound-sampling-and-representation.md) - Estimated: 15 mins | XP Reward: 90 | Free Practice - **Lesson 1.9:** [Bitmap Graphics & Pixel Calculations](https://csmasters.dev/learn/igcse-0478/image-representation-and-pixels.md) - Estimated: 15 mins | XP Reward: 90 | Free Practice - **Lesson 1.10:** [Data Compression: Lossy vs Lossless (RLE)](https://csmasters.dev/learn/igcse-0478/compression-lossy-and-lossless.md) - Estimated: 15 mins | XP Reward: 90 | Free Practice - **Lesson 1.11:** [Mixed Practice: Data Representation](https://csmasters.dev/learn/igcse-0478/representation-review.md) - Estimated: 20 mins | XP Reward: 30 | Free Practice ### Module 2: Section 2: Data Transmission Packet switching and packet structure, data transmission methods (serial, parallel, simplex, half-duplex, full-duplex), Universal Serial Bus (USB), error detection methods (parity checks, checksums, echo checks, check digits, ARQ), and symmetric vs asymmetric encryption. - **Lesson 2.1:** [2.0 Module Overview: Data Transmission](https://csmasters.dev/learn/igcse-0478/data-transmission-overview.md) - Estimated: 5 mins | XP Reward: 5 | Open Theory (All-Access Practice) - **Lesson 2.2:** [Packet Switching & Packet Structure](https://csmasters.dev/learn/igcse-0478/packet-switching-and-structure.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 2.3:** [Transmission Methods and Directions](https://csmasters.dev/learn/igcse-0478/transmission-methods-and-usb.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 2.4:** [USB Interfaces](https://csmasters.dev/learn/igcse-0478/usb-interfaces.md) - Estimated: 10 mins | XP Reward: 30 | Open Theory (All-Access Practice) - **Lesson 2.5:** [Error Detection: Parity Checks & Parity Blocks](https://csmasters.dev/learn/igcse-0478/error-detection-parity-checks.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 2.6:** [Parity Blocks](https://csmasters.dev/learn/igcse-0478/parity-blocks.md) - Estimated: 15 mins | XP Reward: 60 | Open Theory (All-Access Practice) - **Lesson 2.7:** [Checksums, Echo Checks & Check Digits](https://csmasters.dev/learn/igcse-0478/checksum-echo-check-digits.md) - Estimated: 15 mins | XP Reward: 85 | Open Theory (All-Access Practice) - **Lesson 2.8:** [Automatic Repeat reQuest (ARQ)](https://csmasters.dev/learn/igcse-0478/automatic-repeat-requests-arq.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 2.9:** [Symmetric & Asymmetric Encryption](https://csmasters.dev/learn/igcse-0478/symmetric-and-asymmetric-encryption.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 2.10:** [Mixed Practice: Data Transmission](https://csmasters.dev/learn/igcse-0478/transmission-review.md) - Estimated: 20 mins | XP Reward: 30 | Open Theory (All-Access Practice) ### Module 3: Section 3: Hardware & Architecture Von Neumann CPU architecture, registers (PC, MAR, MDR, CIR, ACC), the Fetch-Decode-Execute (FDE) cycle, CPU cores/cache/clock speed, instruction sets, embedded systems, input/output peripherals, sensors, primary RAM/ROM, and secondary magnetic/optical/SSD storage technologies. - **Lesson 3.1:** [3.0 Module Overview: Hardware](https://csmasters.dev/learn/igcse-0478/hardware-overview.md) - Estimated: 5 mins | XP Reward: 5 | Open Theory (All-Access Practice) - **Lesson 3.2:** [CPU Architecture & Von Neumann Architecture](https://csmasters.dev/learn/igcse-0478/cpu-architecture-von-neumann.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 3.3:** [The Fetch-Decode-Execute (FDE) Cycle](https://csmasters.dev/learn/igcse-0478/fetch-decode-execute-cycle.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 3.4:** [CPU Performance Factors](https://csmasters.dev/learn/igcse-0478/cpu-performance-factors.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 3.5:** [Instruction Sets & Machine Code](https://csmasters.dev/learn/igcse-0478/instruction-sets-machine-code.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 3.6:** [Embedded Systems](https://csmasters.dev/learn/igcse-0478/embedded-systems.md) - Estimated: 10 mins | XP Reward: 60 | Open Theory (All-Access Practice) - **Lesson 3.7:** [Input Devices](https://csmasters.dev/learn/igcse-0478/input-devices-and-sensors.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 3.8:** [Touchscreen Technologies](https://csmasters.dev/learn/igcse-0478/touchscreen-technologies.md) - Estimated: 15 mins | XP Reward: 30 | Open Theory (All-Access Practice) - **Lesson 3.9:** [Sensors in Context](https://csmasters.dev/learn/igcse-0478/sensors-in-context.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 3.10:** [Output Devices & Actuators](https://csmasters.dev/learn/igcse-0478/output-devices-and-actuators.md) - Estimated: 15 mins | XP Reward: 85 | Open Theory (All-Access Practice) - **Lesson 3.11:** [Printing Technologies](https://csmasters.dev/learn/igcse-0478/printing-technologies.md) - Estimated: 10 mins | XP Reward: 30 | Open Theory (All-Access Practice) - **Lesson 3.12:** [Primary Storage: RAM, ROM & Virtual Memory](https://csmasters.dev/learn/igcse-0478/primary-storage-ram-rom.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 3.13:** [Secondary Storage Technologies](https://csmasters.dev/learn/igcse-0478/secondary-storage-technologies.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 3.14:** [Cloud and Local Storage](https://csmasters.dev/learn/igcse-0478/cloud-storage.md) - Estimated: 10 mins | XP Reward: 30 | Open Theory (All-Access Practice) - **Lesson 3.15:** [Network Hardware and Addresses](https://csmasters.dev/learn/igcse-0478/network-hardware.md) - Estimated: 10 mins | XP Reward: 30 | Open Theory (All-Access Practice) - **Lesson 3.16:** [Mixed Practice: Hardware](https://csmasters.dev/learn/igcse-0478/hardware-review.md) - Estimated: 20 mins | XP Reward: 30 | Open Theory (All-Access Practice) ### Module 4: Section 4: Software & Translators System software vs application software, operating system functions, hardware-firmware-OS layering, hardware and software interrupts, high-level vs low-level languages, compilers, interpreters, assemblers, and Integrated Development Environment (IDE) tools. - **Lesson 4.1:** [4.0 Module Overview: Software](https://csmasters.dev/learn/igcse-0478/software-overview.md) - Estimated: 5 mins | XP Reward: 5 | Open Theory (All-Access Practice) - **Lesson 4.2:** [Types of Software: System vs Application](https://csmasters.dev/learn/igcse-0478/types-of-software.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 4.3:** [From Hardware to Applications](https://csmasters.dev/learn/igcse-0478/firmware-and-startup.md) - Estimated: 10 mins | XP Reward: 30 | Open Theory (All-Access Practice) - **Lesson 4.4:** [Operating System Functions](https://csmasters.dev/learn/igcse-0478/operating-system-functions.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 4.5:** [Hardware & Software Interrupts](https://csmasters.dev/learn/igcse-0478/hardware-and-software-interrupts.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 4.6:** [Programming Languages: High-Level vs Low-Level](https://csmasters.dev/learn/igcse-0478/programming-languages-high-low.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 4.7:** [Translators: Compilers, Interpreters & Assemblers](https://csmasters.dev/learn/igcse-0478/language-translators.md) - Estimated: 15 mins | XP Reward: 95 | Open Theory (All-Access Practice) - **Lesson 4.8:** [Integrated Development Environments](https://csmasters.dev/learn/igcse-0478/ide-tools.md) - Estimated: 10 mins | XP Reward: 60 | Open Theory (All-Access Practice) - **Lesson 4.9:** [Mixed Practice: Software](https://csmasters.dev/learn/igcse-0478/software-review.md) - Estimated: 20 mins | XP Reward: 30 | Open Theory (All-Access Practice) ### Module 5: Section 5: The Internet & Security Internet vs World Wide Web, URL architecture, HTTP/HTTPS protocols, web browsers, cookies, blockchain & digital currencies, cyber security threats (malware, phishing, pharming, DoS), and defensive solutions (firewalls, proxy servers, SSL/TLS, 2FA). - **Lesson 5.1:** [5.0 Module Overview: The Internet & its Uses](https://csmasters.dev/learn/igcse-0478/the-internet-and-its-uses-overview.md) - Estimated: 5 mins | XP Reward: 5 | Open Theory (All-Access Practice) - **Lesson 5.2:** [The Internet & World Wide Web (IP & MAC Addresses)](https://csmasters.dev/learn/igcse-0478/the-internet-and-world-wide-web.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 5.3:** [HTTP, HTTPS & Web Page Retrieval](https://csmasters.dev/learn/igcse-0478/http-https-and-web-retrieval.md) - Estimated: 15 mins | XP Reward: 95 | Open Theory (All-Access Practice) - **Lesson 5.4:** [Web Browsers & Cookies](https://csmasters.dev/learn/igcse-0478/web-browsers-and-cookies.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 5.5:** [Digital Currency and Blockchain](https://csmasters.dev/learn/igcse-0478/digital-currency-and-blockchain.md) - Estimated: 10 mins | XP Reward: 60 | Open Theory (All-Access Practice) - **Lesson 5.6:** [Digital Cyber Threats & Malware](https://csmasters.dev/learn/igcse-0478/digital-cyber-threats.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 5.7:** [Security Defences: Firewalls, Proxies & SSL/TLS](https://csmasters.dev/learn/igcse-0478/security-defences-and-firewalls.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 5.8:** [Mixed Practice: Internet and Security](https://csmasters.dev/learn/igcse-0478/internet-review.md) - Estimated: 20 mins | XP Reward: 30 | Open Theory (All-Access Practice) ### Module 6: Section 6: Automated Systems & AI Automated sensor-processor-actuator control loops, industrial and service robotics, artificial intelligence principles, machine learning adaptability, and expert systems architecture. - **Lesson 6.1:** [6.0 Module Overview: Automated & Emerging Technologies](https://csmasters.dev/learn/igcse-0478/automated-and-emerging-technologies-overview.md) - Estimated: 5 mins | XP Reward: 5 | Open Theory (All-Access Practice) - **Lesson 6.2:** [Automated Systems & Feedback Control Loops](https://csmasters.dev/learn/igcse-0478/automated-feedback-systems.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 6.3:** [Industrial & Service Robotics](https://csmasters.dev/learn/igcse-0478/industrial-and-service-robotics.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 6.4:** [Artificial Intelligence & Expert Systems](https://csmasters.dev/learn/igcse-0478/artificial-intelligence-expert-systems.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 6.5:** [Machine Learning & The Ethics of AI](https://csmasters.dev/learn/igcse-0478/machine-learning-and-ethics.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 6.6:** [Mixed Practice: Automated Systems](https://csmasters.dev/learn/igcse-0478/automation-review.md) - Estimated: 20 mins | XP Reward: 30 | Open Theory (All-Access Practice) ### Module 7: Section 8: Programming Concepts & File Handling Variables, constants, 5 data types, assignments, IF/CASE selection, FOR/WHILE/REPEAT loops, string routines, procedures & functions (up to 3 params), scope, 1D/2D arrays, and sequential text files. - **Lesson 7.1:** [8.0 Module Overview: Programming Concepts and File Handling](https://csmasters.dev/learn/igcse-0478/00-programming-concepts-overview.md) - Estimated: 5 mins | XP Reward: 5 | Open Theory (All-Access Practice) - **Lesson 7.2:** [Variables, Data Types & OUTPUT in Cambridge Pseudocode](https://csmasters.dev/learn/igcse-0478/variables-and-output.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 7.3:** [Constants, Scope & Value Protection](https://csmasters.dev/learn/igcse-0478/constants-and-scope.md) - Estimated: 10 mins | XP Reward: 85 | Open Theory (All-Access Practice) - **Lesson 7.4:** [User Input & Standard Arithmetic Operations](https://csmasters.dev/learn/igcse-0478/user-input-and-arithmetic.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 7.5:** [Integer Division: DIV (Quotient) & MOD (Remainder)](https://csmasters.dev/learn/igcse-0478/arithmetic-div-mod.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 7.6:** [Library Routines: ROUND and RANDOM](https://csmasters.dev/learn/igcse-0478/library-routines.md) - Estimated: 10 mins | XP Reward: 60 | Open Theory (All-Access Practice) - **Lesson 7.7:** [Selection & Decision Making (IF ... THEN ... ELSE)](https://csmasters.dev/learn/igcse-0478/selection-if-statements.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 7.8:** [Multi-Way Selection (CASE OF ... OTHERWISE ... ENDCASE)](https://csmasters.dev/learn/igcse-0478/selection-case-statements.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 7.9:** [Count-Controlled Loops (FOR ... TO ... NEXT)](https://csmasters.dev/learn/igcse-0478/count-controlled-loops.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 7.10:** [Post-Condition Loops (REPEAT ... UNTIL)](https://csmasters.dev/learn/igcse-0478/post-condition-repeat-loops.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 7.11:** [Pre-Condition Loops (WHILE ... DO ... ENDWHILE)](https://csmasters.dev/learn/igcse-0478/trace-tables-and-while-loops.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 7.12:** [Nested Loops & Multidimensional Iteration](https://csmasters.dev/learn/igcse-0478/nested-loop-constructs.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 7.13:** [String Handling Functions (LENGTH, SUBSTRING, UCASE, LCASE)](https://csmasters.dev/learn/igcse-0478/string-handling-routines.md) - Estimated: 10 mins | XP Reward: 85 | Open Theory (All-Access Practice) - **Lesson 7.14:** [1D Arrays & 1-Based Indexing](https://csmasters.dev/learn/igcse-0478/one-dimensional-arrays.md) - Estimated: 10 mins | XP Reward: 85 | Open Theory (All-Access Practice) - **Lesson 7.15:** [2D Arrays & Matrix Grid Iteration](https://csmasters.dev/learn/igcse-0478/two-dimensional-arrays.md) - Estimated: 20 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 7.16:** [Procedures & Parameter Passing](https://csmasters.dev/learn/igcse-0478/procedures-and-parameters.md) - Estimated: 10 mins | XP Reward: 115 | Open Theory (All-Access Practice) - **Lesson 7.17:** [Functions & Return Values](https://csmasters.dev/learn/igcse-0478/functions-and-return-values.md) - Estimated: 15 mins | XP Reward: 95 | Open Theory (All-Access Practice) - **Lesson 7.18:** [Sequential File Handling (OPENFILE, READFILE, WRITEFILE)](https://csmasters.dev/learn/igcse-0478/sequential-file-handling.md) - Estimated: 20 mins | XP Reward: 95 | Open Theory (All-Access Practice) - **Lesson 7.19:** [Mixed Practice: Programming](https://csmasters.dev/learn/igcse-0478/programming-review.md) - Estimated: 20 mins | XP Reward: 30 | Open Theory (All-Access Practice) - **Lesson 7.20:** [Independent Scenario: Club Results](https://csmasters.dev/learn/igcse-0478/integrated-scenario-scores.md) - Estimated: 30 mins | XP Reward: 30 | Open Theory (All-Access Practice) ### Module 8: Section 7: Algorithm Design & Problem-Solving Program Development Life Cycle (PDLC), IPOS decomposition, ISO flowcharts, algorithm comprehension, linear search, bubble sort, totalling/counting, validation/verification, test data, and trace tables. - **Lesson 8.1:** [7.0 Module Overview: Algorithm Design and Problem-Solving](https://csmasters.dev/learn/igcse-0478/00-algorithm-design-and-problem-solving-overview.md) - Estimated: 5 mins | XP Reward: 5 | Open Theory (All-Access Practice) - **Lesson 8.2:** [Program Development Life Cycle (Analysis, Design, Coding, Testing)](https://csmasters.dev/learn/igcse-0478/pdlc-stages.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 8.3:** [System Decomposition & Structure Charts](https://csmasters.dev/learn/igcse-0478/system-decomposition.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 8.4:** [Cambridge Pseudocode Standards & Identifier Tables](https://csmasters.dev/learn/igcse-0478/pseudocode-standards-and-identifiers.md) - Estimated: 15 mins | XP Reward: 115 | Open Theory (All-Access Practice) - **Lesson 8.5:** [Flowchart Symbols & Decision Logic](https://csmasters.dev/learn/igcse-0478/flowchart-conventions.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 8.6:** [Totalling, Counting & Sentinel Input Loops](https://csmasters.dev/learn/igcse-0478/totalling-and-counting.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 8.7:** [Finding Maximum, Minimum & Calculating Average](https://csmasters.dev/learn/igcse-0478/calculating-stats-min-max.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 8.8:** [Mean and Empty Data](https://csmasters.dev/learn/igcse-0478/mean-and-empty-data.md) - Estimated: 10 mins | XP Reward: 30 | Open Theory (All-Access Practice) - **Lesson 8.9:** [Linear Search Algorithm on 1D Arrays](https://csmasters.dev/learn/igcse-0478/linear-search.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 8.10:** [Bubble Sort Algorithm with Swap Optimization](https://csmasters.dev/learn/igcse-0478/bubble-sort.md) - Estimated: 20 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 8.11:** [Data Validation Checks (Range, Length, Type, Presence)](https://csmasters.dev/learn/igcse-0478/validation-techniques.md) - Estimated: 15 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 8.12:** [Data Verification Methods (Double Entry & Visual Check)](https://csmasters.dev/learn/igcse-0478/verification-methods.md) - Estimated: 15 mins | XP Reward: 85 | Open Theory (All-Access Practice) - **Lesson 8.13:** [Designing Test Data (Normal, Boundary, Extreme, Erroneous)](https://csmasters.dev/learn/igcse-0478/test-data-types.md) - Estimated: 15 mins | XP Reward: 85 | Open Theory (All-Access Practice) - **Lesson 8.14:** [Trace Tables & Algorithm Dry-Run Execution](https://csmasters.dev/learn/igcse-0478/trace-tables-and-dry-runs.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 8.15:** [Error Detection, Debugging & Algorithm Correction](https://csmasters.dev/learn/igcse-0478/error-detection-and-correction.md) - Estimated: 15 mins | XP Reward: 85 | Open Theory (All-Access Practice) - **Lesson 8.16:** [Mixed Practice: Algorithms](https://csmasters.dev/learn/igcse-0478/algorithm-review.md) - Estimated: 20 mins | XP Reward: 30 | Open Theory (All-Access Practice) - **Lesson 8.17:** [Independent Scenario: Monitoring Readings](https://csmasters.dev/learn/igcse-0478/integrated-scenario-readings.md) - Estimated: 30 mins | XP Reward: 30 | Open Theory (All-Access Practice) ### Module 9: Section 9: Relational Databases & SQL Single-table database entities, fields, records, validation, primary keys, and SQL queries (SELECT, FROM, WHERE, ORDER BY ASC/DESC, SUM, COUNT, AND, OR). - **Lesson 9.1:** [9.0 Module Overview: Relational Databases and SQL](https://csmasters.dev/learn/igcse-0478/00-databases-overview.md) - Estimated: 5 mins | XP Reward: 5 | Open Theory (All-Access Practice) - **Lesson 9.2:** [Database Terminology: Tables, Records & Field Data Types](https://csmasters.dev/learn/igcse-0478/database-fields-and-records.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 9.3:** [Primary Keys, Foreign Keys & Data Integrity](https://csmasters.dev/learn/igcse-0478/primary-keys-and-validation.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 9.4:** [Structured Query Language (SELECT, FROM, WHERE)](https://csmasters.dev/learn/igcse-0478/sql-select-queries.md) - Estimated: 15 mins | XP Reward: 160 | Open Theory (All-Access Practice) - **Lesson 9.5:** [SQL Ordering & Aggregate Functions (ORDER BY, SUM, COUNT)](https://csmasters.dev/learn/igcse-0478/sql-ordering-and-aggregates.md) - Estimated: 10 mins | XP Reward: 115 | Open Theory (All-Access Practice) - **Lesson 9.6:** [Mixed Practice: Databases](https://csmasters.dev/learn/igcse-0478/database-review.md) - Estimated: 20 mins | XP Reward: 30 | Open Theory (All-Access Practice) ### Module 10: Section 10: Boolean Logic & Gate Circuits 6 standard logic gates (NOT, AND, OR, NAND, NOR, XOR), 2/3-input truth tables (8 rows), combinational logic circuit drawing, and boolean expressions. - **Lesson 10.1:** [10.0 Module Overview: Boolean Logic and Logic Circuits](https://csmasters.dev/learn/igcse-0478/00-boolean-logic-overview.md) - Estimated: 5 mins | XP Reward: 5 | Open Theory (All-Access Practice) - **Lesson 10.2:** [Standard Logic Gates (NOT, AND, OR, NAND, NOR, XOR)](https://csmasters.dev/learn/igcse-0478/logic-gates-and-symbols.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 10.3:** [Truth Tables for 2-Input & 3-Input Circuits](https://csmasters.dev/learn/igcse-0478/truth-tables-2-and-3-inputs.md) - Estimated: 15 mins | XP Reward: 110 | Open Theory (All-Access Practice) - **Lesson 10.4:** [Combinational Logic Circuit Simulation](https://csmasters.dev/learn/igcse-0478/combinational-circuits.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 10.5:** [Boolean Expressions & Circuit Simplification](https://csmasters.dev/learn/igcse-0478/boolean-expressions-and-equivalence.md) - Estimated: 10 mins | XP Reward: 90 | Open Theory (All-Access Practice) - **Lesson 10.6:** [Mixed Practice: Boolean Logic](https://csmasters.dev/learn/igcse-0478/logic-review.md) - Estimated: 20 mins | XP Reward: 30 | Open Theory (All-Access Practice)