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    
 
    
 
  Nov 24, 2017
 
Courses of Study 2017-2018
[Add to Favorites]

AEM 2011 - Spreadsheet Modeling for Non-Dyson Majors


     
Winter, summer. 3 credits. Letter grades only (no audit).

D. Haeger.

This course will be developed as a data-driven, model-based approach to decision-making. Most applications will rely on the standard array of Excel functionality but other platforms (e.g., Access, SQL, presentation software) may be employed. A unique feature of this course will be applications drawn from the diverse program areas of the Dyson School: management, international development/trade; environment/resource economics; and food/agricultural economics. Case material will be contributed by the companies from the DUAC. Key topics will include: Optimization (Solver), Data graphing, Financial modeling, Ethical/social dimensions of IT, Forecasting, Pivot tables, Exponential smoothing, and Simulation.

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.



[Add to Favorites]