Faculty of Information Technology

Monash University

Postgraduate - Unit

This unit entry is for students who completed this unit in 2013 only. For students planning to study the unit, please refer to the unit indexes in the the current edition of the Handbook. If you have any queries contact the managing faculty for your course or area of study.

print version

6 points, SCA Band 2, 0.125 EFTSL

To find units available for enrolment in the current year, you must make sure you use the indexes and browse unit tool in the current edition of the Handbook.

FacultyFaculty of Information Technology
OfferedCaulfield First semester 2013 (Day)
Sunway First semester 2013 (Evening)
Caulfield Second semester 2013 (Evening)


This unit provides an introduction to the principles and practice of programming for business applications. This includes an overview of spreadsheet modelling and a detailed introduction to programming with Excel including general programming concepts, the syntax and semantics of a current business programming language, design and development of graphical user interfaces.


At the completion of this unit students will have:

  • a knowledge of the fundamentals of spreadsheets which will provide them with an understanding of spreadsheet modelling presentation and analysis using Excel;
  • learnt the fundamentals of OO concepts;
  • gained an understanding of the Excel object model;
  • learnt how to create Excel macros;
  • learnt the basics of programming including variables, data types, control structures, subroutines and functions;
  • learnt to create custom dialog boxes and custom forms using VBA;
  • the ability to create non-trivial applications using Visual Basic for Applications;
  • learnt to create executable programs with custom dialog boxes and custom forms using appropriate software tools.


Examination (2.5 hours): 60%; In-semester assessment: 40%

Chief examiner(s)

Contact hours

2 hrs lectures/wk, 2 hrs laboratories/wk


BUS4520, BUS5520, BUS9001, BUS9003, BUS9004, GCO4801, BUS9520, GCO1810, FIT2066, BUS1010, FIT1013

Additional information on this unit is available from the faculty at: