Overview
Aim
The aim of this unit is to provide learners with the skills required to design a spreadsheet which uses appropriate functions and presentation formats to meet the requirements of a user.
Unit Learning Outcomes
1
Understand spreadsheets.
- Purpose
Collate, organise, categorise and manipulate data. - Advantages;
organisation
Analyse and visualise data; manage data; process complex formula; flexibility to present data in many ways and for different purposes; business forecasting.
employee
Pre-determined formulae; reduces complexity of calculations; data manipulation; numerous ways to present data.
Assessment Criteria
-
1.1
Explain the purpose of spreadsheets, giving specific examples of different uses within an organisation.
-
1.2
Explain the advantages to an organisation and an employee of using spreadsheets.
2
Be able to design, modify and use a spreadsheet.
- Basic functions
Saving; sharing; cell basics; modifying columns, rows and cells; formatting cells; adding, deleting, copying and moving spreadsheets; page layout; printing. - Formulas and functions
Simple formulas; complex formulas; relative and absolute cell referencing; creating arguments to create values and cell references. - Techniques for working with data
Freezing panes; view options; filtering data; groups; subtotals; using styles to format tables. - Advanced functions
Track changes and comments; finalising and protecting workbooks; conditional formatting; pivot tables; what-if analysis.
Assessment Criteria
-
2.1
Use basic spreadsheet functions.
-
2.2
Use formulas and functions associated with spreadsheets.
-
2.3
Use techniques to work with spreadsheet data.
3
Be able to use alternative views to present spreadsheet data.
- Graphs and charts
Insert, modify and graphs and charts to compare data; insert and label sparklines; pie charts; line charts; bar charts; tree map; histogram.
Assessment Criteria
-
3.1
Present data in graphs and charts.
-
3.2
Use labels to correctly identify elements of graphs and charts.