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 display either formulae or values
Learning Objective/s:
  • Identify the difference between a formula and its resulting value in a spreadsheet.
  • Demonstrate how to toggle between displaying formulas and values in Excel and Google Sheets.
  • Evaluate when to show formulas versus values for error checking and presentation.
  • Apply shortcut keys and menu commands to switch views accurately.
Materials Needed:
  • Computer with Microsoft Excel installed
  • Computer with internet access to Google Sheets
  • Projector or interactive whiteboard
  • Sample spreadsheet file (price calculation)
  • Worksheet handout with practice tasks
  • Teacher guide with step‑by‑step instructions
 Introduction:
Begin with a quick question: “How can we see the exact calculations behind a total?” Recall that cells can hold either values or formulas, a concept explored in previous spreadsheet lessons. Explain that today they will learn to switch views to verify work and present data clearly, and they will be assessed by demonstrating the toggle in both Excel and Google Sheets.
Lesson Structure:
  1. Do‑now (5'): Students complete a short quiz on identifying formulas vs. values in a printed sheet.
  2. Mini‑lecture (10'): Explain the purpose of displaying formulas or values and demonstrate the Excel “Show Formulas” button and Ctrl+` shortcut.
  3. Guided practice – Excel (12'): Students open the sample workbook, toggle the view using the shortcut, and locate the formulas in column C.
  4. Guided practice – Google Sheets (12'): Repeat the toggle using View → Show formulas and discuss any differences.
  5. Paired activity (10'): Students audit a new worksheet, switching views to spot errors and record observations.
  6. Check for understanding (5'): Exit ticket – write one situation where showing formulas is essential.
Conclusion:
Summarise that displaying formulas helps us check calculations while showing values is best for presenting results. Invite a few students to share an example from their exit tickets. For homework, students will create a simple spreadsheet of their own and practice toggling between formula and value views before the next lesson.