Digital Functional Skills - L1 - Mod 2 - Creating & Editing - Unit 2.6 - Formatting 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.6 Format numeric data (including font sizes, font styles, alignment, cell formatting, merging cells, splitting cells, row height, column width).

Task 1 – Formatting Oliver’s Monthly Outgoings
Learners enter Oliver’s expenses and apply key formatting skills, including bold headings, currency formatting, alignment, and column adjustments. This introduces clear and professional presentation of financial data.

Task 2 – Adding Income Data
Learners add Oliver’s income to the same spreadsheet, matching font styles, applying colour-coded headings, centre-aligning amounts, and using borders. They learn the importance of consistency when presenting financial information.

Task 3 – Creating a Monthly Summary with Formulas
Learners build a “Monthly Summary” section and use SUM formulas to calculate total outgoings, total income, and money remaining. They merge headings, format totals, and begin to understand how spreadsheets support budgeting.

Task 4 – Managing Unexpected Changes
Learners add “Extra Costs” and “Bonus Income” to simulate real-life financial changes. They update formulas, adjust layouts, apply borders, and practise merging and unmerging cells. This develops flexibility and problem-solving within spreadsheets.

Task 5 – Over to You! Creating a Personal Budget
Learners design their own simple budget spreadsheet, using headings, formatting, numeric data, and formulas. A structured checklist supports independent working and ensures success criteria are met.

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

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.