Variables in Games · Spring Term

Searching and Filtering Data

Using queries to find specific information within large datasets.

About This Topic

Searching and filtering data teaches Year 5 pupils to use queries for finding specific information in large datasets. They explain how 'AND' operators narrow results by requiring all conditions, while 'OR' widens them by accepting any. Pupils compare database searches, which process data instantly, to paper filing systems that require manual sorting. They also differentiate filters, which hide non-matching rows, from sorts, which reorder data by columns. This meets KS2 Computing standards for data and information handling.

In the Variables in Games unit, these skills parallel querying game states with variables, building logical reasoning and data literacy. Pupils practice precise questioning, a key computational thinking element, preparing them for real-world tasks like safe online research or spreadsheet analysis in other subjects.

Active learning suits this topic perfectly. Collaborative challenges with class datasets let pupils test operators live, observe result changes, and debate efficiencies. Hands-on races between digital tools and paper copies reveal speed differences tangibly, boosting engagement and retention through trial, error, and peer explanation.

Learning Objectives

• Explain how 'AND' and 'OR' operators modify search query results by requiring or accepting multiple conditions.
• Compare the efficiency of searching digital datasets versus manual paper-based filing systems.
• Differentiate between filtering data to hide non-matching rows and sorting data to reorder columns in a spreadsheet.
• Construct search queries using logical operators to retrieve specific information from a given dataset.

Before You Start

Introduction to Spreadsheets

Why: Students need basic familiarity with rows, columns, and cells to understand filtering and sorting operations.

Basic Data Entry and Organization

Why: Understanding how to input and organize simple lists of information is foundational for performing searches and applying filters.

Key Vocabulary

Query	A request for information from a database or dataset. It specifies what data you want to find.
AND operator	A logical operator used in searches that requires all specified conditions to be true for a result to be included.
OR operator	A logical operator used in searches that requires at least one of the specified conditions to be true for a result to be included.
Filter	A tool that hides rows in a dataset that do not meet specific criteria, showing only the matching data.
Sort	The process of arranging data in a specific order, such as alphabetically or numerically, based on the values in one or more columns.

Active Learning Ideas

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.

⏱ 25 min·Pairs

Generate mission

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.

⏱ 35 min·Small Groups

Generate mission

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.

⏱ 20 min·Whole Class

Generate mission

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.

⏱ 30 min·Individual

Generate mission

Real-World Connections

Librarians use search queries with operators like 'AND' and 'OR' to help patrons find specific books or articles within a library's digital catalog, ensuring efficient information retrieval.

Online shoppers use filters on retail websites to narrow down product choices by brand, size, and price. This is similar to how a spreadsheet filter hides items that don't match the customer's needs.

Researchers analyzing scientific data use complex queries to extract specific findings. For example, a biologist might search for all studies on a particular species conducted in a specific region using 'AND' operators.

Watch Out for These Misconceptions

Common Misconception

'AND' adds more results than 'OR'.

What to Teach Instead

'AND' requires both conditions, so it narrows results; 'OR' accepts either, broadening them. Venn diagram activities in pairs help pupils overlap sets visually, clarifying logic through drawing and comparison.

Common Misconception

Filtering deletes data permanently.

What to Teach Instead

Filters only hide rows temporarily; data returns when cleared. Group demos toggling filters on shared screens let pupils see data reappear, building confidence via repeated, reversible trials.

Common Misconception

Sorting and filtering do the same job.

What to Teach Instead

Sorting reorders data; filtering shows subsets. Side-by-side races in small groups highlight differences, as pupils time tasks and explain why one suits ordering, the other selecting.

Assessment Ideas

Exit Ticket

Provide 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'.

Discussion Prompt

Pose 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.

Quick Check

Present 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).

Frequently Asked Questions

How do AND and OR operators work in data searches?

'AND' requires all conditions to match, narrowing results, for example, 'cat AND black' finds only black cats. 'OR' matches any condition, broadening results, like 'cat OR dog' for all pets. Pupils test these on sample datasets to see result counts drop or rise, grasping precision control for efficient querying.

What is the difference between filtering and sorting in spreadsheets?

Filtering hides rows not meeting criteria, keeping the dataset intact for quick views. Sorting rearranges rows by column values, like A-Z by name. Hands-on practice with class data shows filtering for subsets versus sorting for sequences, helping pupils choose tools correctly.

How can active learning help teach searching and filtering data?

Active approaches like query relays or digital-paper races make operators concrete. Pupils collaborate on real datasets, test predictions, and adjust queries live, experiencing speed gains firsthand. Peer discussions during rotations correct errors quickly, deepening understanding through doing and sharing over rote memorisation.

Why compare database searching to paper filing systems?

This highlights digital efficiency: databases scan instantly, while paper requires manual checks. Timed races with matching datasets prove the point, motivating pupils on technology's value. It ties to curriculum goals, showing computational advantages in everyday data tasks.