Lesson Plan

Resources → Subject Notes → Information Communication Technology ICT → Notes
Lesson Plan
Grade: Date: 25/02/2026
Subject: Information Communication Technology ICT
Lesson Topic: Be able to use functions including sum, average, maximum, minimum, integer, rounding, counting, LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, IF
Learning Objective/s:
  • Apply SUM, AVERAGE, MAX and MIN to calculate totals and key statistics.
  • Use INT and ROUND to format numeric data accurately.
  • Implement COUNT/COUNTA to determine the quantity of data entries.
  • Construct and apply LOOKUP, VLOOKUP, HLOOKUP and XLOOKUP for data retrieval.
  • Create IF statements to perform logical tests and assign outcomes.
Materials Needed:
  • Computer lab with spreadsheet software (Excel or Google Sheets)
  • Projector and screen
  • Sample sales worksheet handout
  • Practice task worksheet
  • Whiteboard and markers
  • Internet access for XLOOKUP demonstration
 Introduction:

Begin with a quick poll: “What everyday tasks rely on calculations?” Connect this to the previous lesson on basic formulas. Explain that today students will master a range of functions to analyse data efficiently. Success criteria: correctly apply each function in a realistic spreadsheet scenario.
Lesson Structure:
  1. Do‑now (5') – Short quiz on simple SUM/AVERAGE formulas displayed on the board.
  2. Mini‑lecture (10') – Demonstrate syntax and use of SUM, AVERAGE, MAX, MIN with a live spreadsheet.
  3. Guided practice (15') – Students calculate totals, averages, and extremes on a provided worksheet while the teacher circulates.
  4. Rounding & integer activity (10') – Demo INT and ROUND, then students format monetary values.
  5. Lookup functions workshop (15') – Show LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP; students build a product price table and retrieve data.
  6. Logical IF challenge (10') – Students write IF formulas to assign grades; peer‑check results.
  7. Error‑spotting quiz (5') – Identify common errors (#VALUE!, #N/A, #DIV/0!) in sample formulas.
  8. Recap & exit ticket (5') – Students note one function they mastered and one question remaining.
Conclusion:

Review the key functions and how they interrelate, reinforcing correct syntax and error handling. Collect exit tickets where students record the function they feel confident using and any lingering question. For homework, assign students to create a personal budget spreadsheet that incorporates at least five of the taught functions.