Making Sense of Data & Spreadsheets

Lesson overview

Turning a messy pile of numbers into something that answers a real question — the everyday skill under all of data science. This module climbs from an everyday intuition to the real mechanism, then names the Stanford course it descends from.

Teacher script · ~45 min

1. 0–5

   Hook

   Data isn't scary or technical — it's just 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

   The real skill isn't computing — it's questioning. 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 each other. Good data work is as much doubt as arithmetic.

4. 30–40

   Connect to the summit

   Show students this is the real thing professionals build: The real data pipeline. Turning a messy pile of numbers into something that answers a real question — the everyday skill under all of data science.

5. 40–45

   Check

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

Student activity

Slides

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.

From the summit · the Stanford source