2009 PMI Award Medallion
PMI Baltimore Chapter logo
About Us Events Education Membership Newsletters Job Listings PMO
Earned Value & MS Project 2007 Class

Loyola College Graduate Center
Thursday, March 25, 2010

Earned Value & MS Project 2007: Using Microsoft Project to Collect, Track and Report True Earned Value

Edwards Project Solutions (Timonium, MD)

Register for this event.
NOTE: This is a 2-DAY COURSE that runs March 25 and 26!

Do you have a requirement to track Earned Value metrics on your project? Have you ever built a detailed schedule plan in Microsoft® Project only to toss it away because you can’t properly track the required Earned Value metrics? This 2-day, instructor-led course will present you with a very clear step-by-step process for setting up, tracking and reporting Earned Value Metrics using Microsoft® Project 2007. The skills and best practices that you will learn are engaging and sustainable. Make this course your first step toward better planning and effective reporting! What You Will Learn • A full-life cycle, PMI® based, project management methodology for scheduling with MS Office Project. • Create and manage a project resource pool. • Set up and manipulate project and resource calendars. • Set up and modify task relationships • Assign project resources to tasks • Set up performance and level-of-effort (LOE) tasks Understand task types and the schedule formula • Resolve resource conflicts and baseline the project • Track project progress (in good times and bad) • Create project reports and analyze project, resource and task data • Track and Report Earned Value metrics at both detailed and summary task levels. • Best Practices for Baseline Management, Scope Management and Resource Management

Time and Location Information

March 25-26, 2010

Loyola University Graduate Center
Timonium Campus
Timonium, Maryland

Contact Edwards Project Solutions at (800) 556-2506 with any specific questions related to this course.

Agenda

Course Outline Section 1: Introduction and Overview. This section, based on PMI principles and doctrine, provides an introduction to project scheduling and Earned Value Management along with the techniques that are utilized to create a comprehensive and manageable project schedule. History and overview of Earned Value management process. This section also provides an introduction and overview to the Edwards Industries method for developing comprehensive work plan, defining and estimating task and milestones and determining the interdependencies and constraints of the tasks. Section 2: Properties and Options. This section begins the use of Microsoft Project. The MS Project property and option settings are discussed in detail. Each property and option is defined with an explanation of how MS Project reacts to the setting of the property or option. This section provides recommendations for the setting of each property and option. Section 3: Templates and Calendars. This section defines the templates and calendars available in Project and provides insight on how and when to use these features. The uses of global and local templates are reviewed with discussions on defining and applying them. Custom scheduling templates, developed by Edwards Industries to support our PMI-based methodology, are presented and discussed. These templates, which are provided on media (floppy or CD) to each student taking the course, have been developed by Edwards Industries over many years of managing projects using MS Project to present schedule and status data to customers and senior management. Calendars are also discussed in this section of the course. The instructor demonstrates how to define, apply and maintain project "master" calendars, resource calendars, task calendars and special purpose calendars. A complete explanation of each type of calendar and recommendations on which types to use under different scheduling scenarios is provided. Section 4: Setting up a New Project. In this section, a sample project will be introduced to the students. The students will begin to exercise the Edwards Industries methodology for using Microsoft Project. The students, working at their workstations, will follow along with the instructor and translate the information resulting from a planning session for our sample project into an MS Project schedule. The students will learn to begin to establish the schedule in MS Project by entering the properties and general project information into MS Project. Next the students will learn to define the resource pool in MS Project including defining the financial information and resources calendar information, including resource rates, rate increases, company holidays and shift work. Section 5: Entering Project Data. While still following the methodology and following the lead of the instructor, the students will enter the tasks and milestones, including Level of Effort (LOE) tasks, for our sample project; the students will define the tasks, the task interdependencies and constraints in MS Project. Earned Value tracking will be set up at both detailed and summary task levels. In this section, the instructor will lead the students through assigning resources from the resource pool to the tasks and entering the "work" required to complete each task. Once the project task data and assignment data for our sample project is entered, the instructor will conduct discussions on how to read and understand the critical path and slack time (lag time) of the project. This is followed by an exercise on "resource leveling" to ensure that no resource is working more than their planned availability during the project. The section concludes with setting the baseline on the exercise project and a discussion of the tools that can assist in communicating the schedule and Earned Value Performance Measurement Baseline. Section 6: Tracking Project Progress. Now that the students have completed building and base lining the schedule for our sample project, ...THE SAMPLE PROJECT IS READY TO BEGIN... In this section, the students will learn to record the actual progress of project tasks and actual work schedule for project resources. Tracking techniques will be applied to both detailed tasks as well as Summary level tracking. Resource status information for our sample project, which is not executing according to plan, is presented to the class. The students use the status information to follow along with the instructor and record the task and resource status into MS Project. This section provides step-by-step instructions for recording the Actual Start, Percent Completion, and the Actual Work performed for the tasks of our sample project and also for recording sick and vacation time for project resources and will include update of Earned Value. Once the entry process is completed, the students will learn to examine the resource and task expenditures using the "Usage" views. The student will learn techniques for adjusting the resource leveling based on the actual progress that is entered and applying adjustments to project LOE tasks and handling of Earned value. Section 7: Reporting Project Progress. Now that the students have built a schedule and recorded status for a schedule, this section provides tools and techniques that can be utilized to analyze and report the status of the project. This analysis will be performed using (a) standard and custom views such as the various "Usage" views and the Project Statistics screen; (b) Creation of Visual Reports to create reports in Microsoft Excel (c) Using custom fields to calculate additional project metrics and linking the calculated data to graphical indicators to create "Stop-Light" charts;. Several examples and reports will be generated for the project schedule developed in sections 4, 5 and 6. An overview of the various "canned" reports available in MS Project will be discussed and demonstrated in this section. The Visual Reports offered in Project 2007 will also be discussed. Section 8: Earned Value Best Practices. Now that the students have built a schedule, tracked progress and performed analysis, it is time to learn some best practices and techniques for handling those various changes that affect the Earned Value Management plan. Discussed will be practices around Resource Management, Scope and Baseline Management and things you should know. How to handle planning packages. Understanding Earned Value methods and the best way to use them. Obtaining CAM level earned value reporting, setting up a field for drilling into CAM level EV details. Section 9: Class Exercise. Now that the class has completed the entire process with the instructor, it is time to try it on their own. Section 9, allows each student to use the principles from the previous sections to build a schedule on their own with individual oversight and guidance from the instructors. Each student, working independently, will use MS Project and the step-by-step methodology to set up, create, baseline and communicate this new project schedule. Once the student has completed creating the schedule, the project status information for the third week into the project is provided. Using this status information, each student will update his/her schedule with the status and analyze the results. Section 10: Supplemental Information on Microsoft Project. In this final section of the course, the class will review some of the lessons learned from the 2-days of training. The instructor will share with the class some of the nuances and anomalies in MS Project and how to avoid or work around them. Techniques for EV tracking in hours is summarized. Finally the course will discuss some of the additional benefits and features available in the next release Microsoft Project.

