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 use named cells and named ranges
Learning Objective/s:
  • Define named cells and named ranges in a spreadsheet.
  • Explain how names improve formula readability and reduce errors.
  • Create and edit named cells and ranges using the Name Box and Name Manager.
  • Apply named ranges in formulas to calculate totals, taxes, and other aggregates.
  • Identify and correct common naming mistakes such as invalid characters or duplicate names.
Materials Needed:
  • Computers with spreadsheet software (Excel or Google Sheets)
  • Projector or interactive whiteboard
  • Sample budget worksheet handout
  • Practice activity worksheet
  • Keyboard shortcut cheat‑sheet
  • Access to Name Manager dialog
 Introduction:

Start with a quick question: “How would you keep track of tax rates and cost totals without getting lost in cell addresses?” Review students’ prior experience with basic formulas, then state that by the end of the lesson they will be able to name cells and ranges to make spreadsheets clearer and more reliable.
Lesson Structure:
  1. Do‑now (5') – Students examine a simple formula sheet and identify which parts are cell references.
  2. Mini‑lecture (10') – Explain named cells vs. named ranges, benefits, and naming rules; demo naming a cell via the Name Box.
  3. Guided practice (12') – Teacher models creating a named cell “TaxRate” and a named range “CostList” in a budget worksheet.
  4. Pair activity (15') – Learners build their own budget sheet, assign names to key cells/ranges, and use those names in formulas.
  5. Name Manager exploration (8') – Students open Name Manager, edit a name, and observe automatic formula updates.
  6. Common mistakes quiz (5') – Quick Kahoot/handout on invalid characters, duplicate names, and scope.
  7. Summary & exit ticket (5') – Students write one advantage of using names and one tip for avoiding errors.
Conclusion:

Recap the key steps for creating and managing named cells and ranges, emphasizing how they simplify formulas and reduce mistakes. Collect exit tickets and assign a homework task: each student must create a personal spreadsheet (e.g., a simple expense tracker) that uses at least three named ranges and one named cell.