- Mathematics
- Class 11
- Project 23
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
- Brainstorm community questions (weather, population, schooling, health, transport). Choose one with your teacher.
- With your teacher, find a public dataset from an official or well-known source. Write down the exact source, date and link.
- Sharpen the question so the data can answer it, for example comparing two periods or two places.
- Clean the data: check units, spot missing or odd values, and record every change you make.
- 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.
- Look for a trend or relationship. Fit a line if suitable, and be careful not to claim cause.
- List the limitations: what the data does not include, possible errors, and what else you would need.
- 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.