May 31, 2024  
University of Alberta Calendar 2018-2019 
    
Catalog Navigation
  Calendar Home
  Notes re: Archived Calendars
  Message from the President
  Inquiries
  Academic Schedule
  Undergraduate Application Deadlines for Admission and Readmission
  Undergraduate Admission
  University Regulations and Information for Students
  Graduate Policy and Regulations
  The Faculties
  Undergraduate Programs
  Graduate Programs
  Glossary
  Course Listings
  General Information
  University Staff
  Errata
  Previous Calendars
HELP
University of Alberta Calendar 2018-2019 [ARCHIVED CATALOG]

OM 671 - Decision Support Systems

★ 3 (fi 6) (either term, 3-0-0) 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. Prerequisite: MGTSC 501.