๐Ÿ“‹ 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
Pencils Student 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.