Computer databases
Lesson details
Learning outcome
I can navigate and sort data in a computer-based database using different views.
Key learning points
- Data can be stored in fields.
- Flat-file databases can display information in different ways.
- Each record in a database holds all of the data about one item.
Keywords
Field - a category of data in each record
View - a way of presenting data that has been sorted and organised
Common misconception
You must look through every record individually to find an answer.
Sorting a computer database by fields allows you to quickly find answers without checking each record one at a time.
Teacher tip
Use live modelling of the database software to support pupil understanding and allow space for questioning during the demonstration.
Equipment
Pupils will need access to a device with database software. Examples in this lesson use J2E database https://oak.link/database
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.What is a database?
Q2.What does a record in a database represent?
Q3.What term refers to letters, words or numbers collected for a purpose but stored without context?
Q4.Why is it important to organise data?
Q5.What is one challenge of using a paper database?
Q6.Why would a database use tick boxes?
Assessment exit quiz
6 Questions
Q1.What is the term for a category of data in each record of a database?
Q2.What is the term for a complete set of data about one item in a database?
Q3.Match the term to its definition:
a way to organise and display data in rows and columns
a tool used to collect and input information
letters, words, or numbers collected for a purpose
an organised collection of data stored for easy access
to arrange data in a specific order based on a chosen field.
Q4.What allows you to quickly find an answer in a computer database without looking through every record individually?
Q5.Order the steps to find specific information in a database:
Q6.Why is it important to compare views of a database?
To help you plan your 5 computing lesson on: Computer databases, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your 5 computing lesson on: Computer databases, 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.