- Schedule of Classes - January 31, 2019 7:14PM EST
- Course Catalog - January 31, 2019 7:15PM EST
Course information provided by the Courses of Study 2018-2019.
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.
When Offered Fall, Winter, Spring, Summer.Outcomes
- Understand business applications of spreadsheet modeling analysis and decision making.
- Efficiently organize and retrieve data and datasets.
- Apply logic when making business decisions.
- Solve real world business problems using statistical analysis tools.
- Apply Excel tools and skills for problem solving and decision making using business scenarios.
- Leverage data tables to run scenarios and conduct what-if analysis.
- Design and utilize effective and efficient data display with charts and tables.
- Apply financial impact analysis using loan and investment scenarios.
- Expand into more complex decision making using multivariable scenarios.
Regular Academic Session.
Credits and Grading Basis
3 Credits GradeNoAud(Letter grades only (no audit))
Class Number & Section Details
- TRStatler Hall 365
Enrollment not open to Dyson students.
Disabled for this roster.