Year 5 - Computing
Using search tools
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 explain that tools can be used to select specific data.
Key Notes
- 'AND' and 'OR' can help to narrow or widen searches in a database.
- Fields and values can be used to answer questions.
- Questions can be answered by using multiple pieces of information.
Vocabulary To Learn
- AND: used in a search to find records that match all the given criteria
- OR: used in a search to find records that match at least one of the given criteria
Common Mistakes To Avoid
- Using 'AND' produces more results than a search with a single condition.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
'AND' and 'OR' can help to narrow or widen searches in a database. Fields and values can be used to answer questions.
2. Define this computing term and give one practical example. 'AND'
used in a search to find records that match all the given criteria. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Using 'AND' produces more results than a search with a single condition. Correction: 'AND' reduces the number of results because it narrows the search to records that meet all the given conditions.
More Lessons In This Unit
Browse all guides in the Year 5 Computing guide library.