Course Search > Search Results > Course DescriptionAnalytical Decision Modeling (OPNS-450-0)
1.00 CreditDescription:
This course counts toward the following majors: Analytical Consulting, Decision Sciences, Operations.
This course focuses on structuring, analyzing and solving managerial decision problems on Excel spreadsheets. We address problems of resource allocation (how to use available resources optimally), risk analysis (how to simulate the effects of uncertainty in problem parameters), decision analysis (how to analyze sequential decisions involving uncertainty), data analysis (how to synthesize the available data into useful information) and forecasting (how to extrapolate past observations into the future). In each area, we pose specific problems from operations, finance and marketing, structure them on Excel spreadsheets, and analyze and solve them using the available Excel commands, tools and add-ins. The course involves a hands-on, in-class learning experience in modeling and analyzing a variety of business decision problems on a common spreadsheet platform. It should, therefore, enhance one's problem-solving capabilities as well as spreadsheet skills. A good working knowledge of Microsoft Excel is required.
Prerequisites:
All Students: OPNS-430-0 AND FINC-430-0
Corequisites:
None
We are currently in the Fall 2009 quarter.
Academic Year: 2009-2010 Quarter: Fall 2009 Sec ID Instructor Day Time Location 61 Walker MR 10:30 - 12:00 Jacobs (G43) 62 Walker MR 13:30 - 15:00 Jacobs (G43)
Academic Year: 2009-2010 Quarter: Winter 2010 Sec ID Instructor Day Time Location 71 Ata M 18:00 - 21:00 Wieboldt (TBD) 81 Ata T 18:30 - 21:30 Jacobs (TBD)
Academic Year: 2009-2010 Quarter: Spring 2010 Sec ID Instructor Day Time Location 61 Deshmukh MR 10:30 - 12:00 Jacobs (TBD)
Academic Year: 2009-2010 Quarter: Summer 2010 This course has not yet been scheduled.
* indicates Sections where First Session is Mandatory.+ indicates Sections with Second Year Preference. Please send questions to kellogg-registrar@kellogg.northwestern.edu .