Course Title: Operate computing packages

Part A: Course Overview

Program: C4131 Certificate IV in Technology (Computing)

Course Title: Operate computing packages

Portfolio: SEH Portfolio Office

Nominal Hours: 60

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: Geoff Moss

Course Contact Phone: +61 3 9925 4852

Course Contact Email:

Course Description

This unit provide the participant with the knowledge and skills required to identify, select and correctly operate desktop applications for a range of purposes observing the OH&S practice: to use a spreadsheet package to create, edit and format a worksheet effectively; to create, manipulate and maintain a database package for common scientific application; to use Crystal Reports to design and generate reports; to design and build a website to specification.
This semester length course consists of 4 separate modules. These are: Spreadsheets (MS-Excel); Scientific Databases (MS-Access); Crystal Reports; and Introduction to HTML Design.
The Spreadsheets module provides students with an understanding of the main concepts of a spreadsheet at an Intermediate level, and the necessary skills to create tables, charts, formulae and Macros. Students will use a range of functions to perform a set of tasks.
The Scientific Databases module provides students with an understanding of the main concepts of a database, and the necessary skills to create and maintain a database, using MS Access as the application software. Students will produce forms and reports and undertake basic queries.
The Crystal Reports module will introduce students to a business application that is able to be used to design and generate reports from a wide range of data sources, specifically in this unit using data from Excel and Access. Students will plan and create reports that will transform data and will help them analyse and interpret information.

Pre-requisite Courses and Assumed Knowledge and Capabilities

There are no pre-requisites for this course, however, it is assumed that students will have a basic knowledge of computer systems and basic keyboard skills.

National Competency Codes and Titles

National Element Code & Title:

ICAITU006C Operate computing packages


Operate Computing Packages

Learning Outcomes

Students will learn how to use, and develop skills in efficiently using, the software packages: MS Excel, MS Access and Crystal Reports to produce documents and reports to an intermediate standard.

Students will be provided with classroom &/or tutorial instruction in each of the three software packages and tasks associated with the topics above including the use of relevant software.
Self-paced materials and tasks will be provided on a network drive. Self-paced materials to be supported by active teacher supervision, guidance and consultation during lessons.
Learning of theoretical concepts of each topic using provided and recommended materials.
Individual exercises for each software application (MS Excel, MS Access and Crystal Reports) will be presented in handouts and/or provided as part of the class materials on the network drive.

Overview of Assessment

Assessment will require demonstration of:
 Consistent performance of each element of the unit across a representative range of applications, autonomously and to requirements
 Performance criteria for each element of competence
 Underpinning knowledge and skills specified.

This is a competency-based course. Each assessment task specifically relates to demonstration of knowledge, skills and/or attitudes relevant to an element of competence. To achieve a Grade of ‘Competent’, the student must be able to demonstrate the knowledge and skills required in each assessment task of the course to the level required by industry.
Students will be assessed on whether they are competent by demonstrating their skills and underpinning knowledge in practical tasks in the labs, as well as demonstrating broader skills and knowledge in analysing and designing assignments and tests. In general, the assessment of the student level of competence is made through continuing evaluation of their level of work and their progression in the development of skills. The style of assessments will provide them with:
 Opportunities to demonstrate application of the necessary knowledge, attitudes and skills not just recall information.
 Information on their progress through the course with emphasis on encouraging them to monitor their own progress and plan their program of study.
 An open system where standards are specified and the required level of competence is known beforehand

Assessment method:

MS Excel
• Assignment 15%
• Practical tasks 10%
• Examination 15%

MS Access
• Assignment 15%
• Practical tasks 10%
• Examination 15%

Crystal Reports
• Assignment 10%
• Practical tasks 10%

Total 100%

Each element of competence will be assessed twice during the course