SEU Spreadsheet Decision Modeling ( MGT425 )

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%

Leave a Reply

Your email address will not be published. Required fields are marked *