Changing the current date of the active project
Title: Project Essentials
Edition: 4.2.3
Advantages of using Microsoft Project 3
Understanding task duration 32
Setting up task relationships 38
Key points about constraints and deadlines 66
Entering resource information 83
Defining resource calendars 84
Removing a resource allocation 99
Strategies to shorten the schedule 104
Adjusting table column width 119
Saving the project as an HTML document 143
Changing the current date of the active project 154
Tracking in-progress tasks 158
Microsoft Project help menu 172
Project 2 – Project Computerise 179
Selecting and editing in a dialog box 189
Using the Office Assistant 193
Appendices
The design of your manual is to support maximum learning for you during and after the course. Your manual is structured in visual levels and is easy to navigate. We would encourage you to review this manual a number of times after completing the course to refresh your memory and allow you to take full advantage of the many skills, tips and tricks to which you were introduced on the course. You cannot hope to be fully competent with everything that will be covered on this course immediately the course is finishes. Some practice, trial and error, by you after the course will help make these skills come readily to hand as you move on to master the software.
A chapter may consist of several tasks. A procedure documents the necessary steps to perform the task. A procedure may be followed by a workshop to practice the information learned. However the instructions are not specific to using a particular file.
Navigating your manual
Level Three is the detailed text
The Table of Contents at the beginning of your manual provides quick access to broad topic sections.
Terms and Symbols
Choose indicates that the user may have a variety of options
Click indicates that a tool button or command button is to be activated
Procedure | Details the steps required to perform a task or procedure |
---|
Revision | Details the steps for a section revision exercise |
---|
Tip: Provides a useful hint or information about using a related function. |
---|
Caution: Details possible negative consequences of performing an action. |
---|
Minimise risk of developing RSI-related complaints by taking the following into consideration:
Work behind a computer no more than 5 to 6 hours per day. This includes the hours you work with a computer at home
Alternate between easy and difficult tasks
Take regular short breaks and briefly leave the work station
Setting up the workstation
Height of the sitting position
Check the circulation to your upper legs and knees is not restricted. Angle the upper and lower leg approximately 90 degrees with the lower legs vertical.
Back support
Adjust the height of the back of the chair to support the lower part of the back
The arm rests
The work surface or desk
If the work surface is too low, blocks or telescopic legs may be a solution, but make sure there is sufficient leg room
Reading and writing activities
The area of the table used for reading and writing activities is at a good height if, with relaxed upper arms hanging downwards, the work surface is a few centimeters above elbow height.
Monitor and accessories
The monitor
The keyboard
Place the keyboard 8 to 10 cm away from the edge of the work surface and sit straight in front of it
The keyboard should not be too high; otherwise the work surface will no longer provide any support
The document holder
The mouse
Use the function keys wherever possible to avoid using the mouse. The Help function on the computer will automatically indicate the alternatives. When using the keyboard allow your fingers to rest on the keys
A good mouse is not too big to cause the hand to be bent backwards. This position can result in a great deal of stress on the joint. People with small hands may find a wrist support helpful
Use the mouse with the alternate hand from time to time
Allow the edge of your palm to rest on the mouse pad. An ergonomically-designed mouse ensures that the hand and wrist are in the most natural position. Hold the mouse in the front of your hand and allow the fingers to rest on the mouse buttons in a relaxed manner
Climate in the workplace
Because (computer) equipment produces a fair amount of heat, the climate in the workplace needs to be regulated to ensure that dry air and heat are not the cause of problems.
Laser printers and photocopy machines which are used frequently should ideally be placed in a ventilated room due to heat and dust production.
Home situation
Avoid carrying out activities which aggravate the pain such as cycling, mopping the floor, ironing, carrying shopping, playing piano/violin
Make sure you alternate sufficiently between rest and movement
Exercises to prevent RSI
A good starting position for these exercises is as follows:
Sit or stand with a straight back
Stretch your arms up and make yourself as tall as possible.
Keep your shoulders low. Imagine your shoulder joint is a clock. Make circular movements with both shoulders. First 10 circles in a forwards movement and then 10 circles backwards. Do this slowly and focused. Feel the effect it is having.
Rotate your hands from the wrists (to the left and the right).
Spread out and then tighten your fingers into a fist a number of times.
Using a product such as Microsoft Project gives you control of the management of projects, a task managed previously by sheets of paper on the office walls. This is a demanding and intensive two-day course that uses both instructor led and hands-on exercises.
Course prerequisites
A sound working knowledge of other Microsoft Office applications, an understanding of basic project management principles, and some experience with spreadsheet operations are highly desirable to gain the most out of this course.
Course aim
Course objectives
Set up and use Project and Resource calendars.
Understand the critical path.
Generate standard project reports.
Record, track and evaluate progress throughout the life of the project.
Objectives
Understand what project management is, and the importance of project planning
Know how Microsoft Project keeps track of information
What is a project?
Projects have the following features:
A one-time goal with specific and measurable objectives (what is the stated goal of the project?)
What is project management?
Project management can be broken down into the following activities:
Identify the tasks needed to complete the project successfully
Advantages of using Microsoft Project
Microsoft Project is a powerful, flexible tool that has been specifically designed to help you to plan, control and stay on top of even the most complex projects.
Microsoft Project will help you automate many of the procedures involved in effective project management. It will help you to:
Calculate and create a working schedule based on information you provide
Produce professional-looking, detailed reports to allow effective communication with all project stakeholders
General guidelines and project manager responsibilities
Motivate people to cooperate in the project. Microsoft Project like all other computer programs cannot compensate for ineffective people skills
Establish the role as coordinator of the project planning at the very beginning, and then make the planning stage a group effort as much as is possible
Set calendar information such as working days, working hours, public holidays and other periods of no work
As the project progresses, the Project Manager will be responsible for inputting task progress information including:
Once this is done, Microsoft Project will:
Compare actual dates and future schedule with the baseline plan to identify delays
How Project manages the information
A list of information about all of the tasks involved in the project (task information)
A list of information about all of the resources involved in the project (resource information)
In Microsoft Project, these individual pieces of information are known as fields.
It would be very difficult for a project manager to work with all of this information if it was all displayed on the screen at the same time. Microsoft Project uses a hierarchical structure to display the information in a more manageable form:
Changing the view, table, filter and/or group enables the user to display different degrees/levels of information in a format appropriate for their specific needs.
Starting Microsoft Project
When Microsoft Project is first started, a new blank project is displayed with the Gantt chart view.
To start Microsoft Project |
---|
Microsoft Project application window
Figure - Microsoft Project window, Gantt chart view
Use the Minimise, Restore and Maximise buttons to manage the windows of files and the application. Use the Close button to close the application.
Figure - Standard toolbar as a floating palette.
The New Project task pane
Note: The drop down arrow on the top right of the task pane displays Basic Search. |
---|
Figure - Basic Search task pane.
When the task pane is closed with the close button on the top right corner, the Project Guide task pane is displayed.
The Project Guide task pane
Figure - Project Guide toolbar.
Tip: Choose the Tools Menu, Options, Interface panel and Project Guide settings to switch off the Project Guide. |
---|
Close the Basic Search task pane.
Choose buttons on the Project Guide toolbar to view the different task panes.
Managing toolbars
To display toolbars |
---|
Right mouse click on any toolbar.
Choose the toolbar required with a left-mouse click.
To move toolbars |
---|
To resize the toolbar |
---|
Click and drag on the right edge of the toolbar.
Hide the drawing toolbar.
Opening an existing project file
Project opens files in the same manner as other Microsoft applications.
To open an existing Project file |
---|
Close the blank file with the Close button.
Open the file Residential Construction.
Project menus
Figure - Project Menu toolbar
Listed in the table below are the functions of the menus.
Menu | Function |
---|---|
File | Project file management, printing and quitting the program. |
Edit | Text editing options (cut, copy, paste), clearing, task linking, search and replace. |
View | Selection of project views, reports, toolbars and screen size (zoom). |
Insert | Add or insert tasks, resources, and OLE objects. |
Format | Adjust the font, format or layout of items in the project windows. |
Tools | A number of software ‘tools’ ranging from spellchecker to customising Microsoft Project. |
Project | Setting the start date, sorting and filtering. |
Collaborate | Share information with others using email, servers and Project centre |
Window | Windows options such as hide, new, arrange and split. |
Help | Gives access to the extensive help system, including the Answer Wizard and Tutorials. |
Navigating with the keyboard
Table - Keyboard commands to navigate.
Workshop | Navigating the project screen |
---|
Using the file Residential Construction, practice some of the keyboard navigation techniques listed above.
Using views
Resource views
Assignment views (often called ‘Usage’ views)
Applying views
Views may be selected from the View menu or the View Bar on the left of the screen if it is visible.
Select the View menu.
Figure - View Bar.
Gantt chart view
Figure - Gantt chart View.
Tip: To view the selected task on any timescale, click the ‘Go To Selected Task’ button on the Standard toolbar. | |
---|---|
Tip: To quickly move to the Project start date on the Gantt Chart timescale, press Alt+Home. |
Working with the Gantt chart view
The Gantt chart view can be manipulated by:
Use the Zoom In
or Zoom Out
buttons on the Standard toolbar.
To align the Gantt chart with a task: |
---|
Select the task.
Figure - Gantt Chart with the Task Form displayed
Tip: With the Task Frm displayed in the lower pane, selecting a task in the Gantt chart allows details to be viewed in the Task Form. |
---|
Revision | Check your knowledge |
---|
What are the three types of information displayed in project tables?
Describe the display hierarchy used by Microsoft Project:
Level 1 –
Level 2 –
Level 3 –
Level 4 –
Creating the project plan using Microsoft Project is an exciting and rewarding process. It must be remembered however that Microsoft Project cannot do the planning for the project manager. It is still necessary to identify the tasks that need to be undertaken, their estimated durations and, most importantly, the many and varied relationships between those tasks.
Microsoft Project will greatly assist in modelling the plan once all this information is entered.
Objectives
Name, save and assign passwords to the Project file
Recognise the types of tasks and enter task information
Identify and alter the critical path
Establishing basic project information
The first set of tasks involved in setting up the project plan includes:
Setting project information
The Project Information dialog box allows the project manager to set key details concerning the project. This includes the project start or finish date and the default project calendar.
The project start date
Setting the project start date will enable the project to be planned to start on a date other than today’s date (the default start date). Changes to the start date may be made at any time.
To set the project start date: |
---|
The Project Information dialog box appears
Choose the project start date from the Start date drop-down list.
The project calendar
Each project will have a default project calendar on which the schedule is initially based.
Note: A project can make use of many different calendars if necessary however it must still have a single project calendar defined in the Project Information dialog box. |
---|
Choose the Project menu.
Workshop | Setting the project start date: |
---|
Start a new, blank project file.
Using the Project Information dialog box, set the project to begin on a date designated by the instructor.
Entering file properties
Select the Summary tab.
Enter the required information.
Title | This is used to identify the project in master projects. It is essential to do this for duplicate projects. The title can be different from the actual filename. |
---|---|
Subject | This adds a subject to use when searching for a specific file, type the subject of the file in the Subject box. Use this property to group similar files together so that you can search for all files that have the same subject. |
Author | The author of the project file. |
Manager | To add a manager name to use when searching for a specific file, type a name in the Manager box. |
Company | To add a company name to use when searching for a specific file, type a company name in the Company box. |
Item | Item description. |
Category | To add a category to use when searching for a specific file, type a category in the Category box. |
Keywords | To create keywords to use when searching for a specific file, type the words in the Keywords box. |
Comments | To add comments to use when searching for a specific file, type your remarks in the Comments box. This will display against the project summary task. |
Save preview picture | To save a picture of the first page of a file for previewing in the Open dialog box, select the Save Preview Picture check box. |
Hyperlink base | Used to indicate the main “address” or path of the hyperlinks used in the project. This can be a link to another file on the computer or server or a link to a location on the World Wide Web. |
Project Title: Office Relocation
Subject: Relocation
Author: (Your name)
Manager: (Your name)Enter other details that may be required for the project file.
Tip: The detail entered under the headings Project Title, Company, Manager and Comments can easily be included in printed project reports. |
---|
Changing working time
The working week is Monday through to Friday
No public holidays are listed
To alter the Standard calendar to enter a period of non work (Pre Project 2007): |
---|
Choose Nonworking time under Set selected date(s) to: to make the entire day non working
OR
The Pre Project 2007 Change Working Time dialog box includes:
For: | The list of available calendars. |
---|---|
Set | Working time for selected date(s). |
Use default | Select to reset the selected days and any working hours to their default settings. If the Default option button is selected while working with the Standard calendar, the selected days and any working hours on those days will revert to the Microsoft Project default settings. |
Nonworking time | Select to make the day or days of the week selected in the Calendar to be nonworking days. |
Working time | Select to make the day or days of the week selected in the Calendar to be working days. |
From | Type the beginning work time for any of the three periods. |
To | Type the ending work time for any of the three periods. |
New | Displays the Create New Base Calendar dialog box where a new project calendar can be created. |
Options | Displays the Options dialog box to set the number of hours in a working day in the Tools menu, Options, Calendar. |
Choose the Tools menu, Change Working Time.
Select the date on which the exception ends in the Finish column.
Click the Details button to set the specific details for this exception.
Figure - The Details for dialog box – Project 2007.
Workshop | Changing working time |
---|
Change the working time of the Standard calendar to include public holidays for your location that fall during the 6 month period following the chosen project start date.
Saving the project
The Save As dialog box appears
OR
Choose OK or press Enter.
Note: File names can be up to 255 characters, including spaces. Certain characters are not permitted, including / ? \ : * , “ < > |. |
---|
Password protecting files
Figure - Tools menu in the Save As dialog box (Project 2007).
Note: If a password is forgotten, the file can not be opened. Passwords are case-sensitive and they should only be used if considered essential. | |
---|---|
Tip: Save work on a regular basis. |
Project tasks
Identifying tasks
Create tasks that enable tracking of major action items, but don’t overburden the schedule with small, reasonably insignificant items
Include milestones to mark off points in the project
Understanding task duration
The duration assigned to a task is defined as:
‘Working time from the start of the task to the end of the task.’
Using elapse time
To define duration as elapse time enter the letter ‘e’ before the usual duration unit abbreviation e.g. enter ‘ed’ for ‘elapse days’.
Duration units
The following table summarises the different units of duration that can be used in Microsoft Project.
Abbreviation | Meaning | Default period |
---|---|---|
m or em | Minutes or elapsed minutes | 1 minute |
h or eh | Hours or elapsed hours | 60 minutes |
d or ed | Days or elapsed days | 8 hours |
w or ew | Weeks or elapsed weeks | 40 hours |
mo or emo | Months or elapsed months | 20 days |
Recording estimated durations
Entering tasks
Select the Task Name field in the Gantt Chart task table.
Type the task name.
Note: Once a task name has been entered, Microsoft Project sets an estimate tentative duration of one day. A Scheduled Start and Scheduled Finish date for the task is set, based on the task duration and the project start date. | |
---|---|
Tip: After entering a task name and duration, to see how it appears on the Gantt Chart, click the ‘Go to Selected Task’ button on the Standard toolbar. |
Milestones
Milestones are used to record a significant accomplishment or event — not to schedule work that must be done. A milestone is therefore a task that usually has no duration and is often connected to the end of another task.
Projects can be ‘filtered’ to show only milestones in the Gantt chart view.
To enter a milestone in the Gantt chart view: |
---|
Workshop | Entering tasks in the Gantt chart view |
---|
Save the file.
View the project on the Gantt chart time line. Note that you have a series of tasks starting at the same time.
Task splitting
To split a task in the Gantt chart view: |
---|
Choose the Edit menu, Split Task
In the timescale side of the Gantt Chart, position the pointer over the task bar for the task to be split.
Note: A task can be split into many parts. | |
---|---|
Note: When a link is made to a task that is split, the link is to the start or end of the task. A link cannot be created to a split portion of a task. |
Remove the split.
Save the file.
Viewing project statistics
To display project statistics: |
---|
OR
Display the Tracking Toolbar, and use the
Project Statistics button
Tip: Use the Project Summary report (View, Reports, Overview category) to print out the project statistics. |
---|
What is the current finish date and current duration?
What do you think these dates are based on at this time?
Task relationships
A task may have multiple predecessors and successors.
Types of relationships
Different types of relationships may be defined between tasks. The Finish-to-Start relationship is the most common link used in modelling projects.
Type of Link | Description | Example |
---|---|---|
The finish of the predecessor determines the scheduling of the date of the successor task. | Completion of a house foundation determines commencement of house frame. | |
Start-to-Start SS |
The start of the predecessor determines the scheduling of the start of the successor. | When moving house, schedule the movers to start loading boxes soon after the packers start disassembling equipment. |
The finish of the predecessor determines the scheduling of the finish of the successor. | The stories for a newsletter must be complete before the newsletter layout is finished. | |
The start of a predecessor task determines the scheduling of the finish of the successor task. | When preparing for an exam, most students schedule to finish studying when the exam starts. |
Table - Types of task relationships.
Setting up task relationships
Using the Predecessor field on a Task Table.
Double-click the successor task in the task table of the Gantt Chart.
Enter other relationships on their own line in the Predecessor’s table.
Choose OK.
Linking multiple tasks
To select tasks: |
---|
Drag the mouse down the tasks. This may be done on any field
OR
Click on the Link Tasks
button on the Standard toolbar.
Tip: The order in which tasks are added to the selection defines the order of the relationship. | ||
---|---|---|
Note: The toolbar button will always create a finish-to-start relationship. |
Unlinking tasks
At times it will be necessary to unlink tasks.
OR
Use Delete to remove the link in the predecessor field
Note: Deleting the entry in the predecessor field will break the links to all previous tasks. The toolbar button will remove only the link to the selected task. |
---|
Tip: Using mini-practice files is a simple way to see what project does when data is added. |
---|
Open Office Relocation 1.
Link Research Sites to the Project Start task in a Finish-to-Start relationship using the Task Information dialog box.
What do you think these dates are based on at this time?
View the predecessor’s field, and link the next 4 tasks by typing into the field.
Workshop | Editing links |
---|
Save the Project. View the Project Statistics for your project.
What is the current duration? ………………………
Lag and lead time
Figure - Tasks on the Gantt chart showing the effect of 2 days lag in a Finish-to-Start relationship.
Adding lag time
To add lag time in a task view: |
---|
The Task Information dialog box appears
Choose the Predecessors tab in the Task Information dialog box.
Figure - Task Information dialog box showing the Predecessors tab with Lag time entered.
Workshop | Using lag time |
---|
Open a new project file.
Set up both task2 and task3 as predecessors to task4. Make both relationships finish-to-start.
Experiment with adding 2 days lag time to each of the relationships.
Adding lead time
Choose the Predecessors tab.
Click on the Lag Field of the relevant predecessor task.
Note: Lead time is entered as duration. |
---|
Using the new practice file created previously, experiment with adding 3 days lead time to some (all) of the relationships).
Close the file without saving.
Workshop | Using lag and lead time |
---|
Workshop | Working with lag and lead time |
---|
Save the project file. View the Project Statistics for your project.
What is the current duration?
Viewing task drivers
If a baseline is not set Project displays the selected task’s scheduled start date, predecessor task(s), type of relationship between the tasks, the amount of lag or lead time, the selected task’s calendar, and any resource assignments for the selected task.
If a baseline has been set and actual information recorded, Project shows actual start date information in the Task Drivers pane.
Critical path management
What CPM does, through a relatively complex mathematical formula, is to analyse the difference between the timeframe set for the project and the project duration as calculated from the durations and relationships of each task. If there is a big difference, the program tries to locate those tasks that cannot be delayed. These tasks are then put on the critical path.
Critical path
The critical path of a project is that sequence of tasks adding up to the longest total time required to complete the project. The duration of the project is the total duration of these critical tasks. By definition therefore, the critical path is that sequence of tasks that have no slack time from project start to project finish.
Critical tasks
Changing the critical path
Strategies for changing the critical path include:
Reducing task durations
Non-critical tasks
Slack
Slack results from the calculations done by CPM scheduling to determine which tasks are critical and which are non-critical. A non-critical task can have two types of slack, free slack and total slack.
Free slack is the amount of time that a task can be delayed before it delays a successor task, and total slack is the amount of time that a task can be delayed before it delays the finish date of the entire project.
Displaying critical tasks in the Gantt chart
To display critical tasks in the Gantt chart: |
---|
Right-click the Gantt chart and choose Gantt Chart Wizard
Choose Next.
Choose Exit Wizard.
Workshop | Displaying the critical path in the Gantt chart. |
---|
Editing data
Once the initial project plan is developed it is likely that changes will need to be made. Editing data in Microsoft Project is a reasonably straight forward process however care must be taken to ensure that the project plan ‘remains intact’ following each change.
To edit a cell: |
---|
Select the cell.
Choose the Edit menu, Clear, All
OR
Press Delete on the keyboard
To delete a task: |
---|
Right-click the row heading (usually the task ID number).
The row heading context menu appears.
OR
Choose the Edit menu, Delete Task
To insert a task: |
---|
Choose the Insert menu, New Task
Using undo
To undo an action: |
---|
OR
Click the Undo
button on the Standard toolbar
Note: The Edit, Undo menu command changes to show which action can currently be undone. |
---|
Copying and moving tasks
Right-click the ID number to select the entire row.
The row context menu appears
Keyboard: Ctrl + C and Ctrl + V can be used to copy and paste selected task. |
---|
Click the row heading.
Click and drag the heading with Ctrl pressed down.
To move a task using the right-mouse context menu: |
---|
Right-click the row above which the copied row is required.
The row context menu appears
Workshop | Editing the project plan |
---|
Insert the following tasks into your schedule:
Note: Microsoft Project has set up FS links where it considers appropriate. This was not done for the Disconnect computers task as the links between the tasks between which it was inserted were other than simple FS links.
Attaching notes to tasks
Explanation of the chosen duration
Explanation of the use of lag and lead time
Rather than maintain this data in another location, for example, in a word processor, notes can be attached to each task using the Task Information dialog box. The notes window can contain up to 3,000 characters allowing a lot of information to be entered. These notes may then be printed from any task view.
To attach notes to tasks in any task view: |
---|
Double-click any cell of the task.
Figure - Task Information dialog box with Notes tab selected.
Workshop | Adding notes to tasks |
---|
Add a note to the task of Meet with Staff Associations to remind yourself that you should seek their input to the planning phase of the move and that you would like their advice concerning the best way to keep staff informed of the move.
Save the Project file.
What is the typical duration of a milestone?
How can project statistics be displayed?
With any project however, external constraints such as deliverable dates, meeting dates that have been ‘locked in’ and the demands of management and other projects can all impact on the dates on which tasks within the project have to start or finish. It will often be the case that the project has to be finished ‘no later than…’ a particular date as well. Microsoft Project needs to be provided with this additional scheduling information.
By default, Microsoft Project schedules each task to start as soon as possible - based on the starting dates of the project and the relationships that have been set up. However, by setting a constraint on a task the project manager is able to further define factors that impact on the scheduling of the task.
Objectives
Assign a task constraint
Remove a task constraint
Constraints
Types of constraints
The following table lists the eight types of constraints and their effects.
Constraint | Effect |
---|---|
As Soon As Possible | Schedules the task to begin as early as it can occur. (The default and a very flexible constraint.) |
As Late As Possible | Schedules the task to begin as late as it can occur in the schedule without delaying subsequent tasks. (A very flexible constraint.) |
Finish No Earlier Than | Schedules the task to finish on or after the constraint date. Use to ensure that a task will not finish before a certain date. |
Finish No Later Than | Schedules the task to finish on or before the constraint date. Use to ensure that a task will not finish after a certain date. |
Must Finish On | Schedules the task to finish on the constraint date. Anchors the task in the schedule. (One of the least flexible constraints.) |
Must Start On | Schedules the task to start on the constraint date. Anchors the task in the schedule. (One of the least flexible constraints.) |
Start No Earlier Than | Schedules the task to start on or after the constraint date. Use to ensure that a task will not start before a specified date. |
Start No Later Than | Schedules the task to start on or before the constraint date. Use to ensure that a task will not start after a specified date. |
Table - Constraint Types.
Soft and hard constraints
Setting a task constraint
To set a constraint in any task view: |
---|
The Task Information dialog box appears
Choose the Advanced tab.
If a Planning Wizard dialog box appears, choose the appropriate option to set the constraint as set above.
Removing a constraint
To remove a constraint in any task view: |
---|
The Task Information dialog box appears
Choose the Advanced tab in the Task Information dialog box.
Workshop | Applying and removing constraints |
---|
Remember to add task notes to explain why the constraints were set.
Close the file without saving.
Note what happens.
Scheduling conflicts
When a change is made to the project schedule that causes a conflict with a constraint, Project will display a Planning Wizard dialog box to inform the project manager that there is a scheduling conflict.
Workshop | Applying task constraints |
---|
Modify the schedule to allow for this.
Save the Project File.
Task Deadlines
If the completion date of a task on which a deadline is set passes the deadline, Project displays a symbol in the Indicators column.
Choose the Advanced tab.
Select a date and time for the deadline in the Deadline text box.
Workshop | Setting a task deadline |
---|
Use the file Office Relocation 1.
Enter a task deadline for the Project Complete milestone to reflect the Lease Expiry date used for the constraint in the earlier exercise.
Key points about constraints and deadlines
The first action for the project manager when considering a constraint is to see if it is possible to ‘negotiate your way out of it’
The language used by others will be a good indicator of the need for constraints. Examples include:
The need for constraints is likely to arise as the project progresses and milestones, key tasks etc. start to be ‘locked in’
Deadlines simply refer to a tasks end date and are ‘informational only’ as they do not restrict or impact on the project schedule in any way
Name the four hard constraints?
Name the two soft constraints?
Indenting detail tasks under major tasks assists in developing summary reports that show an overview of the project and in developing customised reports that focus on a phase or part of the project in more detail.
An outline also gives control over which tasks appear on the screen. Collapsing and expanding summary tasks can quickly shift the focus shifted from the big picture to the detail.
Objectives
Promote and demote tasks
Format an outline
Approaches to project planning
Top-down approach
Bottom-up approach
This approach involves listing all the task details, and then arranging the details into larger groups under the broader summary tasks.
The bottom up approach is useful for project managers who understand the detail of the project but who need to present information in a summarised form to other key stakeholders – many of whom do not need to see a high level of detail.
Summary tasks
Review at management level
Management approval
Figure - A list of tasks without Outlining
Values such as duration and cost are calculated automatically from each subordinate task
Summary tasks, and all of its subordinate tasks, can be cut, copied, moved or deleted as a group
Creating an outline
When tasks are demoted, Microsoft Project automatically summarises the information from the demoted tasks in the summary task.
As more tasks are demoted below a summary task, the information in the summary task is automatically updated to reflect the information in the current set of subordinate tasks.
Demoting tasks
To demote a task one level lower in the Outline: |
---|
Select the tasks to be demoted.
Click on the Indent button
Promoting tasks
Figure - Outline view showing summary tasks.
Caution: Using too many levels of outline indentation (usually more than three or four) makes it difficult to see the entire schedule on-screen. In fact, a very detailed project outline may indicate that you need to rethink the scope of the project and break it into smaller, more manageable projects. |
---|
New Summary Task | Before |
---|---|
Planning Phase | Research Office Requirements |
Modification Phase | Modify New Site |
New Stationery Phase | Design New Stationery |
New Phone System Phase | Choose New Phone System |
Uplift Phase | Distribute Boxes |
Delivery & Unpack Phase | Move Boxes |
Reformat the outline as you wish, including WBS codes.
Save the project file.
Outline options
Select or clear the appropriate check box in the Outline options section of the View page.
Choose OK.
Indent name | Select to indent the tasks to reflect their levels. |
---|---|
Show summary tasks | Select to show all summary tasks. This check box must be selected to show the outline buttons. |
Project summary task | Select to display project-level summary tasks. This is particularly useful when viewing consolidated projects. |
Show outline number | Select to display the outline number to the left of each task. |
Show outline symbol | Select to show a plus sign (+) next to summary tasks that have subordinate tasks, and a minus sign (-) next to tasks with no subordinate tasks. |
Collapsing and expanding an outline
Collapsing or expanding summary tasks to hide or display their subordinate tasks can control the level of detail of a project that is displayed on the screen.
To collapse part of an outline: |
---|
Select the summary tasks for the part of the outline to be collapsed.
Click the Show Subtasks button.
To expand the outline for the entire project: |
---|
Click on the Show Subtasks button.
Creating a Project Summary Task
The project summary task is at the start of the task list. The task name comes from the project title entered in the properties box.
To display the summary task: |
---|
Work breakdown structure
More detailed outline structures can be defined within Project to fit with standards used within the organisation.
Revision | Check your knowledge |
---|
The outlining capabilities allow the user to use either a
Or
approach to building your project.
The Show All Tasks button expands the outline for the?
Mid course revision exercise
At this stage of the course it is a good idea to consolidate what has been covered and create your own project. Add summary headings and subtasks as required.
Modify the Standard Calendar as required.
Create summary tasks and add sub tasks as required.
Working with resources
Resources are needed to complete tasks. They may include people and assets that must be assigned to do the work of tasks. Resources can include the members of the project team, consultants, other external agencies, equipment and materials. Within Microsoft Project, the focus should be on items that must be managed for the project to achieve its objectives, especially those resources that are in short supply or are limited.
Objectives
Correctly assign the different types of resources
Access and update resource calendars
Identifying resources
Determine the cost of each task and the project as a whole
Resource types
Resources may be people or equipment, materials (Project 2000 +) or costs (Project 2007). Considerable attention is normally paid to the management of human resources in a project however project managers should not ignore other resources that need to be managed to achieve the project goals.
Viewing resource information
Information about resources is maintained in resource fields within the project. This information can then be accessed by all tasks in one, or more, projects.
Resource Sheet view
The Resource Sheet view is similar to a table or spreadsheet style view and is used to enter and review resource summary information or creating text reports of resources.
Resource Name | Name for the resource. |
---|---|
Type | Work, material or cost. |
Material Label | For material resources only - enter the name of the units to be used. |
Initials | Shows the first character of the resource name, unless an abbreviated name for the resource is typed. Initials can be used in the Resource Initials field to assign resources to tasks rather than the full name. |
Group | Group name for this resource. Group names allow resource categories for your project and can be used for sorting and filtering. |
Max Units | For work resources only – the total quantity of the resource that is available. The default percentage is 100%, but a value between 0% and 1,000,000% can be entered. For a single unit resource, 100% means this resource is available to work full-time on this project. If resources are grouped, enter a percentage greater than 100%. For example, to indicate two full-time writers and one part-time writer enter 250%. |
Std Rate | Standard wage, salary, or rate for the resource. |
Ovt Rate | Overtime rate for the resource. |
Cost/Use | Type the per use cost of each resource unit. |
Accrue At | Select the accrual method for actual costs. |
Start | Actual costs are incurred when a task using this resource starts. |
End | Actual costs are incurred when remaining work is zero. |
Prorated | Costs are incurred as work is completed on the task. |
Base Calendar | Base calendar used by this resource. |
Code | Use this field for later use with sorting and/or filtering. |
Resource Information dialog box
More complete information on resources can be found in the resource information dialog box.
To access the resource information dialog box, double click on the resource name in the resource sheet view.
Entering resource information
To enter resources through the Resource Sheet view: |
---|
Choose the appropriate Resource Type.
Enter the appropriate Material Label.
Open Office Relocation 4.
Enter the following resources into the Resource Pool for your project and save the Project file.
Resource Name | Max Units | Type | Material Label | Group | Std Rate |
---|---|---|---|---|---|
Project Manager | 100% | Work | Admin | $250/hr | |
Managing Director | 100% | Work | Admin | $500/hr | |
Finance Manager | 100% | Work | Fin | $200/hr | |
Finance Staff | 1500% | Work | Fin | $120/hr | |
Personnel Manager | 100% | Work | Pers | $200/hr | |
Personnel Staff | 1000% | Work | Pers | $120/hr | |
Technical Staff | 200% | Work | Tech | $150/hr | |
Phone Company | 100% | Work | Ext | ||
Removalist | 100% | Work | Ext | ||
Fuel | Material | Litres | Cons | $1.35 | |
Hire Car | Material | Hire day(s) | Cons | $100 |
Defining resource calendars
The Resource Information dialog box appears
Choose the Working Time tab
Figure - Working Time tab of the Resource Information dialog box.
Base Calendar | Select the Calendar to apply. |
---|---|
Set working time for selected date(s): | Select day labels to choose a day through out the calendar. |
Set selected date(s) to: | |
Use default | Select to reset the selected days and any working hours to their default settings. |
Nonworking time | Select to make the day or days of the week selected in the Calendar nonworking days. |
Nondefault working time | Select to make the day or days of the week selected in the Calendar working days. |
If the Default option button is selected when working with a resource calendar which is based on the Standard calendar - the selected days and any working hours on those days revert to the settings on the Standard calendar. | |
Working Time | |
From | Type the beginning work time for any of the three periods. |
To | Type the ending work time for any of the three periods. |
Details | Checks the Outlook Contacts folder for schedules |
Assigning resources
Working times as defined by dates and times on the resource calendars
The process of assigning resources to tasks is quite straightforward. Microsoft Project gives several ways to do this, and some are described below.
Understanding resource units
A unit assignment of greater than 100% implies that more than one full time resource is being assigned to work on the task
If no value is entered for the units for a work resource, Project will supply the default value, 100%.
Using the Task Entry view
Adding resources with the Task Entry view
To assign resources using the Task Form: |
---|
Select the task in the Task table of the Gantt Chart.
Select the Resource Name field in the Task form.
Choose OK.
Choose Next to move to the next task.
Task ID | Name | Resource | Units |
---|---|---|---|
3 | Research Office Requirements | 50% 25% |
|
4 | Research Alternative Sites | 75% 25% |
|
5 | Shortlist Removalist Companies | 25% |
|
6 | Gain Management Approval | Project Manager |
|
7 | Plan Physical Aspects of Move | Project Manager | 75% |
8 | Meet with Staff Associations | Managing Director |
100% |
10 | Modify New Site | Project Manager | 10% |
Using the Assign Resources dialog box
This method is included here for your information, but its use is not recommended.
Resource list options | Expand to allow filtering of the list of available resources. |
---|---|
Name | Select a resource to assign to the selected tasks. |
R/D | Request/Demand. When preparing projects for resource substitution, specify whether the selected resource must do the task or whether any resource with the required skills can do the task. |
Units | Enter the average number of units of this resource that will be used on the selected tasks per day. |
Assign | Choose to add the resources named to the selected tasks. |
Remove | Choose to remove the resource assignments. |
Replace | Choose to replace the resource assignment selected. |
Figure - Using the Task Information dialog box for resource management.
Workshop | Updating resource calendars |
---|
A good view for entering resources is the:
When selecting resources for tasks, what should be kept in mind?
Often conflicts exist between the work that the available resources can undertake and the work required to complete the scheduled tasks.
This chapter will review the techniques available to change resource allocations, and to determine which resources may be over allocated.
Objectives
Resolve resource over allocations
Changing resource allocations
Resource allocation often presents the most difficulties when managing a project. It is easy to schedule a person into a number of tasks and then discover scheduling conflicts. At times it will be necessary to adjust the resource allocations of tasks to meet other demands placed on the resource in question or on the project itself.
Viewing resource work
Note: Using a right mouse click on the task form title bar will give a menu for different displays of information. |
---|
Resource Usage view
Figure - Resource Usage View.
Task Usage view
Resource Graph view
The Resource Graph view is a graphical display of resource usage over time.
View resource work in the Resource Usage, Task Usage and Resource Graph views.
Understanding resource work
Work measures the effort expended by the resources during the assignment. Work is always measured in hours in Microsoft Project, and it can be entered by the user or the initial value of work will be automatically calculated by Project.
Effort driven scheduling
In essence, once the initial resource assignment has been confirmed for a task, WORK IS KING. Changes to resource units will cause a change to task duration so that the same amount of work can still be completed.
For example:
When working with effort-driven scheduling, keep the following in mind:
The effort-driven calculations apply only after the first resources are initially assigned to the task. After the first resources are assigned, the work value doesn't change as new resources are assigned to or removed from the same task
Effort Driven scheduling calculations
Remembering that the duration of a task is defined as:
“Work time units from the start of the task to the end of the task”
Example of effort driven scheduling
Example: Preparing building site for foundations.
The working day is 8 hours, and more resources are added to the task at a later time. Note that the duration will be shortened.
Duration | Number of resources | Work done per day | Total work |
---|---|---|---|
10 days | 4 (400%) | 32 hours | 320 hours |
5 days | 8 (800%) | 64 | 320 hours |
Managing effort driven scheduling
Removing a resource allocation
Click on the resource to be removed on the bottom screen.(Task Form)
Press Delete.
Tip: Resources can also be removed using the Task Information dialog box. Choose the Resources tab, select the units text box for the resource to be removed and press the Delete key on the keyboard. |
---|
Replacing a resource
Choose the replacement resource from the drop-down list.
Choose OK.
Note: Project will apply the units allocated to the previous resource. |
---|
Changing resource units
Select the Units field of the resource to be changed and enter the revised number of units.
Choose OK.
Workshop | Editing resource allocations and managing effort driven scheduling |
---|
Experiment with changing task durations.
Add resources to the other tasks and experiment with effort driven scheduling.
Determining resource over allocation
Finding over allocations
Select the over allocated resource (the one in red).
Press Alt + Home to line up the daily allocations.
Figure - Resource Usage view, showing over allocations.
To see over allocations in the Resource Graph view: |
---|
Make the time frame on the right smaller with the zoom out button.
Open Office Relocation 7.
View the over allocations in the Resource Usage view.
Resolving over allocations
Use Resource Levelling.
Microsoft Project does not make the best decisions to resolve resource over allocation. It cannot substitute a resource on an over allocated task, change the resource units assigned to a task, or change the duration of a task.
Enter a delay to remove the work conflict
Change task relationships
Overtime Work
Assigning work to overtime
Assigning work to overtime can best be done using the Task Form from the Task Entry view.
|
To lay out the Task Form to show overtime: |
---|
Enter the number of hours work to be completed in overtime in the Ovt. Work text box for the appropriate resource.
Note: When assigning work to be done in overtime, do not reduce the value in the Work column. This is the total work to be done by that resource on the task and includes any work to be done during normal working hours PLUS any work to be done during overtime. |
---|
Project strategies
Strategies to shorten the schedule
Deleting or combining tasks
Break tasks into subtasks
Decrease task durations:
Shorten tasks on the critical path
If you add additional resources you also need to decrease the number of work hours for the previously assigned resources
Increase a resources work schedule:
Strategies to resolve resource over allocation
Remove a resource from a task that occurs at a time of over allocation
Reschedule that task to occur when the resource is available
Change the working hours in the resource calendar
Resolve resource over allocations automatically by levelling
Strategies to reduce project costs and manage cash flow
Revision | Check your knowledge |
---|
What is meant by Effort Driven scheduling?
What result will this have if more resources are added to a task?
Tables and filters are also provided to display selected task or resource information, focusing on particular elements of the project such as cost information for over budget tasks etc. Tables are used to display different fields of information within each record (task or resource) for example, cost fields and filters are used to display different records (tasks or resources) that meet criteria for example, all the tasks that are currently over budget.
By combining different views, tables and filters it is possible to view very specific, targeting information to make management of the project easier and reports more meaningful.
Objectives
Customise a view
Working with views
Changing from one view to another allows the project manager to view the project ‘from different angles’. For example, changing from the Resource Usage view to the Task Usage views provides a different view of how resources are being utilised within the project.
To add a view to the View menu: |
---|
Choose the View menu, More Views.
The More Views dialog box appears
Choose OK.
Choose Close.
Creating a new view
Project has two different view structures:
A single view displays a single window pane containing the view
To create a new single view: |
---|
Click New.
The Define New View dialog box appears
Choose the Table, Group and/or Filter for the new view.
Select Show in Menu to have the new view appear in the View menu.
The Define New View dialog box appears
Select Combination view and choose OK.
Choose OK.
Tip: A letter can be designated as the ‘hot key’ to choose the view from the View menu using the keyboard rather than the mouse. Type an ampersand (&) before the chosen letter in the view name. When the view is displayed in the menu, this letter is underlined to indicate that this character is used to select the table. | |
---|---|
Note: Not all views will be able to be displayed in the bottom pane of a combination view. If a view is unable to be displayed an error message will appear. |
Create a new combination view that allows you to fully utilise the Network views.
Name the new view Network Combo.
Customising a view
An existing view can be copied and customised should the original not suit the needs of the project manager exactly. As mentioned earlier, it is best to create a copy of an existing view and customising it rather than changing the original view.
To create a customised Gantt Chart: |
---|
Choose More Views from the view bar.
Check the Show in Menu box and select Apply.
Choose the Format menu, Gantt Chart Wizard.
Choose Format It.
Choose Exit Wizard.
Workshop | Creating a customised Gantt chart |
---|
Using the GanttChartWizard, format the Gantt chart to display the Critical path, the task name (name field) to the right of the Gantt bars and the task start date (start field) to the left of the Gantt bars.
View your changes. Make any other changes you may like to the My Critical Gantt view.
Customising the timescale for a view
To make detailed changes to the appearance of the timescale: |
---|
The Timescale dialog box appears
Select the number of tiers to display from the Timescale Options, Show box.
Choose the alignment from the Align box.
Repeat steps 2 - 5 for each tier.
Units | Divisions for the scales. |
---|---|
Count | Interval for unit labels to appear. |
Label | Select the format of the date in the label. |
Align | Controls text alignment between the tick marks. |
Show | Choose the number of tiers to display. |
Scale separator | Draws a line to separate the scales. |
Changing display of nonworking time
By default, Microsoft Project indicates nonworking time on the Gantt Chart View by shading.
Choose the Format menu, Timescale.
Select the Calendar to use.
Choose OK.
Draw: | |
---|---|
Behind task bars | Select to have the task bars of the Gantt Chart display over the top of the nonworking time pattern. |
Do not draw | Select to not have nonworking time displayed on the Gantt Chart. |
Color | Choose an appropriate colour. |
Pattern | Choose the required shading pattern. |
Calendar | Select the appropriate calendar. |
Experiment with various other timescales. Use the Zoom In and Zoom Out buttons.
What did you notice about the timescale once you use the Zoom In and Zoom Out buttons?
Note: The timescale displays non working time as shown on the Standard Calendar. If the project is using a different/custom calendar it will be necessary to change the calendar used to display non-working time in the Timescale dialog box if this is to be shown on the Gantt chart. |
---|
Working with tables
The data fields displayed
The column title
Applying a Table
For example, the tracking table may be displayed in the Tracking Gantt view.
Use a right mouse click on the blank square above the ID numbers.
To apply a table with the More Tables option: |
---|
The More Tables dialog box appears
Select the table required from the More Tables dialog box.
Note: The More Tables box offers tables not in the menus. |
---|
Figure - More Tables dialog box.
The More Tables dialog box includes:
Task tables
Schedule Displays scheduling information, including start and finish dates, late start and finish dates, free slack, and total slack
Summary Displays basic project information, including task duration, start and finish dates, percent complete, cost, and work
Baseline Displays information about what is planned during the design phase of the project. Baseline information is created at the time the baseline is set
Constraint Dates Used for locating tasks that have had constraints applied, whether they were applied intentionally or not
Resource tables
Cost Provides cost data by resource
Resource Entry Displays information about resources that are usually gathered when the resource pool is being created
Earned Value Using traditional project management calculation, this table is useful for comparing the budgeted work and costs with the actual cost of the work. All the values in this table are calculated. It is used for analysis only, not for entering or editing data
Export Like the Task Export Table, designed with exporting to another application in mind. Most of the resource fields, including many that are calculated, are displayed
Adjusting table column width
To adjust the column width of a table to fit the widest entry: |
---|
Inserting a column
Choose the required field from the Field name drop-down list.
Enter a title for the column in the Title box.
Figure - Column Definition dialog box.
The Column Definition dialog box includes:
Field Name | Choose the required field name from the pull down list. |
---|---|
Title | Enter an appropriate title for the column. If Title is left blank, the field name will be used as the title. |
Align title | Choose the appropriate alignment for the column title. |
Align data | Choose an appropriate alignment for the column data. |
Width | Enter the required column width. |
Best Fit | Choose to have Project determine the most appropriate column width to display all the information, including the column title for the column. |
Deleting a column
Note: The above changes will permanently change the definition of the table for use in this project only. |
---|
On the left of the Task Name field, add the WBS field.
Add the Text 1 field and name it Responsibility.
Save and keep the file open.
Working with filters
Filters identify and display only the tasks or resources (depending on the view) that match one or more criteria. All other tasks or resources are temporarily hidden.
Applying a filter
To apply a filter: |
---|
OR
Choose the Project menu, Filtered For, More Filters
To apply a filter with the More Filters command: |
---|
Choose Apply or Highlight.
Figure - More Filters dialog box.
The More Filters dialog box includes:
Note: Any view in the bottom pane of a combination view will not have any filters available. The bottom pane is already being filtered because it is controlled by what is selected in the top pane. | |
---|---|
Note: Any filters on the Project, Filtered For menu command that contain an ellipsis are interactive filters. | |
Tip: You can also apply an existing filter by using the Filter list box on the Formatting toolbar. |
AutoFilter
Choose the funnel button on the toolbar
On the columns to filter, click the drop-down list and select the required value.
Figure - AutoFilter field drop-down list.
Workshop | Applying filters |
---|
Using the file Office Relocation7, change to the Gantt Chart view.
Experiment with other filters.
Leave the file open.
Filter limitations
Highlighting a list does not work with the filter tool button on the formatting toolbar.
By using the Filter drop-down list on the Standard toolbar or the standard filters on the Project, Filtered For menu, successive filters cannot be selected to progressively narrow the selection of tasks or resources. For example; a filtered list for critical tasks which is then filtered for milestones, will show all milestones - critical or not.
List of task filters
Cost Greater Than Shows a prompt asking for the cost to be used in a test for tasks that are greater than that cost
Cost Overbudget Is a calculated filter that shows all tasks that have a cost greater than the baseline cost
Incomplete Tasks Shows all tasks that haven’t finished
Late/Overbudget Tasks Assigned To Displays a prompt for a resource name to be used in a test for tasks assigned to that resource where the task’s finish date is later than the baseline finish or the cost is greater than the baseline
Should Start/Finish By Prompts for a range of dates which are used to display tasks that should have started by the beginning date or should have finished by the end date
Slipped/Late Progress Displays tasks where the finish date is later than the baseline or the Budgeted Cost of Work Scheduled is greater than the Budgeted Cost of Work Performed
Tasks with Fixed Dates Shows all tasks that do not have the constraint As Soon As Possible or that have an actual start date
Tasks/Assignments With Overtime Displays all tasks where overtime work has been assigned
Using Resource in Date Range Is an interactive filter that shows all tasks that use the resource specified
Using Resource Displays all tasks that use the resource named by the user
List of resource filters
Cost Greater Than Shows resources where the cost is greater than the amount specified by the user
Cost Overbudget Is a calculated filter that shows all resources that have a scheduled cost greater than the baseline cost
Overallocated Resources Shows all resources that are overallocated
Resource Range Is an interactive filter that shows all resources with ID numbers within the range specified
Slipped/Late Progress Displays resources with tasks assigned where the finish date is later than the baseline or the Budget Cost of Work Scheduled is greater than the Budgeted Cost of Work Performed
Slipping Assignments Displays resources with tasks assigned that are not finished and whose scheduled finish date is later than the planned finish date
Work Overbudget Is a calculated filter that shows all resources with scheduled work greater than baseline work
The Organiser
The organiser is used to copy views and other Project objects to other files and the global template file. In this way, the work done to create custom calendars, views, table and filters can be shared amongst multiple projects or made available in the template for new projects.
Select each project file name in the Views available in list box – one on each side.
Select the view to be copied from the view list on one side.
Figure - Views tab of the Organizer dialog box.
Workshop | Copying a view between project files |
---|
Add the view “My Critical Gantt” to the project file Office Relocation 8.
Filters are applied using which menu?
Some examples of task and resource filters are:
Project has many features that integrate it with the Internet. Consistent with Word, PowerPoint, Excel and Access, Microsoft Project includes a Save as HTML feature which saves a HTML document that can be published to the Internet or to a corporate Intranet.
This is also a way of moving the content of reports into another application like Microsoft Word.
Objectives
Print a standard report
Save and view a project report as a HTML document
Printing the active view
Format the view. Make the view highlight important information by using formatting tools.
Set up and print the view. There are a number of page setup options such as headers, footers etc which can be added to the printed view.
Tip: In an effort to reduce waste paper, it is very important to view the output in Print Preview to be clear on exactly what is being printed before printing. |
---|
Tip: When printing a view that includes a time scale such as the Gantt chart, the time scale date range to be printed can be changed in the Print Preview dialog box. The default settings are to print from the project start date to the project finish date. |
---|
Print Preview
Print Preview can be accessed from:
The toolbar Print Preview
button
Page setup
The Page Setup dialog box contains the settings for the page layout, margins, legends, headers and footers and View options. Project maintains different page setup options for each view that can be printed. For example, the default page orientation option for printing the Gantt chart view is landscape where as for printing the Resource sheet view it is portrait.
Any changes made to these settings are remembered by Project so that they are available to print with the same layout every time.
Page tab
Figure - Page Setup dialog box showing the Page tab.
The Page Setup dialog box showing the Page tab includes:
Orientation | Select either Portrait or Landscape. |
---|---|
Scaling | Enter appropriate options for % scaling and to control the number of pages used for the print. |
Margins tab
Header and footer tabs
Figure - Page Setup dialog box showing the Header tab.
Alignment | Choose the appropriate tab before entering text for Left, Center or Right aligned pieces of text in the header. |
---|---|
Buttons | Click on a button to have the associated text included in the header. |
Add | Choose an item from the pull down list box and click Add to have the text associated with that item print in the header. |
The header and footer data buttons
Legend tab
The Page Setup, Legend tab, dialog box includes:
Alignment | Choose the appropriate tab before entering text for Left, Center or Right aligned pieces of text in the legend text. |
---|---|
Buttons | Click on a button to have the associated text included in the legend text. See the Header tab details above for information regarding each of the available buttons. |
Add | Choose an item from the pull down list box and click add to have the text associated with that item print in the legend text. |
Legend On | Select an option to have the legend appear on Every Page, a page by itself or to have no legend at all. |
Width | Enter a desired width for the legend text area. |
View tab
Copying the Gantt chart as a picture
An alternative to printing the Gantt chart from Project is to copy it as a picture which can then be pasted into a word processing document or a web page. Obviously this feature will work best for smaller projects that can be displayed appropriately on an A4 page or a single screen.
To copy the Gantt chart to the clipboard as a picture: |
---|
Use the zoom tool to reduce the Gantt chart to the desired timescale.
Choose OK.
The picture can then be pasted into Word from the clipboard.
Paste the clipboard contents into the document.
If the resultant page is unsuitable, redo the process choosing alternative options in the Copy Picture dialog box.
Reports
Printing a report
To print a report: |
---|
OR
In Project 2007, choose the Report menu, Reports
The report will open in print preview.
Make any page setup changes necessary.
Figure - Assignment Reports dialog box.
Workshop | Printing reports |
---|
Reports available in project
Saving the project as an HTML document
Microsoft Project 2007 has continued the development of a web interface for project files through the project web server. Using this product is not part of this course.
In versions of Project prior to Project 2007 the following can be done:
To save the project as an HTML document: |
---|
Navigate to the directory where the document is to be saved.
Name the file and choose Save.
Choose Save.
Note: The Import/Export map is automatically saved in the global.mpt file, and will be available for all future projects. |
---|
Figure - Export Wizard- Map Selection dialog box.
Figure - Export Wizard – End of Map Definition dialog box.
Use the file Office Relocation 8.
Viewing the project as an HTML document
To view the HTML document: |
---|
Click Open. Click OK.
Revision | Check your knowledge |
---|
Project information can be reported in one of two ways:
You can print:
Tracking the progress of a project from the planning phase to the commencement of the project through to completion involves updating the schedule regularly and comparing it to the original plan. This is done to identify which tasks are slipping, or which are starting or finishing early or on time. This process helps anticipate and correct schedule problems and assists in monitoring resource work and costs.
Tracking progress also helps answer questions such as:
Objectives
By the conclusion of this chapter you should be able to:
Set the project plan
Steps in tracking progress
Establish a baseline plan by saving your original schedule.
As the project progresses, enter the actual data for each task.
Creating a baseline plan
The baseline plan may be viewed and compared to the current schedule at any time with the Tracking Gantt.
Before setting the baseline plan, the project should be given a careful overview. The following items should be checked before a baseline is set:
The costs have been examined and reflect the real-life situation (where costs are being managed within the project).
The start and finish dates of the project are acceptable.
To save a baseline plan for the entire project: |
---|
The Save Baseline dialog box appears
Ensure that the Save baseline (Set baseline in Project 2007) option is selected.
Workshop | Saving the baseline plan |
---|
Open Office Relocation 8.
View the project in the Gantt chart view.
Changing a baseline plan
Often it may be necessary to alter baseline information before the commencement of a project, or during it. This would normally only happen when significant changes are made to the scope of the project.
It is important, and reassuring, to note however that Project will never change the baseline on its own.
Choose OK.
Tip: Selective changes can be made to a Baseline plan by saving the plan to ‘Selected Tasks’ only. |
---|
Preparing to track project progress
Tracking the project as it progresses can be an integral part of the success of a project. The project schedule should be updated with actual information at regular intervals by the Project Manager.
Future tasks – tasks that have not yet started.
The Tracking toolbar
Microsoft Project provides a custom toolbar to assist in tracking tasks known as the Tracking Toolbar.
Tracking Gantt view
Figure - Tracking Gantt View.
Changing the current date of the active project
By default, Microsoft Project uses the date provided by the computer's internal clock as the current date. At times however, it may be desirable to change this date so that the project can be analysed from a different time perspective.
To change the current date in the active project: |
---|
Change the current date for the project to halfway through the project.
This will be set by the instructor
Understanding actual information
Figure - Tracking table.
Tip: It is not necessary to display the actual fields in a view to update them. |
---|
Setting up tracking views
One layout that is quite successful involves the following elements:
the Tracking Gantt view (View menu, Tracking Gantt) with the
Figure - Tracking Gantt and Table, and Task form.
Use the file Office Relocation 8.
Tracking project progress
Tracking completed tasks
By definition, a completed task has:
an actual start date
tasks that started or finished earlier or later than scheduled
tasks that had a duration different from that scheduled
Workshop | Tracking completed tasks |
---|
Using the file Office Relocation 8 track the progress of the project as listed below.
Save and keep the file open.
Tracking in-progress tasks
An in-progress task is a task that has started, but is not yet complete.
In-progress tasks may be:
Project provides a number of tools to assist in tracking progress of in-progress tasks.
When updating in-progress tasks in Project the following simple rules apply:
Finally, if the task is behind schedule and the outstanding work is to be completed from the next working day, use the Reschedule Remaining Work
button on the Tracking toolbar to have Project reschedule the work and update the rest of the project accordingly.
Workshop | Tracking in-progress tasks |
---|
Using the file Office Relocation 8, update the schedule as follows:
Revision | Check your knowledge |
---|
…………………………………………………………………………………………………………
………………………………………………………………………………………………………..
Completed tasks fall into which 3 categories?
Multiple Projects and Resource Pools
Objectives
Create a resource pool
Link projects to a resource pool
Creating a resource pool
Open a new project file.
The Project Information dialog box appears
Show the Resource sheet view and enter the resource details.
Save the file.
Linking projects to a resource pool
To share resources with a pool: |
---|
Choose the Tools menu, Resource Sharing, Share Resources.
The Share Resources dialog box appears
Figure - Share Resources dialog box.
Open the files Applying Project and Computer Games.
Activate the file Applying project.
Choose Tools, Resource sharing, Share resources.
Viewing projects in the same window
A number of projects may be viewed in the same window. A new file is created that allows all files to be linked. The linking is automatic. The project may be altered from either file.
Project will ask if both files are to be updated.
To view projects in the same window: |
---|
Save the new file.
Figure - Projects in the same window.
Open the files Book 1 and Book 2.
Revision | Check your knowledge |
---|
What does Take Precedence mean with resource sharing?
What are the advantages of using subprojects?
Objectives
Use the Help menu to search for a particular topic
Use Point and Click Help
Use the Office Assistant
Using help to search for a topic
To search for a particular topic: |
---|
The Microsoft Project Help window appears
Select the Answer Wizard tab.
Figure - Microsoft Project Help Answer Wizard.
Microsoft Project help menu
The Help menu includes features to give assistance in ways other than the Help application.
The Office Assistant
To Show the Office Assistant: |
---|
Figure - Planning Wizard dialog. Figure - The Office Assistant.
Customising the Office Assistant
Figure - Office assistant context menu.
Hide | Choose to close the Office Assistant. |
---|---|
Options | Choose to set options for the Office Assistant. |
Choose Assistant | Choose to select a different assistant. |
Animate | Choose to have the assistant animated. |
Setting Preferences for the Office Assistant
Select a different office assistant from the gallery.
Point & Click Help
Point and click on the menu or area of the screen for which help is required.
Click away from the Help window to clear it off the screen.
Tip: It is also possible to gain access to point and click help by pressing Shift + F1. |
---|
Help on dialog boxes
Click on the Help Button.
Choose the required topic from the dialog box.
Printing help topics
To print a help topic: |
---|
Figure - The Options menu on the Help application.
Appendix B: Workshops
These exercises have been included to help develop speed and practical knowledge of Microsoft Project.
Project 1 – Busy Office Products Marketing
Scenario
Task
Start Date: | You decide |
---|---|
Title: | Marketing The Utility Office Computer |
Author: | you |
Company: | Busy Office Products |
Manager: | you |
Task Durations and Linking: The following table is a list of all the tasks in the project. Enter the durations and predecessors for each task.
Lag Time: Before task 7 (testing) can begin you would like a few of your colleagues to see a copy of the draft survey (task 6). Lag the start of task 7 by 2d after the finish of task 6.
Standard Calendar: Indicate the non-working days.
Project 2 – Project Computerise
The Scenario
The Organisation
The organisation has eight offices in different states. The Head Office is located in the city with the highest population not far from one of the sites. Each office has the same organisation structure. The seven functional area involved at each site in Project Computerise are Front Office and Reception, Pay and Personnel, Marketing and Conferences, Purchasing, maintenance and Accounting. Approximately 30 staff will need to be trained at each site.
Proposed Software Package
The organisation has decided to buy an integrated package that maximises the interfaces between the different functional areas. This will automate, for example, the exchange of data between Purchasing and Accounting. There are several integrated packages on the market.
Current Systems
Task
Start Date: | Your choice |
---|---|
Title: | Computerise |
Author: | You |
Company: | Your organisation |
Manager: | You |
Task Durations and Linking: The following table is a list of all the tasks in the project. Enter the durations and predecessors for each task.
Summary Tasks: Insert the following summary tasks:
Name | Before |
---|---|
Software Phase | Specify Software |
Site Modifications | Contract Finalisation |
Hardware Phase | Purchasing Hardware |
Training Phase | Train the trainer |
Implement New System | Parallel Running |
Tracking the project The project has started and it is time to update the project schedule with actual data. Today is the (you set the date). Enter the following completed tasks:
Task | Actual Data |
---|---|
Project Start | Started & Finished as scheduled |
Specify Software | Started on schedule, dur of 32d |
Evaluate Software | Started 2 days late, dur as planned (watch the dur, if it changes correct it) |
Contract Finalisation | Started on schedule, dur of 12d |
Site Preparation | As scheduled |
Purchase Hardware | As scheduled |
Install Hardware | As scheduled |
C
Commonly used Project keys
Accessing dialog boxes
Key | Description |
---|---|
Switch to the next tab in a dialog box | CTRL+TAB |
Switch to the previous tab in a dialog box | CTRL+SHIFT+TAB |
Move to the next option or option group | TAB |
Move to the previous option or option group | SHIFT+TAB |
Move between options in the active list box or between options in a group of options | UP ARROW and DOWN ARROW keys |
Perform the action assigned to the active button (the button with the dotted outline), or to select or clear the active check box | SPACEBAR |
Move to an option in a list box | The letter key for the first letter in the option name you want (when a list box is selected) |
Select an option, or to select or clear a check box | ALT+ letter, where letter is the key for the underlined letter in the option name |
Open the selected list box | ALT+DOWN ARROW |
Close the selected list box | ESC |
Perform the action assigned to the default command button in the dialog box (the button with the bold outline— often the OK button) | ENTER |
Cancel the command and close the dialog box | ESC |
Accessing menus
Note: Any command on a menu or visible toolbar can be selected with the keyboard. To select a command on a menu, press ALT to select the menu bar, press the underlined letter in the menu title that contains the required command and then press the underlined letter in the command name. To select a command on a toolbar, press CTRL+TAB until the toolbar is selected and then press TAB to select the toolbar command. |
---|
Accessing text boxes
Accessing toolbars
To | Press |
---|---|
Make the menu bar active | F10 or ALT |
Select the next or previous toolbar | CTRL+TAB or CTRL+SHIFT+TAB |
Select the next or previous button or the menu on the toolbar | TAB or SHIFT+TAB (when a toolbar is active) |
Open the selected menu | ENTER |
Perform the action assigned to the selected button | ENTER |
Enter text in the selected text box | ENTER |
Select an option from a list box or from a menu | Arrow keys to move through options in the list or menu, and then press ENTER to select the option you want (when a list box is selected) |
Accessing windows
Moving in the Network Diagram view
Description | Key |
---|---|
Move to a different Network Diagram box | Arrow keys |
Add Network Diagram boxes to the selection | SHIFT+Arrow keys |
Move a Network Diagram box (Note that manual positioning must be set first. Click Layout on the Format menu, and then click Allow manual box positioning.) | CTRL+Arrow keys |
Move to the top Network Diagram box in the view or project | |
Move to the lowest Network Diagram box in the project | |
Move to the left-most Network Diagram box in the project | HOME SHIFT+HOME |
Move to the right-most Network Diagram box in the project | |
Move up one window height | |
Move down one window height | PAGE DOWN SHIFT+PAGE DOWN |
Move left one window width | |
Move right one window width | |
Select the next field in the Network Diagram box | ENTER |
Select the previous field in the Network Diagram box | SHIFT+ENTER |
Navigating views and windows
Opening, saving, and closing files
Description | Key |
---|---|
New | CTRL+N or F11 |
Open | CTRL+O |
CTRL+P | |
Save | CTRL+S |
Save As | F12 or ALT+F2 |
Close | CTRL+F4 |
Exit | ALT+F4 |
Outlining a project
Selecting and editing in a dialog box
Description | Key |
---|---|
Extend the selection left by one character | SHIFT+LEFT ARROW |
Extend the selection right by one character | SHIFT+RIGHT ARROW |
Extend the selection to the end of the text | SHIFT+END |
Extend the selection to the start of the text | SHIFT+HOME |
Move between fields at the bottom of a form | Arrow keys |
Move down in a list | DOWN ARROW |
Move into tables at the bottom of a form | ALT+1 (left) or ALT+2 (right) |
Move left one character | LEFT ARROW |
Move right one character | RIGHT ARROW |
Move to any box, button, or option | ALT+ underlined letter in name |
Move to the end of the text | END |
Move to the next box, group, option, or button | TAB |
Move to the next option in group | RIGHT ARROW or DOWN ARROW |
Move to the next tab in a dialog box | Arrow keys |
Move to the next task or resource | ENTER |
Move to the previous box, group, option, or button | SHIFT+TAB |
Move to the previous option in a group | LEFT ARROW or UP ARROW |
Move to the previous task or resource | SHIFT+ENTER |
Move to the start of the text | HOME |
Move up in a list | UP ARROW |
Select an option, check box, or button | SPACEBAR |
Show a list in a box | ALT+DOWN ARROW |
Editing in a view
Moving in a view
Description | Key |
---|---|
Move to the beginning of a project (timescale (timescale: The time period indicator at the top of the Gantt views, the Resource Graph view, the Task Usage view, and the Resource Usage view. You can customize it to show up to three tiers that can display various time units: top, middle, and bottom.)) | ALT+HOME |
Move to the end of a project (timescale) | ALT+END |
Move down in a selection | ENTER |
Move up in a selection | SHIFT+ENTER |
Move down one page | PAGE DOWN |
Moved down one row (row: A horizontal series of side-by-side fields displaying a common category of information. A row in Project typically consists of information about a task, resource, assignment, or some such detail as work and cost.) | DOWN ARROW |
Move left one field (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) | LEFT ARROW |
Move left one page | CTRL+PAGE UP |
Move right one field | RIGHT ARROW |
Move right one page | CTRL+PAGE DOWN |
Move the timescale left | ALT+LEFT ARROW |
Move the timescale right | ALT+RIGHT ARROW |
Move to the first field in a row | |
Move to the first row | CTRL+UP ARROW |
Move to the first field of the first row | CTRL+HOME |
Move to the last field in a row | END or CTRL+RIGHT ARROW |
Move to the last field of the last row | CTRL+END |
Move to the last row | CTRL+DOWN ARROW |
Move to the end of the information | CTRL+END |
Move to the start of the information | CTRL+HOME |
Move up one page | PAGE UP |
Move up one row | UP ARROW |
Move the next program window to the top | ALT+TAB |
Move the next program window | ALT+ESC |
Move the previous program window to the top | ALT+SHIFT+TAB |
Move the previous program window | ALT+SHIFT+ESC |
Moving in the side pane
Selecting in a view
Extend the selection down one page | SHIFT+PAGE DOWN |
---|---|
Extend the selection up one page | SHIFT+PAGE UP |
Extend the selection down one row | SHIFT+DOWN ARROW |
Extend the selection up one row | SHIFT+UP ARROW |
Extend the selection left | SHIFT+LEFT ARROW |
Extend the selection right | SHIFT+RIGHT ARROW |
Extend the selection to the first field in a row | SHIFT+HOME |
Extend the selection to the last field in a row | SHIFT+END |
Extend the selection to the start of the information | CTRL+SHIFT+HOME |
Extend the selection to the end of the information | CTRL+SHIFT+END |
Extend the selection to the first row | CTRL+SHIFT+UP ARROW |
Extend the selection to the last row | CTRL+SHIFT+DOWN ARROW |
Extend the selection to the first field of the first row | CTRL+SHIFT+HOME |
Extend the selection to the last field of the last row | CTRL+SHIFT+END |
Select all rows and columns | CTRL+SHIFT+SPACEBAR |
Select a column | CTRL+SPACEBAR |
Select the next field | TAB |
Select the previous field | SHIFT+TAB |
Select a row | SHIFT+SPACEBAR |
Move within a selection down one field | ENTER |
Move within a selection up one field | SHIFT+ENTER |
Move within a selection right one field | TAB |
Move within a selection left one field | SHIFT+TAB |
Selecting and editing in the entry bar
Using a timescale
Description | Key |
---|---|
Move the timescale left one page | ALT+PAGE UP |
Move the timescale right one page | ALT+PAGE DOWN |
Move the timescale to beginning of the project | ALT+HOME |
Move the timescale to end of the project | ALT+END |
Scroll the timescale left | ALT+LEFT ARROW |
Scroll the timescale right | ALT+RIGHT ARROW |
To show smaller time units | CTRL+ / (slash on the numeric keypad) |
To show larger time units | CTRL+* (asterisk on the numeric keypad) |
Using the Office Assistant
Baseline
Changing, 152
Resource, 84
Conflicts
Removing, 63
Setting, 61
Reducing, 106
Critical Path
Deadlines
Tasks, 64
Properties, 23
Files
Limitations, 125
Resource, 127
Copy as picture, 138
Wizard, 50
Help Menu, 172
Inserting
Lead time, 44
Lead Time, 42
Milestones, 34
Navigating
Attaching, 55
Office Assistant, 172
Options, 74
WBS, 76
work, 103
Page Setup, 133
Print Preview, 133
Printing
Project
Definition, 2
Responsibilities, 3
Projects
Protection
Password, 29
Setting up, 38
Types, 37
Resources
Assigning, 86, 88
Managing, 93
Overallocation, 101
Work, 94, 96
Saving, 28
Effort Driven, 97
Searching
Starting
MS Project, 5
Tables
Adjusting column width, 119
Task, 118
Task
New Project, 7
Project Guide, 9
Deadlines, 64
Deleting, 52
Promoting, 73
Slack, 49
Toolbars
Managing, 10
Setup, 153
Toolbar, 153
Creating, 109
Customising, 111
Resource Usage, 94
Task Entry, 87
Tracking Gantt, 154
Using, 13
Overtime, 103
Resources, 96