Activity 01
Pairs: Query Relay Challenge
Pairs share a spreadsheet of class survey data on hobbies. One pupil enters an AND or OR query, like 'sport AND football'; partner checks results and scores accuracy. Switch roles after five queries, then discuss refinements.
Explain how 'AND' and 'OR' operators make search results more specific.
Facilitation TipDuring Query Relay Challenge, circulate and ask each pair to explain their query logic aloud before moving to the next station.
What to look forProvide students with a simple dataset (e.g., a list of pets with names, types, and colors). Ask them to write two queries: one using 'AND' to find all 'dogs' that are 'brown', and another using 'OR' to find all 'cats' or 'dogs'.
AnalyzeEvaluateCreateDecision-MakingSelf-Management
Generate Complete Lesson→· · ·
Activity 02
Small Groups: Digital vs Paper Race
Provide identical datasets: one digital spreadsheet, one printed. Groups search for specifics, like 'girls OR Year 5 who like reading', timing each method. Record times and compare why digital wins.
Compare the speed of searching a database versus a paper filing system.
Facilitation TipIn Digital vs Paper Race, provide identical datasets on paper and screen so students time and compare the same task.
What to look forPose the question: 'Imagine you have a huge pile of Lego bricks. Would it be faster to find a specific red brick by sorting them all by color first, or by looking through them one by one for a red brick? Explain why.' This prompts comparison between sorting and filtering/searching.
AnalyzeEvaluateCreateDecision-MakingSelf-Management
Generate Complete Lesson→· · ·
Activity 03
Whole Class: Filter and Sort Demo
Project a large class pet dataset. Teacher demonstrates filtering by colour, then sorting by age. Class predicts outcomes, votes, and tries on personal copies to verify.
Differentiate between a filter and a sort in a spreadsheet.
Facilitation TipFor Filter and Sort Demo, use a shared screen to show filters hiding and revealing rows, and sorts rearranging columns in real time.
What to look forPresent students with a spreadsheet view showing a list of students and their test scores. Ask them to identify which action would hide students who scored below 70% (filter) and which action would arrange students from highest to lowest score (sort).
AnalyzeEvaluateCreateDecision-MakingSelf-Management
Generate Complete Lesson→· · ·
Activity 04
Individual: Personal Data Hunt
Pupils enter their own profile data into a template spreadsheet. They create three queries using AND/OR to find matches, like 'age >10 AND favourite colour blue', then share one with a partner.
Explain how 'AND' and 'OR' operators make search results more specific.
What to look forProvide students with a simple dataset (e.g., a list of pets with names, types, and colors). Ask them to write two queries: one using 'AND' to find all 'dogs' that are 'brown', and another using 'OR' to find all 'cats' or 'dogs'.
AnalyzeEvaluateCreateDecision-MakingSelf-Management
Generate Complete Lesson→A few notes on teaching this unit
Teach this topic by pairing concrete analogies with immediate digital practice. Start with a physical sorting task, such as organizing cards by color, to introduce sorting and filtering. Then move to digital tools to show how computers automate these actions, reinforcing that filters hide data while sorts reorder it. Avoid rushing into Boolean logic without first building confidence in basic operations.
Successful learning looks like pairs explaining why their query returned a specific subset of results, small groups racing to find data faster with digital tools than paper, and individual students confidently distinguishing filters from sorts in a real dataset. Clear articulation of logic gates and data-handling actions shows understanding.
Watch Out for These Misconceptions
During Query Relay Challenge, watch for students who believe 'AND' adds more results than 'OR'.
Have these students draw a Venn diagram on their worksheet to visualize overlapping sets, then re-run their query to see how 'AND' narrows results to the overlap.
During Digital vs Paper Race, watch for students who think filters delete data permanently.
Ask them to clear the filter during the demo and watch the hidden rows reappear, repeating this process until the misconception is addressed through repeated observation.
During Filter and Sort Demo, watch for students who confuse sorting with filtering.
Ask them to predict what will happen before each action: 'Will the list shrink to a subset or reorder?' Then run both actions side by side to highlight the difference.
Methods used in this brief