Courses of Study 2017-2018 
    
    Nov 15, 2018  
Courses of Study 2017-2018 [ARCHIVED CATALOG]

[Add to Favorites]

AEM 2010 - Spreadsheet Modeling for Management and Economics


     
Fall, winter, spring, summer. 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.



[Add to Favorites]