BSBITU202 - Create and use spreadsheets

Unit code: BSBITU202 | Study level: TAFE

Credit points

N/A

Location

Footscray Nicholson

Industry

Sunshine

Prerequisites

N/A

Overview

This unit describes the skills and knowledge required to correctly create and use spreadsheets and charts using spreadsheet software. It applies to individuals who perform a range of routine tasks in the workplace using a limited range of practical skills and fundamental knowledge of creating spreadsheets in a defined context under direct supervision or with limited individual responsibility.

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:

produce documents following correct ergonomic, conservation, organisational and statutory requirements;
consult with appropriate personnel as required;
adhere to organisational style and presentation requirements;
refer to online help function and user documentation to rectify document problems;
create and modify simple charts;
follow designated timelines and ensure high accuracy when preparing documents, and;
demonstrate ability to prevent data loss and damage.

Students will also be expected to demonstrate the following knowledge:

demonstrate knowledge of how to format workplace documents;
describe organisational requirements for ergonomic standards, work periods and breaks, and conservation techniques;
outline organisational guidelines on spreadsheet manipulation and processing, and;
explain purpose and range of use of spreadsheet functions.

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.