AEM 4010 - Organizational Analytics

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

Prerequisite: AEM 2010 and AEM 3030.

D. Haeger.

This course takes an analytics based approach to managerial decision making within a spreadsheet platform. Through case analysis, emphasis will be placed on the exploration and application of Microsoft Excel to enhance decision making and improve outcomes. This data-driven course will require students to leverage complex functionality available in the Excel platform. Key mechanics employed will be: advanced methods of data management, data visualization, financial modeling, forecasting, optimization, pivot tables, and simulation. Key topics covered could be, but are not limited to areas such as employee productivity, succession planning, organizational safety, employee satisfaction, team dynamics, leadership, Just-in-Time inventory, recruitment and selection, training and engagement.

Outcome 1: Critically analyze cases in the management and organizational behavior disciplines

Outcome 2: Evaluate problems on a case basis to determine proper methods of analysis using spreadsheet modeling.

Outcome 3: Design models with which to investigate and solve business problems.

Outcome 4: Interpret and apply analysis results to decision making using logic and industry knowledge.

Outcome 5: Explore a breadth of business problems faced by management considering both quantitative and qualitative inputs in decision making.

Outcome 6: Demonstrate the ability to independently conceptualize and design spreadsheet models.

Outcome 7: Collaboratively explore and make complex decisions involving multiple variables and contingencies.

Outcome 8: Explain ethical implications to decisions making.