Elements and Performance Criteria
- Prepare for spreadsheet tasks.
- Spreadsheet requirements for spatial data entry, storage, output, reporting and presentation are identified to determine task requirements in consultation with appropriate persons.
- Tasks are evaluated to identify design parameters, required mathematical formulas and areas where automation would increase efficiency according to task requirements.
- Software is set up and checked to ensure functionality and capacity to meet task and organisational requirements.
- Set up spreadsheets.
- Spreadsheet templates are developed and edited to standardise spreadsheet operation and ensure quality and consistency in format and design.
- Linked worksheet solution is developed using software functions and formulas to meet task requirements.
- Worksheets are formatted to incorporate cell and data attributes, formulas and graphs with labels and titles.
- Formulas are tested to confirm that output meets task requirements and errors are identified and resolved or contingencies managed.
- Use functions and features of spreadsheet software.
- Spatial data is entered, checked and edited according to task and organisational requirements.
- Spatial data is imported and exported between compatible spreadsheets, and host documents are adjusted according to task requirements.
- Software documentation and online help are used to overcome problems with spreadsheet design and production.
- Spreadsheets, including graphs, are produced and stored according to organisational requirements.
- Finalise spreadsheets.