
SQLite: select, filter and aggregate lesson for Pearson Edexcel International A Level Computer Science, with editable PowerPoint slides, a student worksheet and full answers. Students use Python and SQL to select data from an SQLite table, filter it with WHERE, sort it and total it with aggregate functions.
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
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
- 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.
More lessons in this series- Previous lesson: SQLite: insert, update and delete – Edexcel IAL Computer Science
- Next lesson: SQLite: joining tables – Edexcel IAL Computer Science lesson
- Save with the bundle: Organising and handling data – Edexcel IAL CS (11 lessons)
Last updated: November 2026.
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.