📊
Learning objective
Charts & Visualisations
Spreadsheet Graphics
1
2
3
4
5
6
Welcome to Spreadsheet Graphics! In this strand, you will master turning raw data tables into clear, visually compelling charts and graphs, choosing the right chart type to represent trends, comparisons, and proportions accurately.
Visual Charts
Selecting data and creating simple 1-to-1 visual charts.
Let's Go!
Learn
Charts convert walls of numbers into instant visual pictures. Selecting your data table and choosing a simple chart type helps everyone understand your findings instantly!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
Try it yourself
Create your first visual chart!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Identify pictures representing counts.
Developing
Select a simple table and click 'Insert Chart'.
Secure (Goal)
Create a 1-to-1 visual chart from a 2-column table.
Mastery
Explain what each symbol represents. Typing: 5 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Visual Charts includes:
- Core Deliverable: Create your first visual chart!
- Target Quality: Create a 1-to-1 visual chart from a 2-column table.
- Excellence & Polish: Explain what each symbol represents. Typing: 5 WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: See, Think, Wonder
Achievement pathway
- Foundation: Identify pictures representing counts.
- Developing: Select a simple table and click 'Insert Chart'.
- Secure: Create a 1-to-1 visual chart from a 2-column table.
- Mastering: Explain what each symbol represents. Typing: 5 WPM.
Curriculum links
Curriculum strand: MAT.01.C.1.4
Outcome: SPG-O-01 — Selecting data and creating simple 1-to-1 visual charts.
PYP: Form · Visual charts help us compare quantities easily.
Learner profile: Inquirer
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 2: Bar Charts
Complete the previous learning check to unlock this next level.
Bar Charts
Building column and bar charts with axes and labels.
Learning objective
Learning About: Bar Charts. Learning To: Compare categories. Learning To Be: Communicator.
Let's Go!
Learn
Bar charts compare different categories side-by-side using vertical or horizontal bars. Always label your axes so readers know what each bar measures!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
📊
Data Visualization Chart
Try it yourself
Build and label a bar chart!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Distinguish vertical column charts from horizontal bar charts.
Developing
Select category and value columns to generate a bar chart.
Secure (Goal)
Add custom axis titles and chart headers.
Mastery
Explain why category order matters in bar charts. Typing: 10 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Bar Charts includes:
- Core Deliverable: Build and label a bar chart!
- Target Quality: Add custom axis titles and chart headers.
- Excellence & Polish: Explain why category order matters in bar charts. Typing: 10 WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: Zoom In
Achievement pathway
- Foundation: Distinguish vertical column charts from horizontal bar charts.
- Developing: Select category and value columns to generate a bar chart.
- Secure: Add custom axis titles and chart headers.
- Mastering: Explain why category order matters in bar charts. Typing: 10 WPM.
Curriculum links
Curriculum strand: MAT.02.C.1.4
Outcome: SPG-O-02 — Building column and bar charts with axes and labels.
PYP: Function · Bar charts allow side-by-side category comparisons.
Learner profile: Communicator
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 3: Line Graphs
Complete the previous learning check to unlock this next level.
Line Graphs
Plotting continuous time-series data using line graphs.
Learning objective
Learning About: Line Graphs. Learning To: Plot time trends. Learning To Be: Thinker.
Let's Go!
Learn
Line graphs connect data points across time (hours, days, months). They reveal patterns, spikes, and drops that show how something changes over continuous time!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
📊
Data Visualization Chart
Try it yourself
Plot a 7-day temperature trend!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Recognize that line graphs connect data points across time.
Developing
Plot a time-series table (Days vs Temperature) into a Line Graph.
Secure (Goal)
Identify upward, downward, and flat trendlines.
Mastery
Predict future data points by extending line trends. Typing: 15 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Line Graphs includes:
- Core Deliverable: Plot a 7-day temperature trend!
- Target Quality: Identify upward, downward, and flat trendlines.
- Excellence & Polish: Predict future data points by extending line trends. Typing: 15 WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: Think, Puzzle, Explore
Achievement pathway
- Foundation: Recognize that line graphs connect data points across time.
- Developing: Plot a time-series table (Days vs Temperature) into a Line Graph.
- Secure: Identify upward, downward, and flat trendlines.
- Mastering: Predict future data points by extending line trends. Typing: 15 WPM.
Curriculum links
Curriculum strand: CM.02.B.1.1
Outcome: SPG-O-03 — Plotting continuous time-series data using line graphs.
PYP: Change · Line graphs show how continuous variables change over time.
Learner profile: Thinker
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 4: Pie Charts
Complete the previous learning check to unlock this next level.
Pie Charts
Displaying parts of a whole using pie charts and percentages.
Learning objective
Learning About: Pie Charts. Learning To: Represent percentages. Learning To Be: Principled.
Let's Go!
Learn
Pie charts show how a total amount (100%) is divided into parts. Each slice represents a percentage of the total. Keep slices under 6 so the chart remains easy to read!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
📊
Data Visualization Chart
Try it yourself
Chart your daily activity shares!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Recognize that a pie chart represents 100% of a dataset.
Developing
Generate a pie chart from a budget or survey table.
Secure (Goal)
Add data labels with percentages to pie slices.
Mastery
Evaluate when pie charts become unreadable (too many slices). Typing: 20 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Pie Charts includes:
- Core Deliverable: Chart your daily activity shares!
- Target Quality: Add data labels with percentages to pie slices.
- Excellence & Polish: Evaluate when pie charts become unreadable (too many slices). Typing: 20 WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: See, Think, Wonder
Achievement pathway
- Foundation: Recognize that a pie chart represents 100% of a dataset.
- Developing: Generate a pie chart from a budget or survey table.
- Secure: Add data labels with percentages to pie slices.
- Mastering: Evaluate when pie charts become unreadable (too many slices). Typing: 20 WPM.
Curriculum links
Curriculum strand: CM.02.B.1.1
Outcome: SPG-O-04 — Displaying parts of a whole using pie charts and percentages.
PYP: Perspective · Pie charts illustrate proportions and parts of a 100% whole.
Learner profile: Principled
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 5: Multi-Series
Complete the previous learning check to unlock this next level.
Multi-Series
Comparing multiple data series and combo charts.
Learning objective
Learning About: Multi-Series Charts. Learning To: Compare dual variables. Learning To Be: Knowledgeable.
Let's Go!
Learn
Multi-series charts compare two or more related sets of data on the same axes (like Boys vs Girls sports scores, or Rainfall vs Temperature). Combo charts mix columns and lines for dual insights!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
📊
Data Visualization Chart
Try it yourself
Build a multi-series combo chart!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Identify a chart legend showing multiple colored series.
Developing
Plot two data series (e.g. Sales 2024 vs Sales 2025) on one bar chart.
Secure (Goal)
Create a Combo Chart combining columns (Rainfall) and a line (Temperature).
Mastery
Format a secondary Y-axis for different measurement scales. Typing: 25 WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Multi-Series includes:
- Core Deliverable: Build a multi-series combo chart!
- Target Quality: Create a Combo Chart combining columns (Rainfall) and a line (Temperature).
- Excellence & Polish: Format a secondary Y-axis for different measurement scales. Typing: 25 WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: I used to think...
Achievement pathway
- Foundation: Identify a chart legend showing multiple colored series.
- Developing: Plot two data series (e.g. Sales 2024 vs Sales 2025) on one bar chart.
- Secure: Create a Combo Chart combining columns (Rainfall) and a line (Temperature).
- Mastering: Format a secondary Y-axis for different measurement scales. Typing: 25 WPM.
Curriculum links
Curriculum strand: CM.03.B.1.3
Outcome: SPG-O-05 — Comparing multiple data series and combo charts.
PYP: Connection · Combining data series provides deeper comparative analysis.
Learner profile: Knowledgeable
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow
Locked level
Level 6: Dashboards
Complete the previous learning check to unlock this next level.
Dashboards
Building dynamic charts linked to formulas and interactive slicers.
Learning objective
Learning About: Interactive Dashboards. Learning To: Design visual analytics. Learning To Be: Reflective.
Let's Go!
Learn
Professional dashboards combine multiple dynamic charts on a clean page. When source data or formula values update, your charts update instantly. Adding interactive slicers lets users filter charts live!
| A | B | C | |
|---|---|---|---|
| 1 | Item | Amount | |
| 2 | Apples | 5 | |
| 3 | Bananas | 3 | |
| 4 | Carrots | 2 | |
| 5 | Total | =SUM(B2:B4) |
📊
Data Visualization Chart
Try it yourself
Assemble a dynamic 3-chart dashboard!
🚀 Open a practice space
Or try locally: 💻 LibreOffice Calc (free)
🌟 Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)
🎯 Task Success Criteria (Rubric)
Foundation
Format custom chart colors, fonts, and data callouts.
Developing
Link chart data dynamically to summary formula cells (SUM/AVERAGE).
Secure (Goal)
Assemble a 3-chart interactive dashboard with connected Slicers.
Mastery
Critically evaluate chart formatting to avoid misleading visual distortion. Typing: 30+ WPM.
👀 What A Good One Looks Like (WAGOLL)
Exemplar Standard
A top-tier student project for Dashboards includes:
- Core Deliverable: Assemble a dynamic 3-chart dashboard!
- Target Quality: Assemble a 3-chart interactive dashboard with connected Slicers.
- Excellence & Polish: Critically evaluate chart formatting to avoid misleading visual distortion. Typing: 30+ WPM.
📁
Save to Your Website Portfolio:
When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!
⭐Self-Assessment: How confident do you feel with this skill?
Reflect
Learning check
Teacher setup, curriculum links and progress descriptors
Spark support
Routine: Step Inside
Achievement pathway
- Foundation: Format custom chart colors, fonts, and data callouts.
- Developing: Link chart data dynamically to summary formula cells (SUM/AVERAGE).
- Secure: Assemble a 3-chart interactive dashboard with connected Slicers.
- Mastering: Critically evaluate chart formatting to avoid misleading visual distortion. Typing: 30+ WPM.
Curriculum links
Curriculum strand: MAT.03.E.1.6
Outcome: SPG-O-06 — Building dynamic charts linked to formulas and interactive slicers.
PYP: Reflection · Interactive dashboards synthesize complex data for decision-making.
Learner profile: Reflective
Competency tags
Gate support
Accessibility alternative:
Teacher override: allow