Course Title: Business Solutions Using Spreadsheet Models

Part A: Course Overview

Course Title: Business Solutions Using Spreadsheet Models

Credit Points: 12

Course Code




Learning Mode

Teaching Period(s)


City Campus


620H Business Info Technology


Course Coordinator: Associate Professor Hepu Deng

Course Coordinator Phone: +61 3 9925 5823

Course Coordinator

Course Coordinator Location: 108.17.89

Course Coordinator Availability: Monday, Tuesday and WEdnesday

Pre-requisite Courses and Assumed Knowledge and Capabilities

There is no pre-requisite courses for ISYS2067 Business Solutions Using Spreadhseet Models. Students are assumed to have a basic understanding of  business  knowledge. This is however not critical as students can easily pick up those knowledge from the lectures as well as from outside readings.

Course Description

This course introduces students to a range of business problems for which spreadsheet modelling can be applied for developing solutions or leading to a better understanding of the underlying issues. Risk analysis techniques are emphasised. It is expected that at the conclusion of the course that students are able to use the Spreadsheet modelling techniques more effectively for problem solving in business.

Objectives/Learning Outcomes/Capability Development

On the successful completion of this course students would have

* A better understanding of the use of Spreadsheet software for addressing real business problems.

* Enhanced analytic skills and problem solving skills.

* Improved communication skills

* demonstarted abilityies to use the common modelling techniques for problem solving

Upon completion of this course, students will have:

*  An understanding of modelling business problems using spreadsheets. 
*  An understanding of risk analysis techniques in business.
* An appreciation of business decision making issues in an uncertain environment .
* Substantial practical experience in using spreadsheet software which is widely used in business

A key objective of this course is to develop students’ analytical and problem solving skills, so they can critically evaluate business problems and creatively model them.

Overview of Learning Activities

The course consists of a series of one hour lectures and two hour workshops. It is divided into four sections: model building using the investment problem as the vehicle, the forecasting problem, the linear programming problem and finally application of model building to a further three problems decision analysis, break even analysis and inventory analysis.

Overview of Learning Resources

A Course book will be provided to all students at the beginning of the semester which has all the lecture notes and the assignment specifications for teh semester.

All lecture materials, workshop notes, and assignment details are available at the G: drive as well as at the DLS site, and regular updates of those study materials are being carried thorughtout the semester.

A weekly email to all students in the course will be sent out with all the study materials attached for next week during the semester.

Both the Course Coordinator and the tutors will be available for consultation during the semester. 

Overview of Assessment

There are 3 assignments and an end of semester examination. The assignments are described in the Course Manual booklet.

Students must submit assignments by the due date unless there is a medical reason why this is not possible, in which case a medical certificate will be provided. Work submitted late may be rejected or marked with a penalty at the discretion of the lecturer. Students can expect the assignments to be returned within two weeks of submission with written feedback.

Should the lecturer deem that variation to the assessment tasks is needed, this will be discussed with the class and only proceed with documented consent of 75% of the class.