Skip to content
Truth Academy.
Truth Academy
← All modules
The Math UnderneathFoundational45 min

Making Sense of Data & Spreadsheets

Turning a messy pile of numbers into an answer to a question you care about.

AI tutor is turned off for this class

Use the DATA10 lectures, notes, and assignments below to keep learning.

Big Idea

The Math Underneath

Grade bands

K-2 · 3-5 · 6-8 · 9-12

View on the ladder →

Lesson overview

Turning a messy pile of numbers into an answer to a question you care about.

Teacher script · 45 min

  1. 0–5

    Hook

    Data is observations written down in rows and columns. Each row is one thing (a student, a day, a sale); each column is something you noticed about it (a name, a temperature, a price). A spreadsheet is a giant, tidy notebook. Once you see that, 'data' stops being intimidating.

  2. 5–15

    Explore

    Students do the activity in pairs: In your meal table, find the average 'liked it' score and your best and worst meal. Three numbers now describe five rows.

  3. 15–30

    Explain

    Computing the average is the easy part. Questioning it is harder. An average can hide everything (one billionaire makes a room's 'average wealth' meaningless). CORRELATION (two things moving together) is not CAUSATION (one causing the other). Ice cream sales and drownings rise together because of summer, not because of each other.

  4. 30–40

    Connect to the summit

    Read aloud the "Where this course leads" section below. Ask students which ideas from today they recognize in it.

  5. 40–45

    Check

    Run the formative check below. Anyone who can explain a key term in their own words has it.

Student activity

In your meal table, find the average 'liked it' score and your best and worst meal. Three numbers now describe five rows.

Slides

1Title: Making Sense of Data & Spreadsheets
2Hook: Data is just organized observations
3Do it: Summarize: the shape of the pile
4How it works: Ask questions, and distrust the answer
5Key idea: Dataset
6Key idea: Average (mean)
7Key idea: Correlation vs. causation
8Where it leads: The data courses

Formative check

  • 1.In your own words, what is "Dataset"? (Looking for: Observations organized into rows (things) and columns (what you noticed about them).)
  • 2.In your own words, what is "Average (mean)"? (Looking for: The typical value: the total shared equally across all rows.)
  • 3.In your own words, what is "Correlation vs. causation"? (Looking for: Two things moving together isn't proof that one causes the other.)

Carry-away concepts

Dataset
Observations organized into rows (things) and columns (what you noticed about them).
Average (mean)
The typical value: the total shared equally across all rows.
Correlation vs. causation
Two things moving together isn't proof that one causes the other.
Denominator
The 'out of how many?' that decides whether a number is big or small.

Where this course leads

From here the quantitative courses open: probability and uncertainty (CS109), and the full data-for-impact pipeline of sourcing, cleaning, and careful inference (DATASCI154).

This is a beginner course written for Feynman, not a Stanford course.