Unit of competency Outline

Date retreived
23/07/2026 7:31 AM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Develop spreadsheets for spatial data

Develop spreadsheets for spatial data

Unit of competency
National Code
CPPSSI5060
State Code
OCU97
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
13/01/2021
State Implementation and Classification
Approved Date
01/06/2021
Field of Education
031199 - Geomatic Engineering, N.e.c.
Original Release Date
01/06/2021
Nominal Hours
35
Description
This unit specifies the skills and knowledge required to design, create and validate spreadsheets for spatial data and to translate spatial data into spreadsheet design and layout. It includes translating between spreadsheet and spatial software, and using functions and features of spreadsheet software, including linked spreadsheets, documents and advanced mathematical formulas. The unit also includes identifying design parameters and setting up software and spreadsheet templates to ensure quality and consistency in format and design, as well as using technology to apply advanced mathematical concepts to spatial data, including identifying and resolving errors relating to formulas and other spreadsheet functions.This unit is suitable for skilled surveying technicians and skilled spatial information system (SIS) technicians who use a broad range of cognitive, technical and communication skills to select and apply methods and technologies to analyse information and provide solutions to sometimes complex surveying/spatial information problems.Surveying and spatial information skills are applied in a range of industry contexts, including town planning, civil construction, mining, engineering, health, agriculture and defence.All work must be carried out to comply with workplace procedures, in accordance with relevant state/territory regulations that govern surveying work, as well as work health and safety (WHS) legislation and regulations that apply to the workplace.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1 Prepare for spreadsheet tasks.
  • 1.1 Determine specifications for spreadsheets and identify the task requirements for spatial data entry, storage, output, reporting and presentation.
  • 1.2 Evaluate tasks to identify design parameters, required features and functions and areas where automation would increase efficiency.
  • 1.3 Set up and check software for functionality and capacity to meet task requirements.
2 Set up spreadsheets.
  • 2.1 Develop linked spreadsheet solution using software features and formulas to meet task requirements.
  • 2.2 Test formulas and functions and resolve errors to confirm that output meets task requirements.
  • 2.3 Format spreadsheets and use titles, colours, headings, labels and data to enhance meaning and presentation of data.
3 Use functions and features of spreadsheet software.
  • 3.1 Enter, check and edit spatial data according to task and organisational requirements.
  • 3.2 Import and export spatial data between compatible software applications and adjust host documents according to task requirements.
  • 3.3 Use software documentation and online help to overcome errors and problems with spreadsheet design and production as required.
  • 3.4 Develop and edit spreadsheet templates to standardise spreadsheet operation and ensure quality and consistency in format and design.
4 Finalise spreadsheets.
  • 4.1 Protect completed spreadsheets to prevent accidental corruption and archive according to organisational requirements.
  • 4.2 Complete documentation and inform appropriate persons of results according to organisational requirements.
No information
No information
Replaces
State Code National Code Title Type
AXG29 CPPSIS5060 Develop spreadsheets for spatial data Unit of competency