AEM 2011 - Spreadsheet Modeling for Non-Dyson Majors

Fall, Winter, Spring, Summer. 3 credits. Letter grades only (no audit).

D. Haeger, R. Moghimi.

This course will be developed as a data-driven, model-based approach to decision-making. Most applications will rely on the standard array of Excel functionality but other platforms (e.g., Access, SQL, presentation software) may be employed. A unique feature of this course will be applications drawn from the diverse program areas of the Dyson School: management, international development/trade; environment/resource economics; and food/agricultural economics. Case material will be contributed by the companies from the DUAC. Key topics will include: Optimization (Solver), Data graphing, Financial modeling, Ethical/social dimensions of IT, Forecasting, Pivot tables, Exponential smoothing, and Simulation.

Outcome 1: Understand business applications of spreadsheet modeling analysis and decision making.

Outcome 2: Efficiently organize and retrieve data and datasets.

Outcome 3: Apply logic when making business decisions.

Outcome 4: Solve real world business problems using statistical analysis tools.

Outcome 5: Apply Excel tools and skills for problem solving and decision making using business scenarios.

Outcome 6: Leverage data tables to run scenarios and conduct what-if analysis.

Outcome 7: Design and utilize effective and efficient data display with charts and tables.

Outcome 8: Apply financial impact analysis using loan and investment scenarios.

Outcome 9: Expand into more complex decision making using multivariable scenarios.