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
Databases Worksheets
2 resources match. Newest first. Opening a resource shows the whole thing, with answers and marking held back.
H446 1.3.2 · Databases
Includes OCR H446 1.3.2 Database foundations, tables and keys
OCR H446 1.3.2 opens with the vocabulary everything else depends on: database, table, field, record, and the primary, foreign and secondary keys that link them. This worksheet builds that model from a ticket-booking scenario so students can justify a key choice rather than recite a definition. Students will: - distinguish a flat file design from a set of linked relational tables - identify primary, foreign and secondary keys from where a field appears in a schema - explain the job each key does in the table it sits in - propose tables and keys for an unfamiliar equipment-loan scenario - recall the core definitions from memory with no answer bank available Inside: 7 explanation cells, 2 multiple-choice questions, 2 fill-in-the-blanks cells and 3 written answers. 27 marks, about 25 to 35 minutes. Series: H446 1.3.2 · Databases, part 1 of 13.
WorksheetJ277 2.2.3 SQL
Part 3 · J277 2.2.3 · Applied programming
SQL at the level OCR J277 requires: SELECT, FROM and WHERE, written against a sample table. Students will: - build a query as SELECT fields, FROM table, then WHERE condition - quote string values and leave numerical values unquoted - use the wildcard when a question asks for all fields - join two conditions with AND or OR as the wording requires - predict the records a query returns, and correct one that is wrong Inside: 4 explanation cells, 4 multiple-choice questions, 2 fill-in-the-blanks cells and 4 written answers. 25 marks, about 45 minutes. Series: J277 2.2.3 · Applied programming, part 3 of 5.