Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
ICAICT105A Mapping and Delivery Guide
Operate spreadsheet applications
Version 1.0
Issue Date: July 2024
Qualification | - |
Unit of Competency | ICAICT105A - Operate spreadsheet applications |
---|---|---|---|
Description | This unit describes the performance outcomes, skills and knowledge required to operate spreadsheet applications and perform basic operations, including creating and formatting spreadsheet data, incorporating charts and objects, and customising and printing spreadsheets. | ||
Employability Skills | This unit contains employability skills. | ||
Learning Outcomes and Application | This unit applies to individuals who perform a range of routine tasks in the workplace using a fundamental knowledge of spreadsheets under direct supervision or with limited responsibility.The use of spreadsheets for business and mathematical applications is widespread. In some cases, spreadsheets can operate as sophisticated computerised ledgers and enable the collation, manipulation and presentation of complex data. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. |
||
Prerequisites/co-requisites | Not applicable. | ||
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: Create spreadsheets |
| |||||||
Element: Customise basic settings |
| |||||||
Element: Format spreadsheet |
| |||||||
Element: Incorporate object and chart in spreadsheet |
| |||||||
Element: Print spreadsheet |
|