Computing · Year 5

Active learning ideas

Searching Tables

Students learn best when they are actively engaged with the material, and searching tables is no exception. Hands-on practice with data allows students to directly experience how search functions work, building intuitive understanding. This active approach moves beyond simply explaining search bars to letting students discover their power.

• National Curriculum Attainment Targets
• KS2: Computing - Information Technology

• 30–45 min
• Pairs → Whole Class
• 3 activities

Activity 01

• Think-Pair-Share
• 45 min · Small Groups

Format Name: Animal Fact Finder

Provide students with a spreadsheet of animal facts, including columns for habitat, diet, and characteristics. Challenge them to use search and filter functions to find animals that meet specific criteria, such as 'lives in the ocean' AND 'is a mammal'.

Explain how filtering helps you find specific information quickly in a large table.

Facilitation Tip

During the Inquiry Circle for Animal Fact Finder, encourage students to formulate questions that require specific data points, guiding them towards effective search terms.

• Understand
• Apply
• Analyze
• Self-Awareness
• Relationship Skills

Activity 02

• Think-Pair-Share
• 30 min · Pairs

Format Name: Recipe Search Challenge

Students are given a list of recipes with ingredients and cooking times. They must filter the list to find recipes that meet certain requirements, like 'takes less than 30 minutes' OR 'contains chicken'.

Predict what happens if you search for a word that isn't in your data.

Facilitation Tip

In the Recipe Search Challenge, circulate to ensure students are correctly applying filter criteria rather than just sorting, prompting them with examples of what they want to find.

• Understand
• Apply
• Analyze
• Self-Awareness
• Relationship Skills

Activity 03

• Think-Pair-Share
• 35 min · Individual

Format Name: Class Data Explorer

Create a simple database of student interests or favourite books. Students practice searching for specific entries or filtering to find classmates who share particular preferences, fostering a sense of community.

Design a set of criteria to filter a list of animals (e.g., 'has fur' AND 'eats meat').

Facilitation Tip

For the Class Data Explorer, help students refine their search queries during their inquiry, ensuring they are using the correct syntax or keywords to find the data they seek.

• Understand
• Apply
• Analyze
• Self-Awareness
• Relationship Skills

A few notes on teaching this unit

Teachers can effectively introduce searching tables by modeling the process with clear, relatable examples and then providing ample opportunity for guided and independent practice. It's crucial to differentiate between searching and sorting early on, using visual aids or direct comparisons. Emphasize that technology is a tool, and understanding how to use it precisely is the key skill.

Students will be able to confidently use search functions and basic filters to locate specific information within a given dataset. They will understand that precise keywords are necessary for accurate results and can articulate the difference between finding information and organizing it. Success looks like students independently navigating a table to answer specific questions.

---

Watch Out for These Misconceptions

• During Animal Fact Finder, watch for students who assume that slight misspellings of animal names or characteristics will still yield results.

  Redirect students by having them deliberately misspell a term and observe the "no results" output, then guide them to correct their spelling for an accurate search.

• In the Recipe Search Challenge, watch for students who confuse filtering (hiding rows that don't match) with sorting (rearranging rows).

  Ask students to first sort the recipes by cooking time, then apply a filter for vegetarian options, prompting them to describe what happened to the list in each step.

• During Class Data Explorer, students might assume that searching for a general term like "sports" will find all related entries, even if entries are more specific like "basketball" or "swimming."

  Guide students to test broader versus narrower search terms, showing them how "sports" might yield fewer results than a more specific query if the data isn't tagged that way, or vice-versa depending on data structure.

---

Methods used in this brief

• Think-Pair-Share