Course Title: Use advanced features of computer applications

Part A: Course Overview

Program: C5148

Course Title: Use advanced features of computer applications

Portfolio: BUS

Nominal Hours: 40.0

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)


City Campus


650T TAFE Business

Face-to-Face or Internet


VET in Schools


650T TAFE Business

Face-to-Face or Internet

Course Contact: Michelle Edwards

Course Contact Phone: 99255936

Course Contact Email:

Course Description

This course employs three computer applications – Microsoft Word, Microsoft Excel and Microsoft Access in order to solve client problems. Students will be presented with scenarios that will require them to utilise a range of advanced features of the applications including the creation of macros and templates in each application. Also included are the creation of relationships and complex forms and reports in Access, the creation and management of related spreadsheets in Excel and the creation of presentable documents and form letters in Word. Students will also be required to provide training for their creations and use system management tools to enhance PC performance.

Pre-requisite Courses and Assumed Knowledge and Capabilities

Pre-requisites: Operate Computing Packages ICAITU006B COSC5744C OR equivalent intermediate level knowledge of Word, Excel and Access.

Co-requisites : Develop Macros and Templates for clients using standard products ICAITU018B COSC5752C

National Competency Codes and Titles

National Element Code & Title:

ICAITU126A Use advanced features of computer applications


Access and Use Support Resources

Configure the Computing Environment

Manipulate Data

Learning Outcomes

See details under elements of competency.

Overview of Assessment

Assessment will incorporate a variety of methods including software requirements documentation, homework and in class exercises, written tests, practical problem solving exercises and practical tests. Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher during class exercises to ensure that competency standards are being met. Regular feedback on work will be provided to learners during the course.
Final examination optional for RMIT grading purposes only.