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 format numerical values to a specified number of decimal places
Learning Objective/s:
  • Describe the purpose of decimal formatting in charts and tables.
  • Apply rounding rules to numbers to a specified number of decimal places.
  • Use spreadsheet functions and cell formatting to display numbers with the required precision.
  • Format axis labels and data labels in charts to match the chosen decimal places.
  • Evaluate the impact of decimal precision on chart readability.
Materials Needed:
  • Computer with Microsoft Excel or Google Sheets
  • Projector and screen
  • Worksheet with rounding practice questions
  • Sample spreadsheet file containing raw data
  • Whiteboard and markers
  • Printed handout of rounding rules checklist
 Introduction:
Begin with a quick poll: how many students have ever noticed mismatched numbers on a chart? Review that numbers can be displayed with varying precision, which affects readability. Explain that today they will learn to round numbers correctly and format them in spreadsheets so charts look professional. Success will be shown when they can apply the ROUND function and adjust chart label formats.
Lesson Structure:
  1. Do‑Now (5’) – Students round a set of numbers on a mini‑worksheet and share answers.
  2. Mini‑lecture (10’) – Explain rounding rules and demonstrate cell formatting in Excel/Sheets.
  3. Guided practice (12’) – Students use the ROUND function to format a temperature column and update a line chart.
  4. Chart label activity (8’) – Students format axis and data‑label decimal places in a pre‑made column chart.
  5. Independent practice (10’) – Complete the practice questions from the source, with teacher support.
  6. Check for understanding (5’) – Quick exit ticket: write the rounded value for a given number.
Conclusion:
Summarise the key steps: decide the needed precision, use ROUND if calculations require it, then apply cell and chart formatting. For the exit ticket, each student writes one reason why too many decimals can mislead a viewer. Assign homework to format a provided dataset to two decimal places and create a chart that reflects the chosen precision.