|
| |
Module 0 |
Course Introduction |
|
| |
|
|
| |
Lecture 1: Course Introduction |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
30 Minutes |
PPT |
Syllabus May 13, 2010
Course Topics May 13, 2010 |
Panko Article |
Interfaces Article |
|
| |
|
|
| |
Top of Page |
|
|
| |
Module 1 |
Introduction to Spreadsheet Modeling |
|
| |
|
|
| |
Lecture 1: A Basic Spreadsheet Model |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
30 Minutes |
PPT |
Excel File Base |
Excel File Finished |
|
|
| |
|
|
| |
Lecture 2: Breakeven analysis and one-way data tables |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
20 Minutes |
PPT |
Excel File Base |
Excel File Finished |
|
|
| |
|
|
| |
Lecture 3: Uncertainty and Two-Way Data Tables |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
30 Minutes |
PPT |
Excel File Base |
Excel File Base |
|
|
| |
|
|
| |
Top of Page |
|
|
| |
Module 2 |
Decision Making Under Uncertainty 1 |
|
| |
|
|
| |
Lecture 1: Decision Analysis |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
25 Minutes |
PPT |
Excel File Base |
Excel File Finished |
|
|
| |
|
|
| |
Lecture 2: Decision Analysis Examples |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
20 Minutes |
PPT |
Excel File Base |
Excel File Finished |
|
|
| |
|
|
| |
Lecture 3: Precision Tree Add-in |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
35 Minutes |
PPT |
Excel File Base |
Excel File Finished |
|
|
|
Click here to see folder to download Precision Tree
|
|
|
|
|
| |
|
|
| |
Top of Page |
|
|
| |
Module 3 |
Decision Making Under Uncertainty 2 |
|
| |
|
|
| |
Lecture 1: Bayes' Rule |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
35 Minutes |
PPT |
|
|
|
|
| |
|
|
| |
Lecture 2: Multi-stage Decision Making |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
35 Minites |
PPT |
Excel File Base |
Excel File Finished |
|
|
| |
|
|
| |
Top of Page |
|
|
| |
Module 4 |
Introduction to Queues |
|
| |
|
|
| |
Lecture 1: Queueing Terminology |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
25 Minutes |
PPT |
No Excel Files |
|
|
|
| |
|
|
| |
Lecture 2: M/M/1 and M/M/s queues |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
35 Minutes |
PPT |
Excel File Base |
Excel File Finished |
|
|
| |
|
|
| |
Top of Page |
|
|
| |
Module 5 |
Intro to Optimization Modeling |
|
| |
|
|
| |
Lecture 0: Installing Solver for Excel 2007 |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
5 Minutes |
PPT |
|
|
|
|
| |
|
|
| |
Lecture 1: Intro, Setting up a 2 Variable Model |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
35 Minutes |
PPT |
Gurgar Morley Lockheed Interfaces article |
|
|
|
| |
|
|
| |
Lecture 2: Solving a 2 Variable Model |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
30 Minutes |
PPT |
Excel File Base |
Excel File Finished |
|
|
| |
|
|
| |
Lecture 3: Sensitivity |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
25 Minutes |
PPT |
Excel File Base |
Excel File Finished |
|
|
| |
|
|
| |
Lecture 4: Properties of Linear Models |
Streaming |
Podcast |
Enhanced Podcast |
Vodcast |
|
| |
25 Minutes |
PPT |
Excel File Base |
Excel File Finished |
|
|
| |
|
|
| |
Top of Page |
|
|