units

FIT9004

Faculty of Information Technology

12 April 2013 20 May 2013

Postgraduate - Unit

print version

6 points, SCA Band 2, 0.125 EFTSL

Refer to the specific census and withdrawal dates for the semester(s) in which this unit is offered, or view unit timetables.

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

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.

Outcomes

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.

Assessment

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

Chief examiner(s)

Dr Caddie Gao

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