This unit describes the skills and knowledge required to use spreadsheet software to complete business tasks and produce complex documents. It applies to individuals employed in a range of work environments who require skills in creation of complex spreadsheets to store and retrieve data. They may work as individuals providing administrative support within an enterprise, or may be independently responsible for designing and working with spreadsheets relevant to their own work roles.
Assessment tasks will be designed to reinforce and extend knowledge and skill competence within set and controlled parameters in accordance with each unit’s learning outcomes and performance criteria requirements, including the setting of work based practical application tasks designed to provide evidence of competence outcomes, within periodic and scheduled timelines.
Students will be expected to demonstrate the following required skills:
Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.
The qualified trainer and assessor will provide teaching and learning materials as required in the form of workbooks produced by the Polytechnic and/or via the Polytechnic e-learning system.
This unit is not compulsory for any specific course. Depending on the course you study, this unit may be taken as an elective.