Course Title: Computer Applications (1999)

Part B: Course Detail

Teaching Period: Term2 2012

Course Code: ISYS5415

Course Title: Computer Applications (1999)

School: 130T Engineering (TAFE)

Campus: City Campus

Program: C6016 - Advanced Diploma of Engineering Technology (Principal Technical Officer)

Course Contact : Program Manager

Course Contact Phone: +61 3 9925 4668

Course Contact

Name and Contact Details of All Other Relevant Staff

Teacher Mark Burns;
Telephone: 9925 4604;
Fax: 9925 4377;

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

Delivered in conjunction with this module:
COSC6083C (ICAU2006B) Operate Computing Packages

Course Description

The purpose of this module is to provide participants with the skills, knowledge and attitudes required to design and implement spreadsheets and data bases to meet business application needs, using appropriate computer software packages.

National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

VBH626 Computer Applications (1999)

Learning Outcomes

On completion of this module the learner should be able to:
NB: AC=Assessment Criteria

Learning Outcome 1Use appropriate computer software packages to produce customised spreadsheets and graphical representations, including slideshow presentations to meet business application needs.
AC 1.1.Set-up macro commands for execution within spreadsheets.
AC 1.2.Design and implement a customised spreadsheet to meet a business application need.
AC 1.3.Use all of the spreadsheet graph commands to convert spreadsheet data into graphic screen and hardcopy displays.
AC 1.4.Combine macro and graphical commands to execute slideshow displays of data in graphical format.
AC 1.5.Install and configure a spreadsheet package onto a microcomputer.

Learning Outcome 2Use appropriate computer software packages to produce customised databases to meet business application needs.
AC 2.1.List and discuss the features and uses of commercially available database packages.
AC 2.2.Install and configure a database package onto a microcomputer.
AC 2.3.Carry out interactive commands on multifile databases.
AC 2.4.Design a database for a business application.
AC 2.5.Develop simple database application programs using appropriate computer software.

Details of Learning Activities

You will be working in a computer laboratory developing/reinforcing your Spreadsheet, Database and Presentation package skills, so that you have all the Office computer skills needed to successfully complete your program and prepare for your professional career.
The total number of scheduled hours of teaching, learning and assessment involved in this course includes all planned activities (face to face workshops, external visits, and structured learning). It also covers the amount of effort necessary to undertake, evaluate and complete all assessment requirements, observation of work performance, discussions, one on one and group assessment sessions with students.

Teaching Schedule

Session 1-16: This unit is partly co-delivered with COSC6083C (Operate Computing Packages) Excel spreadsheet (sessions 1-5) and Access database (sessions 11-15). [AC 1.1,1.2; 2.3-2.5]  Also refer course guide for COSC6082C: Operate Computing Packaqes
Session 16 Remaining assessment criteria are covered and practiced. [AC 1.3-1.5 and 2.1-2.2.]

Learning Resources

Prescribed Texts



Other Resources

Notes and practice files are provided.

Overview of Assessment

Assessment for this module will consist of the following:

Practical demonstration of computer skills per tests, including some written test answers.

Assessment Tasks

Session 5: Excel Test: co-assessed with ICAU2006B Excel assessment AT 4  (Open book) 25%
Session 15: Access Test: co-assessed with ICAU2006B Excel assessment AT 5 (Open book)  30%
Session 17: Test covering remaining items (Open book) 45%

This is a curriculum unit. You need to achieve sufficient marks to achieve a pass. Only the above listed assessments contribute to your final result.

Feedback will be provided throughout the course.

Assessment Matrix

Assessment Task No. (ATN)

ATN 1 –Excel workplace simulated test (open book) (Operate Computing Packages): AC 1.2 (15%); AC 1.3 (10%) = 25%

ATN 2 – Access workplace simulated test (open book) (Operate Computing Packages): AC 2.3 (7%); AC 2.4 (8%) & AC 2.5 (15%) = 30%

ATN 3 – CA1999 test (open book) AC1.1 (20%); AC 1.4 (5%) & AC 2.1 (20%).

Other Information

Please note: while your teacher will cover all the material in the above schedule, the weekly teaching and assessment order is subject to change depending on class needs and availability of resources.

Study and learning Support:

Study and Learning Centre (SLC) provides free learning and academic development advice to you.
Services offered by SLC to support your numeracy and literacy skills are:

assignment writing, thesis writing and study skills advice maths and science developmental support and advice English language development

Please Refer to find more information about Study and learning Support

Disability Liaison Unit:

If you are suffering from long-term medical condition or disability, you should contact Disability Liaison Unit to seek advice and support to complete your studies.

Please Refer to find more information about services offered by Disability Liaison Unit

Late submission:

If you require an Extension of Submittable Work (assignments, reports or project work etc.) for 7 calendar days or less (from the original due date) and have valid reasons, you must complete and lodge an Application for Extension of Submittable Work (7 Calendar Days or less) form and lodge it with the Senior Educator/ Program Manager.
The application must be lodged no later than one working day before the official due date. You will be notified within no more than 2 working days of the date of lodgement as to whether the extension has been granted.

If you seek an Extension of Submittable Work for more than 7 calendar days (from the original due date) must lodge an Application for Special Consideration form under the provisions of the Special Consideration Policy, preferably prior to, but no later than 2 working days after the official due date.

Submittable Work (assignments, reports or project work etc.) submitted late without approval of an extension will not be accepted or marked.

Special consideration:

Special Consideration is a variation to an assessment which takes into account the impact of unexpected or extenuating circumstances which have affected a student’s performance in assessment or prevented them from attempting an assessment task, including an examination.
Please Refer to find the latest information about the purpose, eligibility and process of special consideration and the online form.


Plagiarism is a form of cheating and it is very serious academic offence that may lead to expulsion from the University.

Please Refer: to find more information about plagiarism.

Other Information:

All email communications will be sent to your RMIT email address and you must regularly check your RMIT emails.

Course Overview: Access Course Overview