Study Guide Courses
AS & A Level (Cambridge 9618)
AS and A level (ages 16 to 18). Lessons in the order of the Cambridge International AS & A Level Computer Science (9618) 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.
59 lessons so far, matching 26 of the 44 specification points. A lesson that serves several points is listed under each.
1 Information representation
1.1 Data Representation
- How Computers Count in Binary · gives background for this point · about 50 minutes · Provisional
- Hexadecimal · teaches part of this point · about 60 minutes · Provisional
- Binary Addition and Overflow · gives background for this point · about 60 minutes · Provisional
- Logical Binary Shifts · gives background for this point · about 60 minutes · Provisional
- Two’s Complement · teaches part of this point · about 60 minutes · Provisional
- Representing Text · gives background for this point · about 50 minutes · Provisional
- Measuring Storage and File Sizes · teaches part of this point · about 60 minutes · Provisional
1.2 Multimedia
- Representing Sound · teaches part of this point · about 55 minutes · Provisional
- Representing Images · teaches part of this point · about 55 minutes · Provisional
- Measuring Storage and File Sizes · teaches part of this point · about 60 minutes · Provisional
1.3 Compression
- Data Compression · teaches part of this point · about 60 minutes · Provisional
2 Communication
2.1 Networks including the internet
- Data Transmission Methods · gives background for this point · about 60 minutes · Provisional
- Network Hardware and Addresses · gives background for this point · about 75 minutes · Provisional
- The Internet and the Web · gives background for this point · about 60 minutes · Provisional
- How a Web Page Is Loaded · gives background for this point · about 60 minutes · Provisional
3 Hardware
3.1 Computers and their components
- Input and Output Devices · gives background for this point · about 90 minutes · Provisional
- Sensors · gives background for this point · about 75 minutes · Provisional
- Primary Storage and Virtual Memory · gives background for this point · about 60 minutes · Provisional
- Secondary and Cloud Storage · gives background for this point · about 90 minutes · Provisional
- Automated Systems · gives background for this point · about 90 minutes · Provisional
- Robotics · gives background for this point · about 75 minutes · Provisional
3.2 Logic Gates and Logic Circuits
- Introduction to Logic Gates · gives background for this point · about 60 minutes · Provisional
- More Logic Gates · teaches part of this point · about 60 minutes · Provisional
- Logic Expressions and Truth Tables · teaches part of this point · about 60 minutes · Provisional
- Designing Logic Circuits · teaches part of this point · about 60 minutes · Provisional
4 Processor Fundamentals
4.1 Central Processing Unit (CPU) Architecture
- The CPU and Von Neumann Architecture · gives background for this point · about 60 minutes · Provisional
- The Fetch-Decode-Execute Cycle · gives background for this point · about 60 minutes · Provisional
- CPU Performance and Embedded Systems · gives background for this point · about 60 minutes · Provisional
- Firmware, Booting and Interrupts · gives background for this point · about 75 minutes · Provisional
Not covered yet: 4.2, 4.3.
5 System Software
5.1 Operating Systems
- System Software and Operating Systems · gives background for this point · about 90 minutes · Provisional
5.2 Language Translators
- Programming Languages and Translators · gives background for this point · about 90 minutes · Provisional
6 Security, privacy and data integrity
6.1 Data Security
- Cyber Security Threats · gives background for this point · about 70 minutes · Provisional
- Keeping Data Safe · gives background for this point · about 70 minutes · Provisional
6.2 Data Integrity
- Error Detection · gives background for this point · about 90 minutes · Provisional
- Validation and Verification · teaches part of this point · about 90 minutes · Provisional
7 Ethics and Ownership
7.1 Ethics and Ownership
- Creating Digital Artefacts for an Audience · gives background for this point · about 70 minutes · Provisional
8 Databases
8.1 Database Concepts
- Designing a Database Table · gives background for this point · about 65 minutes · Provisional
8.3 Data Definition Language (DDL) and Data Manipulation Language (DML)
- Querying a Database with SQL · gives background for this point · about 70 minutes · Provisional
Not covered yet: 8.2.
9 Algorithm Design and Problem-solving
9.1 Computational Thinking Skills
- Solving Problems with Algorithms · gives background for this point · about 60 minutes · Provisional
9.2 Algorithms
- 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
- Trace Tables and Dry Runs · gives background for this point · about 75 minutes · Provisional
10 Data Types and Structures
10.2 Arrays
- Arrays · teaches part of this point · about 90 minutes · Provisional
- Linear Search and Bubble Sort · gives background for this point · about 90 minutes · Provisional
10.3 Files
- File Handling · gives background for this point · about 75 minutes · Provisional
Not covered yet: 10.1, 10.4.
11 Programming
11.1 Programming Basics
- Variables, Data Types and Operators · gives background for this point · about 75 minutes · Provisional
- String Handling · gives background for this point · about 75 minutes · Provisional
- Writing Your First Python Programs · gives background for this point · about 75 minutes · Provisional
11.2 Constructs
11.3 Structured Programming
- Procedures and Functions · gives background for this point · about 90 minutes · Provisional
- Python Loops, Lists and Functions · gives background for this point · about 90 minutes · Provisional
12 Software Development
12.3 Program Testing and Maintenance
- 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
Not covered yet: 12.1, 12.2.
14 Communication and internet technologies
14.2 Circuit switching, packet switching
- Packets and Packet Switching · gives background for this point · about 60 minutes · Provisional
Not covered yet: 14.1.
17 Security
17.1 Encryption, Encryption Protocols and Digital Certificates
- Encryption · gives background for this point · about 60 minutes · Provisional
- Keeping Data Safe · gives background for this point · about 70 minutes · Provisional
18 Artificial Intelligence (AI)
18.1 Artificial Intelligence (AI)
- What Counts as AI? · gives background for this point · about 50 minutes · Provisional
- How Language Models Write · gives background for this point · about 55 minutes · Provisional
- Expert Systems and Machine Learning · gives background for this point · about 65 minutes · Provisional
19 Computational thinking and Problem-solving
19.1 Algorithms
- Binary Search · teaches part of this point · about 75 minutes · Provisional
Not covered yet: 19.2.
Not covered yet
- 13 Data Representation
- 15 Hardware and Virtual Machines
- 16 System Software
- 20 Further Programming