2020 Courses

  • Winter Session 2020 course rosters will be available in late September.
  • Summer Session 2020 course rosters will be available in November.

Course description

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.

Prerequisites

Students are expected to enter this course with basic computing skills using Microsoft Office applications and a Windows platform.

Classes

Winter 2019: Online course

Section ID:AEM 2011 001-LEC
Number:1060
Class dates:January 2-19, 2019
Days/times:Online course
Location:Online course
Credit:3
Grade:Graded (no audit)
Instructor:Haeger, D. (dlh266)
Max. enroll:20
Notes:Students considering transfer to the Dyson School should NOT take this course, as it will not count towards the Dyson major requirements.
  This is an online course. Please review the online course FAQs.

Summer 2019: Online course

Section ID:AEM 2011 001-LEC
Number:1379
Class dates:May 29-June 21, 2019
Days/times:Online course
Location:Online course
Credit:3
Grade:Graded (no audit)
Instructor:Haeger, D. (dlh266)
Max. enroll:20
Restrictions:Enrollment limited to non-Dyson majors.
Notes:If you are a student planning on transferring into the Dyson School, this course does NOT count toward degree requirments.
  This is an online course. Please review the online course FAQs.

Summer 2019: Online course

Section ID:AEM 2011 002-LEC
Number:1364
Class dates:June 24-July 12, 2019
Days/times:Online course
Location:Online course
Credit:3
Grade:Graded (no audit)
Instructor:Haeger, D. (dlh266)
Max. enroll:20
Restrictions:Intended for non-Dyson majors only.
Notes:If you are a student planning on transferring into the Dyson School, this course does NOT count toward degree requirments.
  This is an online course. Please review the online course FAQs.

Related websites