Computer Science

Custom-built resources for Secondary Computer Science teaching. Including OCR J277 and A Level H446 Specifications. Designed for clarity, depth, understanding and success.

Key Stage 3

Years 7, 8 & 9 Curriculum

Year 7

Foundation
Algorithm Design using Scratch
BlockBuild
Algorithm Design in Python3
PyCode

Year 8

Intermediate
Web Design with HTML and CSS
CodeCraft - Web Development
Databases

L1 What is a Database:

Teacher Slides DataDrop_L1 Student Worksheet

L2 Designing a Database:

Teacher Slides DataDrop_L2_starter Student Worksheet

L3 Queries in Access:

Teacher Slides DataDrop_L3 Student Worksheet

L4 Introduction to SQL:

Teacher Slides DataDrop_L4 Student Worksheet SQL Reference Card

L5 Forms and Reports:

Teacher Slides Student Worksheet

L6 Mini Project:

Teacher Slides Student Worksheet Peer Review Form

Year 9

Transition
Biometrics and Security Aspects of Computing

Lesson 1 - Fingerprints:

Teacher Slides Student Task

Lesson 2 - Gait and Eyes:

Student Task

Lesson 3 - Cryptography:

Student Task

Lesson 5 - Supersleuth:

Supersleuth

Assessment:

Biometrics Assessment Assessment Brief Assessment Rubric
Spreadsheet Modelling

L1 Creator Dashboard:

Teacher Slides Student Slides Worksheet Starter Data

L2 Follow the Money:

Teacher Slides Student Slides Worksheet Starter Data

L3 What If I Went Viral:

Teacher Slides Student Slides Worksheet Starter Data

L4 Keep It Clean:

Teacher Slides Student Slides Worksheet Starter Data

L5 The Big Picture:

Teacher Slides Student Slides Worksheet Starter Data
Robotics with Edisons

Lesson 1 - Meet Edison:

Teacher Slides

Lesson 2 - Moving with EdPy:

Teacher Slides

Lesson 3 - Loops & Shapes:

Teacher Slides

Lesson 4 - Flowcharts & Obstacle Detection:

Teacher Slides

Lesson 5 - Light, Sound & Robot Claw:

Teacher Slides

Lesson 6 - Final Challenge:

Teacher Slides

Student Hub (all 6 lessons):

Student Portfolio Hub

GCSE Computer Science

OCR J277 Specification

Component 01

Exam: 13th May
Computer Systems
1.1 Systems Architecture
CPU and the Fetch-Decode-Execute Cycle CPU Performance Factors
1.2 Memory and Storage
Number Base Conversions Sound Digital Images & Bitmaps Data Compression Storage Devices
1.3 Computer Networks & Topologies
Packet Switching Simulator Network Protocols and Layers Network Topologies & Hardware
1.4 Network Security
Network Threats - Cyber Command Network Security Defences
1.5 Systems Software
Operating Systems & Utility Software
1.6 Ethical, Legal, Cultural & Environmental
Legal Aspects of Computing Ethical Issues

Component 02

Exam: 19th May
Algorithms & Programming
2.1 Algorithms
Searching Algorithms Sorting Algorithms
2.2 Programming Fundamentals
Programming Fundamentals
2.3 Producing Robust Programs
Testing & Defensive Design
2.4 Boolean Logic
Logic Gates and Truth Tables
2.5 Programming Languages & IDEs
Languages, Translators & IDEs

Exam Technique

Success Strategy
Question Command Words Essay Writing Guide Revision Scheduler

A Level Computer Science

OCR H446 Specification

Component 01

Exam: 10th June
Computer Systems
1.1 Structure & Role of Processor
CPU and the Fetch-Decode-Execute Cycle with Pipelining Assembler - LMC Simulator RISC vs CISC Architecture Interrupts & Interrupt Handling
1.2 Types of Software
Concepts of OOP and Constructors Stages of Compilation Virtual Machines & Operating Systems
1.3 Exchanging Data
Page Rank Algorithm Databases, SQL & Normalisation Huffman Coding & Compression Encryption Methods
1.4 Data Types & Structures
Data Structures Number Base Conversions Sign & Magnitude and Two's Compliment Logic Gates and Truth Tables Simplification of Boolean Algebra Karnaugh Maps
1.5 Legal, Moral & Ethical
Legislation Hub Ethical Issues

Component 02

Exam: 17th June
Algorithms & Programming
2.1 Elements of Computational Thinking
Computational Thinking
2.2 Problem Solving & Programming
Programming Paradigms & Recursion
2.3 Algorithms
Big O Notation (Time & Space) Sorting & Searching Algorithms Graph Traversal — BFS, DFS & Dijkstra's

Exam Technique

Success Strategy
Revision Scheduler