Course Title: Operate spreadsheet applications

Part A: Course Overview

Program: C4386 Certificate IV in Tertiary Preparation

Course Title: Operate spreadsheet applications

Portfolio: SEH Portfolio Office

Nominal Hours: 30

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Course Code




Learning Mode

Teaching Period(s)

Course Contact: Melanie Kyle

Course Contact Phone: +61 3 9925 4488

Course Contact Email:

Course Description

This unit describes the performance outcomes, skills and knowledge required to operate spreadsheet applications and perform basic operations, including creating and formatting spreadsheet data, incorporating charts and objects, and customising and printing spreadsheets.

Pre-requisite Courses and Assumed Knowledge and Capabilities

Not applicable.

National Competency Codes and Titles

National Element Code & Title:

ICAICT105A Operate spreadsheet applications


1. Create spreadsheets

2. Customise basic settings

3. Format spreadsheet

5. Print spreadsheet

4. Incorporate object and chart in spreadsheet

Learning Outcomes

On successful completion of this course, you will have developed and applied the skills and knowledge required to demonstrate your competence of the above elements. 

Overview of Assessment

Assessment will consist of:

  1. Assignments
  2. In class assessment