Digital Functional Skills - L1 - Mod 2 - Creating & Editing - Unit 2.4 - Process Numeric 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.4: Process numeric data using simple formula (including sum, subtraction, multiplication, division, maximum, minimum, average) using relative cell references.

Task 1 – Understanding Basic Formulas
Learners are introduced to the structure of simple formulas in spreadsheets. Using a fundraising scenario, they enter data, calculate totals, and use multiplication formulas to work out how much was made from each item sold.

Task 2 – Using the SUM Function
Learners move on to faster, more efficient methods of adding values using the SUM function. They also practice essential spreadsheet formatting such as bold text, borders, and applying currency formats.

Task 3 – Averages, Highest and Lowest
Learners extend their skills by using AVERAGE, MAX, and MIN to analyse sales data. They explore how functions help identify trends, compare results, and summarise findings with automatic calculations.

Task 4 – Practicing Relative Cell References
Learners explore how formulas change when copied down or across cells, using several short practice tables to master relative cell references. They create multiple sheets, rename tabs, and practice accurate formula copying.

Task 5 – Over to You! Creating a Budget Spreadsheet
Learners apply everything from the unit to create a complete monthly budget spreadsheet for a sports club. They calculate:
• total income
• total expenses
• remaining balance (profit or loss)

A learner checklist is included to promote independence and ensure all success criteria have been met.

9 Question Multiple-Choice Quiz

Also included is 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.