Introduction to Functions: SUM, AVERAGE

Active learning helps students grasp how spreadsheets model real-world scenarios through immediate feedback and trial-and-error. For functions like SUM and AVERAGE, manipulating data in a spreadsheet builds intuition that abstract formulas alone cannot. This concrete experience demystifies how predictive modeling works.

• Year 6
• Computing
• 3 activities
• 30 min–50 min

Flipped Classroom

⏱ 45 min·Small Groups

Function Challenge: Class Data

Students are given a dataset of fictional class scores for a subject. They must create a spreadsheet to calculate the total score and average score for each student and for the whole class using SUM and AVERAGE functions.

Prepare & details

Explain the efficiency benefits of using functions over manual calculations.

Facilitation Tip: During the Simulation: The School Fair Predictor, circulate and ask guiding questions like, 'What happens to your total if you change the ticket price?' to encourage students to think about variables.

Setup: Standard classroom, flexible for group activities during class

Materials: Pre-class content (video/reading with guiding questions), Readiness check or entrance ticket, In-class application activity, Reflection journal

• Understand
• Apply
• Analyze
• Self-Management
• Self-Awareness

Flipped Classroom

⏱ 30 min·Whole Class

Formula vs. Function Race

Divide the class into two. One half uses manual formulas to sum a list of numbers, while the other uses the SUM function. Time both groups to demonstrate the efficiency difference.

Prepare & details

Differentiate between using a simple formula and a function for summing numbers.

Facilitation Tip: In the Think-Pair-Share, assign roles explicitly—one student explains the human prediction process, the other the computer’s—and time the discussion to keep it focused.

Setup: Standard classroom, flexible for group activities during class

Materials: Pre-class content (video/reading with guiding questions), Readiness check or entrance ticket, In-class application activity, Reflection journal

• Understand
• Apply
• Analyze
• Self-Management
• Self-Awareness

Flipped Classroom

⏱ 50 min·Individual

Spreadsheet Design: Favorite Foods

Students survey their classmates about favorite foods and record the data. They then design a spreadsheet to calculate the average number of votes per food item using the AVERAGE function.

Prepare & details

Design a spreadsheet that uses the AVERAGE function to analyze class test scores.

Facilitation Tip: For the Collaborative Investigation: Climate Modeling, assign roles such as data recorder, function tester, and presenter to ensure all students contribute meaningfully.

Setup: Standard classroom, flexible for group activities during class

Materials: Pre-class content (video/reading with guiding questions), Readiness check or entrance ticket, In-class application activity, Reflection journal

• Understand
• Apply
• Analyze
• Self-Management
• Self-Awareness

Teaching This Topic

Teach SUM and AVERAGE by starting with small, manageable data sets before scaling up to larger ones. Emphasize that functions are tools for efficiency and accuracy, not just commands to memorize. Avoid rushing to abstract formulas—instead, let students experiment with variations to see how inputs affect outputs. Research shows that students retain function syntax better when they first experience the problem-solving context in which those functions are useful.

What to Expect

Students will confidently explain why SUM and AVERAGE are efficient tools for analyzing data sets. They will use these functions correctly in spreadsheets to calculate totals and means, and describe how changes in data affect outcomes. Missteps in syntax or logic should be caught and corrected independently.

Watch Out for These Misconceptions

Common Misconception

During Simulation: The School Fair Predictor, watch for students assuming the spreadsheet’s prediction is exact.

What to Teach Instead

Use the post-activity discussion to contrast the spreadsheet’s output with real-world unpredictability, such as asking, 'If the weather is bad, will attendance drop exactly as predicted? Why or why not?'

Common Misconception

During Think-Pair-Share: Human vs. Computer Predictions, watch for students believing that more data always improves accuracy.

What to Teach Instead

Guide students to test their hypothesis by giving them irrelevant data (e.g., shoe sizes) and asking them to predict a classmate’s favorite color, then discuss why quality of data matters more than quantity.

Assessment Ideas

Quick Check

During Simulation: The School Fair Predictor, provide students with a small table of ticket sales data in a spreadsheet. Ask them to use the SUM function to find the total revenue and the AVERAGE function to find the mean number of attendees. Check their syntax and accuracy.

Exit Ticket

After Think-Pair-Share: Human vs. Computer Predictions, ask students to write down one reason why using the SUM function is more efficient than adding numbers manually in a spreadsheet. Then, have them write the formula they would use to find the average of cells B2 through B10.

Discussion Prompt

During Collaborative Investigation: Climate Modeling, pose the question: 'Imagine you have a list of 100 monthly rainfall measurements. Which is faster and less prone to error: typing each number into a calculator and adding them, then dividing by 100, or using the AVERAGE function in a spreadsheet? Ask students to explain their reasoning in pairs before sharing with the class.

Extensions & Scaffolding

• Challenge: Ask students to create a 'what-if' scenario where they adjust three variables (e.g., ticket price, number of attendees, and expenses) and predict the impact on profit using SUM and AVERAGE.
• Scaffolding: Provide a partially completed spreadsheet with pre-entered formulas for students to analyze and troubleshoot before creating their own.
• Deeper: Introduce conditional logic by asking students to use SUMIF or AVERAGEIF to analyze a subset of their climate data, such as average temperature only for months with rainfall.