AEM 2010 - Spreadsheet Modeling for Management and Economics

Fall, spring, summer, winter. 3 credits. Letter grades only.

Enrollment required of and limited to Dyson/AEM majors in the Fall and Spring. Course is open to all non-Dyson majors during summer and winter session.

D. Haeger.

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: Provide students with the skills needed to employ spreadsheet modeling techniques for economic and management analysis.