Computing · Year 6

Active learning ideas

Organizing Data in Spreadsheets

Active learning works for organizing data in spreadsheets because students need to experience the immediate consequences of their choices. When they build formulas and see results change in real time, they grasp why structure matters. This topic moves beyond passive data entry into active problem-solving, which is best learned by doing.

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

• 15–45 min
• Pairs → Whole Class
• 3 activities

Activity 01

• Inquiry Circle
• 45 min · Small Groups

Inquiry Circle: The Tuck Shop Model

In small groups, students create a spreadsheet to manage a tuck shop. They must use formulae to calculate profit and use 'what-if' scenarios to see what happens if the price of chocolate doubles.

Explain the importance of clear headings and consistent data entry in a spreadsheet.

Facilitation Tip

During Collaborative Investigation: The Tuck Shop Model, circulate and ask questions like, 'If the price of crisps changes to 40p, how will your formula update automatically?' to reinforce cell references.

What to look for

Provide students with a blank spreadsheet template for tracking classroom attendance. Ask them to add clear column headers for 'Student Name', 'Date', and 'Present/Absent'. Then, ask them to enter data for three fictional students and use the filter tool to show only students marked as 'Absent'.

• Analyze
• Evaluate
• Create
• Self-Management
• Self-Awareness

Activity 02

• Think-Pair-Share
• 15 min · Pairs

Think-Pair-Share: Function Finder

The teacher provides a dataset of sports day results. Students must decide which function (SUM, AVERAGE, or MAX) is best for finding the winner, the total points, and the average score.

Compare different methods for sorting and filtering data to find specific information.

Facilitation Tip

During Think-Pair-Share: Function Finder, provide a one-page reference guide with function names and examples to reduce cognitive load.

What to look for

Display a sample spreadsheet with inconsistent data entry and unclear headings. Ask students to identify two specific problems with the organization and suggest one way to improve it. For example: 'The dates are entered in different formats, making it hard to sort. We should use YYYY-MM-DD for all dates.'

• Understand
• Apply
• Analyze
• Self-Awareness
• Relationship Skills

Activity 03

• Peer Teaching
• 20 min · Pairs

Peer Teaching: Formula Doctors

Students are given a spreadsheet with 'broken' formulae (e.g., missing equals signs or wrong cell references). They work together to diagnose and fix the errors.

Design a spreadsheet layout to effectively track classroom attendance.

Facilitation Tip

During Peer Teaching: Formula Doctors, give students a checklist of common errors to look for when reviewing each other’s work.

What to look for

Pose the question: 'Imagine you have a spreadsheet with 100 student names and their scores on five different tests. Describe two different ways you could sort or filter this data to find interesting information about student performance, and explain why each method would be useful.'

• Understand
• Apply
• Analyze
• Create
• Self-Management
• Relationship Skills

A few notes on teaching this unit

Teach this topic by modeling spreadsheet use live, not through slides. Start with a simple calculation, then break it by inserting a row to show why absolute references matter. Avoid telling students 'just use this function.' Instead, ask them to predict outcomes before the computer calculates. Research shows this prediction-observation cycle deepens understanding of formulas.

By the end of these activities, students should confidently use cell references in formulas, apply functions like SUM and AVERAGE, and explain why clear organization improves data analysis. They should also be able to troubleshoot errors and justify their spreadsheet design choices.

---

Watch Out for These Misconceptions

• During Collaborative Investigation: The Tuck Shop Model, watch for students typing numbers directly into formulas like '=10+5' instead of using cell references.

  Pause the class and demonstrate by changing a price in the model. Show how fixed numbers break the formula but cell references update automatically. Ask students to rewrite their formulas using cell addresses.

• During Think-Pair-Share: Function Finder, some students may think SUM and AVERAGE are just buttons with no formula syntax.

  Have students write out the full formula first, like '=SUM(C2:C10)', before using the function button. Ask them to predict the result before pressing Enter.

---

Methods used in this brief

• Inquiry Circle
• Think-Pair-Share
• Peer Teaching