OCR A-Level CS H446 Paper 1 Data Exchange Workbook | SQL, Databases, Networks, Encryption, Web

Stop guessing what to revise for Paper 1 Data Exchange. Teach it, practise it and test it in one complete workbook.

The Data Exchange Mastery Workbook covers the exchanging-data content of OCR A-Level Computer Science H446 Paper 1. It combines clear revision notes with a large bank of original exam-style questions. Every question has a full model answer, so marking is quick for teachers and self-marking is easy for students.

What you get

127 original exam-style questions (415 marks), each with question number, topic and subtopic, specification reference, marks, difficulty, command word and a student response space

Five teaching parts: Database Concepts, SQL Mastery, Data Exchange and Communication, Encryption and Security, and Web Technologies

Seven clear diagrams: ER diagram, TCP/IP stack, packet switching, client-server, encryption, hashing, and client-side v server-side

A complete School Library database used throughout, with realistic tables and sample records. Every SQL query has been run and checked, and every expected output is generated from the data.

A separate Answer Booklet with model answers, indicative marking points, step-by-step explanations for SQL, database and encryption questions, and a common-errors note for every question

Topic coverage matrix, revision checklist and student confidence tracker

Five topic assessments and a Final Paper 1 Readiness Assessment with score bands

Teacher marking guidance, including SQL marking conventions and levels-of-response guidance for 8-mark questions

Topics covered

Relational databases, keys, ER diagrams, referential integrity, normalisation to 3NF, indexing, ACID and record locking

SQL: SELECT, WHERE, AND/OR, LIKE, ORDER BY, INSERT, UPDATE, DELETE, joins, aggregates, GROUP BY, HAVING and nested queries (stretch topics are clearly flagged “Extension”)

Protocols, the TCP/IP stack, DNS, packet and circuit switching, network hardware, client-server and peer-to-peer, firewalls and proxies

Symmetric and asymmetric encryption, hashing, authentication and digital signatures

HTML, CSS, JavaScript, client-side and server-side processing, search engine indexing and PageRank

Question types
Multiple choice, definitions, explain and describe, SQL writing, query interpretation, error correction, database design, data exchange and encryption scenarios, and 8-mark extended responses.

Why teachers and students love it

Saves hours of planning and marking
Works as classroom practice, homework, cover work or independent revision
Builds exam technique through command words, difficulty levels and common-error feedback
Printer-friendly A4 layout with a separate answer section

Format: editable Word document (.docx), 130 pages. Answers can be removed before giving the workbook to students.

Questions or feedback? Message me through my shop. A review helps other teachers find this resource.