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

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:1379
Class dates:May 29-June 21, 2019
Exam dates:Will be provided by instructor (see Final exams)
Days/times: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.
To enroll:To enroll, complete and submit a course enrollment form and your payment to the Summer Session office. For more information, see enrollment and registration. Please note that late registration fees may apply.
  This is an online course. Please review the online course FAQs.

AEM 2011 002-LEC Online course

Number:1364
Class dates:June 24-July 12, 2019
Exam dates:Will be provided by instructor (see Final exams)
Days/times: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.
To enroll:To enroll, complete and submit a course enrollment form and your payment to the Summer Session office. For more information, see enrollment and registration. Please note that late registration fees may apply.
  This is an online course. Please review the online course FAQs.

Related websites