Unit 27: Spreadsheet Modelling
Unit code: K/601/5816
QCF Level 2: BTEC First
Credit value: 10
Guided learning hours: 60
Aim and purpose
The aim of this unit is to give learners a knowledge of the uses of spreadsheets and enable them to develop,
test and document spreadsheet models.
Unit introduction
Although traditionally associated with financial applications and mathematical calculations, spreadsheet
software is very versatile. A spreadsheet can be used to store, manipulate and analyse data and to present it
in easy-to-understand formats, such as charts and graphs. Many people also use spreadsheets in preference
to word processing software when creating complex tables.
Spreadsheets can be used in many different situations, such as finance and engineering and the unit content
includes a wide range of spreadsheet features, formulae and functions. In addition, spreadsheet users need
to be able to choose from a variety of different ways of presenting and analysing spreadsheet data, including
producing graphs and filtering and sorting lists of data.
Learning outcomes
On completion of this unit a learner should:
1 Know what spreadsheets are and how they can be used
2 Be able to develop spreadsheet models
3 Be able to test and document spreadsheet models.
