1 / 63

Project Review Packet Creation: Steps, Labs, and Examples

This presentation provides step-by-step instructions, labs, and examples for creating a Project Review Packet. Learn how to organize files, create cover and agenda pages, and include performance metrics, budget status, and executive issues. Access Eclipse for additional resources.

brendagrant
Download Presentation

Project Review Packet Creation: Steps, Labs, and Examples

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Overview • This presentation outlines the steps used to complete a Project Review Packet. It also includes examples, labs and videos. • The format of the labs will be an explanation what you are going to do, followed by step by step instructions. Example: • Create a folder structure on your desktop for your Project Review Documentation. A. Open your Folder Go to Desktop  New Folder B. Title it “Monthly Review Process”. C. Within that folder, create another folder; title it “2013 Review Source Files D. Within that folder create another folder; title it “201301 Source Files • By the end of this session you should have a sample packet and feel comfortable with you ability to create a Project Review Packet once you return to your agency.

  2. Monthly Review Packet Discipline: Portfolio Management Relationships: Primary performer- Portfolio Administrator Additional Performers- Business Segment Director and Project Manager Output- the Project Review Packet Purpose: The purpose of this procedure is to provide instruction for creating the Monthly Review Presentation Packets. This procedure assumes the operator has working knowledge of creating, copying and deleting files and folders in the Windows network and desktop environment; and of the HP PPM Software. MainDescription: The Monthly Review Presentation consists of the following:Performance Metrics (dashboards, closed projects, etc.), Budget Status, Execution Delivery Schedule, Program Status (Milestones, Scorecard, Snapshot and Project Status Reports), and Executive Issues.

  3. Outline of The Project Review  • The Project Review should include the following: • Cover Page* • Agenda* • Performance Metrics* • Closed Projects* • Portfolio/Programs: • Projects in Execution* • Program Status- • Scorecard * • Snapshot * • Status Reports (If required) • Milestone Reports (If required) • Issue, Risk and Scope Changes (If required) • Executive Issues *Required • Some of these steps will be done in PowerPoint and some of them will be done through the PPM Tool and its Excel and PDF export functions. • All of the files will be copied into PowerPoint for the final Project Review Packet.  • The remaining steps will explain how to produce each of these things.

  4. Metrics • There are some additional metrics your BSD may want/require in the Monthly Review Packets. • These include Project/Enhancement Service and Operation Level Metrics, Project Metrics for Completed Projects and Resource Utilization Metrics. • We will go over the Required metrics in this class. You will work with your Business Segment Director to determine any additional metrics they may want to see, or as you go through transformation, additional classes will be held to demonstrate how to report additional metrics in the Project Review.

  5. Eclipse • Eclipse is an online tool used to support agency transparency by providing descriptions and procedures to role, discipline and work products involved with various project lifecycles. • Eclipse will be a place you can go to view documentation, and it can assist you by providing appropriate guidance (templates, reusable assets, etc. for specific tasks and/or work products). • You can access Eclipse at: http://eclipse.omes.ok.gov

  6. Step 1: Create a Folder Structure for the Project Review Process   • In order to create the Monthly Review Packet, you need some working space. • Create this working space somewhere on your network that you will use each month. • Folders that you will need: • Monthly Review Process- High Level Folder • YYYY Monthly Review Source Files- High Level Folder • YYYMM Project Review Source Files- Content Folder Sample Folder Structure:

  7. Lab 1: Create Working Folders PURPOSE: Setup your folder structure for storing your files for the labs. For training purposes, we will create working folders on the desktop and we will delete them once training has concluded. • Create a folder structure on your desktop for your Project Review Documentation. • Go to My Computer  Desktop  New Folder • Title it “Monthly Review Process”. • Open your Folder • Within that folder, create another folder, and title it “2013 Review Source Files” • Within that folder, create another folder, and title it “201301 Source Files” It is within these subfolders that you will save your documentation for you Project Review. (The snapshot, scorecard, status reports, milestone plans, and any other elements that need to be included). • <LAB 1 COMPLETE>

  8. Step 2: Create Cover and Agenda Pages   • For the Packet, Create a Cover Page . • that includes the Project Review title, the meeting date, and the next scheduled meeting date. • Create an Agenda Page • This page should outline the contents of the Project Review

  9. Lab 2: Create a PowerPoint Presentation • Access Eclipse: http://eclipse.omes.ok.gov • Go to Work Products Portfolio Management Project Review Packet • Under the Illustrations section, select the Project Review Packet Template, then open the Project Review Template.pptx under the Attached files. This template will provide you with your basic template for the project review. • Update the [Agency] with your agency name. • Update both the dates [Date] with a Date (any date will do). • Save the presentation in the lowest level folder that you just created in Lab 1. Name it : “201301 [agency name] Review Draft” • <LAB 2 COMPLETE>

  10. Print Screen and Cropping VIDEO

  11. Step 3: Create Performance Metrics   • Agency dashboards are used to create Performance Metrics for the Project Review Packet. • These metrics are found on the State CIO Public website and are copied to your presentation. • These metrics measure service and operation levels for projects. • For this class, we will use an agency that has already reported their metrics, but you would use your own agency, once you have been added to the dashboard.

  12. Agency Dashboard Example: • Business Application Services Change Requests on Time: • This shows the software enhancements requests that were • Completed as planned for the month. You will not begin reporting • This until you either go through transformation or begin using the • PPM tool to track your Software Enhancements. • Business Application Services Projects on Time and On Budget: • This shows the projects that were for the month and their health for • Budget and Schedule. This one is a mandatory section, and you will begin • Reporting it after you have submitted data to the Business Intelligence group. • There will be additional Steps and labs to show you how to get this data loaded into the dashboard.

  13. Lab 3: Create Project Service Level Slide PURPOSE: Create the Project/Enhancement Service Level Dashboard Slide In this lab you will learn how to create the Project/Enhancement Service Level slide. Below is and example of what your slide should like when you are finished.

  14. Lab 3: Create Agency Dashboard…continued • To Create Service Level Dashboards of performance metrics, go to the CIO website. http://ok.gov/cio • Select the Project/Enhancement Service Level Dashboard Link; it can be found under Online Tools/Services

  15. Lab 3: Create Agency Dashboard…continued • Navigate to the Business Segment and Agency dropdowns, and select the appropriate segment and agency.  For training, select Education for the Business Segment – then select APPLY – this will filter for only Education Agencies, then select Education Department – then select APPLY. • Take a screen shot of the dashboard title, index, segment and agency for the top of your metrics slide. • It may take two screen shots (depending on your screen resolution size) to get the data into your presentation.

  16. Lab 3: Create Agency Dashboard…continued • To take a screen shot: • place the scroll bar all the way to the top of the screen, make sure you can see the title, segment, agency and definitions. • Select SHIFT and PRTSCRN (in your upper right hand corner of the keyboard). • Go to your presentation page titled: Project/Enhancement Service Levels • Right click and select Paste • You will now need to crop this image to fit on the page and look good. To crop: • Double click on the image, it will open the format tab. • Select the CROP button

  17. Lab 3: Create Agency Dashboard…continued • Select the black corner lines on your image • Drag it and position it just above the title • Do this for all four corners and the top, bottom and sides of your image to crop it. • It will probably be too wide, as well. You will need to click off the image (to get it out of crop mode) and click on it again to resize it. • Click on the corner or sides to resize the image to fit on the width of the page and move it to the top. Example of cropped image:

  18. Lab 3: Create Agency Dashboard…continued • If you were not able to get the entire set of information in one screen shot, use the same method as above. And, take a screen shot of the part of the screen with the metrics in it, crop it, size it and place it in the middle of the slide. • Refer to the first page of the lab for what your finished product should look like. • Save your presentation file. *Note: You are done for lab purposes, but there is also a Support Services Level Dashboard you will need to include in your packet by following the steps outlined above. However, this time you will select the Support Services Level Dashboard link. <LAB 3 COMPLETE> • <LAB 3 COMPLETE>

  19. Take a Break!

  20. Step 4: Export the Closed Projects List • For the Project Review, there will need to be a list that includes the agency’s closed projects. • The first step to creating that list is exporting the closed project list from the tool. • Then, it needs to be formatted and added to the presentation.

  21. Lab 4: Create Closed Project List PURPOSE: To create the Closed Project List Slide. Below is and example of what the Closed Project Slide will look like when you are finished.

  22. Lab 4: Create Closed Project List…continued • 1. Login to the PPM Tool: • Navigate to the CIO website: http://ok.gov/cio • Go to the Project Portfolio Management (PPM) Center link • Enter your User ID & Password

  23. Lab 4: Create Closed Project List….continued • For many of the tables in the presentation, you will need to format Excel spreadsheets, Macros have been created for you to aid you in this effort. You will need to enable Macros in Excel prior to using Excel. • To enable macros in Excel: • Open Excel Excel Options Trust Center Trust Center Settings Macro Settings Make sure that Enable all macros is selected. (See detailed steps on the following pages) Open Excel Excel Options Click Click OR

  24. Lab 4: Create Closed Project List….continued Trust Center Click

  25. Lab 4: Create Closed Project List…..continued Trust Center Settings

  26. Lab 4: Create Closed Project List…continued Macro Settings Click *Make sure Enable all macros is selected.

  27. Lab 4: Create Closed Project List..continued • Go back to the PPM Tool. 4. Navigate to the State Department of Education Dashboard: Dashboard Shared  Education Agencies  State Department of Education (IF your agency has data, you may use your agency for this lab, or you can use the Education agency to assure you have data for the exercises) • This is where you will pull the data for the closed projects, projects in execution, snapshots, scorecards, milestones and status reports.

  28. Lab 4: Create Closed Project List….continued 5. Export the Closed Projects list • Open your agency’s dashboard • Navigate to the Projects Completed Portlet and select the Export to Excel link. If you are having trouble getting the excel to open, try holding down the Ctrl key and selecting the link. • Click Save in the dialogue box • Within your folder structure in on the desktop: • Save the file as: 201301 Closed Projects as an Excel Macro-Enabled Workbook

  29. Lab 4: Create Closed Project List….continued 6. Now, that the Closed Projects List has been exported, some modifications need to be made. In order to make changes to the file the Macro Workbook needs to be opened. • To open the Macro Workbook, you will have to access Eclipse: http://eclipse.omes.ok.gov • The Macro Workbook is attached under Work Products Portfolio Management Project Review Packet • Under the Illustrations tab go to Reusable Assets  select the Macro Workbook link • Under the Description tab select the Project Review Packet Macro and Schedule Health Formula Workbook • Open the Macro workbook, Enable Editing (if required) and then minimize the Excel session. • Navigate to the saved Closed Projects Excel file. • Now that the Closed Projects List has been exported, saved as a Macro enabled workbook, and the Macro Workbook is open, it is time to format it so it will look nice in the presentation.

  30. Lab 4: Create Closed Project List….continued • Run the Macros (the Workbook should be minimized from earlier). • Click the Macros group in the ribbon (upper right). If it is not present, select the View tab. • Select View Macros from the list. • Run the two macros created for the Closed List to reformat the exported file. • Save after each macro is executed. PPM_Closed_List_Conditional_Formatting_Color_Cell PPM_Closed_List_Format_Cells *These macros need to be ran in this order. • The last line of the report will have the date and time the export occurred in column A, you can delete this line.

  31. Lab 4: Create Closed Project List….continued • Copy and paste the cells into the PowerPoint presentation. • Highlight all the cells in the excel spreadsheet. • Right Click  Select Copy • Go to your PowerPoint Presentation  to the Project Completed page • Go to Paste  Paste Special • Select Picture (Enhanced MetaFile) • Select OK • Reposition and Resize to fit the page • Refer back to first page of the lab for an example of a finished slide. • Save your presentation file. • Close the Closed Excel Spreadsheet. <LAB 4 COMPLETE>

  32. Step 5: Create the Projects in Execution Page • Every month the status of projects in Execution should be reported. The tool’s Projects in Execution portlet displays a Gantt Chart that captures the current status of projects in execution, and you can use that portlet to report execution data in your monthly review meeting and packet.

  33. Lab 5: Create the Projects in Execution PURPOSE: To create the Projects in Execution Slide. Below is and example of what the Projects in Execution Slide will look like when you are finished.

  34. Lab 5: Create the Projects in Execution….continued • Navigate to the primary Dashboard for your Agency: Dashboards Your Agency Program Dashboard or the State Department of Education Dashboard • Select the Export to PDF button in the upper right corner of the page. • Under the Choose Portlets Section, select the Projects in Execution box: (Make sure all the other boxes are unchecked.) • Under Paper, Orientation Select Landscape And Fit to Page in scale 5. Select Export.

  35. Lab 5: Create the Projects in Execution….continued 6. Using the Alt + PrtScn Function (Refer to Lab 3 for detail instructions), copy and paste the Projects in Execution exported file into your PowerPoint presentation. Adjust and expand the image as needed to fit the slide. 7. Refer back to first page of the lab for an example of a finished slide. <LAB 5 COMPLETE>

  36. Step 6: Projects Waiting Approval and Project List  • The agency’s dashboard is used to create a Snapshot of Project Plans Waiting for Approval, Projects Ready for Governance Board, and the Project List. This Snapshot allows you to account for projects that are not Complete or in Execution.

  37. Lab 6: Create the Project List & Approval List PURPOSE: To create the Projects Waiting Approval and the Project List Slides Below is and example of what the Project Plans Waiting for Approval and Projects Ready for Governance Board Review parts of the Snapshot will look like when you are finished.

  38. Lab 6: Create the Project List & Approval List…continued Below is and example of what the Project List part of the Snapshot will look like when you are finished.

  39. Lab 6: Create the Project List & Approval List…continued 1. Navigate to the primary Dashboard for your Agency: Dashboards Your Agency Program Dashboard 2. Select the Export to PDF button in the upper right corner of the page, 3. Check the: Project Plans Waiting for Approval and the Projects Ready for Governance Board Review boxes in the PDF Settings dialogue box, make sure all the other portlets are unchecked. Under Paper make sure Orientation is set to Landscape and Fit to Page is selected 4. Select the Export button. 5. Maximize the screen to fit your entire screen. 5. Using the Alt + PrtScn Function (Refer to Lab 3 for detail instructions), copy and paste the Project Plans Waiting for Approval and Projects Ready for Governance Board Approval exported file into your PowerPoint presentation. Adjust and expanded the image to fit the slide.

  40. Lab 6: Create the Project List & Approval List…continued 6. To get the agency’s Project List; • Go to the Project List Portlet • Click the Export to Excel + Ctrl • Select all the Cells of data in the Excel Spreadsheet • Right Click, Select Copy • Go Back to your PowerPoint, to the Project List Page • Go to Paste Paste Special; Select Picture (Enhanced Metafile) • Resize the picture to fit on the slide; you can delete the header if you want. • Refer back to first page of the lab for an example of a finished slide. • Save your presentation file. • Save the Project List Spreadsheet as “201301 Project List” and close. <LAB 6 COMPLETE>

  41. Step 7: Projects Milestone Plans  • Milestone plans are required when a project goes from: • Initiation  Planning (+/- 50%) • OR • Planning  Execution (+/- 10%) • If you have any projects on your Project Plans Waiting for Approval portlet in one of the following statuses: High Level Business Case Ready for Approval or Waiting for Detail Plan Approval, you will need to create a Milestone Slide for each of the projects. • Some agencies will not use milestone plans during their project reviews, but during their Governance Board meetings. You will need to work with your Business Segment Director to determine if to include milestone plans in your project reviews.

  42. EXAMPLE

  43. Lab 7: Projects Milestone Plans  Purpose: To create a milestone plan for a project review. For this lab, we will all create the same Milestone Plan. Within the PPM Tool, open project ID: 30824 Select the Export to PDF Link in the upper left hand corner.

  44. Lab 7: Projects Milestone Plans…continued  Under the Display, select Display header Under Choose Portlets; select the Work Plan and Milestone Summary boxes. Make sure all others are unchecked. Make sure you change the Display Title to: Statewide PPM Tool Rollout Under Paper; select Landscape for Orientation. 6. Under Scale, select fit to page 7. Select Export 8. Maximize the PDF. 9. Using the same print screen and crop method we have been using in this class, put the first part of the Milestone plan into your presentation on the Milestone plans page, you can delete the header on this page.

  45. Lab 7: Project Milestone Plans…continued Go back to the PPM Tool, on the Project Summary Tab, scroll down to the bottom; within the Project Cost Section, click on the View Financial Summary Button. Scroll down to the bottom of the financial summary, click on the following hyperlinks 5 Detail Lines, Forecast and Actuals and Quarters (see picture below)

  46. Lab 7: Project Milestone Plans…continued Using the same print screen and crop method we have been using in this class, Crop the financial information to look like the below, and place it at the bottom of the Milestone Plan in your presentation. Refer back to the example. Save your PowerPoint presentation. <LAB 7 COMPLETE>

  47. Step 8: Create the Scorecard   • The Scorecards allow for review of projects in various statuses from Initiation through Requesting Closure. To create the Scorecard, it must first be exported and formatted from the tool.

  48. EXAMPLE

More Related