Faculty of Information Technology

Skip to content | Change text size

print version

Monash University

Monash University Handbook 2010 Undergraduate - Unit

6 points, SCA Band 2, 0.125 EFTSL

FacultyFaculty of Information Technology
OfferedNot offered in 2010
Coordinator(s)Dr Shyh Wei Teng


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 and understanding of:

  • the fundamentals of spreadsheets which will provide them with an understanding of spreadsheet modelling presentation and analysis using Excel;
  • the fundamentals of OO concepts;
  • the Excel object model;
  • how to create Excel macros;
  • the basics of programming including variables, data types, control structures, subroutines and functions;
  • how to create custom dialog boxes and custom forms using VBA;
  • how to create non-trivial applications using Visual Basic for Applications;
  • the Internet and XHTML.
Developed the skills to:
  • create Excel macros;
  • create executable programs with custom dialog boxes and custom forms using appropriate software tools.
Demonstrated the communication skills necessary to:
  • work co-operatively with a team of IT peers on the development of computer programs.


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

Contact hours

2 hrs lectures/wk, 2 hrs laboratories/wk


Completion of 24 points at level 1


FIT9004, BUS4520, BUS5520, GCO9801, BUS9001, BUS9002, BUS9003, BUS9004, CSE9000, GCO4801, GCO8019, BUS9520, GCO2851
This unit is not available to any student enrolled in an FIT degree

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