Decision Support with Spreadsheets

Course Code
TO 512
Hours
1.5 hours
Type
Elective
Offered
  • Fall 18 (A)
  • Fall 19 (A)
  • Winter 18 (A)
  • Winter 19 (A)
Prerequisites
No credit in TO 311 or 411 or 511

Decision Support with Spreadsheets --- Spreadsheets have advanced to the point of providing powerful, general-purpose functionality and are among the most widely used decision-support tools in business today. This course deals with decision support using spreadsheets, including: what if analysis; financial, statistical and time/date functions; graphical presentation of data; organizing, sorting, querying and extracting information from spreadsheet and external databases and the World Wide Web; cross-tabulation of data; data tables; creation and management of scenarios; use of a solver to find optimal solutions to problems; the design to macros to support spreadsheet applications; and data maps. An expert level of spreadsheet use is achieved. Lecture-demonstrations illustrate relevant features of spreadsheet software. Students do assigned cases on a computer to reinforce and extend conceptual and operational aspects of the material. Windows-based spreadsheet software (such as Excel) is used.

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...