pptx, 173.95 KB
pptx, 173.95 KB
docx, 38.65 KB
docx, 38.65 KB
docx, 39.32 KB
docx, 39.32 KB

SQL SELECT, FROM and WHERE lesson for OCR GCSE Computer Science (J277), with editable PowerPoint slides, a student worksheet and full answers. SQL SELECT chooses fields, FROM names the table and WHERE filters the rows, which lets a query pull out just the records needed.

Written for J277/02 Computational thinking, algorithms and programming, section 2.2 Programming fundamentals (spec 2.2.3.4). Everything is editable, so you can adapt it to your class.

What’s included
  • PowerPoint lesson (14 slides) with teacher notes on every slide
  • Student worksheet (Word), ready to print or edit
  • Answer sheet (Word) with mark-scheme style answers for every question
OC2.36 SQL: SELECT, FROM and WHERE

By the end of the lesson students can:

  • Explain what SQL is used for and what SELECT, FROM and WHERE each do
  • Predict the result of a query on a table of records
  • Write queries that pick fields and records with a condition, and run them from Python

Worksheet sections: A. Key words; B. Predict the results; C. Write and run queries; D. Exam-style questions; E. Challenge

Every lesson includes
  • Learning goals and a starter question
  • Clear explanations, diagrams and worked examples (Python 3 throughout, with the OCR Exam Reference Language alongside)
  • A quick check and a “your turn” task linked to the worksheet
  • Exam-style questions with marks, and an exit ticket
Format
  • PowerPoint (.pptx) and Word (.docx), fully editable
  • Works in PowerPoint and Google Slides
  • Bright, clear GCSE design, consistent across the whole course

These are independent resources written for the Cambridge OCR GCSE (9–1) Computer Science specification (J277, version 3.1). They are not produced or endorsed by OCR or Cambridge University Press & Assessment. Spec point numbers are our own numbering of the specification statements.

More lessons in this series

Last updated: November 2026.

Get this resource as part of a bundle and save up to 36%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Bundle

Programming fundamentals Part 2 – OCR GCSE CS (14 lessons)

14 ready-to-teach lessons for OCR GCSE Computer Science (J277): Programming fundamentals Part 2. Every lesson has editable PowerPoint slides, a student worksheet and full answers, and the bundle costs less than buying the lessons one by one. A ready-to-teach bundle for OCR GCSE (9–1) Computer Science (J277): Section 2.2 Programming fundamentals, part 2 of 2, lessons OC2.24 to OC2.39. Every lesson comes with: - **Editable PowerPoint slides**: goals, starter, explanations, diagrams, worked examples, a quick check, a task and an exit ticket, with teacher notes - **Student worksheet (Word)**: recall, applied practice and exam-style questions with marks - **Answer sheet (Word)**: full mark-scheme style answers Worth £69.86 if bought lesson by lesson. ## What's inside - **OC2.24** One-dimensional arrays - **OC2.25** Arrays and loops - **OC2.26** Two-dimensional arrays - **OC2.27** Programming practice: arrays - **OC2.28** Procedures - **OC2.29** Functions - **OC2.30** Local and global variables - **OC2.32** Programming practice: sub programs - **OC2.33** Reading from a file - **OC2.34** Writing to a file - **OC2.35** Records - **OC2.36** SQL: SELECT, FROM and WHERE - **OC2.37** SQL: wildcards and conditions - **OC2.39** Programming project: build and test The rest of Section 2.2 Programming fundamentals is in the other part, sold as a separate bundle. ## Why teachers use it - Mapped lesson by lesson to the specification, so coverage is easy to track - Python 3 throughout, with the OCR Exam Reference Language alongside - Fully editable: adapt to your class, timings and school template - Works for teaching, revision, cover lessons and homework These are independent resources written for the Cambridge OCR GCSE (9–1) Computer Science specification (J277, version 3.1). They are not produced or endorsed by OCR or Cambridge University Press & Assessment. Spec point numbers are our own numbering of the specification statements. Last updated: November 2026.

£26.99

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.