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 select data to produce a graph or chart including using contiguous data, non-contiguous data and specified data ranges
Learning Objective/s:
  • Describe the purpose of different graph types and when to use them.
  • Identify whether a data set is contiguous, non‑contiguous, or requires a specified range.
  • Apply spreadsheet selection techniques to choose appropriate data for a chart.
  • Create and format a graph (bar, column, line, pie, or scatter) that accurately represents the selected data.
  • Evaluate a completed chart for readability, correct scaling, and appropriate labeling.
Materials Needed:
  • Computer lab with spreadsheet software (e.g., Excel or Google Sheets)
  • Projector and screen
  • Sample data worksheets (printed or digital)
  • Whiteboard and markers
  • Handout of graph type reference chart
  • Instructional video tutorial (optional)
 Introduction:
Begin with a quick poll: how many students have created a chart in a spreadsheet before? Review the key reasons we use graphs to communicate data and link to the success criteria: students will select the correct data set and produce an accurate chart that matches its purpose. Clarify that today’s focus is on choosing contiguous, non‑contiguous, or specified ranges.
Lesson Structure:
  1. Do‑now (5'): Students list three real‑world situations where a graph would be useful.
  2. Mini‑lecture (10'): Explain contiguous vs non‑contiguous data and specified ranges, using projector examples.
  3. Guided practice (15'): In pairs, students select appropriate cells from a sample worksheet and insert a chart, following the 7‑step checklist.
  4. Teacher modelling (10'): Demonstrate adjusting a data range, adding titles, axis labels, and a legend.
  5. Independent task (15'): Each student creates a chart of their choice from a new data set and writes a brief justification for the chart type.
  6. Exit ticket (5'): Write one tip for avoiding common pitfalls when selecting data for a graph.
Conclusion:
Summarise the checklist, highlighting how the purpose determines data selection and chart type. Students complete an exit ticket stating the most important step they will remember. For homework, ask learners to find a real‑world data set and draft a brief plan for a suitable graph, including the data range they would use.