Week 4 · 45-60 min
Basic Formulas (SUM, AVERAGE, COUNT)
Week Summary
A quick preview of the main ideas in this week before you begin the slides.
- Recap: Why Formulas Matter
- SUM for Totals
- AVERAGE for Central Tendency
- COUNT and COUNTA
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.
- Recap: Why Formulas Matter
- Recap: Why Formulas Matter
- SUM for Totals
- SUM for Totals
- AVERAGE for Central Tendency
- AVERAGE for Central Tendency
Recap: Why Formulas Matter
Progress
1 / 8
Apply core formulas to summarize datasets.
Read one card at a time. Focus on the main idea first, then look at the visual on the right to help it stick.
Formulas automate repeated calculations.
They update automatically when data changes.
They save time on larger datasets.
They turn raw tables into analytical tools.
They are the foundation of deeper analysis.
Remember
Formulas are what turn a spreadsheet from storage into analysis.
Recap: Why Formulas Matter
Slide 1 of 8
Use arrows or dots to move through the lesson
Practice
- Write 2-3 sentences about what you learned this week.
Coming Next Week: Next: Conditional Formulas (IF, COUNTIF)