Week 12 · 45-60 min

Putting It All Together

Week Summary

A quick preview of the main ideas in this week before you begin the slides.

Review these key terms before starting this week. They are kept simple so students can learn the new vocabulary before moving into the slides.

Slide 1💡

Progress

1 / 8

Learning goal

Review the full data analysis workflow before the capstone project.

Read one card at a time. Focus on the main idea first, then look at the visual on the right to help it stick.

Review the sequence: collect, clean, analyze, visualize, interpret.

Each stage builds on the one before it.

Skipping steps increases the risk of weak conclusions.

This workflow applies to many real datasets.

Confidence in the workflow supports success in the capstone.

Remember

A reliable workflow is one of the strongest tools a beginner analyst can learn.

Slide 1 of 8

Use arrows or dots to move through the lesson

Coming Next Week: Take the weekly quiz, then continue to the next week.

Complete the "Analyze a Real Dataset" project across weeks 11-12.

Day 1: Choose or receive a dataset, explore its structure, and identify the guiding question.
Day 2: Clean the data by addressing missing values, duplicates, and formatting inconsistencies.
Day 3: Apply core formulas such as SUM, AVERAGE, and COUNT to summarize the dataset.
Day 4: Apply at least one conditional formula such as IF, COUNTIF, or SUMIF.
Day 5: Build a pivot table to explore the data from a new angle.
Day 6: Create at least two appropriate charts.
Day 7: Calculate descriptive statistics such as mean, median, and range.
Day 8: Write a findings summary explaining what the data shows and noting limitations.
Day 9: Prepare a short presentation for peer review.
Day 10: Present the findings and answer questions.