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.