From spreadsheet table to chart

Computer ScienceDigital ApplicationsAges 13–14

Use with my class

The data table can be edited right on the page: change a number and the chart beside it redraws instantly. Students choose a bar, line, or pie chart to see which type suits which purpose, sort and filter the rows, and click a bar to highlight its row. A Group and summarise screen works like a pivot table on real World Bank data for about 200 economies: group them by region or income group, count, add up or average a column, filter the rows, and hover over or tap a bar to read its value.

Lesson: Presenting and visualizing data with charts in spreadsheet software; sorting and filtering data

What it shows

Charts turn a table of numbers into a picture, and each chart type answers a different question: bars compare categories, a line shows change over an ordered sequence, and a pie shows shares of one whole. The Group and summarise screen works like a spreadsheet pivot table: it groups about 200 economies from the World Bank's 2023 data by region or income group and counts the rows, adds a column up or takes its mean. Filters decide which rows are kept, and the chart's tooltips show each group's value. Students see why a mean of countries differs from a total and why some summaries make no sense.

How to use

Choose a Dataset or edit the table to see the chart change, and try Bar chart, Line and Pie, sorting and the filter. Then press Group and summarise. Choose Group by, Value and Summary, set Population at least and the income-group boxes, and read the table and the bars; hover over or tap a bar for its tooltip. Press Record this summary to keep each grouping in the results table.

Parameters you can change

  • Dataset Number of students per Grade 8 class, Number of books borrowed by month, Number of students choosing each sport
  • Chart type Bar chart, Line chart, Pie chart
  • Sort data Keep original order, Ascending by value, Descending by value
  • Only show rows with value at least 0–80
  • Show data labels on chart
  • Screen Chart from the table, Group and summarise
  • Group by Region, Income group
  • Value Population, Life expectancy, GDP per person, Urban population
  • Summary Count, Sum, Mean
  • Population at least (million) Any, 1, 10, 50, 100

Questions to explore

  1. Why is the mean urban share of a region different from the share of its people who live in towns?
  2. How does keeping only countries with at least 10 million people change the mean life expectancy of each region?
  3. Which summaries of life expectancy make sense, and why is a sum of them meaningless?