dayzero-365
Button 1 Button 2

EMAIL LESSON 8: More Essential Formulas (COUNT, MAX, MIN)

Subject Line: Day 8: 3 More Formulas Every Teacher Needs 📊

Welcome to Week 2! You've mastered SUM and AVERAGE - now let's add three more essential formulas that will give you deeper insights into your students' performance.

Today's 15-Minute Lesson: COUNT, MAX, and MIN

These formulas answer questions every teacher asks: "How many students took the test?" "What's the highest score?" "What's the lowest score?"

What You'll Learn Today:

  • COUNT: How many students (or scores) you have

  • MAX: Find the highest score automatically

  • MIN: Find the lowest score automatically

  • When to use each formula

The New Formulas Explained:

COUNT Formula:

  • =COUNT(F2:F9) counts how many cells have numbers

  • Use for: How many students took a test, total submissions, attendance count

MAX Formula:

  • =MAX(F2:F9) finds the highest number in the range

  • Use for: Top score, best performance, highest attendance

MIN Formula:

  • =MIN(F2:F9) finds the lowest number in the range

  • Use for: Lowest score, students needing help, minimum attendance

Today's Practice: Enhance Your Grade Sheet (12 minutes)

Open your grade sheet from Day 7 and add these analysis features:

Step 1: Create Analysis Section (3 minutes)

  1. Click on A13 and type: CLASS ANALYSIS

  2. Make it bold (Ctrl+B)

  3. In A15 type: Total Students

  4. In A16 type: Highest Average

  5. In A17 type: Lowest Average

Step 2: Add COUNT Formula (2 minutes)

  1. Click B15 (next to "Total Students")

  2. Type: =COUNT(F2:F9)

  3. Press Enter

  4. Excel shows 8 (the number of students with averages)

Step 3: Add MAX Formula (2 minutes)

  1. Click B16 (next to "Highest Average")

  2. Type: =MAX(F2:F9)

  3. Press Enter

  4. Excel shows the highest student average automatically!

Step 4: Add MIN Formula (2 minutes)

  1. Click B17 (next to "Lowest Average")

  2. Type: =MIN(F2:F9)

  3. Press Enter

  4. Excel shows the lowest student average

Step 5: Test the Magic (3 minutes)

  1. Change one of the test scores in your data

  2. Watch how MAX, MIN, and averages all update automatically!

  3. This is why formulas are so powerful

Real Teacher Applications:

COUNT Formula Uses:

  • "How many students submitted their projects?"

  • "How many attended today's lesson?"

  • "How many tests have been marked?"

MAX Formula Uses:

  • "What's the top score for recognition?"

  • "Best performance this term?"

  • "Highest attendance rate?"

MIN Formula Uses:

  • "Which students need immediate intervention?"

  • "Lowest scores for parent contact?"

  • "Students falling behind?"

Today's Success Check:

  • [ ] I can use COUNT to find how many students

  • [ ] I can use MAX to find the highest score

  • [ ] I can use MIN to find the lowest score

  • [ ] My formulas update automatically when data changes

  • [ ] I understand when to use each formula

Tomorrow We'll Learn: Setting up a complete grade book with multiple subjects and assessments.

[📊 Practice More Analysis Formulas] ← Link to: https://yoursite.com/day8-analysis

You're becoming an Excel analyst!

Best regards, Your Excel Course Team
Invite a Friend