Finding Things Out

Handling Data- Branching databases - Possible Scheme of Work

In order to answer a question children collect, organise, classify and interpret data and develop a simple database.

 

Year Group some children will not have made so much progress and will most children will some children will have progressed further and will
Y4 Be able to answer a ready prepared questionnaire. Be able to create a simple graph from data, but will need help interpreting it.

In order to answer a question children collect, organise classify and interpret data and develop a simple database.

E.g. Construct a yes/no branching data base to classify leaves

Will be able to create a database, with relevant fields, and be able to sort and search the collected data for answers.
 
  • I know how to create a series of “yes/no” questions to identify objects.
  • I know that different graphs are used for different purposes.
  • I know how to collect data to enter into a database.
  • I know how to search a branching database on the computer to identify objects.
  • I know how to use a database to create bar charts and pie charts.
  • I know how to compare bar and pie charts, and talk about what they show.
  • I know how to create a line graph.
  • I know how to create a branching database which I can use to identify any object in a collection.
  • I know how to explain why line graphs are better for showing how something changes.

 

Linked Planning Linked Resources

Data Handling

MAPE Whodunnit
Use a database to help Sherlock Holmes solve some crimes.
   
Branching Databases word Fruit Cards    
Collecting and presenting information questionnaires & pie charts excelChange in temp excel Boys and girls  

Branching databases

wordClick here to download the planning seen below


Week

Area of study (From NC PoS)

Learning Objectives

Activities

Key Vocabulary

Resources

Assessment Outcomes

 

1

Gather information from a variety of sources.

To sort objects using yes / no questions.

Pupils sort a collection of objects (e.g. fruit) using questions with yes / no answers to create a tree diagram.

Sort
Tree diagram

Collection of objects

Level 2:
I can use ICT to organise and classify information.

Level 3:
I can use ICT to find and use appropriate stored information. 

I can follow a simple search to find information when using a database.

 

2

Gather information from a variety of sources.

To use the computer to sort objects.

Pupils explore a pre-prepared branching database and identify objects by answering the questions.

Branching database

Branching Database e.g. Textease Branch /
Flexitree / Decision Tree

 

3

Enter and store information in a variety of forms.

To create a branching database.

Demonstrate how to create a branching database.  Pupils suggest yes / no questions to include.

Branching database

Branching Database e.g. Textease Branch /
Flexitree / Decision Tree

 

4

Enter and store information in a variety of forms.

To create a branching database.

Pupils create a branching database to sort a collection of objects using yes / no questions.

Branching database

Branching Database e.g. Textease Branch /
Flexitree / Decision Tree

 

5

Find information … and check it for accuracy.

To test a branching database for errors.

Pupils test their branching database and check that it identifies each object correctly.

Branching database

Branching Database e.g. Textease Branch /
Flexitree / Decision Tree

 

Collecting and presenting information – questionnaires & pie charts

wordClick here to download the planning seen below

Week

Area of study (From NC PoS)

Learning Objectives

Activities

Key Vocabulary

Resources

Assessment Outcomes

 

1

Gather information from a variety of sources.

To interpret charts and graphs.

Show pupils a variety of charts & graphs. Discuss how these present data / information.  Why is it useful to present data in this way?

Charts
Graphs

Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet

Level 2:
I can use ICT to organise and classify information.

Level 3:
I can use ICT to find and use appropriate stored information. 

I can follow a simple search to find information when using a database.

 

2

Enter and store information in a variety of forms.

To design a simple questionnaire.

Design a questionnaire to collect information about pupils in the class e.g. age, hair colour, eye colour.  Pupils add this information to a database.

Questionnaire
Database
Records
Fields
Field type

Database e.g. Information Magic / Textease Database

 

3

Enter and store information in a variety of forms.

To make comparisons using bar and pie charts.

Pupils record the no. of boys & girls in class into a spreadsheet, & create bar charts & pie charts.  Which is more helpful? Pupils create other bar / pie charts.

Spreadsheet
Bar chart
Pie chart

Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet

 

4

Enter and store information in a variety of forms.

To draw a line graph to show changes over time.

Pupils enter the results of a science investigation providing continuous data into spreadsheet (e.g. changes in temp.).  Pupils create bar & pie charts.  Why these are unhelpful?  Create line graph & explain how this shows changes over time.

Spreadsheet
Bar chart
Pie chart
Line graph

Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet

 

5

Enter and store information in a variety of forms.

To interpret and analyse information in graphs.

Pupils use opportunities to interpret and analyse graphs and charts within work undertaken across the curriculum (e.g. science and maths).

Spreadsheet
Bar chart
Pie chart
Line graph

Spreadsheet e.g. Excel / Number Magic / Textease Spreadsheet