Learning Objectives

Design and create a range of programs, systems and content that accomplish given goals, including collecting, analysing, evaluating and presenting data and information

Learning Outcomes

All children: will collect and present data and information

Most children: will collect, present and analyse data and information

Some children: will collect, present, analyse and evaluate data and information

Cross curricular links

Key Stage 2

Maths - solve one-step and two-step questions [for example, ‘How many more is...?’ and ‘How many less is...?’] using information presented in scaled bar charts and pictograms and tables.

interpret and present data using bar charts, pictograms and tables.

Upper Key Stage 2

Complete, read and interpret information in tables.

Begin to decide which representations of data are most appropriate and why

Vocabulary

( see glossary http://www.j2e.com/bett2016/Admin/glossary/ ).

Resources

Card Template: http://www.j2e.com/data/minibeastscards/

Database Template http://test.j2e.com/data/examples/minibeasts/

Introduction

Recap work on understanding what a database is. Explain the meaning of field, datatype and record. Use the staring video as appropriate.

Load the card template and show the information, draw attention to the fields and data type (name, picture, description). What happens if we add another field? Ask questions such as "What will happen if we change the picture of the item?" Will that change the search results? If introducing databases for the first time print out the physical cards to simulate Task 1. Ask the questions.

Which animal(s) have wings?

How many animal(s) have a shell?

Which animal(s) have the most/least amount of legs?

We are encouraging the pupils to realise and understand that the physical database takes a lot more time to add, alter and interrogate the information. Then move to the digital database activity for Task 1 below.

Main Activities

Task 1.

Load the template, ask the pupils to answer the questions below. What other questions might they ask?

Stop the class and review the forms and the fields. Now create a search criteria of tables and forms to answer these questions.

Which animal(s) have wings?

How many animal(s) have a shell?

Which animal(s) have the most/least amount of legs?

Challenge

Add some more Mini beasts of your own to the database.

Create your own farm animal database.