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 IT and Logistics


Sem 1 2006,
Sem 1 2007,
Sem 1 2012,
Sem 1 2013,
Sem 2 2006,
Sem 2 2007,
Sem 2 2008,
Sem 2 2009,
Sem 2 2010,
Sem 2 2011,
Sem 2 2012,

Course Coordinator: Associate Professor Hepu Deng

Course Coordinator Phone: +61 3 9255 5823

Course Coordinator

Pre-requisite Courses and Assumed Knowledge and Capabilities


Course Description

This course introduces you to a range of business problems for which spreadsheet modelling can lead to a solution or a deeper understanding of the underlying issues. A number of interrogation techniques, such as what if analysis, goal seek analysis, sensitivity analysis and optimisation, are taught. Risk analysis techniques through simulation as well as analytical methods are emphasised.

If you are undertaking this course in Melbourne from semester 2, 2012 onward your class will be held in a device-equipped teaching space. Each student group will have access to a laptop. It is however recommended that you have access to a mobile computing device to allow greater flexibility in terms of where you can work on campus both in and outside class times.

Objectives/Learning Outcomes/Capability Development

Capabilities developed in this course are:

  • Ability to analyse design, develop, implement and manage single, multi-user and distributed systems using a range of tools and techniques, across a range of business contexts to meet various stakeholders requirements
  • Ability to critically analyse and synthesise creative and effective solutions to a range of problem/opportunity situations that add value to the business and its stakeholders
  • Ability to apply the most appropriate tool and/or technique for the situation at hand

Upon completion of this course you will have the:

  • Understanding of modelling business problems using spreadsheets
  • Understanding of risk analysis techniques
  • Appreciation of business decision making issues in an uncertain environment
  • Substantial practical experience in using spreadsheet software which is widely used in business

Overview of Learning Activities

A range of learning experiences are planned for you including lectures and workshops. The workshops are designed to develop your analytical skills drawing on knowledge and frameworks offered in the lectures. Your active and constructive participation in group discussions is expected in addition to weekly reading, group and individual exercises and careful planning and completion of assessment tasks.

Overview of Learning Resources

RMIT university will provide you with resources and tools for learning in this course through our online systems and computer laboratories.
You will have access to extensive course materials on myRMIT Studies, including digitised readings, lecture notes and a detailed study program, external internet links and access to RMIT Library online and hardcopy resources.

Overview of Assessment

The assessment may include individual assignments and/or an exam.

Feedback will be provided throughout the semester in class, through individual on practical exercises and by individual consultation.

If you have a long term medical condition and/or disability it may be possible to negotiate to vary aspects of the learning or assessment methods. You can contact the program coordinator or the Disability Liaison Unit if you would like to find out more.

Your course assessment conforms to the RMIT university assessment principles, regulations, policies and procedures which are described and referenced in a single document Assessment Policies and Procedures manual. An 1.2.4 Assessment Charter section of this document summarises your responsibilities as an RMIT student as well as those of your teachers.