Computing · Year 5

Active learning ideas

Sorting Data

Active learning works for sorting data because students need to physically arrange items to see how order changes meaning. When they handle real cards or spreadsheet rows, patterns emerge naturally, showing why ascending or descending sorts matter for different questions.

• National Curriculum Attainment Targets
• KS2: Computing - Data and Information

• 20–35 min
• Pairs → Whole Class
• 4 activities

Activity 01

• Collaborative Problem-Solving
• 25 min · Pairs

Card Sort Challenge: Game Scores

Give pairs sets of cards with player names, scores, and levels from a fictional game. First, sort ascending by score; then descending by level. Pairs record patterns in a table and share one insight with the class.

Analyze how sorting data can reveal hidden patterns or relationships.

Facilitation Tip

During Card Sort Challenge, circulate to listen for students explaining sorting rules aloud as they arrange cards.

What to look for

Provide students with a small list of game scores (e.g., 5 scores). Ask them to write the scores in ascending order on a mini-whiteboard. Then, ask them to write the same scores in descending order. Check for accuracy in both.

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

Activity 02

• Collaborative Problem-Solving
• 35 min · Small Groups

Spreadsheet Relay: Multi-Field Sort

Divide into small groups with laptops or tablets. Load a shared spreadsheet of game data. One student sorts by name ascending, passes to next for score descending, and so on. Groups predict and discuss interpretation shifts.

Predict how sorting by different fields would change the interpretation of data.

Facilitation Tip

In Spreadsheet Relay, limit tools to simple sorts to force students to focus on field selection rather than advanced features.

What to look for

Present a table of fictional player data including 'Player Name', 'Level Reached', and 'Time Played'. Ask: 'If we sort this table by 'Time Played' in descending order, what might we learn about our players? What if we sort by 'Level Reached' in ascending order?'

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

Activity 03

• Collaborative Problem-Solving
• 30 min · Small Groups

Prediction Hunt: Data Patterns

In small groups, provide unsorted game stats lists. Predict top trends before sorting by different fields like time played or wins. Sort digitally, compare predictions, and justify surprises.

Justify why it might be useful to sort data in both ascending and descending order.

Facilitation Tip

For Prediction Hunt, pause after each round to ask students to verbalize why they changed their initial guesses based on the sorted results.

What to look for

Give students a scenario: 'You have a list of student heights. Explain why sorting this list in ascending order would be useful for a PE teacher.' Students write one sentence explaining the benefit.

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

Activity 04

• Collaborative Problem-Solving
• 20 min · Whole Class

Justify the Sort: Class Debate

Whole class views projected game data. Vote on best sort direction and field for scenarios like finding improvers. Debate in pairs first, then share reasons.

Analyze how sorting data can reveal hidden patterns or relationships.

What to look for

Provide students with a small list of game scores (e.g., 5 scores). Ask them to write the scores in ascending order on a mini-whiteboard. Then, ask them to write the same scores in descending order. Check for accuracy in both.

• Apply
• Analyze
• Evaluate
• Create
• Relationship Skills
• Decision-Making
• Self-Management

A few notes on teaching this unit

Teach sorting as a tool for decision-making, not just procedure. Start with concrete objects to build intuition, then move to spreadsheets to connect to real tools. Avoid rushing to algorithms—let students experience the cognitive dissonance when a descending sort reveals unexpected insights. Research shows this hands-on approach improves retention of both process and purpose.

Students will confidently arrange datasets in ascending and descending order, justify their choices, and explain how sorting reveals trends. They will compare original and sorted views to recognize the purpose of each direction.

---

Watch Out for These Misconceptions

• During Card Sort Challenge, some students may assume sorting only applies to numbers and skip text-based fields like player names.

  Prompt students to compare name fields directly, asking: 'How would you order these alphabetically? Is this different from ordering numbers?'

• During Spreadsheet Relay, students may think the act of sorting changes the values themselves, not just their order.

  Have students keep a duplicate sheet open and show how values stay identical before and after sorting, only their positions change.

• During Justify the Sort, students may default to ascending order without considering the purpose of the analysis.

  Ask them to argue for descending sort first, then provide a scenario where extremes matter (e.g., finding the longest play time) to highlight the value of direction choice.

---

Methods used in this brief

• Collaborative Problem-Solving