GCSE Computer Science (AQA)
26 free revision lessons in 7 units. Open the course or go straight to a lesson.
Algorithms
Computational thinking, representing algorithms and the standard searching and sorting approaches
- Computational Thinking: Decomposition and Abstraction
- Representing Algorithms: Pseudo-code, Flowcharts and Trace Tables
- Searching Algorithms: Linear and Binary Search
- Sorting Algorithms: Bubble Sort and Merge Sort
Programming
Data types, programming concepts, structured design and writing robust, validated code
- Data Types and Programming Constructs
- Iteration, Selection and Operators
- Subroutines, Parameters and Local Variables
- Arrays, Records and String Handling
- Robust Programming: Validation, Authentication and Testing
Data Representation
Number bases, character encoding, images, sound and how data gets compressed
- Number Bases and Binary Arithmetic
- Character Encoding: ASCII and Unicode
- Representing Images and Sound
- Data Compression: Huffman and Run-Length Encoding
Computer Systems
Logic gates, the CPU, memory hierarchy and how programming languages reach the processor
- Boolean Logic and Truth Tables
- CPU Architecture and the Fetch-Execute Cycle
- Memory and Storage
- Software, Programming Languages and Translators
Networks and Cyber Security
How data moves between computers, the protocols involved and how to keep networks safe
- Networks, Network Types and Protocols
- Network Security and the TCP/IP Model
- Cyber Security Threats and Social Engineering
- Detecting and Preventing Cyber Threats
Relational Databases and SQL
Designing relational tables and writing SQL to query, insert, update and delete data
- Relational Databases: Tables, Keys and Relationships
- SQL: Retrieving Data with SELECT, FROM, WHERE, ORDER BY
- SQL: Modifying Data with INSERT, UPDATE and DELETE
Ethical, Legal and Environmental Impacts
Privacy, hacking, autonomous vehicles, e-waste and the legal frameworks that govern technology