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.
Lesson overview
Turning a messy pile of numbers into an answer to a question you care about.
Teacher script · 45 min
- 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.
- 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.
- 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.
- 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.
- 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
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.