Data Skills for Teens: Collect, Clean, and Chart a Real Dataset in 60 Minutes

Why data skills matter (and what “data literacy” looks like for teens)

Parents hear “data science” and picture advanced math or coding bootcamps. In reality, data science for teens starts with a simpler (and more useful) skill: data literacy—the ability to collect information, check if it’s trustworthy, and communicate what it shows.

For ages 14–17, this is a sweet spot:

• Teens already make decisions based on “data” every day (grades, sports stats, screen time, fitness apps).
• They’re old enough to notice patterns—and question them.
• They can build a portfolio-ready mini project in under an hour.

A strong teen data habit isn’t “memorize formulas.” It’s asking:

• Where did this data come from?
• What’s missing or messy?
• What’s a fair way to summarize it?
• How can I show it clearly in a chart?

If you’ve wondered how to teach data literacy to teens without turning your kitchen table into a lecture hall, this 60-minute project is the quickest win I know.

The 60-minute data project (real dataset, real skills)

This is a hands-on data project for high school students that works with a spreadsheet (Google Sheets or Excel). No coding required—though you can add it later.

What you’ll need

• A laptop (best) or tablet with Google Sheets
• Internet access
• A timer

Choose a dataset in 5 minutes (two easy options)

Option A: “School Night Sleep Check” (teen-collected dataset)

Have your teen collect data from 10–20 classmates (or family members) using a quick Google Form:

• Hours of sleep last night (number)
• School day? (Yes/No)
• Mood today (1–5)
• Caffeine today? (0/1)

This is great because they control the collection and learn about bias.

Option B: Use a ready-made real dataset (fastest)

Pick a small, trustworthy dataset that’s already public:

• Local weather (daily temperature for your city)
• A school sports team’s game results
• Public health or education datasets (keep it non-sensitive)

If you want something universally accessible, search: “NYC Open Data daily temperature” or “NOAA daily weather CSV.”

A simple project goal (so it doesn’t get overwhelming)

Pick one question your teen can answer with a chart:

• “Do I feel better on days after 8+ hours of sleep?”
• “How does temperature change across the week?”
• “Does caffeine line up with mood ratings?”

This is the difference between a fun project and a confusing spreadsheet.

Clean the data like a beginner (without the pain)

Messy data is normal. Learning data cleaning for beginners is basically learning to be skeptical in a healthy way.

Here’s a teen-friendly checklist that works in 20 minutes.

Step 1: Standardize columns (5 minutes)

Tell your teen: “Computers hate inconsistency.”

• Make sure column names are short and clear: date, sleep_hours, mood, caffeine.
• Keep units consistent (don’t mix “7.5” with “7 hours”).
• Decide how to write categories (always Yes/No, not Y/yes/yeah).

Step 2: Spot common “messy” issues (5 minutes)

Have them scan for:

• Blank cells (missing values)
• Impossible values (sleep = 20 hours)
• Typos (5O instead of 50)
• Mixed types (numbers stored as text)

Step 3: Make a “clean rules” decision (5 minutes)

This part teaches judgment. Ask:

• If sleep_hours is missing, do we delete that row or fill it?
• If someone typed “ten” instead of 10, do we convert it?

For a first project, keep it simple:

• Delete rows that are missing the key number you need for the chart.
• Fix obvious typos when you’re confident.
• Keep a note of what you removed and why.

Step 4: Create one extra column that improves analysis (5 minutes)

Add a helper column that makes charting easier. Example for sleep:

• sleep_bucket: Under 7, 7–8, 8+

In Google Sheets, you can use a simple formula approach or just label it manually for a small dataset.

Here’s a quick guide your teen can follow:

Cleaning task	What to do in Sheets	Why it matters	Time
Remove duplicates	Data → Data cleanup → Remove duplicates	Prevents double-counting	2 min
Standardize Yes/No	Find and replace (Y → Yes)	Makes grouping possible	3 min
Fix number formatting	Format → Number	Allows sorting/averages	2 min
Handle blanks	Filter blanks, delete or fill	Avoids misleading charts	5 min
Add a bucket column	New column with labels	Easier comparisons	5 min

A parent tip: if your teen gets stuck, don’t “take over.” Ask: “What rule would be fair for everyone in the dataset?” That’s data thinking.

Chart it in 15 minutes: one clear chart + one honest takeaway

Now the fun part: turning rows into a picture.

Choose the right chart (fast rule)

• Bar chart: comparing categories (sleep buckets vs average mood)
• Line chart: change over time (temperature by date)
• Scatter plot: relationship between two numbers (sleep hours vs mood)

If your teen isn’t sure, start with a bar chart—it’s the easiest to read.

Build a simple summary table (5 minutes)

Charts work best when they’re based on a summary, not raw rows.

Example summary for the sleep project:

• Group by sleep_bucket
• Calculate average mood

In Google Sheets:

• Insert → Pivot table
• Rows: sleep_bucket
• Values: Average of mood

Create the chart (5 minutes)

• Highlight the summary table
• Insert → Chart
• Pick bar chart

Then do the “three cleanups” that make it look professional:

• Add a clear chart title: “Average Mood by Sleep Amount”
• Label axes (or at least ensure they’re obvious)
• Start the y-axis at 0 for bar charts (to avoid exaggeration)

Write one takeaway and one limitation (5 minutes)

This is the heart of data literacy: not just “what I see,” but “how sure I am.”

Have your teen write:

• Takeaway (1 sentence): “Students who slept 8+ hours reported higher mood on average.”
• Limitation (1 sentence): “This survey is small and self-reported, so it might not represent everyone.”

If you only do one thing to teach good data habits, do this.

Next Steps: turn this into a repeatable skill (and a portfolio piece)

Once your teen finishes the 60-minute version, you can stretch it into a bigger project over a week—without adding stress.

A simple “level-up” menu

Pick one upgrade:

• Collect more data (aim for 30–50 responses) and compare results.
• Add one more variable (exercise minutes, homework time, screen time).
• Try a second chart type (scatter plot + trendline).
• Write a 150-word reflection: What did I clean? What surprised me? What would I do differently?

How parents can support (without being the “data police”)

Use questions, not corrections:

• “What does each column mean?”
• “Which rows did you remove—and why?”
• “If someone disagrees with your chart, what would you show them?”

How to get started today (10-minute setup)

1. Pick the dataset option (survey or public data).
2. Create a spreadsheet with 4–6 columns.
3. Set a timer for 60 minutes and follow the order: collect → clean → summarize → chart → takeaway.
4. Save the final chart and summary table as a shareable link or PDF.

At Intellect Council, we love projects like this because they build the kind of confidence teens need for modern school—and modern careers. Once your teen can clean a dataset and explain a chart, they’re not just “using data.” They’re thinking with it.