Course Title: Business Solutions Using Spreadsheet Models
Part A: Course Overview
Course Title: Business Solutions Using Spreadsheet Models
Credit Points: 12.00
Terms
Course Code |
Campus |
Career |
School |
Learning Mode |
Teaching Period(s) |
ISYS2043 |
City Campus |
Postgraduate |
620H Business IT and Logistics |
Face-to-Face |
Sem 1 2006, Sem 2 2006, Sem 1 2007, Sem 2 2007, Sem 2 2008, Spring2008, Sem 2 2009, Sem 2 2010, Sem 2 2011, Sem 1 2012, Sem 2 2012, Sem 1 2013 |
Course Coordinator: Associate Professor Hepu Deng
Course Coordinator Phone: +61 3 9255 5823
Course Coordinator Email: hepu.deng@rmit.edu.au
Pre-requisite Courses and Assumed Knowledge and Capabilities
None
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.