Computing · Year 6

Active learning ideas

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.

• National Curriculum Attainment Targets
• KS2: Computing - Data Handling
• KS2: Computing - Information Technology

• 30–50 min
• Pairs → Whole Class
• 3 activities

Activity 01

• 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.

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.

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

Activity 02

• 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.

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.

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

Activity 03

• 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.

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.

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

A few notes on teaching this unit

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.

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

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

  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?'

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

  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.

---

Methods used in this brief

• Flipped Classroom