Monash University

Leader(s): Ms Oshadi Alahakoon (Clayton)

Offered

Caulfield Second semester 2009 (Day)
Gippsland First semester 2009 (Day)
Gippsland First semester 2009 (Off-campus)

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 :

1. Have a knowledge of the fundamentals of spreadsheets which will provide them with an understanding of spreadsheet modelling presentation and analysis using Excel. Have learnt the fundamentals of OO concepts;
2. Have gained an understanding of the Excel object model;
3. Have learnt how to create Excel macros. Have learnt the basics of programming including variables, data types, control structures, subroutines and functions;
4. Have learnt to create custom dialog boxes and custom forms using VBA;
5. Have the ability to create non-trivial applications using Visual Basic for Applications;
6. Have an understanding of the Internet and XHTML.

At the completion of this unit, students will:

1. Have a knowledge of the fundamentals of spreadsheets which will provide them with an understanding of spreadsheet modelling presentation and analysis using Excel;
2. Have learnt the fundamentals of OO concepts;
3. Have learnt the basics of programming including variables, data types, control structures, subroutines and functions;
4. Have learnt to create custom dialog boxes and custom forms using VBA;
5. Have the ability to create non-trivial applications using Visual Basic for Applications;
6. Have an understanding of the Internet and XHTML.

At the completion of this unit, students will:

1. Have learnt how to create Excel macros;
2. Have learnt to create executable programs with custom dialog boxes and custom forms using appropriate software tools.

At the completion of this unit, students will have had the opportunity to work co-operatively with a team of IT peers on the development of computer programs.

Assessment

Practical assignments: 40%
Examination (2.5 hours): 60%

Contact hours

One x 2 hr lecture/week, One x 2 hr tutorial/week

Prohibitions

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

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

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