Lesson 5: Organizing Data
Cleaning, sorting, and arranging data so we can see patterns.
🎯 Learning Intentions
- Clean data by removing errors or unclear responses
- Sort data into categories
- Use frequency tables to count responses
- Introduction to digital spreadsheets (optional)
🎥 Media Anchor (8 mins)
Video: Research Skills for Students
- Which organization method makes pattern-finding easiest?
- How can poor data organization distort your conclusions?
1. The Messy Desk Metaphor (5 mins)
Discuss: "Why is it hard to find a specific paper on a messy desk?"
Raw data is like a messy desk. Organizing it helps us find the answers.
2. Activity: Cleaning Data (10 mins)
Look at your data set. Are there any issues?
- Did someone write "dog" when you asked for a number?
- Did someone answer twice?
- Are there blank spaces?
Task: Fix clear errors or decide to remove "spoiled" data entries.
3. Skill: Frequency Tables (20 mins)
Turn a list into a count.
Raw List:
Red, Blue, Red, Green, Blue, Red...
Frequency Table:
- Red: ||| (3)
- Blue: || (2)
- Green: | (1)
Task: Create frequency tables for your own survey questions.
4. Introduction to Google Sheets/Excel (15 mins - Optional)
Demonstrate how to enter data into a spreadsheet:
- One row per person
- One column per question
- Using "Sort" to group answers
📋 Teacher Planning Snapshot
Ngā Whāinga Ako — Learning Intentions
Students will engage with this resource to develop statistical investigation skills — planning inquiries, collecting and analysing data, interpreting distributions, and communicating findings. Tūhuratanga (investigation) is framed as a tool for understanding our communities and environment in Aotearoa New Zealand.
Ngā Paearu Angitū — Success Criteria
- ✅ Students can identify an investigative question, collect relevant data, and display it clearly.
- ✅ Students can interpret statistical findings and discuss what they might mean for a real-world community or environmental context.
Differentiation & Inclusion
Scaffold support: Provide structured investigation frameworks (PPDAC cycle templates) for entry-level access. Offer partially completed data tables for students who need additional support. Extend capable learners by asking them to critique a statistical claim from a news article, or to design their own community data investigation.
ELL / ESOL: Pre-teach statistical vocabulary (median, mode, range, distribution, sample, population). Pair visual representations (graphs, tables) with plain-language explanations. Allow students to discuss statistical ideas orally before writing. Encourage use of home language for initial sensemaking.
Inclusion: Statistical investigation offers natural differentiation — all students can engage with the same real-world question at different levels of mathematical complexity. Neurodiverse learners benefit from structured, step-by-step investigation processes. Use collaborative group investigation formats that distribute roles (data collector, recorder, analyst, presenter).
Mātauranga Māori lens: Tūhuratanga — the practice of careful investigation — resonates deeply with mātauranga Māori. The maramataka is a sophisticated data system: tracking environmental patterns, seasonal cycles, and ecological indicators over generations. Iwi environmental monitoring — counting kaimoana populations, tracking water quality, observing bird migrations — is applied statistical thinking. Framing statistics within community and environmental inquiry connects data to mana whenua responsibilities.
Prior knowledge: Students should have basic familiarity with data displays (bar graphs, dot plots). No prior statistical investigation experience required — the PPDAC inquiry cycle provides accessible scaffolding for first-time investigators.
Curriculum alignment
- Statistics — Statistical Investigation: Plan and conduct investigations using the statistical enquiry cycle — determining appropriate variables and data collection methods; gathering, sorting, and displaying multivariate category, measurement, and time-series data to detect patterns, variations, relationships, and trends; comparing distributions visually; communicating findings, using appropriate display.
- Statistics — Probability: Investigate situations that involve elements of chance by comparing experimental distributions with expectations from models of the possible outcomes, acknowledging uncertainty.