Lesson 3: Sorting and filtering

Inputting data into a database, pupils then sort and filter the data by different values and create questions that can be answered using information from their database

Before the lesson

Download classroom resources

Learning objective

  • To sort, filter and interpret data

National curriculum

Pupils should be taught to:

  • Use search technologies effectively, appreciate how results are selected and ranked, and be discerning in evaluating digital content
  • Select, use and combine a variety of software (including internet services) on a range of digital devices to design and create a range of programs, systems and content that accomplish given goals, including collecting, analysing, evaluating and presenting data and information
  • Use technology safely, respectfully and responsibly; recognise acceptable/unacceptable behaviour; identify a range of ways to report concerns about content and contact

Success criteria

Cross-curricular links

Attention grabber

Main event


Pupils needing extra support: may benefit from creating a paper based series of questions and keep it to a simple ‘highest, lowest, fastest, slowest’ style of question.


Pupils working at greater depth: should be encouraged to type up their questions and explain why sorting and filtering is useful.

Wrapping up

Assessing pupils' progress and understanding


Created by:
Cat Lamin,  
Computing specialist
Cat was a committed primary school teacher for twelve years. After starting her independent consultancy ‘Crossover Solutions’ she has travelled to Argentina, Brazil and America to share her wealth of knowledge of computer science with other teachers. Her enjoyment for…
Find out more