Microsoft Software
Project tracking exercise
Harder than average exercise

This Microsoft Software PROJECT TRACKING exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl MICROSOFT PROJECT 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 & 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-857.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 Land was actually £30,000
  • The balance of the planned cost of the land (£5,000) should be reallocated to furnishing the house.
  • The standard rate of the Electrician is £150/day
4) Change the remaining durations as shown in Red on the tasks shown on the diagram below:
Exercise screen-shot 1913 The view has been filtered to bring the tasks into the same view
5) The actual start or finish dates on the following tasks have changed as indicated in Red below:
Exercise screen-shot 1914 Note that after Baselining all date changes should be made to the Actuals
6) Update the entire project to 05/05/08, (assume this is today's date).
7) Use the 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 on time?
  • What is the current 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 and close your updated file as Dream Home we are on time.

Thank you for showing an interest in this Microsoft Project 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 � Wise Owl Business Solutions Ltd 2007.  All rights reserved.  Design by Branches.