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
SQL and databases
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 SQL selection and conditions
SQL enters H446 1.3.2 here, held to the structures inside the OCR Appendix 5d assumed range. Students read a SELECT query clause by clause, predict exactly which rows it returns, then write their own using Boolean operators and wildcard patterns. Students will: - interpret SELECT, FROM and WHERE as separate parts of one query - predict the rows a supplied query returns from a given table and say why - combine two conditions with Boolean operators - use a wildcard pattern to match part of a text field - write queries for a new catalogue schema while staying inside the assumed SQL range Inside: 7 explanation cells, 2 multiple-choice questions, 2 fill-in-the-blanks cells, 3 written answers and 1 Python task. 29 marks, about 25 to 40 minutes. Series: H446 1.3.2 · Databases, part 8 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.