Preparation: Making a database of Scottish monarchs
Preparation
The class is a P6 set, with pupils aged nine to ten years. Mr Shanks identifies historical dates when Scottish queens and kings came into power and dates when they died. He will ask the class to use the database to calculate how long they reigned.
Mr Shanks creates a PowerPoint presentation with slides introducing the lesson and the database exercise. He will project the presentation to the class through an interactive whiteboard and produce a list of kings and queens of Scotland with relevant dates. Finally, he prepares a worksheet for recording the pupils’ results.
Top tip
When teaching databases to the class, it’s much better to keep it simple – maybe just start with three or four fields. One of the difficulties the pupils had was remembering what a field is, so field types should really be introduced one at a time.
What you need
- Laptops
- Data projector
- Wireless keyboard and gyromouse
- Internet
- Database software
- Microsoft PowerPoint
| Lesson preparation: creating a PowerPoint presentation | |
|---|---|
| Description | Matt Shanks, P6 teacher at Blackridge Primary School, describes the PowerPoint presentation and worksheet he produced and the internet research he carried out before the lesson |
| Duration | 1 minute 25 seconds |
| Windows version |  Windows Media video: Lesson preparation: creating a PowerPoint presentation |
| Mac version |  QuickTime movie: Lesson preparation: creating a PowerPoint presentation |
| Transcript | Read a transcript of the Blackridge Primary School preparation video. |