Spreadsheet Software
Unit summary
This is the ability to use a software application designed to record data in rows and columns, and perform calculations with numerical data. A spreadsheet can be used for different tasks, such as budgeting, producing tables, calculating house-hold bills or producing graphs.
This involves: entering data into cells; using simple formulae and functions (eg sum, divide, multiply, take away and fractions); and simple tools to edit, sort, present and check spreadsheets (eg a duty rota for staff or a work sheet for keeping track of expenses).
using more complex formulae and functions (eg mathematical, statistical and financial) and tools (eg monthly expenditure and sales figures, cash flow forecasts and graphs of results).
Unit details
e-skills - e-skills UK (Note: not an awarding body)
-
06 Information and Communication Technology
This unit is based on National Occupational Standards, as defined by e-skills UK.
| Learning Outcome |
Assessment Criteria |
| 1 Know how to use spreadsheet software |
1.1 Describe who and what the information is for, where it will be used (eg on screen or hard copy) and how it communicates clearly and accurately with the audience when it is needed.
1.2 Describe how to produce professional looking spreadsheets for a wide variety of uses that are accurate and well laid out.
1.3 Describe how to analyse and interpret simple and complex data. |
| 2 Use spreadsheet software |
2.1 Use file handling techniques for the software.
2.2 Use techniques to combine and link information.
2.3 Enter and edit spreadsheet data
2.4 Format simple spreadsheets
2.5 Check that page breaks fall in appropriate places and that the formatting is appropriate.
Check the accuracy of results and sort out errors in formulas.
2.6 Use appropriate functions and formulas in simple spreadsheets.
2.7 Analyse and interpret simple data.
2.8 Present data.
2.9 Improving efficiency (eg Setting up short cuts) |