Functional Skills

This page has been prepared to help with the basics of working in the digital industry as well as support you with your functional skills. The term functional skills refers to skills that any organisation would reasonably expect a professional person to do, regardless of the industry they work in; such as:

  • Reading
  • Writing
  • Speaking and Listening
  • Simple maths
  • The use of basic IT systems, such as email, internet and office tools.

All of these lessons have been made to embed functional skills and to help you to prepare for your functional skills exams.

Functional ICT

Spreadsheet Basics

These exercises have been developed to give you a basic introduction to spreadsheets and to remind you of a few of the most basic principles used in spreadsheets, such as importing data, making charts or graphs and basic formula. Basic Data Handing and Formula; Clothing Store Open a new spreadsheet. Enter your name using text… Read More »


Logical (IF) Formula

Logical formula are basically tests; and the results of that test will determine what will happen next. This lesson has been put together to help you better understand logical formula and practice their usage in a range of different ways. The slideshow below gives four different examples of logical formula, though the first two examples… Read More »


Sorting and Filtering

Sorting and filtering are two ways or organisation data on a spreadsheet or database in order to make it easier to analyse and use. Sorting is the process of putting all the data in a particular order, whereas filtering allows you to turn your headings into drop down menus to display only the information you… Read More »


Conditional Formatting

Conditional formatting is the process of changing the formatting of the contents in a cell depending on the values of the cell, for example, if a cell shows a positive number like £548.37 it will appear black, however if it was a negative number like £397.15 it would appear red automatically. Conditional Formatting Exercise: Open… Read More »



Spelling, Grammar and Proofreading

The objectives of this lesson are to: Recognise reading strategies Use spelling strategies Recognise homophones Effectively use apostrophes Plan writing Proofread for spelling and grammatical errors Record learner support Use the English marking strategy Spelling Strategies Spelling strategies are tips to help you to remember how to spell certain words Say it as it looks… Read More »


Language Features

This lesson explores the different language features that you might notice when you are reading.  

Letterpress chase typography


This lesson explores a vast range of topics surrounding typography, hopefully including everything you ever needed to know plus much more. Due to the shear quantity of information on this subject, we have divided the lesson into different sections below to help you find what you’re interested in more simply. For a general overview as… Read More »



Communication is essential in every workplace, and you will be expected to work with and get along with all different kinds of people as your career progresses. This lesson will explore three different areas around communication and working with other people. The first part delves into the different aspects of teamwork and working with other people; including… Read More »




Area and Perimeter

This lesson has been put together to help with working out area and perimeter. Start with this video courtesy of Khan Academy to get started. What are the missing measurements? What is the perimeter and area?


Costs and Budgets

This is a copy of the Costs and Budgets webinar training session. Some of the materials you might find useful for reference purposes, and the activities referred to in the workbook have been copied below. Ignore the blonde: clip from ‘a beautiful mind’ Business finances Before starting the assessment for the finance part of this… Read More »

Calculating repayments and interest

Financial Decisions

Let’s compare some bad decisions with money, to good financial advice. In this lesson we will be exploring some different aspects of finances that affect young people.