Standards Site

 
 
Schemes of Work
QCA

ICT at key stages 1 and 2    (Year 3)

Unit 3C: Introduction to databases
Section 7: INTEGRATED TASK

QCA

Objectives

Children should learn:
  • to use a database to sort and classify information and to present their findings

Activities

Outcomes

Children:
  • Tell the class that they are going to create a database containing information on each child in the class. Ask them to think of some questions they would like to ask, such as: how many children have brown eyes; who is the tallest in the class? Encourage them to think of questions which require numerical and non-numerical data.
  • Divide the children into pairs and discuss the specific information that they need to collect. Explain the structure and ask the children to measure and record their personal information on a record card. Then ask each pair to add their information to the computer data file. Once all pairs have added their information, create a class list of questions and discuss how they can be translated into search criteria. Allocate questions and give each pair some time to work out and print their answers. Discuss and summarise the information with the class.
  • collect appropriate information, enter it into a database and use the database to answer simple questions

Points to note

Children who find the work difficult could be given simple questions, such as: who is the tallest in the class? More able children could be asked questions which require them to produce bar charts illustrating the numbers with particular eye colours, shoe sizes or favourite sports.

Sections in this unit

<< previous section  
This unit is divided into sections. Each section contains a sequence of activities with related objectives and outcomes. You can view this unit by moving through the sections or print/download the whole unit.
1. SETTING THE SCENE
2. SHORT FOCUSED TASKS
3. SHORT FOCUSED TASKS
4. SHORT FOCUSED TASKS
5. SHORT FOCUSED TASKS
6. SHORT FOCUSED TASKS
7. INTEGRATED TASK