Computing · Year 5

Active learning ideas

Spreadsheet Basics

Active learning works well for spreadsheet basics because pupils need to build spatial memory of grids. By drawing, labeling, and moving through cells, they turn abstract number-letter combinations into concrete knowledge they can recall later.

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

• 25–45 min
• Pairs → Whole Class
• 4 activities

Activity 01

• Experiential Learning
• 30 min · Pairs

Demo and Pairs: Grid Builder

Project a blank spreadsheet on the interactive whiteboard and label rows, columns, and sample cells together. In pairs, pupils replicate the grid on paper or software, add their own labels, and practise addressing five cells like C2. Pairs then swap grids to test each other's addresses.

Explain how a spreadsheet organizes information into a grid.

Facilitation Tip

During Grid Builder, have each pair sketch the grid on paper first so they can correct mistakes before touching devices.

What to look for

Provide students with a printed image of a small spreadsheet grid (e.g., 4x4). Ask them to label one row, one column, and three different cells with their correct addresses. Observe their ability to correctly identify and label these components.

• Apply
• Analyze
• Evaluate
• Self-Awareness
• Self-Management
• Social Awareness

Activity 02

• Experiential Learning
• 45 min · Small Groups

Small Groups: Library Book Tracker

Provide a list of 10 classroom books with details. Groups set up columns for title, author, genre, and available, then enter data into rows. They add one formula row to count total books and discuss how the grid organises information.

Differentiate between a row and a column in a spreadsheet.

Facilitation Tip

In Library Book Tracker, circulate and ask groups to explain why they chose each column heading before they start typing.

What to look for

Give each student a slip of paper. Ask them to draw a simple 3x3 grid and label the columns A, B, C and the rows 1, 2, 3. Then, ask them to write the cell address for the bottom right cell and state what kind of information might be stored there for a classroom library.

• Apply
• Analyze
• Evaluate
• Self-Awareness
• Self-Management
• Social Awareness

Activity 03

• Experiential Learning
• 25 min · Individual

Individual: Cell Address Challenge

Give each pupil a printed grid with highlighted cells and address clues. Pupils write the correct addresses and explain row-column differences in a short note. Follow with digital entry on computers to verify.

Design a simple spreadsheet to keep track of classroom library books.

Facilitation Tip

For the Cell Address Challenge, give pupils one minute to locate each cell before they write its address, preventing rushed errors.

What to look for

Pose the question: 'Imagine you are designing a spreadsheet to track your favourite video games. What would you put in the column headings? What would be in the first row of data?' Facilitate a brief class discussion, encouraging students to explain their choices and listen to peer ideas.

• Apply
• Analyze
• Evaluate
• Self-Awareness
• Self-Management
• Social Awareness

Activity 04

• Experiential Learning
• 35 min · Whole Class

Whole Class: Data Entry Relay

Divide class into teams. Project a shared spreadsheet. Teams send one pupil at a time to enter book data from cards into correct cells. Discuss row-column use after each round.

Explain how a spreadsheet organizes information into a grid.

Facilitation Tip

Run the Data Entry Relay in short rounds so every pupil gets a turn and stays engaged with the data.

What to look for

Provide students with a printed image of a small spreadsheet grid (e.g., 4x4). Ask them to label one row, one column, and three different cells with their correct addresses. Observe their ability to correctly identify and label these components.

• Apply
• Analyze
• Evaluate
• Self-Awareness
• Self-Management
• Social Awareness

A few notes on teaching this unit

Teachers often start with a physical grid drawn on the floor or table using masking tape. This lets pupils walk through the space, matching row numbers and column letters to their own movements. Avoid rushing straight to software; the tactile experience prevents later confusion. Research shows that pupils who build the grid structure by hand retain the layout months later compared with those who only see a screen demonstration.

By the end of these activities, pupils will confidently identify and explain rows, columns, and cell addresses. They will also design a simple spreadsheet with clear column headings and accurate cell references.

---

Watch Out for These Misconceptions

• During Grid Builder, watch for pupils who say rows are vertical and columns horizontal.

  Ask them to trace the row with their finger while saying left to right, then the column top to bottom. Have partners confirm directions before labeling the grid together.

• During Cell Address Challenge, watch for pupils who believe cells have no unique identifiers.

  Provide a 4x4 printed grid. Pupils work in pairs to find and label cells like B2 or C4 using sticky notes, showing each cell has a distinct address.

• During Library Book Tracker, watch for pupils who think spreadsheets handle only numbers.

  Give groups a list of mixed data: fiction, non-fiction, dates, and yes/no borrow status. Ask them to type these exactly as text to see that cells accept all types equally.

---

Methods used in this brief

• Experiential Learning