MGS 3100 - Business Analysis
| Session | Date |
Topic |
Assignment Due | Reading Assignment |
|
I) Generalized Modeling / Basic Profit Models |
||||
| 1) | 1/14/16 (Th) |
|
Groups Formed |
Microsoft Excel 2010 Step by Step (Chapter 1-3) Chapter 1 Introduction |
| 2) | 1/21/16 (Th) |
|
Homework 1 |
Excel 2010 Formulas and Functions
for Dummies, 2nd Edition (Chapter 1-2, 7-8)
Chapter 1 Data & Statistics |
| 3) | 1/28/16 (Th) |
|
Microsoft Excel 2010 Step by Step
(Chapter 10) Appendix
A Building Spreadsheet Models
|
|
| 4) | 2/4/16 (Th) |
|
Homework 2 |
|
|
II) Forecasting |
||||
| 5) | 2/11/16 (Th) |
|
|
Chapter 17 Time Series Analysis and Forecasting |
| 6) | 2/18/16 (Th) |
Trend Analysis |
|
Statistical Analysis with Excel
for Dummies, 2nd Edition (Chapter 14) Chapter 17 Time Series Analysis and Forecasting |
| 7) | 2/25/16 (Th) |
|
Homework 3 |
Statistical Analysis with Excel
for Dummies, 2nd Edition (Chapter 14) Appendix E Microsoft Excel 2013 and Tools for Statistical Analysis |
| 3/1/16 (T) |
Last Day to Withdraw and possibly receive a "WP" for full semester classes. |
|||
| 8) | 3/3/16 (Th) |
|
Homework 4 |
Chapter 17 Time Series Analysis and Forecasting |
| 9) | 3/10/16 (Th) |
|
|
|
|
III) Decision Analysis |
||||
| 3/17/16 (Th) | Spring break (No Class) | |||
| 10) | 3/24/16 (Th) |
|
Group Project 2 |
Chapter 13 Decision Analysis |
| 11) | 3/31/16 (Th) |
|
Chapter 13 Decision Analysis
|
|
| 12) | 4/7/16 (Th) |
Sequential decisions Conditional Probability Expected value of sample information Efficiency |
Homework 5
|
Statistical Analysis with Excel
for Dummies, 2nd Edition (Chapter 16)
Chapter 4 Introduction to Probability |
| 13) | 4/14/16 (Th) |
|
||
|
IV) Simulation |
||||
| 14) | 4/21/16 (Th) |
|
|
Chapter 12 Simulation |
| 4/28/16 (Th) |
|
|||