Skip to content
Cornell University School of Continuing Education and Summer Sessions

Courses will be added to the Winter Session roster between September and December. Visit often to see the latest course listings. Registration begins October 1, 2018.

Courses

AEM 2011 Spreadsheet Modeling for Non-Dyson Majors

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

AEM 2011 001-LEC Online course

Number:1060
Class dates:January 2-19, 2019
Days/times: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.
To enroll:See the Enrollment and registration for more information about enrolling in Winter Session classes.
  This is an online course. Please review the online course FAQs.

Tuition and fees

See the Tuition and fees page for more information.

Related websites