BSBTEC402 - Design and produce complex spreadsheets

Unit code: BSBTEC402 | Study level: TAFE
Nominal hours:
50
Location
Footscray Nicholson
Prerequisites
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.The unit 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 & extend knowledge and skill competence within set & controlled parameters in accordance with each unit’s learning outcomes & performance criteria requirements, incl 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:
*on at least two occasions, prepare, develop, and use a complex spreadsheet.

In the course of the above, the candidate must:
*follow organisational and safe work practices
*adhere to organisational requirements for:

  • ensuring consistency of style, design and layout
  • saving and publishing documents within designated timelines
  • naming and storing documents
    *adhere to identified or task requirements when producing documents including:
  • editing macros and automating some tasks
  • using appropriate templates
  • creating graphs to represent data
    *resolve issues by referring to user documentation and online help
    *use appropriate data storage options.

Students will also be expected to demonstrate the following knowledge:
*advanced functions of spreadsheet software applications
*key aspects of formatting and design on presentation and readability of data
*organisational requirements for ergonomics, work periods and breaks, and conservation techniques
*key aspects of organisational policies and procedures
*key methods to test formulae.

Required reading

The qualified trainer and assessor will provide teaching and learning materials as required in the form of workbooks produced by Victoria University and/or via the Victoria University e-learning system.

As part of a course

This unit is studied as part of the following course(s):

Certificate IV in Business
BSB40120 | Certificate iv | Duration:
Diploma of Accounting
FNS50222 | Diploma | Duration:

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.

Search for units, majors & minors