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.

Unit details

Study level:
Vocational and further education (TAFE)
Unit code:


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: - formulas and functions with: - addition, subtraction, division, multiplication - brackets *design spreadsheets that address a range of data and organisational requirements *use software functions to create spreadsheets that adhere to organisational requirements relating to style and presentation *use relevant help functions to rectify document issues *produce spreadsheet document in appropriate format for review, including ability to create and modify intermediate-level charts that analyse the dataset. Students will also be expected to demonstrate the following knowledge: *key elements of formatting of spreadsheets appropriate to workplace documents, including the ability to calculate: - sum totals - averages - counts of values *key features of spreadsheet applications, both cloud-based and non-cloud based *key features of organisational guidelines on spreadsheet design and use *organisational requirements for ergonomics, work periods and breaks, and sustainability in relation to spreadsheet production.

Where to next?

As part of a course

This unit is studied as part of the following courses. Refer to the course page for information on how to apply for the course.

VU takes care to ensure the accuracy of this unit information, but reserves the right to change or withdraw courses offered at any time. Please check that unit information is current with the Student Contact Centre.