AEM 3030 - Explorations in Analytic Modeling

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

Prerequisite: AEM 2010.

D. Haeger.

Explorations in Analytic Modeling will be developed as a deeper exploration and model based approach to quantitative decision making within a spreadsheet platform. Applied decision making using primarily Microsoft Excel as a business analytics tool will focus on using applied cases requiring various financial and other models. As the course explores models, emphasis will be placed on the exploration and application of the tool to enhance decision making and improve outcomes. This data-driven course will move the student into the most complex functionality available in the Excel platform. Key topics will include: data management, data visualization, financial modeling, forecasting, optimization, pivot tables, and simulation. The course will also employ macro recording with introductory visual basic for applications programming.

Outcome 1: Apply spreadsheet modeling analysis and decision making to different industries in business.

Outcome 2: Design spreadsheet models for a breadth of business situations and problems.

Outcome 3: Evaluate and understand the concept of data integrity and ethics associated with proprietary data.

Outcome 4: Manipulate large data-sets and explore data management and cleansing.

Outcome 5: Apply logic when making business decisions to solve real world business problems.

Outcome 6: Demonstrate effective and efficient data display with charts and tables through model design and experimentation.

Outcome 7: Infer and predict outcomes using forecasting and trending with financial impact analysis.

Outcome 8: Expand into more complex decision making using multivariable scenarios.

Outcome 9: Create and record Macros and become familiar with VBA language syntax.