COURSE DESCRIPTION AND APPLICATION INFORMATION

Course Name Code Semester T+A+L (hour/week) Type (C / O) Local Credit ECTS
Decision Support Systems MIS 311 Fall 03+00+00 Elective 3 6
Academic Unit: Management Information Systems
Mode of Delivery: Face to face
Prerequisites: MIS103
Language of Instruction: English
Level of Course Unit: Undergraduate
Course Coordinator: - -
Course Objectives: To provide conceptual foundations of managerial decision making and major frameworks of computerized decision support.
Course Contents: Managerial decision making, computerized support for decision making, the concept of decision support systems, decision making models, phases of the decision making process, components of decision support systems, the data management subsystem, the model management subsystem, the user interface (dialog) subsystem, management support systems modeling with spreadsheets, multiple goals, solver, what-if analysis, goal seeking, decision analysis with decision tables and decision trees, pivot tables.
Learning Outcomes of the Course Unit (LO):
  • 1- Ability to understand DSS components and how they integrate
  • 2- Ability to analyze business cases and solve business problems
  • 3- Ability to apply analytical skills through the use of the software decision support tools
  • 4- Ability to use and design spreadsheets for DSS modeling and solution
Planned Learning Activities and Teaching Methods: In class lectures, problem solving cases, homework, quizzes, midterm and final exams.


WEEKLY SUBJECTS AND RELATED PREPARATIONS

WeekSubjectsRelated Preperation
1 Decision Support Systems Chapter1
2 Decision Making, Systems, Modeling, and Support Chapter2
3 Decision Support Systems Concepts, Methodologies and Technologies: An Overview Chapter3
4 Modeling and Analysis Chapter4
5 Applying Fundamental Spreadsheet Skills and Tools in Problem Solving Cases #1
6 Solving Problems with Statistical Analysis Tools Cases #2
7 Determining Effective Data Display with Charts Cases #3
8 Applying logic in decision making Cases #4
9 Retrieving Data for Computation, Analysis and Reference Cases #5
10 Evaluating Financial Impact of Loans and Investments Cases #6
11 Organizing Data for Effective Analysis Cases #7
12 Using Data Tables and Scenarios for What-If Analysis Cases #8
13 Enhancing Decision Making with Solver Cases #9
14 Troubleshooting Workbooks and Creating Spreadsheet Applications Cases #10


REQUIRED AND RECOMMENDED READING

Efraim Turban, Ramesh Sharda, Dursun Delen (2011) Decision Support and Business Intelligence Systems, Ninth Edition, Pearson.


OTHER COURSE RESOURCES

D.Gross, F.Akaiwa, K.Nordquist, Succeeding in Business with MS-Excel 2010 A Problem Solving Approach, International Edition (2011), Course Technology Cengage Learning.

E. Monk, J. Brady, G.S. Cook, (2012) Problem Solving Cases in Microsoft Access and Excel, International Edition, 9e, Course Technology Cengage Learning.

Lisa Millar (2009) MIS Cases, Decision Making with Application Software, Fourth Edition, Pearson


ASSESSMENT METHODS AND CRITERIA

Semester RequirementsNumberPercentage of Grade (%)
Midterms / Oral Exams / Quizes 4 60
Final Exam 1 40
Total: 5 100


WORKLOAD

EventsCountDuration (Hours)Total Workload (hour)
Course Hours14342
Practice / Exercise14114
Extra-Class Activities (reading,individiual work, etc.)14342
Midterms / Oral Exams / Quizes4936
Final Exam11616
Total Workload (hour):150


THE RELATIONSHIP BETWEEN COURSE LEARNING OUTCOMES (LO) AND PROGRAM QUALIFICATIONS (PQ)

# PQ1 PQ2 PQ3 PQ4 PQ5 PQ6 PQ7 PQ8 PQ9 PQ10 PQ11 PQ12
LO1                        
LO2                        
LO3                        
LO4