OM 471 - Decision Support Systems

★ 3 (fi 6)(EITHER, 3-0-0)

Faculty of Business

The course focuses on the creation of decision support systems using Microsoft Excel-based spreadsheet models and the associated macro programming language, Visual Basic for Applications (VBA). Students will learn how to create Excel-based applications to aid managers in making decisions based on data and analytics. These applications will have graphical user interfaces, appropriate models in the spreadsheet or in the background, and output reports. Fundamentals of VBA, such as the Excel object model, variables, control logic and loops, subroutines and function subroutines, and user forms will be introduced. Prior programming experience is not assumed. Student projects in this implementation-oriented course will come from different areas such as forecasting, regression, supply chain network design, employee scheduling, and portfolio optimization. Prerequisites: MGTSC 312, MGTSC 352 or OM 352.

Fall Term 2021

Lectures

LECTURE A1 (51290)
Capacity: 20
2021-09-01 - 2021-12-07
MW 09:30 - 10:50 (BUS B-24)

2021-09-01 - 2021-12-07
MW 09:30 - 10:50 (BUS B-28)

Primary Instructor: Maryam Zakeri Hosseinabadi

Winter Term 2022

Lectures

LECTURE B1 (67672)
Capacity: 30
2022-01-05 - 2022-04-08
MW 11:30 - 12:50 (BUS B-24)

2022-01-05 - 2022-04-08
MW 11:30 - 12:50 (BUS B-28)

Primary Instructor: M. Hosein Zare

Spring Term 2022

Lectures

LECTURE X01 (10093)
Capacity: 15
2022-05-09 - 2022-06-15
TH 18:00 - 20:50 (TBD)

Fall Term 2022

Lectures

LECTURE A1 (34891)
Capacity: 20
2022-09-01 - 2022-12-08
MW 09:30 - 10:50 (TBD)

2022-09-01 - 2022-12-08
MW 09:30 - 10:50 (TBD)

Winter Term 2023

Lectures

LECTURE B1 (42574)
Capacity: 30
2023-01-05 - 2023-04-12
MW 11:30 - 12:50 (TBD)

2023-01-05 - 2023-04-12
MW 11:30 - 12:50 (TBD)