Year 5
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
These resources were created for remote use during the pandemic and are not designed for classroom teaching.
Lesson details
Key learning points
- In this lesson, we will search and order a database to answer questions.
Licence
This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.
3 Questions
Q1.
Which of these are examples of database fields? (tick all that apply)

Brazil
Hindi
Q2.
How many records can you see in this database?

36
5
8
Q3.
Here is the table view of a database. We want to answer the question: ‘How long is the longest dinosaur?’ Which field would you use to answer it?

12
Diet
Name
3 Questions
Q1.
Which column has this data been sorted by?

Country Name
Currency
Population
Q2.
The data below has been produced by a search. What was searched for?

Area = 505,990
Currency = Peso
Q3.
By which fields has this data been searched and sorted?

Currency then Area
Language then Area
Population then currency