Lesson Six – Data Queries

This computing teaching pack for Key Stage Two gets the children to explore and record different ways of using information in a database by sorting and querying data about some of the different volcanoes that can be found around the world.

The class can list key questions that a database could answer about different volcanoes such as which volcano is the highest or has erupted the most recently.

Download this teaching pack including a lesson plan, classroom activities and an interactive presentation to explore and record different ways of using information in a database by sorting and querying data about some of the different volcanoes that can be found around the world

Activities in this teaching pack include display posters to identify and describe different ways of sorting and querying sets of data and a set of cards to sort and search a set of data that has been collected about volcanoes around the world.

The interactive presentation gets the children to explore different ways of using information in a database by sorting and querying data about volcanoes.

This lesson is part of a computing scheme of work to get the children to explore how to use databases to store, organise and interrogate data about different volcanoes that can be found in locations and communities around the world. There are teaching activities for shared learning, differentiated worksheets to support independent learning and interactive presentations to introduce concepts and key skills.

  • Fraction Lengths, Masses and Capacities

    Fraction Lengths, Masses and Capacities

    Practise using division number skills to calculate and record the fractions of different measurements for length, mass and capacity

  • Story Changes

    Story Changes

    Explore different ways of changing characters, settings and events in a story by a significant children’s author

  • Easter Viewpoints

    Easter Viewpoints

    Explore some of the main narrative events in the Easter story and suggest how different characters might have reacted to what happened to Jesus

  • Viking Longships

    Viking Longships

    Select, combine and adjust different graphic shapes to create the design that could be used on a replica Viking longship sail