Year 5

Using a database

Link copied to clipboard

Year 5

Using a database

Link copied to clipboard

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

  1. 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.

Loading...

3 Questions

Q1.
Which of these are examples of database fields? (tick all that apply)
An image in a quiz
Brazil
Correct answer: Currency
Hindi
Correct answer: Population
Q2.
How many records can you see in this database?
An image in a quiz
36
5
Correct answer: 6
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?
An image in a quiz
12
Diet
Correct answer: Length
Name

3 Questions

Q1.
Which column has this data been sorted by?
An image in a quiz
Correct answer: Area
Country Name
Currency
Population
Q2.
The data below has been produced by a search. What was searched for?
An image in a quiz
Area = 505,990
Currency = Peso
Correct answer: Language = Spanish
Q3.
By which fields has this data been searched and sorted?
An image in a quiz
Currency then Area
Correct answer: Currency then Population
Language then Area
Population then currency