Module Outline
Date retreived
22/07/2026 5:45 PM AWST
22/07/2026 5:45 PM AWST
Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.
Electronic Spreadsheets 111
Electronic Spreadsheets 111
Module
National Code
State Code
51527
51527
DTWD Status
Approved
Approved
State Implementation and Classification
Approved Date
Field of Education
080905 - Practical Computing Skills
Nominal Hours
51
Description
To describe the features of electronic spreadsheets.
To introduce the main applications of spreadsheets.
To develop students' competency in using
spreadsheets.
To introduce the main applications of spreadsheets.
To develop students' competency in using
spreadsheets.
No information
Evidence Guide
Internal Assessment 100%
Written Test 30%
Mid-semester test consisting of:
Objective, short answer and problem solving
questions relating to spreadsheet features covered.
Assignment 1 30%
Transfer data (and link) a number of supporting
worksheets to an active worksheet. Establish
separate input, calculation and report areas for
worksheet. Use some functions, i.e. If, Table Lookup, etc.
Assignment 2 40%
Produce worksheet incorporating macros and iteration
techniques.
Written Test 30%
Mid-semester test consisting of:
Objective, short answer and problem solving
questions relating to spreadsheet features covered.
Assignment 1 30%
Transfer data (and link) a number of supporting
worksheets to an active worksheet. Establish
separate input, calculation and report areas for
worksheet. Use some functions, i.e. If, Table Lookup, etc.
Assignment 2 40%
Produce worksheet incorporating macros and iteration
techniques.
Elements and Performance Criteria
No information
No information
Associated Qual/Courses
| State Code | National Code | Title | Type |
|---|---|---|---|
| 9600 | Applied Science Computing | Accredited course | |
| 6204 | Computer Applications | Accredited course |