Level 1 - Module 2 - Unit 2.5 - Sorting & Filtering Data

This Workbook includes:

Module 2 - Creating and Editing

Unit 2.5 - Process (including sort, filter) numeric data by values in a column.

Task 1 – Sorting Fitness Class Attendance

Learners enter fitness class data and practise sorting values both from largest to smallest and smallest to largest. They apply formatting techniques such as bold headings, borders, and adjusting column widths.

Task 2 – Filtering Wellbeing Scores

Using data collected by the wellbeing coach, learners apply a range of filters to locate members who may need additional support. They filter by conditions such as stress levels and sleep scores, explore how filters reveal specific information quickly, and format their tables for clarity.

Task 3 – Sorting & Filtering Gym Equipment Usage

Learners combine sorting and filtering to analyse gym equipment usage. They sort by minutes used and calories burned, filter machines based on usage thresholds, and consider how this information helps plan maintenance and gym layouts.

Task 4 – Working with Membership Data

Learners organise membership costs and popularity figures, applying filters and currency formatting. They compare membership plans and take part in a short team discussion to justify decisions.

Task 5 – Over to You! Creating a Wellbeing Dataset

Learners independently create their own dataset using a chosen wellbeing or fitness theme. They must include clear headings, multiple numeric columns, sorting, filtering, and an explanation of what their data shows.

Spreadsheets Included:

This resource includes learner spreadsheets for all tasks and tutor-completed spreadsheets for Tasks 1–4 (with correct figures only).

The unit ends with a 10-question recap quiz to reinforce learning.

Every download also includes:

• ✔ Learner Glossary

• ✔ Skills & Knowledge Checklist

• ✔ Guided Tutor Answers (where applicable)

• ✔ Instant PDF Download