The page uses Browser Access Keys to help with keyboard navigation. Click to learn moreSkip to Navigation

Different browsers use different keystrokes to activate accesskey shortcuts. Please reference the following list to use access keys on your system.

Alt and the accesskey, for Internet Explorer on Windows
Shift and Alt and the accesskey, for Firefox on Windows
Shift and Esc and the accesskey, for Windows or Mac
Ctrl and the accesskey, for the following browsers on a Mac: Internet Explorer 5.2, Safari 1.2, Firefox, Mozilla, Netscape 6+.

We use the following access keys on our gateway

n Skip to Navigation
k Accesskeys description
h Help
Cornell University    
 
    
 
  Dec 11, 2017
 
Courses of Study 2017-2018
[Add to Favorites]

AEM 3030 - Explorations in Analytic Modeling


     
Fall. 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.



[Add to Favorites]