AEM 2011 Spreadsheet Modeling for Non-Dyson Majors
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.
Students considering transfer to the Dyson School should NOT take this course, as it will not count towards the Dyson major requirements.
Students are expected to enter this course with basic computing skills using Microsoft Office applications and a Windows platform.