Course Title: Computer Applications (1999)

Part A: Course Overview

Program: C6016 Advanced Diploma of Engineering Technology (Principal Technical Officer)

Course Title: Computer Applications (1999)

Portfolio: SEH Portfolio Office

Nominal Hours: 40

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	Campus	Career	School	Learning Mode	Teaching Period(s)
ISYS5415	City Campus	TAFE	130T Vocational Engineering	Distance / Correspondence or Face-to-Face	Term2 2011, Term1 2012, Term2 2012

Course Contact: Program Manager

Course Contact Phone: +61 3 9925 4668

Course Contact Email: engineering-tafe@rmit.edu.au

Course Description

The purpose of this module is to provide participants with the skills, knowledge and attitudes required to design and implement spreadsheets and data bases to meet business application needs, using appropriate computer software packages.

Pre-requisite Courses and Assumed Knowledge and Capabilities

Delivered in conjunction with this module:
COSC6083C (ICAU2006B) Operate Computing Packages

National Competency Codes and Titles

National Element Code & Title:

VBH626 Computer Applications (1999)

Learning Outcomes

On completion of this module the learner should be able to:
NB: AC=Assessment Criteria

Learning Outcome 1 Use appropriate computer software packages to produce customised spreadsheets and graphical representations, including slideshow presentations to meet business application needs.
AC 1.1. Set-up macro commands for execution within spreadsheets.
AC 1.2. Design and implement a customised spreadsheet to meet a business application need.
AC 1.3. Use all of the spreadsheet graph commands to convert spreadsheet data into graphic screen and hardcopy displays.
AC 1.4. Combine macro and graphical commands to execute slideshow displays of data in graphical format.
AC 1.5. Install and configure a spreadsheet package onto a microcomputer.

Learning Outcome 2 Use appropriate computer software packages to produce customised databases to meet business application needs.
AC 2.1. List and discuss the features and uses of commercially available database packages.
AC 2.2. Install and configure a database package onto a microcomputer.
AC 2.3. Carry out interactive commands on multifile databases.
AC 2.4. Design a database for a business application.
AC 2.5. Develop simple database application programs using appropriate computer software.

Overview of Assessment

Assessment for this module will consist of the following:

Practical demonstration of computer skills per tests, including some written test answers.