Lesson Plan

Resources → Subject Notes → Information Communication Technology ICT → Notes
Lesson Plan
Grade: Date: 01/12/2025
Subject: Information Communication Technology ICT
Lesson Topic: Be able to select subsets of data using a single criterion, or multiple criteria
Learning Objective/s:
  • Describe what a filtering criterion is and differentiate between single‑criterion and multiple‑criterion filtering.
  • Apply AutoFilter to display rows that meet one condition.
  • Use Advanced Filter or a helper‑column formula to extract rows that satisfy two or more conditions.
  • Evaluate filtered results and explain how conditional formatting can highlight key data.
Materials Needed:
  • Computer lab with spreadsheet software (Excel or Google Sheets)
  • Projector and screen
  • Sample sales data worksheet (digital/printed)
  • Handout with step‑by‑step filter instructions
  • Whiteboard and markers
  • Practice activity sheets
 Introduction:

Begin with a quick question: “How would you locate only the sales records for a specific product in a large spreadsheet?” Review that a criterion is a condition data must meet and recall that students have already used basic sorting. Explain that today they will learn to filter data using one or multiple criteria and will demonstrate their understanding through a practical exit ticket.
Lesson Structure:
  1. Do‑Now (5'): Students answer on the board the information they would need to find a specific product in a sales list.
  2. Mini‑lecture (10'): Explain the concept of criteria, demonstrate AutoFilter by filtering “Region = South”.
  3. Guided practice (10'): Learners apply AutoFilter on the sample worksheet for a single criterion and record the number of rows displayed.
  4. Introduce Advanced Filter (5'): Show how to set up a criteria range for multiple conditions.
  5. Paired activity (10'): Students create a criteria range to show “Clothing” items with “Total Sales < £600” and run the Advanced Filter; discuss results.
  6. Formula‑based helper column (5'): Demonstrate =AND(B2="Electronics",E2>1500); students replicate a formula for “Units Sold >10 AND Unit Price <100” and filter on the TRUE values.
  7. Conditional Formatting & recap (5'): Apply a rule to highlight rows where “Total Sales > £2,000” and discuss visual cues for data selection.
Conclusion:

Recap that AutoFilter, Advanced Filter, and helper‑column formulas each address different filtering needs. For the exit ticket, ask learners to write one real‑world scenario where each method would be most useful. Assign homework: create a new spreadsheet with at least 15 rows of data and apply both a single‑criterion filter and a multiple‑criterion filter.