Edexcel IAL Computer Science – U2.15 SQLite: select, filter and aggregate – Lesson & Worksheet

Bespoke, fully editable lesson for Pearson Edexcel International A Level Computer Science (2026): U2.15 SQLite: select, filter and aggregate. Slides, worksheet and full answers.

Written for Unit 2 Practical Programming, topic 8 Organising and handling data (specification 8.3.3, 8.3.4). Everything is editable, so you can adapt it to your class.

What’s included

• PowerPoint lesson (16 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

U2.15 SQLite: select, filter and aggregate

By the end of the lesson students can:

• Retrieve data with SELECT and DISTINCT, and read results with fetchall() and fetchone()
• Filter rows with WHERE, AND, OR, NOT, BETWEEN, LIKE and NULL tests
• Sort, group and summarise with ORDER BY, GROUP BY, HAVING and aggregate functions

Worksheet sections: A. The club tables; B. Predict; C. Write the query; D. Exam-style questions; E. Challenge

Every lesson includes

• Learning goals and a starter question
• Clear explanations, diagrams and worked examples (Python 3 throughout, as the specification requires)
• 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
• Calm, muted sixth-form design, consistent across the whole course

These are independent resources written for the Pearson Edexcel International Advanced Level Computer Science specification (Issue 1, first teaching 2026; IAS XCP01, IAL YCP01). They are not produced or endorsed by Pearson.