Week 11 ยท 45-60 min

Interpreting Data and Drawing Conclusions

Week Summary

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

  • From Data to Insight
  • Correlation vs Causation
  • Considering Sample Size
  • Avoiding Bias in Interpretation

Glossary

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

From Data to Insight
From Data to Insight
Correlation vs Causation
Correlation vs Causation
Considering Sample Size
Considering Sample Size
Slide 1๐Ÿ’ก

From Data to Insight

Learning goal

Move from summarized data to meaningful, responsible conclusions.

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

Insight means understanding what the data actually shows.

Numbers alone do not fully explain "why" something happens.

Context and background knowledge matter.

Insight should connect back to the original question.

This is one of the main goals of analysis.

Remember

Analysis becomes useful only when numbers are turned into meaningful insight.

From Data to Insight

From Data to Insight

Slide 1 of 8

Use arrows or dots to move through the lesson

Practice

  1. Write 2-3 sentences about what you learned this week.

Coming Next Week: Next: Putting It All Together

Project Brief

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

What to Build

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

Self-Assessment Rubric

  • Data cleaning thoroughness โ€” 20%
  • Correct formula and pivot table usage โ€” 25%
  • Chart clarity and appropriateness โ€” 20%
  • Quality and honesty of written conclusions โ€” 20%
  • Presentation clarity โ€” 15%