Curriculum - ICT - Lesson Plan - A bigger splash

Primary Dive into a project on sea creatures and reach new depths in collecting and sorting data
2nd July 2010, 1:00am

Share

Curriculum - ICT - Lesson Plan - A bigger splash

https://www.tes.com/magazine/archive/curriculum-ict-lesson-plan-bigger-splash

What the lesson is about

It introduces databases through a project on sea creatures and is aimed at Year 3 pupils, but can be adapted for other ages.

Aims: pupils will:

- understand that collecting and sorting information in an organised way helps us to find specific information;

- know that information on record cards is divided into fields and that a set of record cards is called a field;

- understand that information can be held as numbers, words or fixed choices, sometimes known as key words;

- sort a database to find information;

- add a record to a file in a computer database;

- search a computer database to answer simple questions;

- use a computer database to generate bar charts and interpret the data produced.

You will need

Telephone directories, Argos catalogues and non-fiction books about sea creatures.

Getting started

Introduce the idea of a database. What is a database? Discuss telephone directories, Argos catalogues and internet databases. Explain that they are used to search for information and answer questions. Ask children to compare the Argos catalogue with www.argos.co.uk. What are the advantages and disadvantages of both?

Explain that a database is made up of record cards. Show an example of a record card and point out that information on it is divided into fields such as name, type, colour. Explain that record cards in a database use the same fields. For example, a record card of a cormorant can use the same fields as one for a whale shark.

Explain that information can be recorded in different ways - fixed choice, a number or word. For example, a record card for a shark will have “Yes” alongside the field for teeth. A record card for a sea turtle will have “4” alongside the number of limbs, and “jellyfish” alongside the field for food. Explain that a set of record cards is called a file. Ask pupils to use record cards to answer a series of questions on sea creatures, such as: What colour is a whale shark? How long is a sea turtle?

Taking it further

Show pupils a description of a sea creature. How would they turn that information into a record card? Ask pupils to use the books on sea creatures to create their own record cards, listing the creature’s name, type, number of limbs, food, colour and length, and whether it has teeth and fins. Get pupils to use the cards to create a computer database.

Ask children to use the database to create a series of bar charts. How many creatures have teeth? How many are mammals? How many eat fish? Get them to interpret the data. What conclusions can they draw about these sea creatures?

Where to find it

The lesson plan, plus a PowerPoint showing examples of record cards, was uploaded by Olivia_B and can be found at www.tes.co.ukdatabases-lesson.

Want to keep reading for free?

Register with Tes and you can read two free articles every month plus you'll have access to our range of award-winning newsletters.

Keep reading for just £1 per month

You've reached your limit of free articles this month. Subscribe for £1 per month for three months and get:

  • Unlimited access to all Tes magazine content
  • Exclusive subscriber-only stories
  • Award-winning email newsletters
Recent
Most read
Most shared