Introduction to Operations Research with Excel

Course code MATH 2230

Credit 3.0

Length 60.0 hours

Course outline View

This course introduces students to the fundamental concepts and techniques of Operations Research (OR), with a strong focus on practical applications using Microsoft Excel. Emphasizing linear programming, optimization, and decision modeling, students will learn to formulate real-world problems mathematically, solve them using standard techniques, and interpret results. Through hands-on exercises and case studies, students will apply industry-relevant tools such as Excel Solver to conduct sensitivity analysis, simulation, and resource allocation.

Prerequisites

MATH 1221 or equivalent (taken prior to or concurrently).

Course type

This course is offered as part of a VCC program and cannot be taken individually.
International students: Eligibility is determined at the program level. Visit the program page for international student requirements and application information.

  • Overview of Operations Research in Decision Making Mathematical Optimization and Decision-Modeling Linear Programming and Graphical method Excel for Optimization and Solver Reports The Simplex Method Sensitivity Analysis and Real-World Applications Network Models and Applications Modelling problems using discrete-event simulations Queuing Theory and Practical Applications Case Studies in Operations Research Ethical Considerations and Trends in Operations Research

Course schedules

Select your program to see the available course schedules.

How to take this course

This course is offered as part of a VCC program only.

Contact us

If you have any questions, please email at [email protected].

† This information is intended as a guideline only. Program and course details are subject to change with the approval of VCC's Board of Governors.

Indigenous Territory Acknowledgment

VCC is located on the traditional territories of the xʷməθkʷəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səlilwətaɬ (Tsleil-Waututh) peoples who have been stewards of these lands since time immemorial.