Coding activity
Data Detective
Sort and organize items into groups! Put animals in one pile, foods in another, and colors in a third. Learn that organizing information helps us find things faster.
Materials and setup
- index cards
- markers
- sorting trays
- paper
How this changes by age
Pre-K (ages 3–4)
Sort and organize items into groups! Put animals in one pile, foods in another, and colors in a third. Learn that organizing information helps us find things faster.
Steps
- Dump a mixed pile of small items on the table: toy animals, crayons, play food, blocks.
- Ask: 'Can you put all the animals together? All the food together? All the blocks together?'
- Child sorts items into labeled trays or bowls.
- Now ask: 'How many animals do we have? How many foods? Which group is biggest?'
- Discuss: 'When things are organized, we can find what we need quickly!'
- Tell a grown-up one thing that surprised you.
Learning objectives
- Sort mixed items into categories based on shared attributes
- Count items within each category and compare group sizes
- Understand that organizing information makes it easier to use
Kindergarten (ages 5–6)
Become a data detective! Collect information about your family or toys, organize it into lists and charts, and answer questions using your data. Learn that organized data tells stories.
Steps
- Survey: ask 5 family members or friends their favorite color, food, and animal. Write each answer on an index card.
- Sort the cards: group all the color answers together, all the food answers, all the animal answers.
- Make a tally chart: how many people said 'blue' versus 'red' versus 'green'?
- Answer questions using your data: 'What is the most popular color? Do more people like dogs or cats?'
- Discuss: 'You just created a database! Scientists and businesses collect data just like this to learn things.'
- Tell a grown-up one thing that surprised you.
Learning objectives
- Collect data through a simple survey and record it on cards
- Organize data into categories and create a tally chart
- Answer questions by analyzing organized data
Early elementary (ages 6–8)
Build a paper database! Create records with multiple fields, organize them by different attributes, and run queries to answer questions. Learn how computers store and search through information.
Steps
- Create 15 'data cards' about animals: each card has fields for Name, Type (mammal/bird/fish), Size (small/medium/large), Habitat (land/water/air), and Diet (herbivore/carnivore/omnivore).
- Organize cards by Type. How many mammals? Birds? Fish? Record the counts.
- Re-sort by Size. Now by Habitat. Notice: the same data can be organized many different ways!
- Run queries: 'Find all large mammals.' 'Find all animals that live in water AND are carnivores.' Search through your cards.
- Create a simple table (spreadsheet-style) on paper with all 15 animals and their attributes in columns.
- Discuss: 'Databases let computers search millions of records in seconds. Your paper database works the same way, just slower!'
- In one sentence, tell a parent or sibling what surprised you today.
Learning objectives
- Create structured data records with consistent fields
- Sort and re-sort the same dataset by different attributes
- Execute queries using AND/OR logic to filter records
Upper elementary (ages 8–10)
Master database concepts. Design a relational database with multiple tables (using clear, unambiguous column names), write queries in plain English that match SQL logic, normalize data to avoid redundancy, and analyze a real dataset to find patterns and insights.
Steps
- Design a database for a school. Use clear column names so the same word never means two different things. Table 1 = Students (StudentID, Name, GradeLevel, Homeroom) where GradeLevel means 3rd / 4th / 5th. Table 2 = Classes (ClassID, Subject, Teacher). Table 3 = Enrollment (StudentID, ClassID, LetterGrade) where LetterGrade means A / B / C / D / F.
- Create 10 student records, 5 classes, and enroll each student in 3 classes. Write it all on paper in table format.
- Write queries in plain English, using the precise column names: 'Find all students where GradeLevel = 5.' 'Find all students taking Math where LetterGrade = A.' 'Which teacher has the most students?'
- Trace through your tables to answer each query. Count how many records you had to check.
- Discuss why renaming 'Grade' to 'GradeLevel' and 'LetterGrade' matters: if both columns were just called 'Grade', queries like 'Grade = 5' would be ambiguous. Clear names prevent bugs.
- Real-world project: collect data about 20 items (books, movies, games). Design a database, enter the data, and discover 3 interesting patterns.
- In one sentence, tell a parent or sibling what surprised you today.
Learning objectives
- Design a relational database with multiple linked tables
- Write and execute English-language queries that mirror SQL logic
- Understand data normalization and why it prevents redundancy and errors
Safety and evidence note
Read the full activity before beginning. An adult should supervise tools, heat, food, outdoor work, movement, and experiments as appropriate. Completion records that the activity was done; the child’s explanation, work sample, photo, or demonstration is stronger evidence of learning than a completion check alone.
Related coding activities
AI Explorers
Train a pretend 'robot brain'! Show it 5 cat pictures and 5 dog pictures, then test if it can guess a new one.
Algorithm Art
Follow step-by-step drawing instructions to create a picture. The instructions are your algorithm! Each step adds one shape or line.
API Restaurant
Play restaurant! The customer tells the waiter what they want, the waiter tells the kitchen, and the kitchen makes it. The waiter is the messenger — just like how computers talk to each other!
App Design Workshop
Design your dream app! Draw what you'd see on a phone screen. What would your app do? What buttons would it have?