Introduction to databases
In this unit pupils learn to collect and store information involving more than two variables. They will use a database to answer simple questions by sorting and finding the top or bottom and searching in a single field. They will be introduced to files, records and fields by exploring and comparing computer-based data and paper-based information. They will use a computer database, add to it, carry out simple searches and produce bar charts. Pupils will apply what they have learnt in this unit when using ICT to handle and present information in geography, science, design and technology, and history.
Assessment: Pupil Self Review Statements
The Case of the Vanishing Sandwich
"The Mystery of the Vanishing Sandwich" sees Paddington Bear become the victim of a crime. Pupils have to carry out sorting activities at and away from the computer to help the local police find the culprit. Clues to the criminal's identity are hidden within the story and by carrying out (a) a conventional sort using picture cards (b) a sort using a branching database (c) a sort using a spreadsheet, the children are able to "sort out" and pinpoint the culprit.
www.grangeschool.co.uk (Scroll down to Activity 1)
Textease Resources to support this unit
Data handling with Information Workshop
St Mary's Primary School
Databases - Projects and Advice
Short focused tasks:
Using a computer to store data and retrieve information - Party Foods
The above lesson links to Science Unit 3A - teeth and eating, but may be taught independently. It uses a very simple prepared database in order for children to input data quickly, as this is not the main focus of the lesson.
Searching a database for information on holiday weather
This work through three lessons links to Geography Unit 7 Weather around the world. It may be taught alongside, or integrated to address the enquiry question about holiday destinations: “What will the weather be like? How will it affect what we do?”
Suggested Cross Curricular Activities
As part of their geography topic on the weather, the children could add information to a prepared database on different holiday destinations.
Geography 7 Weather around the World
Henry VIII Wives
Y3: p90-93 Handling Data
Y3: p80-89 Shape and Space
Y3 T1 Text Level, Non Fiction
Y3 T2 Text Level, Non Fiction
Y3 T3 Text Level, Non Fiction
ICT Scheme of work from Greenwich
A complete set of resources linked to the QCA scheme of work with lesson plans, activities, downloadable resources and more.
Newham ICT Scheme of Work
Featuring active flip chart resources and tutorial videos. Importantly every unit contains a challenge lesson which gives the children an opportunity to develop their independent ICT capability. www.itass.newham.gov.uk/curriculum/sow.aspx