units

FIT9004

Faculty of Information Technology

Monash University

Postgraduate - Unit

This unit entry is for students who completed this unit in 2012 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

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 2012 (Day)
Sunway First semester 2012 (Evening)
Caulfield Second semester 2012 (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;
  • 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)

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