Art + Math + Science + English
  1. Mathematics
  2. Class 11
  3. Project 23
Mathematics Through Innovation and Problem Solving

23Open Data Detectives: Asking Real Questions of Public Data

Teams choose a real public dataset with their teacher, for example published rainfall or temperature records, population census tables, school enrolment tables or public health reports, and investigate a question that matters to their community. They clean the data, summarise it, draw honest graphs, fit simple models and write up what the data can and cannot tell us, always citing the source exactly.

Class and age
Class 11 · 16–17
Activity type
Group
Time needed
3–4 weeks (one session per week plus home work)
Difficulty
Challenging
Estimated budget
Almost free

Mathematical concepts

  • Data sources and citation
  • Data cleaning and missing values
  • Summary statistics and distributions
  • Trends, rates and per-person comparisons
  • Correlation is not causation

Learning objectives

  • Find and evaluate a trustworthy public dataset.
  • Turn a broad interest into a precise question.
  • Analyse the data with suitable statistics and graphs.
  • Report findings honestly, including limitations.

Real-life connection

Journalists, government planners, researchers and businesses all make decisions from public data. Knowing how to read data critically protects people from misleading graphs and claims in the news and on social media.

Materials required

  • A computer or phone with a spreadsheet
  • A public dataset chosen with the teacher from an official or well-known source
  • A notebook for the research log
  • Poster paper or slides for the final report

Step-by-step instructions

  1. Brainstorm community questions (weather, population, schooling, health, transport). Choose one with your teacher.
  2. With your teacher, find a public dataset from an official or well-known source. Write down the exact source, date and link.
  3. Sharpen the question so the data can answer it, for example comparing two periods or two places.
  4. Clean the data: check units, spot missing or odd values, and record every change you make.
  5. Calculate summaries (mean, median, range, rates per person or per year) and draw at least two honest graphs with labelled axes starting from sensible values.
  6. Look for a trend or relationship. Fit a line if suitable, and be careful not to claim cause.
  7. List the limitations: what the data does not include, possible errors, and what else you would need.
  8. Write a 2-page report or poster that cites the source exactly and present it to the class.

Mathematical explanation

Real data is messy: units change between tables, values are missing and some figures are estimates. A good data scientist records every cleaning step so others can check the work. Totals can mislead when populations differ, which is why rates per person or per year are often fairer comparisons. A graph whose axis does not start at a sensible value can make a small change look dramatic. Finally, two quantities moving together does not prove that one causes the other; a third factor may drive both. The teacher's role is to help choose a trustworthy source; this project never asks students to invent or guess numbers, and every figure in the report must come from the cited dataset or from the students' own calculations.

Expected project output

A research log, a cleaned dataset with a record of changes, graphs and summaries, and a 2-page report or poster with an exact source citation.

Skills developed

  • Data literacy and source evaluation
  • Spreadsheet analysis
  • Honest visualisation
  • Scientific writing and citation

Assessment criteria

  • The source is trustworthy and cited exactly.
  • The question is precise and answerable.
  • Cleaning steps are recorded and the analysis is correct.
  • Graphs are honest and limitations are clearly stated.

Extension challenge

Find a graph about your topic in a newspaper or on social media. Check it against your data. Is it fair? Redraw it honestly if it is not.

Safety and inclusion

Use only public, anonymous datasets. Never collect or publish personal information about real people, and get the teacher's approval before sharing the report outside school.