Monash University Handbook 2010 Undergraduate - Unit

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 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.

• create Excel macros;
• create executable programs with custom dialog boxes and custom forms using appropriate software tools.

• work co-operatively with a team of IT peers on the development of computer programs.

Assessment

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

Contact hours

2 hrs lectures/wk, 2 hrs laboratories/wk

Prerequisites

Completion of 24 points at level 1

Prohibitions

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:

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