Using search tools
Lesson details
Learning outcome
I can explain that tools can be used to select specific data.
Key learning points
- '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.
Keywords
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 misconception
Using ‘AND’ produces more results than a search with a single condition.
‘AND’ reduces the number of results because it narrows the search to records that meet all the given conditions.
Teacher tip
Familiarise yourself with the j2data sample databases ahead of the lesson to confidently model how to use search and filter tools.
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 does the term 'criteria' mean in the context of data?
Q2.What process organises data values in a specific order, such as alphabetical or numerical?
Q3.Arrange the steps for sorting data in descending order in the correct sequence.
Q4.Why might grouping and sorting be combined?
Q5.Match the keywords to their correct definitions.
to look for specific information in a database using a rule
to arrange data values in a specific order
information that is stored, processed or analysed
a structured collection of data
Q6.What does it mean when you sort data?
Assessment exit quiz
6 Questions
Q1.Which operator is used to narrow a search by requiring all conditions to be met?
Q2.Which operator is used in a search to find records that meet at least one of the given criteria?
Q3.Why is it useful to use both AND and OR in a search?
Q4.Which of the following searches correctly uses the AND operator to narrow results?
Q5.Match the keywords to their definitions.
finds records meeting all given criteria
finds records meeting any criteria
a single category of information
content stored in a field
Q6.What happens when you use the AND operator in a search?
To help you plan your 5 computing lesson on: Using search tools, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your 5 computing lesson on: Using search tools, 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.