Community
Community resources
Computer science Worksheets and Python Workspaces shared by Coding Pathway teachers. Worksheets cover exam board theory as well as programming. Read any of them in full here. Teachers can copy one into their own lessons and edit it before setting it to a class.
Planning a whole course or unit? Our mapped pages put the teaching sequence in order with the Worksheets that cover it: OCR GCSE Computer Science (J277), Pearson Edexcel GCSE Computer Science (1CP2), OCR A Level Computer Science (H446), Python Turtle for Key Stage 3.
- 438 resources
- 3 teachers sharing
- Creative Commons licensed
Mastery
12 resources match. Newest first. Opening a resource shows the whole thing, with answers and marking held back.
OCR H446 1.3.4 Web Technologies consolidation
Part 7 · H446 1.3.4 · Web technologies
Consolidation for H446 1.3.4 built around a single community equipment page, so HTML, CSS, JavaScript, search-engine behaviour and processing location all have to hold together at once. No new required knowledge appears; the demand comes from using the ideas at the same time. Students will: - write matching HTML, external CSS and JavaScript for one described page - explain what breaks when an identifier's capitalisation differs between page and script - trace a new page from an incoming directory link to appearing in a query result - explain how a further incoming link could affect ranking without claiming a position - allocate the tasks in a booking route between browser and server and justify each Inside: 5 explanation cells, 1 multiple-choice question, 1 fill-in-the-blanks cell and 4 written answers. 37 marks, about 45 to 60 minutes. Series: H446 1.3.4 · Web technologies, part 7 of 8.
WorksheetOCR H446 1.3.3 Networks consolidation
Part 9 · H446 1.3.3 · Networks
Consolidation across H446 1.3.3, introducing no new content but requiring transfer, switching, threats, controls, hardware and service models to be used together. Students trace one inter-site request end to end, then redesign the same network after an incident report. Students will: - explain an inter-site request from domain name to usable data across all four layers - recommend a switching approach for two contrasting workloads on the same site - identify what is missing from an incomplete explanation of why layering helps - diagnose several threats from one incident report and design a layered response with limitations - select hardware roles and a service model for the redesigned network and justify both Inside: 5 explanation cells, 1 multiple-choice question, 1 fill-in-the-blanks cell and 4 written answers. 45 marks, about 45 to 60 minutes. Series: H446 1.3.3 · Networks, part 9 of 10.
WorksheetSeries · 3 partsH446 1.3.2 · Databases
Includes OCR H446 1.3.2 Third normal form and complete normalisation
Third normal form removes dependencies between one non-key attribute and another, and H446 1.3.2 expects students to carry a relation the whole way from unnormalised data to 3NF. This worksheet keeps partial and transitive dependencies clearly apart and asks for the organisational benefit as well as the mechanics. Students will: - distinguish a partial dependency from a transitive one - follow a dependency chain to find the attribute that determines another - decompose a relation already in 2NF into third normal form with correct keys - distinguish update, insertion and deletion anomalies using the same data - normalise a multi-table clinic schema from first to third normal form Inside: 7 explanation cells, 2 multiple-choice questions, 2 fill-in-the-blanks cells and 3 written answers. 33 marks, about 30 to 45 minutes. Series: H446 1.3.2 · Databases, part 5 of 13.
WorksheetOCR H446 1.3.1 Compression, encryption and hashing consolidation
Part 6 · H446 1.3.1 · Compression, encryption and hashing
Compression, encryption and hashing meet in one running project scenario here, which is the consolidation point for H446 1.3.1 rather than three separate topics revisited. No new content is introduced, so it works as a revision lesson or a checkpoint before the assessment. Students will: - recommend lossy or lossless compression for contrasting files within the same project - encode one sequence under both field orders and explain what a decoder must be told - build and decode a first-appearance dictionary, then account for its cost - trace an asymmetric confidentiality journey and say when a symmetric method becomes practical - trace password verification and a release-file digest check, stating what each match can support Inside: 5 explanation cells, 1 multiple-choice question, 1 fill-in-the-blanks cell and 5 written answers. 49 marks, about 45 to 60 minutes. Series: H446 1.3.1 · Compression, encryption and hashing, part 6 of 7.
WorksheetOCR H446 1.2.4 Programming Languages consolidation
Part 9 · H446 1.2.4 · Types of programming language
The consolidation piece for H446 1.2.4, bringing language choice, LMC execution, addressing modes and object-oriented design together in two running scenarios rather than revisiting each topic separately. No new content is introduced, so it suits a revision lesson or a checkpoint before assessment. Students will: - recommend and compare language levels for a portable application and a memory-constrained controller - trace one LMC execution that accepts several inputs and produces cumulative outputs - explain the output fault caused by removing a store instruction - resolve all four addressing modes against a single supplied memory state - write a class hierarchy that combines a validated capacity change with an overridden display method Inside: 5 explanation cells, 1 fill-in-the-blanks cell, 5 written answers and 1 trace table. 44 marks, about 55 to 70 minutes. Series: H446 1.2.4 · Types of programming language, part 9 of 10.
WorksheetOCR H446 1.2.2 Applications Generation mastery and transfer
Part 6 · H446 1.2.2 · Applications generation
Two extended development contexts pull the whole of H446 1.2.2 together here, covering software types, source models, translators, compilation stages and the library, linker and loader chain. No new content is introduced, so this belongs after the topic has been taught, at the point where students know the parts separately and need to combine them. Students will: - retrieve the topic's distinctions from memory before applying them in context - choose software and utilities for a mixed organisational brief and justify each from function - reach a conditional recommendation between a self-hosted open route and a managed closed one - trace one statement from tokens through to code placed in memory and running - weigh library benefits against drawbacks and repair a claim about reusing tested code Inside: 5 explanation cells, 2 multiple-choice questions, 2 fill-in-the-blanks cells and 5 written answers. 71 marks, about 50 to 65 minutes. Series: H446 1.2.2 · Applications generation, part 6 of 7.
WorksheetOCR H446 1.1.3 Input, output and storage consolidation
Part 5 · H446 1.1.3 · Input, output and storage
This is the consolidation point for H446 1.1.3, worked closed-book. Two unfamiliar contexts, a set of coastal habitat stations and an analysis room with remote partner laboratories, require device selection, storage choice, memory reasoning and virtual storage to be applied together rather than one topic at a time. Students will: - design a complete input, processing and output path for a field monitoring station - justify a single device that carries two roles in the same system - recommend storage under competing constraints and set aside an irrelevant true property - diagnose common misconceptions that confuse RAM with cache or misstate the value of ROM - trace a shared remote drive to its physical media and say why it is not virtual memory Inside: 5 explanation cells, 2 multiple-choice questions, 1 fill-in-the-blanks cell and 4 written answers. 48 marks, about 60 to 75 minutes. Series: H446 1.1.3 · Input, output and storage, part 5 of 6.
WorksheetOCR H446 1.1.2 Types of processor consolidation
Part 4 · H446 1.1.2 · Types of processor
Two unfamiliar applied contexts, a mobile mapping platform and a flood simulation service, carry the consolidation of OCR H446 1.1.2. Students begin with closed-book retrieval and then apply CISC and RISC comparison, CPU and GPU choice and parallel allocation without returning to the worked examples. Students will: - reach a qualified processor recommendation for a low power terminal tied to legacy software - split a workflow between CPU, GPU and mixed processing according to workload shape - schedule a staged job on two cores and then on four - identify the serial stages and the storage bottleneck that cap a speed-up - repair claims that confuse parallel processing with pipelining or assume gain in proportion to cores Inside: 5 explanation cells, 2 multiple-choice questions, 1 fill-in-the-blanks cell and 4 written answers. 46 marks, about 55 to 70 minutes. Series: H446 1.1.2 · Types of processor, part 4 of 5.
WorksheetJ277 2.5.1 Compilers and interpreters
Part 2 · J277 2.5 · Programming languages and IDEs
The two translators OCR requires, and the benefits and drawbacks that follow from how each one works. Students will: - explain why source code must be translated - describe how a compiler translates a program - describe how an interpreter translates a program - give the benefits and drawbacks of each - choose the translator that suits a stated situation Inside: 4 explanation cells, 2 multiple-choice questions, 1 fill-in-the-blanks cell and 4 written answers. 20 marks, about 45 minutes. Series: J277 2.5 · Programming languages and IDEs, part 2 of 4.
WorksheetJ277 2.3.1 Programming validation and authentication
Part 3 · J277 2.3 · Producing robust programs
Defensive design written as runnable Python, using a loop that keeps asking until the input is acceptable. Students will: - write the four parts of a reliable validation loop - express the invalid condition rather than the valid one - validate a number against a stated range - validate an entry against a list of accepted values - write a simple authentication check Inside: 8 explanation cells, 4 runnable Python tasks, 1 multiple-choice question and 2 written answers. 17 marks, about 45 minutes. Series: J277 2.3 · Producing robust programs, part 3 of 7.
WorksheetJ277 1.2.4 Binary shifts and consolidation
Part 5 · J277 1.2.4 · Number systems
Binary shifts, then a mixed checkpoint over the whole OCR number-systems topic. Students will: - carry out left and right binary shifts - connect the number of places with a power of two - identify direction and places from a before-and-after pair - explain when a fixed-width shift loses information - apply conversion, addition and overflow independently Inside: 5 explanation cells, 5 number grids, 3 multiple-choice questions and 3 written answers. 45 marks, about 75 minutes. Series: J277 1.2.4 · Number systems, part 5 of 5.
WorksheetJ277 2.4.1 Combined Boolean operators and truth tables
Part 2 · J277 2.4 · Boolean logic
Expressions that use more than one operator, worked with intermediate columns so the method stays reliable. Students will: - work outwards from the innermost operation in an expression - use an intermediate column for each smaller part - work out how many rows a truth table needs - complete a truth table for a combined two-input expression - complete a truth table for a three-input expression with brackets Inside: 5 explanation cells, 2 multiple-choice questions, 2 fill-in-the-blanks cells and 2 written answers. 23 marks, about 45 minutes. Series: J277 2.4 · Boolean logic, part 2 of 4.