BSBITU402 - Develop and use complex spreadsheets

TAFE Victoria logo
Unit code: BSBITU402 | Study level: TAFE
N/A
City King St
Footscray Nicholson
Footscray Park
St Albans
Sunshine
Werribee
N/A
Overview
Enquire

Overview

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

For Melbourne campuses

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:

  • follow organisational and safe work practices;
  • adhere to organisational requirements;
  • adhere to identified or task requirements when producing documents;
  • resolve issues by referring to user documentation and online help;
  • use appropriate data storage options;
  • evaluate tasks to improve efficiency;
  • apply knowledge of functions and features of contemporary computer applications, and;
  • communicate with relevant personnel.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

Required reading

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.

As part of a course

This unit is not compulsory for any specific course. Depending on the course you study, this unit may be taken as an elective.

Search for units, majors & minors