Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
MSTGN4014 Mapping and Delivery Guide
Produce and analyse spreadsheets
Version 1.0
Issue Date: May 2024
Qualification | - |
Unit of Competency | MSTGN4014 - Produce and analyse spreadsheets |
---|---|---|---|
Description | |||
Employability Skills | |||
Learning Outcomes and Application | This unit of competency describes the skills and knowledge required to design and set up spreadsheets to analyse production and financial performance.The unit applies to individuals employed in a range of production settings, who design and work with spreadsheets. Work may be conducted in all sectors of the textiles clothing and footwear industry and may involve individual and team activities.No licensing, legislative or certification requirements apply to this unit at the time of publication. | ||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. |
||
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: Create spreadsheet |
| |||||||
Element: Produce charts |
| |||||||
Element: Analyse data |
| |||||||
Element: Select and prepare resources |
| |||||||
Element: Identify spreadsheet task requirements in relation to data entry, storage, output and presentation |
| |||||||
Element: Format spreadsheet using software functions to adjust page and cell layout to meet information requirements | ||||||||
Element: Ensure formulas are tested and used to confirm output that meets task requirements | ||||||||
Element: Use manuals, user documentation and online help to support best practice in spreadsheet design and production |
| |||||||
Element: Create charts using required data range in spreadsheet | ||||||||
Element: Modify chart type and layout using formatting features |
| |||||||
Element: Analyse trends in data to identify inventory and cost outcomes | ||||||||
Element: Review and update spreadsheet components to match projected outcomes | ||||||||
Element: Report outcome of analysis to management |