Courses Exchange Display 2022-2023
|Course Description||To PDF|
|Course title||Decision Support Systems and Business Modelling|
For more information: firstname.lastname@example.org
|Language of instruction||English|
Understanding the role and operation of decision support systems. Independent development of a decision support system.
Master programming in Excel and the design of user interfaces in VBA for Excel.
A decision support system (DSS) is a model-based or knowledge-based system intended to support managerial decision making in semi-structured or unstructured situations. A DSS is not meant to replace a decision maker, but to extend his/her decision making capabilities. It uses data, provides a clear user interface, and can incorporate the decision maker’s own insights. During the course, you get acquainted with decision support systems, their use and their most important components. You learn how to design and develop a decision support system that facilitates decision making - in the context of a company or service provider - through specific selection criteria and constraints. This will require precise communication and efficient and harmonious cooperation between you and your teammate.
Very importantly, you learn how to code in the programming language Excel VBA, in order to build a decision support system. This will help you develop and improve your skills in algorithmic thinking. In particular, you learn how create userforms, and how to use tools provided by the toolbox. You learn essential programming techniques and constructs such as loops, subs, functions and macros. All this knowledge will be very useful basically in any programming environment.
In addition, you learn how to describe and present such a decision support system in the form of a report.
We will provide a reader with all necessary information. Other resources include, but are not limited to:
* Albright, S. C. (2006). VBA for Modelers: Developing Decision Support Systems Using Microsoft Excel (2nd ed.). Duxbury Press.
* Holsapple, C. W. and A. B. Whinston (1996). Decision Support Systems; a knowledge-based approach. West Publishing Company.
* Mallach, E. G. (2000). Decision Support and Data Warehouse Systems. McGraw-Hill.
* Sauter, V. (1997). Decision Support Systems. John Wiley & Sons inc.
* Seref, M. M., R. K. Ahuja, and W. L. Winston (2007). Developing Spreadsheet-Based Decision Support Systems. Belmont, USA: Dynamic Ideas.
* Turban, E. and J. E. Aronson (2007). Decision Support Systems and Intelligent Systems (8th ed.). Prentice Hall Business Publishing.
Basic mastery of Excel, or an alternative spreadsheet application: cell referencing, building formulas, use of logical functions.
This does not include mastery of VBA for Excel: training in VBA programming is part of the course.
An advanced level of English.
|Teaching methods (indicative; course manual is definitive)||Lecture / Groupwork / Coaching|
|Assessment methods (indicative; course manual is definitive)||Final Paper / Assignment / Presentation|
|Evaluation in previous academic year||For the complete evaluation of this course please click "here"|
|This course belongs to the following programmes / specialisations||