This unit describes the skills and knowledge required to develop spreadsheets through the use of spreadsheet applications.The unit applies to individuals employed in a range of environments who tend to be personally responsible for designing and working with spreadsheets under minimal supervision. These individuals are generally required to have intermediate knowledge and understanding of a number of spreadsheet applications.
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:
*plan, design, produce and finalise a spreadsheet on at least four occasions.
In the course of the above, the candidate must:
*produce spreadsheet documents that align to document purpose and appropriate to target audience
*design spreadsheets using:
The qualified trainer and assessor will provide teaching and learning materials as required in the form of workbooks produced by the Victoria University and/or via Victoria University e-learning system.
This unit is studied as part of the following course(s):