| GSBA/MSIT 573 | ||
| Session Three Tuesday 13 June 2006 TimeLine and Objectives | ||
| NOTE CLASS MEETS IN AW 221 | ||
| Assignment Due: | Assignment 2 | |
| Session Materials | ||
| chapter seven - cost management | ||
| chapter 11 | ||
| risk file | ||
| golden years | ||
| pivot_file | ||
| Session Topics | ||
| Planning, Selecting, and Managing the Project | ||
| Using Excel as a Project Management Tool | ||
| Learning Objectives | ||
| Be able to describe an overall framework for project integration | ||
| Explain the strategic planning process and apply different project selection methods | ||
| Discuss the process of creating a preliminary project scope statement | ||
| Understand why we track project process in a project schedule. | ||
| Describe the process of monitoring and controlling project work | ||
| Understand the elements that make good project scope mgmt important | ||
| Specific Excel Functions: | ||
| use absolute cell references in a formula. | ||
| use the IF function to enter one value or another in a cell on the basis of a logical test. | ||
| use excel to answer what-if questions | ||
| use the goal seek command to analyze worksheet data | ||
| create and use a template | ||
| drill an entry through a worksheet | ||
| summarize data using consolidation | ||
| use excel's scenario manager to record and save different sets of what-if assumptions | ||
| and the corresponding results. | ||
| create a scenario summary of scenarios | ||
| create a PivotTable | ||
| Session Deliverables | ||
| risk.xls | ||
| Schedule | ||
| 530 | Session Begins | |
| 530-700 | Chapter 4 Lecture | |
| 700-720 | Break | |
| 720-845 | In class Lab Examples | |