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).
producing spreadsheets for analysing and interpreting complex data (eg a cost benefit analysis, budgets and annual accounts).
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 Understand how to use a 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 information that communicates effectively, by structuring the content to take account of different contexts and audience needs.
1.3 Describe how to produce professional looking spreadsheets for a wide variety of uses that are complex in terms of content and meaning as well as the understanding, skills and techniques needed to produce them and are accurate and well laid out.
1.4 Describe how to analyse and interpret simple and complex data, such as to compare related totals or predict trends. |
| 2 Optimize the use of Spreadsheets. |
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.
Checking the validity, relevance and accuracy of analysis and the interpretation of calculations and results.
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. Customising menus and toolbars. Automating common tasks, such as by using macros). |