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 adjust the maximum and minimum values of an axis scale and set incremental values
Learning Objective/s:
  • Describe why appropriate axis scaling is essential for clear data presentation.
  • Explain how to choose suitable minimum, maximum and major‑unit values for a chart.
  • Apply the step‑by‑step procedure to set axis options in spreadsheet software.
  • Evaluate a completed chart to ensure all data points are visible and the grid is readable.
Materials Needed:
  • Computer with spreadsheet software (Excel, Google Sheets, etc.)
  • Projector or interactive whiteboard
  • Printed handouts of sample data sets
  • Worksheet for axis‑scaling practice
  • Teacher’s slide deck demonstrating the procedure
 Introduction:
Begin with a quick visual of a poorly scaled chart to spark curiosity. Review students’ prior experience creating charts in spreadsheets. State that by the end of the lesson they will be able to set axis scales accurately and check their work against an exam checklist.
Lesson Structure:
  1. Do‑now (5'): Students identify problems in a mis‑scaled chart displayed on screen.
  2. Mini‑lecture (10'): Explain key terms (minimum, maximum, major/minor units) and why zero is often the logical minimum.
  3. Demonstration (12'): Live step‑by‑step setting of axis values in a spreadsheet using the sales data example.
  4. Guided practice (15'): Pairs adjust axis scales for a new data set on their computers, referencing the checklist.
  5. Check for understanding (5'): Quick whole‑class poll – “What determines a good major unit?”
  6. Independent exercise (8'): Students complete the worksheet on temperature data, recording their chosen values.
  7. Review & feedback (5'): Teacher circulates, corrects common errors, and highlights best practices.
Conclusion:
Recap the four‑step process for setting axis scales and remind students of the exam checklist. Collect an exit ticket where each learner writes one tip for choosing a major unit. Assign homework: create a chart from a personal data set and apply appropriate scaling.