- Year 5
Creating a paper-based database
I can use a paper database to record data.
- Year 5
Creating a paper-based database
I can use a paper database to record data.
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
- Data can be recorded using forms.
- A database is an organised collection of data.
- A physical database can be sorted in different ways.
- Data can be ordered, sorted and grouped.
Keywords
Data - a letter, word, number etc. that has been collected for a purpose, but that is stored without context
Database - an organised collection of data stored on a computer
Record - one complete set of data about a single item in a database
Common misconception
All records must be filled in with text.
You can use tick boxes, numbers, or other formats to show data.
To help you plan your year 5 computing lesson on: Creating a paper-based database, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your year 5 computing lesson on: Creating a paper-based database, download all teaching resources for free and adapt to suit your pupils' needs.
The starter quiz will activate and check your pupils' prior knowledge, with versions available both with and without answers in PDF format.
We use learning cycles to break down learning into key concepts or ideas linked to the learning outcome. Each learning cycle features explanations with checks for understanding and practice tasks with feedback. All of this is found in our slide decks, ready for you to download and edit. The practice tasks are also available as printable worksheets and some lessons have additional materials with extra material you might need for teaching the lesson.
The assessment exit quiz will test your pupils' understanding of the key learning points.
Our video is a tool for planning, showing how other teachers might teach the lesson, offering helpful tips, modelled explanations and inspiration for your own delivery in the classroom. Plus, you can set it as homework or revision for pupils and keep their learning on track by sharing an online pupil version of this lesson.
Explore more key stage 2 computing lessons from the Flat-file databases unit, dive into the full primary computing curriculum, or learn more about lesson planning.
Equipment
Pupils will use printable record cards, which are provided in the lesson materials.
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.Which of these is an example of a yes/no question?
Q2.What do we call a collection of information kept together?
Q3.Which of these is NOT a good way to organise information?
Q4.What is one advantage of using a list?
Q5.How do yes/no questions help in a branching database?
Q6.Arrange these steps to organise a list:
Assessment exit quiz
6 Questions
Q1.What is a database?
Q2.What is a record in a database?
Q3.Which of these can be used to record data in a paper database?
Q4.What is the purpose of sorting data in a database?
Q5.Which of these is NOT true about a database?
Q6.Match the action to its purpose:
make it easier to find
organise data about single items
record data in a simple format
group and arrange data