Digital Functional Skills - L1 - Mod 2 - Creating & Editing - Unit 2.5 - Sorting & Filtering Data

These resources have been created for those delivering the Digital Functional Skills Qualification at Level 1, which replaces the current Functional Skills ICT Qualification.
The DFS qualification’s main purpose is to provide reliable evidence of a learner’s achievements against content that is relevant to the workplace and real life.
These resources provide a structured assessment in workbook form to evidence learner knowledge and skills, as well as their ability to apply these in different contexts and demonstrate that all learning outcomes have been met. The qualification itself is made up of five main skill areas (Modules), each with its own series of units.
The unit workbooks include various challenges, activities and tasks to prove learners’ understanding. Each page has a header that includes the individual outcomes covered and can be assessed easily and signed off.
This resource covers:
Module 2 – Creating and Editing – 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).
Also included is a 10-question True/False recap quiz, a Glossary for learners to complete and a Skills and Knowledge Checklist to be filled in before and after delivery of this unit.
Guided Tutor Answers for relevant tasks are also included.
This resource is currently in a PDF file format. Word versions are available for free upon purchase of the PDF – please message me directly for these at SmartbooksEd@outlook.com.