Year 5 - Computing
Using a database
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 outline how you can answer questions by grouping and then sorting data.
Key Notes
- Data can be grouped using chosen values.
- Information can be grouped using a search.
- Grouping and sorting can be combined to answer specific questions.
Vocabulary To Learn
- criteria: a rule used to search or sort data
- search: to look for specific data in a database by using a rule
- sort: to put data values in order
Common Mistakes To Avoid
- Searching a database changes all the records.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
Data can be grouped using chosen values. Information can be grouped using a search.
2. Define this computing term and give one practical example. 'criteria'
a rule used to search or sort data. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Searching a database changes all the records. Correction: Searching only shows the records that match the search; it does not change the database itself.
More Lessons In This Unit
Browse all guides in the Year 5 Computing guide library.