Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
CPPSIS5060 Mapping and Delivery Guide
Develop spreadsheets for spatial data
Version 1.0
Issue Date: April 2024
Qualification | - |
Unit of Competency | CPPSIS5060 - Develop spreadsheets for spatial data |
---|---|---|---|
Description | |||
Employability Skills | |||
Learning Outcomes and Application | This unit of competency specifies the outcomes required to design and develop spreadsheets to enter, edit and format spatial data. The unit covers using functions and features of spreadsheet software, including linked spreadsheets, multiple documents and advanced mathematical formulas based on trigonometrical functions. The unit also covers work preparation activities, including evaluating tasks to identify design parameters and setting up software and spreadsheet templates to ensure quality and consistency in format and design. The unit requires the ability to use technology to apply advanced mathematical concepts to spatial data, including identifying and resolving errors relating to formulas and other spreadsheet functions.The unit supports those who work in a lead role in a surveying or spatial information services team.No licensing, legislative, regulatory, or certification requirements apply to this unit of competency at the time of endorsement. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. The following must be present and available to learners during assessment activities: equipment: computer with access to appropriate spreadsheet software printer specifications: organisational policies, procedures and documentation relating to data privacy and information copyright physical conditions: access to equipped work station relationships with team members and supervisor: working in a team. Timeframe: as specified by client and project requirements. Assessor requirements As a minimum, assessors must satisfy the assessor requirements in the Standards for Registered Training Organisations (RTOs) current at the time of assessment. |
||
Prerequisites/co-requisites | |||
Competency Field |
Development and validation strategy and guide for assessors and learners | Student Learning Resources | Handouts Activities |
Slides PPT |
Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | |
---|---|---|---|---|---|---|---|---|
Elements of Competency | Performance Criteria | |||||||
Element: Prepare for spreadsheet tasks. |
| |||||||
Element: Set up spreadsheets. |
| |||||||
Element: Use functions and features of spreadsheet software. |
| |||||||
Element: Finalise spreadsheets. |
|