Year 5 - Computing
Databases in real life
Flat-file databases
Study Hub
Study Guides
This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.
Unit Summary
This unit looks at how a flat-file database can be used to organise data. Pupils will use tools to order and answer questions about data. They will create graphs and charts from their data to solve problems. They will use a real-life database to answer a question, and present their work to others.
Lesson Summary
You will learn to use a real-world database to answer questions.
Key Notes
- A real-world database stores many records that can be searched and filtered.
- Fields are used to search and sort data in a database.
- Search tools (like filters and sort functions) help narrow down large sets of data.
- Data from a database can be used to compare options and explain our choices.
Vocabulary To Learn
- sort: to put data values in order
- filter: to narrow down search results using a specific criterion
Common Mistakes To Avoid
- The database tells you the 'best' option automatically.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
A real-world database stores many records that can be searched and filtered. Fields are used to search and sort data in a database.
2. Define this computing term and give one practical example. 'sort'
to put data values in order. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: The database tells you the 'best' option automatically. Correction: The database provides data, but users must decide which option is best by comparing data in fields like price, duration and times. The 'best' choice depends on the situation.
More Lessons In This Unit
Browse all guides in the Year 5 Computing guide library.