lesson 7.4 - representing information (charts, sparklines and infographics)
Turn boring data into cool visuals! Learn charts, sparklines, and infographics for BTEC DIT.
Tables are great for organising information, but they're not very exciting, are they? To really grab the attention of the managers at Pedal Power Cycles, we need to tell a story with their data. This lesson is all about the art of data visualisation. You'll learn how to transform rows of numbers into clear charts, tiny sparklines, and amazing infographics that reveal the business's secrets at a single glance.
Learning Outcomes
The Building Blocks (Factual Knowledge)
The Connections and Theories (Conceptual Knowledge)
The Skills and Methods (Procedural Knowledge)
Recall the definitions of charts, sparklines, and infographics (C2.A2.4, C2.A2.5, C2.A2.6).
The Connections and Theories (Conceptual Knowledge)
Describe the specific purpose of bar charts, line charts, and pie charts.
Explain how visual representations make it easier to identify trends and patterns.
The Skills and Methods (Procedural Knowledge)
Apply knowledge to select the most appropriate visual representation for a given dataset.
Digital Skill Focus: This lesson, you will focus on creating a suitable chart from a highlighted range of spreadsheet data and applying professional formatting.
Telling Stories with Data: Visual Representations
The managers at Pedal Power Cycles are busy people. They don't have time to read through thousands of rows in a spreadsheet. Our job is to present the key findings visually, so they can understand the information in seconds.
1. Charts
A chart is a graphical representation of data. Choosing the right chart type is essential to telling the right story.
Bar Charts: Perfect for comparing values between different categories. For example, we could use a bar chart to compare the total sales of each staff member at Pedal Power Cycles. The taller the bar, the better the performance.
Line Charts: The best way to show a trend or change over time. For example, a line chart would be ideal for showing Pedal Power Cycles' total monthly sales over the last year, making it easy to see if sales are going up or down.
Pie Charts: Used to show proportions, or how different parts make up a whole. For example, we could use a pie chart to show what percentage of total sales comes from 'Road Bikes', 'Mountain Bikes', and 'Accessories'. The slice sizes make comparison instant.
2. Sparklines
A sparkline is a very small, simple line chart that is typically drawn in a single cell of a spreadsheet. It's designed to give a quick visual impression of a trend without the detail of a full chart.
Example: Imagine a table showing the sales for each product for the last 12 months. In a final column, you could have a sparkline for each product, showing its individual sales trend over the year at a glance. It's a tiny, data-dense picture.
3. Infographics
An infographic (information graphic) is a collection of imagery, charts, and minimal text that gives an easy-to-understand overview of a topic. It's about telling a complete story using data visualisation.
Key Feature: An infographic is more than just a single chart. It combines multiple visualisations and design elements to create a complete and engaging narrative. For Pedal Power Cycles, we could create an infographic titled "Our Year in Review" that uses a bar chart for top staff, a pie chart for product categories, and icons to show the total number of bikes sold.
Choosing the right tool - a chart, a sparkline, or a full infographic - depends on how much detail you need to show.
Turn these words into pictures! In your book, draw a quick, simple icon to represent a bar chart, a line chart, and a pie chart. Add one keyword next to each icon to describe what it's best used for (e.g., 'Compare', 'Trend', 'Parts').
Task A Picture is Worth a Thousand Numbers
You've been given the sales revenue for Pedal Power Cycles for the first six months of the year. The raw numbers are useful, but a chart would make the trend instantly obvious to the managers. Your task is to turn this data into a professional-looking chart.
1
Get Organised!
First, create the file you'll be working in.
Navigate to your Component_2 -> 03-Dashboard folder.
Create a new spreadsheet document and name it Sales Chart Practice.xlsx.
2
Enter the Data
In your new spreadsheet, copy the following table of data exactly as it appears below.
| Month | Sales Revenue |
|---------|---------------|
| January | £12,500 |
| February| £14,000 |
| March | £18,200 |
| April | £17,500 |
| May | £21,000 |
| June | £23,500 |
3
Choose and Create Your Chart
Think about what this data is showing. Is it comparing categories, showing parts of a whole, or showing a trend over time?
Select all the data in your table, including the headers.
Use the 'Insert' menu in your spreadsheet software to add a new chart.
Choose the chart type that you think best tells the story of this data.
4
Make it Professional
An unlabelled chart is a useless chart! You must add the following:
A clear and descriptive title for the chart (e.g., "Monthly Sales at Pedal Power...").
A label for the horizontal axis (the months).
A label for the vertical axis (the sales figures), including the '£' symbol.
5
Justify Your Choice
In a cell underneath your chart, write one clear sentence explaining why you chose that specific type of chart. Use this AI prompt to help you to decide.
Act as a data visualisation expert. I have a dataset of monthly sales figures for a bike shop. Should I use a bar chart, line chart, or pie chart to show this data? Explain the best choice and why the other two are less suitable. Limit the response to 100 words for a Key Stage 4 student. NO intro, NO outro, NO deviation from the topic, NO follow-up questions.
Outcome: A professionally formatted spreadsheet chart with a clear title and labels, and a written justification for your design choice.
Hungry for more?
Infographic Inspiration: Search for "infographic design" online. Find an example you think is really effective and identify the different charts and visual elements it uses to tell its story. Click for inspiration.
Sparkline Skills: Watch a short video tutorial on how to create sparklines in your chosen spreadsheet software. Find a tutorial here. Can you add a sparkline to today's task?
Chart Chooser Tools: Explore an online 'Chart Chooser' tool. These are websites that ask you questions about your data and recommend the best chart type to use.
Application to the Component Sample PSA
Data visualisation is at the very heart of Task 2 of the Component 2 PSA. The dashboard you build for Pedal Power Cycles must include several charts. You will be expected to choose the most appropriate chart types to display the sales trends, staff performance, and product data. Your ability to create clear, well-formatted, and appropriate charts will be a major factor in your final mark. The conclusions you draw in Task 3 will be based on the trends and patterns you can see in the charts you create.
Out of Lesson Learning
⭐ Chart Spotter
Find a chart in a newspaper, on a news website, or in one of your other textbooks. Identify what type of chart it is (bar, line, pie, etc.) and write a single sentence describing the story it is telling.
Find a chart in a newspaper, on a news website, or in one of your other textbooks. Identify what type of chart it is (bar, line, pie, etc.) and write a single sentence describing the story it is telling.
⭐⭐ Sketch-a-Chart
The managers at Pedal Power Cycles want to compare the total annual sales of their top three staff members: Sarah (£150,000), John (£120,000), and David (£95,000). On paper, sketch the most appropriate type of chart to represent this information. Remember to include a title and labels.
The managers at Pedal Power Cycles want to compare the total annual sales of their top three staff members: Sarah (£150,000), John (£120,000), and David (£95,000). On paper, sketch the most appropriate type of chart to represent this information. Remember to include a title and labels.
⭐⭐⭐ Mini-Infographic
On paper or using simple software, design a small infographic for Pedal Power Cycles with the title "Our Best-Selling Bike Category!". Imagine that 60% of their sales are from Mountain Bikes, 30% from Road Bikes, and 10% from Kids Bikes. Combine an appropriate chart to show these proportions with some simple icons and text to create an engaging visual.
On paper or using simple software, design a small infographic for Pedal Power Cycles with the title "Our Best-Selling Bike Category!". Imagine that 60% of their sales are from Mountain Bikes, 30% from Road Bikes, and 10% from Kids Bikes. Combine an appropriate chart to show these proportions with some simple icons and text to create an engaging visual.
Last modified: June 11th, 2026
