Spreadsheet Modeling and Applications

Course Code
TO 513
Hours
1.5 hours
Type
Elective
Offered
  • Fall 18 (B)
  • Fall 19 (B)
  • Winter 18 (B)
  • Winter 19 (B)

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
Tariq Mughal
  • LEO Lecturer I in Technology & Operations
Professor Mughal’s background is in engineering and applied mathematics. Prior to joining academia, he worked in aerospace industry. He joined...
David Mendez
  • Associate Professor of Technology and Operations