AEM 2011 Spreadsheet Modeling for Non-Dyson Majors
Course description
This Excel based course will emphasize applied decision making in the business world. This introductory course covers the theory behind decision making and applying analytic tools like Excel to various business scenarios. Understanding the value of such skills, this course will introduce students to methods used to navigate tools and applications, or typical business scenarios where such capabilities can be leveraged in business. Students dedicated to success in this course can expect to achieve a basic to intermediate understanding of many features available in Excel. Students will enjoy a thorough exposure to real world applications related to leveraging the tool and learn to demonstrate new analytic capabilities in a business environment. AEM2011 will help students understand the dynamics of using Excel to solve optimization problems, forecast future outcomes using assumptions and projections, and evaluate problems that involve uncertainty in order to inform business strategy and quantitative decision-making.
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.
Outcome 10: Become skilled consumers of business data, information and knowledge and leaders in the production of data driven decisions.
If you are a student planning on transferring into the Dyson School, this course does NOT count toward degree requirements. This course counts as the prerequisite for AEM 3030 online.
Prerequisites
Students are expected to enter this course with basic computing skills using Microsoft Office applications and a Windows platform.
Summer 2024: Online course
| Section ID: | AEM 2011 001-LEC |
| Number: | 1012 |
| Session: | Summer 3-week 1 |
| Class dates: | June 3-21, 2024 |
| Final exam/project due: | Friday June 21, 11:59 PM (see Final exams) |
| Time / room: | |
| Mode of instruction: | Online (async) |
| Credit: | 3 |
| Grade: | Graded (no audit) |
| Instructor: | Haeger, D. (dlh266) |
| Max. enroll: | 20 |
| Restrictions: | Enrollment limited to non-Dyson majors. |
| Notes: | Forbidden Overlap: due to an overlap in content, students will receive credit for only one course in the following group: AEM 2011, HADM 4770, HADM 6770, ILRID 4699, ILRID 6990. |
| To enroll: |
See Online Learning FAQs. |
Summer 2024: Online course
| Section ID: | AEM 2011 002-LEC |
| Number: | 1016 |
| Session: | Summer 3-week 2 |
| Class dates: | June 24-July 12, 2024 |
| Final exam/project due: | Friday July 12, 11:59 PM (see Final exams) |
| Time / room: | |
| Mode of instruction: | Online (async) |
| Credit: | 3 |
| Grade: | Graded (no audit) |
| Instructor: | Haeger, D. (dlh266) |
| Max. enroll: | 20 |
| Restrictions: | Enrollment limited to non-Dyson majors. |
| Notes: | Forbidden Overlap: due to an overlap in content, students will receive credit for only one course in the following group: AEM 2011, HADM 4770, HADM 6770, ILRID 4699, ILRID 6990. |
| To enroll: |
See Online Learning FAQs. |