In this unit children 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.
Children 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.
Children 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.
Where this unit fits in
This unit assumes that children can:
- measure in centimetres with some accuracy and reliability
- use different units to measure weight, height and other body measurements.
- database
- field
- record
- file
- sort
- classify
- order
- bar
- chart
Resources
- measuring equipment such as scales, height measures and rulers
- a set of paper-based record cards
- a computer database with the information from the record cards
Images
Video
Software suitable to use:
Online Resources-for Teachers:
DATABASES(primary resources)
http://www.primaryresources.co.uk/ict/ict2.htm
key idea: that collecting and storing information in an organised way helps them find answers to questions
key idea: that information on record cards is divided into fields and that a set of record cards is called a file
key idea: that information can be held as numbers, choices (such as yes/no) or words
key idea: that information can be taken from pictures or text
key idea: that ICT can be used to store and sort information
technique: to add a record to a file in a computer database
technique: to answer simple questions by matching the contents of a single field
technique: to answer simple questions by ordering records by a key field and then taking the top or bottom record
technique: to use a database to produce bar charts
key idea: that information on record cards is divided into fields and that a set of record cards is called a file
key idea: that information can be held as numbers, choices (such as yes/no) or words
key idea: that information can be taken from pictures or text
key idea: that ICT can be used to store and sort information
technique: to add a record to a file in a computer database
technique: to answer simple questions by matching the contents of a single field
technique: to answer simple questions by ordering records by a key field and then taking the top or bottom record
technique: to use a database to produce bar charts
- to use a database to sort and classify information and to present their findings
Section 1: SETTING THE SCENE
Take a random selection of papers and books and discuss how difficult it is to find information when it is not organised. Explain that information can be structured and discuss how this can help them find information more easily.
Introduce the class to a set of paper-based record cards containing information on a particular subject, such as mini-beasts. Explain how the information is structured into fields with all the information on one object held on a single card called a 'record'. Discuss the possible advantages this might have for finding information quickly.
Section 2: SHORT FOCUSED TASKS
Divide the class into small groups and give each group a set of numbered record cards.
Ask the children to use the record cards to answer questions such as: what information is on the fifth record card in the field 'legs'; which record contains the animal called 'woodlouse' in its name field; how many records are in the file; how many fields are in each record?
Section 3: SHORT FOCUSED TASKS
Use the record cards from the above activity and explain how to add information to a record card and point out where the information should be entered as numbers eg the number of legs, text eg colour or as a choice eg 'yes' or 'no' in the wings field. Divide the children into groups and give each group written descriptions, or pictures, of three new mini-beasts. Ask them to extract the relevant information and add three new record cards to the file.
Explain how each card holds information on one mini-beast and that this information is divided into fields with different headings, for example name, size, colour. Tell the class that the fields are the same on each card and discuss how this will help them find information and answer simple questions, such as: how many mini-beasts have four legs?
Section 4: SHORT FOCUSED TASKS
Prepare a database containing information on mini-beasts including details of: name, habitat, number of legs, wings, colour.
Demonstrate how to enter the program and select the correct file on mini-beasts. Show the class how to move through the records. Point out the features that the computer database shares with the paper-based record cards. Demonstrate how to add a record to the database and ask children in turn to add records.
Section 5: SHORT FOCUSED TASKS
Show the class how to turn questions, such as which animals are green?; which animal has the most legs?, into appropriate search criteria, such as colour field = green or order by field legs. Discuss the advantages and disadvantages of using the computer for this.
Section 6: SHORT FOCUSED TASKS
Use the record cards to demonstrate how a database can produce bar charts. For example, group the cards according to the number in the 'legs' field and stack them to produce a bar chart showing the numbers of animals with each amount of legs.
Demonstrate how to use the computer database of mini-beasts to produce bar charts. Discuss the advantages of using ICT to draw graphs, such as accuracy and speed. Divide the children into groups and ask them to create their own bar chart. Ask them to print their bar chart and to write about it. Ask them to think of three questions to ask other children about the graph.
Section 7: INTEGRATED TASK
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.
Expectations
most children will: enter data into a database with a predetermined structure and use it to answer straightforward questions and produce bar charts
some children will not have made so much progress and will: enter data into a database with a predetermined structure and find information in it by matching the query to the question
some children will have progressed further and will: enter data into a database with a predetermined structure and use it to answer straightforward questions and produce bar charts; turn questions into search criteria
Assessment
2simple 2Assess
Activities
Database 1,
Database 2,
Database 3,
Add to a Database,
Database graphs,
Activities by QCA- Database 1,2,3, Add to Database, Database Graphs,
