| Lesson Plan |
| Grade: |
Date: 25/02/2026 |
| Subject: Information Communication Technology ICT |
| Lesson Topic: Be able to perform searches using a variety of operators including AND, OR, NOT, >, <, =, >=, <=, <> |
Learning Objective/s:
- Describe the purpose of logical and comparison operators in spreadsheet formulas.
- Apply AND, OR, NOT, >, <, =, >=, <=, <> to create conditional statements.
- Construct formulas using COUNTIFS, SUMIFS, and FILTER with multiple criteria.
- Identify and correct common errors when combining operators.
|
Materials Needed:
- Computer lab with spreadsheet software (Excel or Google Sheets)
- Projector and screen
- Sample dataset handout
- Worksheet with practice exercises
- Teacher’s demonstration file
- Whiteboard and markers
|
Introduction:
Begin with a quick poll asking students how they currently filter data in spreadsheets, linking to everyday examples like budgeting. Review their prior knowledge of basic formulas, then state that by the end of the lesson they will confidently use a full range of search operators to extract precise information.
|
Lesson Structure:
- Do‑now (5 minutes): Short quiz on identifying logical vs. comparison operators.
- Mini‑lecture (10 minutes): Explain AND, OR, NOT with real‑world examples.
- Demonstration (10 minutes): Show how >, <, =, >=, <=, <> work and how to combine them in formulas.
- Guided practice (15 minutes): Students build COUNTIFS and FILTER formulas on the sample dataset with teacher support.
- Independent exercise (15 minutes): Complete worksheet to flag students scoring ≥70 and from “South”, then calculate totals.
- Check for understanding (5 minutes): Review common mistakes, answer questions, and confirm success criteria.
|
Conclusion:
Summarise how logical and comparison operators work together to create powerful searches, and ask a few students to share their formulas. Collect an exit ticket where each learner writes one correct operator usage and one mistake to avoid. For homework, assign a short task to design a spreadsheet that uses at least three different operators to generate a summary report.
|