Course Title: Develop macros and templates for clients using standard products

Part A: Course Overview

Program: C5148

Course Title: Develop macros and templates for clients using standard products

Portfolio: BUS

Nominal Hours: 60.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

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 include the creation of macros and templates in each application. Students will also be required to provide training for their creations.

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: Use Advanced Features of Computer Applications ICAITU126A COSC5810C

National Competency Codes and Titles

National Element Code & Title:

ICAITU018C Develop Macros and Templates for Clients Using Standard Products


Determine Macro or Template Requirement

Develop Macro or Template for Client

Provide Client Support for the Macro or Template

Learning Outcomes

See details under elements of competency.

Overview of Assessment

Assessment will incorporate a variety of methods including macro and templates 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.