Course Title: Create utility programs

Part A: Course Overview

Program: C5148

Course Title: Create utility programs

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: Chandra Nannegari

Course Contact Phone: 9925 1657

Course Contact Email:

Course Description

This course deals with Programming and the emphasis is:

  • Students will be introduced to the concepts of programming in order to create utility programs in a database environment. The concepts will be covered using VB 2005 / VBA / Transact SQL.
  • Students will be progressively introduced to advance database programming via introductory programming concepts.
  • The procedure will incorporate coding of modules, error handling, module testing with sample data and program documentation.

Pre-requisite Courses and Assumed Knowledge and Capabilities

Model Preferred Solutions ICAITAD046A COSC5731C

National Competency Codes and Titles

National Element Code & Title:

ICAITB166A Create utlity programs


Code each module or program segment

Document the program

Incorporate error handling code

Test each module or program segment

Learning Outcomes

See details under elements of competency.

Overview of Assessment

Assessment may incorporate a variety of methods including technical requirements documentation, homework and in class exercises, written tests, practical problem solving exercises and practical tests. Students are advised that they maybe be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met.

Final examination optional for RMIT grading purposes only.