Teacher Cheat Sheet — Session 4: Organizing What You Found

Data Science for Young Minds · Grade 3 · Ages 8–9
~60 min Ages 8–9 Session 4 of 8 ND-Friendly
Session Agenda
TimeBlockWhat's Happening
0–5 Warm-UpShare take-home tally results. What did students count? Any surprises?
5–18 Lesson 1–2Raw data → organized data · Rows and columns · Frequency tables
18–38 ActivityMessy-to-Clean — turn a messy raw data list into a frequency table
38–50 Lesson 3–4Categories · How to choose category labels · Sorting rules
50–56 ActivityStudents organize their own Session 3 mini-survey data into a frequency table
56–58 Recap"What's the difference between raw data and organized data?"
58–60 ClosePreview Session 5: "Now we'll turn your table into a picture — a chart!"
Key insight to land: Raw data is like a messy pile of puzzle pieces. Organizing it into a table is the first step to seeing the picture. You can't make a chart until the data is organized.
Materials Needed
PencilsStudent worksheets Session 3 mini-survey tally sheets (students keep these) Large sticky notes or whiteboard Colored pencils (optional)
The "Messy-to-Clean" activity works great on the whiteboard — write a messy list of raw data responses live and have students call out how to sort them.
Key Vocabulary
Raw data — information exactly as it was collected, before organizing
Frequency— how many times something appears in your data
Frequency table — a table showing each category and how many times it appears
Category — a group that data can be sorted into
Row — a line going left to right in a table
Column — a line going up and down in a table

Discussion Questions + Teacher Notes
  • "What makes data 'messy'?"
    → Different formats, same thing written multiple ways (cat/Cat/CAT), no grouping. Show example: a list of 20 pet names written out vs. a frequency table.
  • "Why can't we just leave data as a long list?"
    → Hard to count, spot patterns, or compare. Organized tables make it easy to see which category has the most/least.
  • "What if someone gave an answer that doesn't fit any category?"
    → Great question! This is why you design categories BEFORE collecting. In real data science, you might add an "Other" category — but be careful not to use it as a dump for everything.
  • "Does the order of rows matter?"
    → Usually not for frequency tables. But sometimes sorting by highest-to-lowest count makes it easier to read. Let students try both.
  • "What does 'frequency' mean in your own words?"
    → How many times. Connect to everyday usage: "how frequently do you eat pizza?" = how often. In data, frequency = count.
Messy-to-Clean Activity Setup
Write this messy raw data list on the board (results from a pretend "favorite season" survey). Students create a frequency table from it.
Raw data to write on board:
Summer, Winter, Fall, summer, SPRING, Winter, Fall, Spring,
summer, Fall, Winter, spring, Summer, fall, Winter, Summer,
Spring, winter, Summer, Fall
What the finished table should look like:
SeasonTallyFrequency
Summer||||̶ |6
Winter||||̶5
Fall||||̶5
Spring| | | |4
Point out: same word written different ways (Summer, summer, SUMMER) all go in the same category. This is a key real-world data cleaning skill.

Organizing Survey Data — Steps
Post these steps when students organize their own survey data:
  1. List all your answer categories in a column
  2. Go through your tally sheet from Session 3
  3. Copy the tally marks into your table
  4. Count the tally marks and write the frequency number
  5. Add up all frequencies — should equal total responses
The total frequency check helps students catch counting errors before they carry them into charts (Session 5).
Wrap-Up Prompt
Write on board:
"If I gave you a messy list of 50 answers, how would you organize it? Describe your steps."
5 min — write or share aloud. Bridge to Session 5: "Now your table is ready. Next time we turn it into a picture — a bar chart!"
ND-Friendly Tips
  • Physical sorting first — Before the table, let students sort actual paper slips (each slip = one answer) into piles. Counting physical objects is easier than counting from a list.
  • Pre-label rows— Students with executive function challenges benefit from having the category column pre-filled so they can focus on counting, not organizing from scratch.
  • Color code — Assign one colored pencil per category. Sorting = matching colors. Works well for visual-spatial learners.
  • Show the full arc — "Raw data → table → chart → insight." Seeing where today fits in the journey reduces anxiety about the point of the task.
  • Anchor with a total — "If you asked 10 people, all your frequencies should add up to 10." This gives a built-in self-check.