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

Campus

Career

School

Learning Mode

Teaching Period(s)

COSC5810C

City Campus

TAFE

650T TAFE Business

Face-to-Face or Internet

COSC5811C

VET in Schools

TAFE

650T TAFE Business

Face-to-Face or Internet


Course Contact: Michelle Edwards

Course Contact Phone: 99255936

Course Contact Email: michelle.edwards@rmit.edu.au


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

Elements:

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.