Unit at a glance
4 lessons, 180 minutes of teaching
Scheme of work
The lessons in order
| Ref | Lesson pack | Structure | Worksheet | Quiz | Lab tab |
|---|---|---|---|---|---|
| 9 (1-3) | Single-table databases: fields, records and data types A vet surgery, a school library and a games shop all keep the same kind of data again and again: one set of details for each pet, book or game. | Connect-Extend-Challenge | 6 Q, 16 marks | 6 MCQ | tab 1 |
| 9 (1-3) | Primary keys Two students can share a name, a birthday and a town, yet the school must never mix up their records. | Anticipation / Reaction Guide | 6 Q, 12 marks | 6 MCQ | tab 1 |
| 9 (4) | SQL: SELECT, FROM, WHERE and ORDER BY A games shop wants every racing game, cheapest first. | Cooperative Concept Mapping | 6 Q, 19 marks | 6 MCQ | tab 2, tab 3 |
| 9 (4) | SQL: SUM, COUNT, AND and OR How many games can be played online? | Think-Pair-Share | 6 Q, 18 marks | 6 MCQ | tab 2, tab 3 |
Each pack holds the plan, worksheet and quiz for its lesson. Teach the rows in order; the lab tabs match the student lessons.
Also for this topic