Management and Information Technology


MGTE 32072

Computer based tools for Management Applications

Status : Core Pre-requisite : None Co-requisite : None


On completion of this course, the student should be able to:

  • Introduce spreadsheet modelling using Visual Basic for Application (VBA) to model and solve Operations Research, Operations Management, Statistics, Supply chain Management, Economics, Human resource Management, and Finance real world complex problems.
  • Improve student competence in utilizing Excel as a decision-making support tool, emphasizing the use of Excel to document and demonstrate models.

Introduction to Spreadsheet Modelling using VBA.
Introduction to Optimization Modelling using VBA.
Spreadsheet Engineering and Managerial decision modelling.
Decision Making under Uncertainty.
VBA applications for simulation: Goal Seek, Data Tables/Scenario Manager, Solver, PrecisionTree, Risk and Uncertainty via @Risk, Optimization + Uncertainty Risk via Optimizer.
Lectures, in-class discussion of cases, self-study and mini-projects.
End-of-course exam, in-class assignments, mini-project, Quizzes.

  1. Winston, W and Christian,A S (2009), Practical Management Science, Revised, 3rd Edition.
  2. Winston, WL (2007), Microsoft® Office Excel® 2007: Data Analysis and Business Modelling, Microsoft Press.
  3. Christian A S (2007), VBA for Modelers: Developing Decision Support Systems with Microsoft® Excel, Thomson, Brooks/Cole.
  4. Stephen, G P and Kenneth, R B (2010), Management Science The Art of Modeling with Spreadsheets3rd Edition.