AEM 2010 - Spreadsheet Modeling for Management and Economics

Fall, Spring. 3 credits. Letter grades only (no audit).

Enrollment limited to: Dyson students.

Fall, D. Haeger; Spring, R. Moghimi.

This course will place a strong emphasis on applied decision making in the business world using Excel as a business analytics tool. This is not just a “how to use Excel” course. We will cover the theory behind our decisions and apply the tools and methods to various business scenarios throughout the semester. 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 an intermediate to advanced knowledge of business analytic skills and Excel. Students will enjoy a thorough exposure to real world applications and learn to demonstrate these new capabilities in a business environment. AEM 2010 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. In business analytic vernacular, students will learn to leverage descriptive, predictive and prescriptive analytic methods using data. The course also covers Text Management and Analytics.

Outcome 1: Provide students with the skills needed to employ spreadsheet modeling techniques for economic and management analysis.