Study Guide Courses
Key Stage 3
Key Stage 3 (ages 11 to 14). Lessons in the order of the National curriculum in England: computing programmes of study, Key Stage 3 specification.
Matches are provisional. Each lesson says how much of a specification point it teaches. These matches are the author's, and are marked “Provisional” until checked point by point. The full specification record shows every point and its source.
56 lessons so far, matching 9 of the 9 specification points. A lesson that serves several points is listed under each.
The programme of study
1. design, use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems
- Solving Problems with Algorithms · teaches part of this point · about 60 minutes · Provisional
- Modelling the Real World · teaches this point · about 75 minutes · Provisional
2. understand several key algorithms that reflect computational thinking [for example, ones for sorting and searching]; use logical reasoning to compare the utility of alternative algorithms for the same problem
- Flowcharts and Pseudocode · gives background for this point · about 60 minutes · Provisional
- Totalling, Counting and Finding Extremes · gives background for this point · about 75 minutes · Provisional
- Linear Search and Bubble Sort · teaches part of this point · about 90 minutes · Provisional
- Binary Search · teaches part of this point · about 75 minutes · Provisional
3. use 2 or more programming languages, at least one of which is textual, to solve a variety of computational problems; make appropriate use of data structures [for example, lists, tables or arrays]; design and develop modular programs that use procedures or functions
- Variables, Data Types and Operators · teaches part of this point · about 75 minutes · Provisional
- Selection · teaches part of this point · about 75 minutes · Provisional
- Iteration · teaches part of this point · about 75 minutes · Provisional
- Totalling, Counting and Finding Extremes · teaches part of this point · about 75 minutes · Provisional
- Trace Tables and Dry Runs · gives background for this point · about 75 minutes · Provisional
- String Handling · teaches part of this point · about 75 minutes · Provisional
- Procedures and Functions · teaches part of this point · about 90 minutes · Provisional
- Arrays · teaches part of this point · about 90 minutes · Provisional
- Linear Search and Bubble Sort · gives background for this point · about 90 minutes · Provisional
- Validation and Verification · gives background for this point · about 90 minutes · Provisional
- Choosing Test Data · gives background for this point · about 75 minutes · Provisional
- Finding and Fixing Errors · teaches part of this point · about 90 minutes · Provisional
- File Handling · gives background for this point · about 75 minutes · Provisional
- Tackling a Programming Scenario · teaches part of this point · about 120 minutes · Provisional
- Binary Search · gives background for this point · about 75 minutes · Provisional
- Writing Your First Python Programs · teaches part of this point · about 75 minutes · Provisional
- Python Loops, Lists and Functions · teaches part of this point · about 90 minutes · Provisional
- Designing a Database Table · gives background for this point · about 65 minutes · Provisional
4. understand simple Boolean logic [for example, AND, OR and NOT] and some of its uses in circuits and programming; understand how numbers can be represented in binary, and be able to carry out simple operations on binary numbers [for example, binary addition, and conversion between binary and decimal]
- How Computers Count in Binary · teaches part of this point · about 50 minutes · Provisional
- Binary Addition and Overflow · teaches part of this point · about 60 minutes · Provisional
- Introduction to Logic Gates · teaches part of this point · about 60 minutes · Provisional
- More Logic Gates · gives background for this point · about 60 minutes · Provisional
5. understand the hardware and software components that make up computer systems, and how they communicate with one another and with other systems
- The CPU and Von Neumann Architecture · teaches part of this point · about 60 minutes · Provisional
- CPU Performance and Embedded Systems · teaches part of this point · about 60 minutes · Provisional
- Input and Output Devices · teaches part of this point · about 90 minutes · Provisional
- Sensors · teaches part of this point · about 75 minutes · Provisional
- Primary Storage and Virtual Memory · teaches part of this point · about 60 minutes · Provisional
- Secondary and Cloud Storage · teaches part of this point · about 90 minutes · Provisional
- System Software and Operating Systems · teaches part of this point · about 90 minutes · Provisional
- Firmware, Booting and Interrupts · teaches part of this point · about 75 minutes · Provisional
- Programming Languages and Translators · teaches part of this point · about 90 minutes · Provisional
- Automated Systems · teaches part of this point · about 90 minutes · Provisional
- Robotics · teaches part of this point · about 75 minutes · Provisional
- Packets and Packet Switching · gives background for this point · about 60 minutes · Provisional
- Data Transmission Methods · gives background for this point · about 60 minutes · Provisional
- Error Detection · gives background for this point · about 90 minutes · Provisional
- Encryption · gives background for this point · about 60 minutes · Provisional
- Network Hardware and Addresses · teaches part of this point · about 75 minutes · Provisional
- The Internet and the Web · teaches part of this point · about 60 minutes · Provisional
- How a Web Page Is Loaded · teaches part of this point · about 60 minutes · Provisional
6. understand how instructions are stored and executed within a computer system; understand how data of various types (including text, sounds and pictures) can be represented and manipulated digitally, in the form of binary digits
- How Computers Count in Binary · gives background for this point · about 50 minutes · Provisional
- Representing Text · teaches part of this point · about 50 minutes · Provisional
- Representing Sound · teaches part of this point · about 55 minutes · Provisional
- Representing Images · teaches part of this point · about 55 minutes · Provisional
- Data Compression · gives background for this point · about 60 minutes · Provisional
- The CPU and Von Neumann Architecture · teaches part of this point · about 60 minutes · Provisional
- The Fetch-Decode-Execute Cycle · teaches part of this point · about 60 minutes · Provisional
7. undertake creative projects that involve selecting, using, and combining multiple applications, preferably across a range of devices, to achieve challenging goals, including collecting and analysing data and meeting the needs of known users
- Querying a Database with SQL · gives background for this point · about 70 minutes · Provisional
- Collecting and Analysing Data · teaches part of this point · about 75 minutes · Provisional
8. create, reuse, revise and repurpose digital artefacts for a given audience, with attention to trustworthiness, design and usability
- Creating Digital Artefacts for an Audience · teaches part of this point · about 70 minutes · Provisional
9. understand a range of ways to use technology safely, respectfully, responsibly and securely, including protecting their online identity and privacy; recognise inappropriate content, contact and conduct, and know how to report concerns
- How a Web Page Is Loaded · gives background for this point · about 60 minutes · Provisional
- Cyber Security Threats · teaches part of this point · about 70 minutes · Provisional
- Keeping Data Safe · teaches part of this point · about 70 minutes · Provisional
- Protecting Your Online Identity · teaches part of this point · about 70 minutes · Provisional
- Recognising and Reporting Online Risks · teaches part of this point · about 60 minutes · Provisional
- Using AI Well and Responsibly · gives background for this point · about 55 minutes · Provisional