Level 1 - Module 2 - Unit 2.7 - Data & Chart Types
This Workbook includes:
Module 2 - Creating and Editing
Unit 2.7 Chart a single series of numeric data using an appropriate type of chart and apply suitable titles and labels (including chart titles, axis titles, data legends and data labels).
Task 1 – Identifying Chart Types
Learners explore common chart types and match them to different data scenarios, developing an understanding of when each chart is most suitable.
Task 2 – Creating a Column Chart: Sports Fundraiser
Learners create a column chart using existing spreadsheet data, adding titles, axis labels, and data labels with clear step-by-step guidance.
Task 3 – Creating a Pie Chart with a Legend: Gym & Wellbeing Centre
Learners create a pie chart to show proportions and practise using data labels and legends, with reduced guidance to build confidence.
Task 4 – Creating a Bar Chart: Oliver’s Budget
Learners sort financial data and create a bar chart to compare outgoings, applying titles, labels, and formatting for clarity.
Task 5 – Over to You! Independent Chart Creation
Learners work independently using a college canteen scenario, calculate totals using a SUM function, select non-adjacent data, and create two different charts. A checklist supports independent working. Followed by a Recap True//False Quiz
Spreadsheets Included: This resource includes learner spreadsheets for all tasks and tutor-completed example spreadsheets for Tasks 2–5, demonstrating expected outcomes and supporting assessment and delivery.
Every download also includes:
✔ Learner Glossary
✔ Skills & Knowledge Checklist
✔ Guided Tutor Answers (where applicable)
✔ Instant PDF Download