Monash University Handbook 2010 Postgraduate - Unit

Level	Postgraduate
Faculty	Faculty of Information Technology
Offered	Caulfield First semester 2010 (Day) Caulfield Second semester 2010 (Evening)
Coordinator(s)	Ms Oshadi Alahakoon

Synopsis

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.

Objectives

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;
• 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;
• 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 how to create Excel macros;
• learnt to create executable programs with custom dialog boxes and custom forms using appropriate software tools.

Assessment

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

Chief examiner(s)

Mrs Sue Bedingfield

Contact hours

2 hrs lectures/wk, 2 hrs laboratories/wk

Prohibitions

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

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

http://www.infotech.monash.edu.au/units/fit9004