ÌÇÐÄVlog

Please consent to cookies to view content.

' ); iframeDoc.close(); } } } } } const observer = new MutationObserver(switchSrc); observer.observe(document.documentElement, { childList: true, subtree: true, }); })();

ÌÇÐÄVlog

Last updated

11 November 2026

docx, 38.24 KB
docx, 38.24 KB
docx, 39.23 KB
docx, 39.23 KB
pptx, 177.48 KB
pptx, 177.48 KB

SQL injection lesson for OCR GCSE Computer Science (J277), with editable PowerPoint slides, a student worksheet and full answers. SQL injection is an attack that types database commands into an input box; it is prevented by validating and sanitising input.

Written for J277/01 Computer systems, section 1.4 Network security (spec 1.4.1.1). 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
OC1.32 SQL injection

By the end of the lesson students can:

  • Explain how a program that joins user input into an SQL query can be attacked
  • Show how an injected condition such as OR ‘1’=‘1’ changes what a query returns
  • Describe the purpose of SQL injection and outline how it is prevented

Worksheet sections: A. Key words; B. Build the query; C. Explain the attack; 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 27%

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

Bundle

Network security – OCR GCSE Computer Science (5 lessons)

5 ready-to-teach lessons for OCR GCSE Computer Science (J277): Network security. 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 complete, ready-to-teach bundle for OCR GCSE (9–1) Computer Science (J277): Section 1.4 Network security, in 5 bespoke lessons. 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 £24.95 if bought lesson by lesson. ## What's inside - **OC1.30** Malware and social engineering - **OC1.31** Brute force, DoS and interception - **OC1.32** SQL injection - **OC1.33** Preventing attacks: software - **OC1.34** Preventing attacks: people and access ## 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.

£10.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

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