COURSE DESCRIPTION | ||||
College |
College of Administrative & Financial
Sciences |
Department |
Business
Administration |
|
Course Name |
Spreadsheet Decision
Modeling |
Course Code: |
MGT425 | |
Credit Hours | 3 Credit Hours | Contact Hours | 3 | |
Language | Arabic | English | ||
Track | College Req. | Dep. Req. | Concentration | |
Level | Levels 6, 7, 8 | Prerequisite | ||
Course Description:
This Course provides an introduction to several quantitative methods used to facilitate complex decision-making in business, with applications in many different industries, at different levels in the organization, and with different scopes of decisions. The power of the methods covered in this class is further enhanced by implementing them in spreadsheet software, which allows complex problems to be approached and solved in a straightforward and understandable manner. |
||||
Course Learning Outcomes:
1. Explain simple decision models and management science ideas that provide powerful and (often surprising) qualitative insight about large spectrum of managerial problems (Lo 1.2) 2. Build an understanding of the kind of problems that is tackled using spreadsheet modelling and decision analysis (Lo 1.5) |
3. Demonstrate the tools for deciding when and which decision models to use for specific problems (Lo 2.2)
4. Ability to find some structured way of dealing with complex managerial decision problems (Lo 2.5) 5. Demonstrate the tools for deciding when and which decision models to use for specific problems (Lo 2.5) 6. Apply powerful ways of spreadsheet as a ubiquitous tool in managerial career (Lo 2.5) 7. Ability to find some structured way of dealing with complex managerial decision problems (Lo 2.6) 8. Demonstrate the tools for deciding when and which decision models to use for specific problems (Lo 2.8) 9. Explain simple decision models and management science ideas that provide powerful and (often surprising) qualitative insight about large spectrum of managerial problems (Lo 2.9) 10. Employ decision analysis for organizational effectiveness related to decision making, problem solving and general operational performance effectiveness (Lo 4.1) 11. Build an understanding of the kind of problems that is tackled using spreadsheet modelling and decision analysis (Lo 4.3) 12. Build an understanding of the kind of problems that is tackled using spreadsheet modelling and decision analysis (Lo 4.5) |
Course Major Topics:
1. Introduction 2. Modeling in a Problem-Solving Framework 3. Spreadsheet Engineering 4. Spreadsheet Analysis 5. Data Exploration and Visualization |
6. Classification and Prediction Methods
7. Time Series Forecasting 8. Nonlinear Optimization 9. Linear Optimization 10. Network Models 11. Integer Optimization 12. Non-smooth Models 13. Decision Analysis |
Learning Resources:
· Textbook Powell, S. G., & Baker, K. R. (2014). Management Science: The art of modeling with spreadsheets (4th ed.). Wiley. ISBN: 9781118582695 (print version); ISBN: 9781118801314 (E-copy). |
Grading:
Course works (assignments, quizzes, projects, case studies, board discussion): 25% Midterm exam 25% Final Exam 50% |