Lesson Plan

• Identify the most suitable chart type for a given data set and select the appropriate data range.
• Construct bar, pie, and line charts using spreadsheet software, applying correct headings and numeric formatting.
• Customize chart elements (titles, axis labels, data labels, colours) and interpret the resulting visual to convey information clearly.

• Projector or interactive whiteboard
• Computers with spreadsheet application (Excel/Google Sheets)
• Printed sample data handout
• Worksheet with step‑by‑step chart tasks
• Whiteboard and markers
• Checklist for chart quality (printed)

Begin with a quick visual of a messy data table versus a colourful chart to hook interest. Ask students how they currently interpret sales numbers and link this to prior lessons on basic spreadsheet functions. Explain that by the end of the lesson they will be able to choose, create, and fine‑tune bar, pie, and line charts that clearly communicate trends and comparisons.

1. Do‑Now (5'): Students examine the sample data and write which chart type would best answer three quick questions.
2. Mini‑lecture (8'): Review why charts are useful and match chart types to purposes (comparison, proportion, trend).
3. Demonstration – Bar Chart (12'): Teacher creates a bar chart from the data, shows how to set titles, axis labels, and data labels.
4. Guided Practice – Bar Chart (10'): Pupils build their own bar chart, teacher circulates for feedback.
5. Demonstration – Pie & Line Charts (15'): Quick modelling of a pie chart (percentages, explode slice) and a line chart (multiple series, markers).
6. Independent Practice (12'): Students create both a pie chart and a line chart using the remaining data, checking the checklist for accuracy.
7. Exit Ticket (5'): Write one tip for avoiding a common pitfall when designing charts.

Summarise the key steps for preparing data, selecting the right chart, and polishing visual details. Collect the exit tickets to gauge understanding, and assign a short homework task: students must turn a new set of sales figures into a bar and a line chart and bring a screenshot for the next class.