Microsoft Project 2007
Tracking a Project exercise
Average difficulty

This Microsoft Project 2007 TRACKING A PROJECT exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl MICROSOFT PROJECT 2007 course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: Dream Home - Tracking and Reporting

A full answer to this exercise is provided as part of the training course!

1) Download the files needed to start this exercise: exercise-874.zip (and click here if you experience any problems unzipping this file after downloading it).
2) Open the file in the folder shown above.
3) Using the appropriate tables / views update the following costs:
  • The fixed cost of the Purchase Land task was actually £30,000.
  • The balance of the planned cost of the land (£5,000) should be reallocated to Furnishings for the interior of the house (task 23).
  • The standard rate of the Electrician is £150/day.
4) Change the durations as shown in Red on the table below:
Exercise screen-shot 2153 The total duration is the sum of the actual and remaining durations fields.
5) The actual start or finish dates have changed as indicated in Red on the table below:
Exercise screen-shot 2154 Date changes should only be recorderd in the Actual fields.
6) Update the entire project to 07/07/08 (as if this is today's date).
7) Use the View, Filters and Reports to answer the following questions.
  • What date will our Dream Home actually be ready for us to move in and is this before our lease runs out?
  • What is the current overall cost variance?
  • Which tasks are 'overbudget' and by how much?
  • Which tasks are slipping?
  • Who has tasks which are yet to start?
  • What is the variance on the work hours required for this project?
  • How many tasks are currently in progress?
8) Save your updated file as Dream Home still on time and close it down.

Thank you for showing an interest in this Microsoft Project 2007 training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.

All content copyright Wise Owl Business Solutions Ltd 2008.  All rights reserved..