Year 5 – Data and information – Flat-file databases

Curriculum KS2 Unit


This unit looks at how a flat-file database can be used to organise data in records. Pupils use tools within a database to order and answer questions about data. They create graphs and charts from their data to help solve problems. They use a real-life database to answer a question, and present their work to others.

Unit guide

Updated: 10 Feb 2023

Learning graph

Updated: 10 Feb 2023

Summative assessment

Updated: 10 Feb 2023

Summative answer

Updated: 10 Feb 2023


Lesson 1

Creating a paper-based database

Lesson 2

Computer databases

Lesson 3

Using a database

Lesson 4

Using search tools

Lesson 5

Comparing data visually

Lesson 6

Databases in real life