Back To Event List.

Meeting Information

The PMI Baltimore Chapter hosts monthly dinner meetings and bi-monthly luncheon meetings.

Dinner meetings are held on the third Thursday of the month and alternate between the Crowne Plaza in Timonium MD and the Ramada Inn BWI in Hanover MD. They start at 6:00 PM.

We will be having bi-monthly Annapolis dinner meetings on the fourth Wednesday of the month at Carrol's Creek Cafe. The Annapolis meetings start at 5:30 with an hour for networking, dinner starts at 6:30, and the presentation starts at 7:30.

We will also be having a bi-monthly dinner meeting in the Salisbury, MD area on the alternating months on the fourth Wednesday of the month at the Adam's the Place for Ribs restaurant in Fruitland. The Eastern Shore dinner meetings start at 6:00 PM.

Every other month, we will be meeting in Frederick, MD, at the Red Horse Steak House. Networking starts at 6pm, with dinner at 7pm, and a presentation starting promptly at 8pm.

We also hold luncheon meetings in Columbia, MD on the fourth Monday of the month at the Howard County Business Center, 6751 Columbia Gateway, Columbia, MD 21046. These meetings start at 11:30 AM. Please note that payment for the Columbia luncheon meeting is at the door. Online payment via PayPal is currently not available for the Columbia luncheon meetings.

We also have events at NASA Space Flight Facility at Wallops Island, VA and at Aberdeen, MD.

You can register for meetings through the event links on our Calendar of Events page.

PMI Contact Information

841 East Fort Avenue
Suite 252
Baltimore, MD 21230

info@pmibaltimore.org

   HOME  |  ABOUT US  |  EVENTS  |  EDUCATION  |  MEMBERSHIP  |  NEWSLETTERS  |  JOB LISTINGS

   PMI Baltimore Chapter, 841 East Fort Avenue, Suite 252, Baltimore, MD 21230 E-mail: webmaster@pmibaltimore.org
   ©2007 Project Management Institute, Inc. Baltimore Chapter. All Rights reserved.