Course Title: Use advanced features of computer applications

Part B: Course Detail

Teaching Period: Term1 2012

Course Code: COSC5441C

Course Title: Use advanced features of computer applications

School: 155T Vocational Health and Sciences

Campus: City Campus

Program: C4293 - Certificate IV in Information Technology (Networking)

Course Contact: Geoff Moss

Course Contact Phone: +61 3 9925 4852

Course Contact Email:

Name and Contact Details of All Other Relevant Staff

Teacher: Geoff Moss
Phone: 9925 4852
Office: 51.07.01

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.

Pre-requisites and Co-requisites

Not Applicable

Course Description

This unit defines the competency required to fully utilise computer applications employing advanced features.

National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICAU3126B Use advanced features of computer applications


1. Manipulate data

1.1 Employ advanced features of applications in the preparation and presentation of data
1.2 Efficiently transfer data between applications, linking and embedding related data files as required
1.3 Create and employ objects, macros and templates for routine activities
1.4 Use shortcuts and features to increase personal productivity

Performance Criteria:



2. Access and use support resources

2.1 Solve routine problems using support resources
2.2 Use on-line help to overcome difficulties with applications
2.3 Solve problems with manuals and training booklets
2.4 Access and apply technical support for system problems, utilising troubleshooting results and alert messages

Performance Criteria:


Learning Outcomes

Details of Learning Activities

Activities in this course are aimed at achieving the competency required to use computer applications employing advanced features.  This learning unit consists of two competencies covering the knowledge and skills to assist students in setting standards for organisation documents, and manage document design and production. These outcomes will be obtained largely through learning by doing a range of tasks.

The Internet and YouTube videos will be used as a learning tool and a resource for students to seek and locate relevant information.
Learning activities may be modified during the semester to meet the needs of students in the current program and the needs of their workplace.

Teaching Schedule

WeeksTopicSoftware / ReadingPractical ExercisesAssessment
1Introduction to Topic, Overview of course and relevance to traineeship and workplace. Identification of relevant tasks and softwareSee reading list and online resources
Tasks as per assignment
and Activity Workbook
Practical tasks; Assignment
2Embedding images, videosPowerPointsTasks as per assignment
Practical tasks; Assignment
3Review task and assignment progressSee reading list and online resources
Tasks as per assignmentPractical tasks; class discussion and observation

Learning Resources

Prescribed Texts


Other Resources

Overview of Assessment

Assessment occurs throughout the program and includes learning and assessment activities conducted in the classroom, online and in the workplace giving you the opportunity to practice and be assessed on what you are learning in a work context. You must demonstrate an understanding of all elements of a particular competency to be deemed competent. Assessment methods have been designed to measure achievement of each competency in a flexible manner over a range of assessment tasks.

Assessment will incorporate a variety of methods including technical requirements, documentation, workplace activities, in class exercises, quizzes, practical problem solving exercises and presentations. Participants are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met.

If you have a long term medical condition and/or disability it may be possible to negotiate to vary aspects of the learning or assessment methods. You can contact the program coordinator or the Disability Liaison Unit if you would like to find out more.

Assessment Tasks

Class and Work-Based Assessment Activities

Use of Software applications

Assessment Matrix

ElementAssignmentPractical TasksIn Class/Work ObservationIn Class TestingIndividual and Group discussion**
1.1x x  
1.2x x  

** small group discussion and problem solving on variety of issues at appropriate times during delivery of the course

Other Information

Access to an internet connected computer outside of class times – Internet connected computers are available in the School of Life & Physical Sciences labs on levels 4, 6 or 8 of building 51, 81 Victoria Street, Melbourne.
Further lab access can be found in the student lab on level 3 (ground floor) of Building 8, in Swanston Street, Melbourne; as well as RMIT Libraries.

Course Overview: Access Course Overview