Spreadsheet Modeling and Applications

Course Code
TO 513
Hours
1.5 hours
Type
Elective
Offered
  • Fall 21 (B)
  • Fall 22 (B)
  • Winter 21 (B)
  • Winter 22 (B)
Prerequisites
Graduate Standing

Spreadsheet Modeling and Applications --- This course, a continuation of TO 512, emphasizes problem solving using spreadsheet software. Extensive use is made of a spreadsheet solver (such as Solver in Excel) to formulate and solve practical optimization problems from such mathematical programming areas as linear, integer, and nonlinear programming, and multiple-objective decision making. Probabilistic modeling to support risk analysis in the context of spreadsheets is also studied, using native spreadsheet capabilities alone and then supplementing these capabilities with spreadsheet problem analysis, model formulation, implementation, execution and interpretation. Students are assigned computer work to reinforce and extend conceptual and operational aspects of the material.

Taught By
Jean-Paul Baldwin
  • LEO Intermittent Lecturer
Jean-Paul (‘J-P’) Baldwin is currently a Data Scientist and Section Supervisor at Ford Credit Motor Company. Originally from South Africa, Jean-Paul...
David Mendez
  • Associate Professor of Technology and Operations