Microsoft project 2013 tutorial pdf

Microsoft Official Academic Course

Microsoft Project 2013

Microsoft® Official Academic Course

Microsoft® Project 2013

Credits

EDITOR Bryan Gambrel DIRECTOR OF SALES Mitchell Beaton EXECUTIVE MARKETING MANAGER Chris Ruel MICROSOFT STRATEGIC RELATIONSHIPS MANAGER Gene Longo of Microsoft Learning eXperience EDITORIAL PROGRAM ASSISTANT Allison Winkle SENIOR PRODUCTION AND MANUFACTURING MANAGER Janis Soo ASSOCIATE PRODUCTION MANAGER Joel Balbin CREATIVE DIRECTOR Harry Nolan COVER DESIGNER Tom Nery PHOTO EDITOR Felicia Ruocco TECHNOLOGY AND MEDIA Wendy Ashenberg

Cover Photo Credit: Getty Images, Inc.

This book was set in Garamond by Aptara, Inc. and printed and bound by Bind Rite Robbinsville. The covers were printed by Bind Rite Robbinsville.

Copyright © 2013 by John Wiley & Sons, Inc. All rights reserved.

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc. 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030-5774, (201) 748-6011, fax (201) 748-6008. To order books or for customer service, please call 1-800-CALL WILEY (225-5945).

Microsoft, ActiveX, Excel, InfoPath, Microsoft Press, MSDN, OneNote, Outlook, PivotChart, PivotTable, PowerPoint, SharePoint, SQL Server, Visio, Windows, Windows Mobile, and Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Other product and company names mentioned herein may be the trademarks of their respective owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred.

The book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, John Wiley & Sons, Inc., Microsoft Corporation, nor their resellers or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

Founded in 1807, John Wiley & Sons, Inc. has been a valued source of knowledge and understanding for more than 200 years, helping people around the world meet their needs and fulfill their aspirations. Our company is built on a foundation of principles that include responsibility to the communities we serve and where we live and work. In 2008, we launched a Corporate Citizenship Initiative, a global effort to address the environmental, social, economic, and ethical challenges we face in our business. Among the issues we are addressing are carbon impact, paper specifications and procurement, ethical conduct within our business and among our vendors, and community and charitable support. For more information, please visit our website: www.wiley.com/go/citizenship.

ISBN 978-047-0-13312-5

Printed in the United States of America

10 9 8 7 6 5 4 3 2 1

www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

| iii

Wiley’s publishing vision for the Microsoft Official Academic Course series is to provide students and instructors with the skills and knowledge they need to use Microsoft technology effectively in all aspects of their personal and professional lives. Quality instruction is required to help both educators and students get the most from Microsoft’s software tools and to become more productive. Thus our mission is to make our instructional programs trusted educational companions for life.

To accomplish this mission, Wiley and Microsoft have partnered to develop the highest quality educational programs for Information Workers, IT Professionals, and Developers. Materials created by this partnership carry the brand name “Microsoft Official Academic Course,” assuring instructors and students alike that the content of these textbooks is fully endorsed by Microsoft, and that they provide the highest quality information and instruction on Microsoft products. The Microsoft Official Academic Course textbooks are “Official” in still one more way – they are the officially sanctioned courseware for Microsoft IT Academy members.

The Microsoft Official Academic Course series focuses on workforce development. These programs are aimed at those students seeking to enter the workforce, change jobs, or embark on new careers as information workers, IT professionals, and developers. Microsoft Official Academic Course programs address their needs by emphasizing authentic workplace scenarios with an abundance of projects, exercises, cases, and assessments.

The Microsoft Official Academic Courses focus on real skills for real jobs. As students work through the projects and exercises in the textbooks, they enhance their level of knowledge and their ability to apply the latest Microsoft technology to everyday tasks. These students also gain resume-building credentials that can assist them in finding a job, keeping their current job, or in furthering their education.

The concept of lifelong learning is today an utmost necessity. Job roles, and even whole job categories, are changing so quickly that none of us can stay competitive and productive without continuously updating our skills and capabilities. The Microsoft Official Academic Course offerings, and their focus on Microsoft certification exam preparation, provide a means for people to acquire and effectively update their skills and knowledge. Wiley supports students in this endeavor through the development and distribution of these courses as Microsoft’s official academic publisher.

Joe Heider General Manager and Senior Vice President

Foreword from the Publisher

www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

Welcome to the Microsoft Official Academic Course (MOAC) program for Microsoft Project 2013. MOAC represents the collaboration between Microsoft Learning and John Wiley & Sons, Inc. publishing company. Microsoft and Wiley teamed up to produce a series of text- books that deliver compelling and innovative teaching solutions to instructors and superior learning experiences for students. Infused and informed by in-depth knowledge from the crea- tors of Microsoft Project and Windows, and crafted by a publisher known worldwide for the pedagogical quality of its products, these textbooks maximize skills transfer in minimum time. Students are challenged to reach their potential by using their new technical skills as highly productive members of the workforce.

Because this knowledgebase comes directly from Microsoft, creator of Microsoft Project 2013, you are sure to receive the topical coverage that is most relevant to students’ personal and pro- fessional success. Microsoft’s direct participation not only assures you that MOAC textbook content is accurate and current; it also means that students will receive the best instruction possible to enable their success in the workplace.

The Microsoft Official Academic Course Program The Microsoft Official Academic Course series is a complete program for instructors and institu- tions to prepare and deliver great courses on Microsoft software technologies. With MOAC, we recognize that, because of the rapid pace of change in the technology and curriculum devel- oped by Microsoft, there is an ongoing set of needs beyond classroom instruction tools for an instructor to be ready to teach the course. The MOAC program endeavors to provide solutions for all these needs in a systematic manner in order to ensure a successful and rewarding course experience for both instructor and student – technical a nd curriculum training for instructor readiness with new software releases; the software itself for student use at home for building hands-on skills, assessment, and validation of skill development; and a great set of tools for delivering instruction in the classroom and lab. All are important to the smooth delivery of an interesting course on Microsoft software, and all are provided with the MOAC program. We think about the model that follows as a gauge for ensuring that we completely support you in your goal of teaching a great course. As you evaluate your instructional materials options, you may wish to use the model for comparison purposes with available products.

Preface

iv | www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

Illustrated Book Tour

Pedagogical Features

Many pedagogical features have been developed specifically for Microsoft Official Academic Course programs. Unique features of our task-based approach include a Lesson Skill Matrix Workplace Ready, and Step by Step exercises; and three levels of increasingly rigorous lesson- ending activities: Competency, Proficiency, and Mastery Assessment.

Presenting the extensive procedural information and technical concepts woven throughout the textbook raises challenges for the student and instructor alike. The Illustrated Book Tour that follows provides a guide to the rich features contributing to Microsoft Official Academic Course program’s pedagogical plan. Following is a list of key features in the lessons, which are designed to prepare students for success on the certification exams and in the workplace:

• Lesson Skill Matrix: Each lesson begins with a lesson skill matrix. This feature outlines all the topics covered in the lesson.

• Business Cases: Each lesson features a real-world business case scenario that places the software skills and knowledge to be acquired in a real-world setting.

• Software Orientation: Every lesson includes a software orientation. This feature pro- vides an overview of the software features students will be working with in the lesson. The orientation will detail the general properties of the software or specific features, such as a ribbon or dialog box, and it includes a large, labeled screen image.

• Step-by-Step Instructions: Concise and frequent step-by-step instructions teach stu- dents new features and provide an opportunity for hands-on practice. Numbered steps give detailed instructions to help students learn software skills. The steps also show results and screen images to match what students should see on their computer screens.

• Illustrations: Screen images provide visual feedback as students work through the exercises. The images reinforce key concepts, provide visual clues about the steps, and allow students to check their progress.

• Button Images: When the text instructs a student to click a particular button, an image of that button is shown in the margin or in the text.

• Key Terms: Important technical vocabulary is listed at the beginning of the lesson. When these terms are used later in the lesson, they appear in bold italic type and are defined. The Glossary contains all of the key terms and their definitions.

• Reader Aids: Engaging point-of-use reader aids, located throughout the lessons, tell students why this topic is relevant (The Bottom Line), provide students with helpful hints (Take Note), show alternate ways to accomplish tasks (Another Way), or point out things to watch out for or avoid (Troubleshooting). Reader aids also provide additional relevant or background information that adds value to the lesson.

| vwww.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

vi | Illustrated Book Tour

• Skill Summary: Each lesson ends with a recapping of the skills covered in the lesson.

• Knowledge Assessment: Provides a total of 20 questions from a mix of True/False, Fill-in-the-Blank, Matching, or Multiple Choice, testing students on concepts learned in the lesson.

• Competency, Proficiency, and Mastery Assessment: Provide three progressively more challenging lesson-ending activities.

• Circling Back: These integrated projects provide students with an opportunity to renew and practice skills learned in previous lessons.

• Online Files: The student companion website contains the data files needed for each lesson. These files are indicated by the icon in the margin of the textbook.

www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

Illustrated Book Tour | vii

Lesson Features

Lesson Skill Matrix

Key Terms

Step-by-Step Exercises

The Bottom Line

Another Way Reader Aid

59

3 Resource and Task Assignments

LESSON

As the video production manager at Southridge Video, you are working on a new music video for Don Funk, an up-and-coming singer/songwriter. You fi rst mapped out the initial tasks in the project, then identifi ed the resources needed to complete the tasks in the project. Now you need to put the two together. When you make assignments (link resources and tasks), Microsoft Project 2013 can provide several key pieces of information including: who is working on what tasks and when; if the resources are available when you need them to be, or are over-allocated; and more. In this lesson, you will learn how to assign work, material, and cost resources to a task and how to use the Actions tag to affect Project’s scheduling behavior.

K E Y T E R M S actions tag assignment duration formula effort-driven scheduling units work work formula

L E S S O N S K I L L M A T R I X

SKILLS TASKS

Assigning Work Resources to Tasks Make individual resource assignments

Assign multiple resources simultaneously

Adding More Work Resource Assignments to Tasks Add work resources to a task

Add work resources to an effort-driven task

Use the Actions tag to change Project’s scheduling behavior

Assigning Material Resources to Tasks Assign a material resource to a task

Assigning Cost Resources to Tasks Assign a cost resource to a task

c03ResourceandTaskAssignments.indd Page 59 31/08/13 8:02 PM user-1 /208/WB01159/9780470133125/ch03/text_s

42 | Lesson 2

ESTABLISH EQUIPMENT RESOURCES

USE the project schedule you created in the previous exercise.

1. In the Resource Sheet, click the next empty cell in the Resource Name column. 2. Click the Resource tab and then click the Information button in the Properties group;

the Resource Information dialog box appears.

Establishing Equipment Resources

THE BOTTOM LINE

Setting up equipment resources in Microsoft Project is very similar to setting up people resources. There are key differences, however, in the way equipment resources can be scheduled.

Establishing Equipment Resources

You don’t need to track every piece of equipment that will be used in your project. It will be helpful, though, to track equipment resources when you need to schedule and track equipment costs or when the equipment might be needed my multiple people at the same time. In this exercise, you learn how to establish the equipment resources for your project.

3. If it is not already displayed, click the General tab in the Resource Information dialog box.

4. In the Resource Name fi eld, type Digital Truck-Mounted Video Camera. 5. In the Type fi eld, select Work from the drop-down menu. Your screen should look

similar to Figure 2-5. Notice that the Resource Information dialog box contains many of the same fi elds as the Resource Sheet.

Figure 2-5

Resource Information dialog box with newly added resource

Resource name field

Resource type field

You can also activate the Resource Information dialog box by double-clicking a resource name or an empty cell in the Resource Name column.

ANOTHER WAY

c02EstablishingResources.indd Page 42 31/08/13 6:46 PM user-1 /208/WB01159/9780470133125/ch02/text_s

Screen Images with Callouts

File Download icon

Project Information: Sorting, Grouping, and Filtering | 143

Microsoft Project’s Sort Dialog Box In Microsoft Project, you can use the Sort dialog box to sort task or resource information in the current view by a specifi ed fi eld or fi elds (see Figure 7-1).

SO F T W A R E OR I E N T A T I O N

Sorting Data

THE BOTTOM LINE It is easiest to review and utilize data in Microsoft Project when you have it organized to fi t your needs. The simplest way to reorganize task and resource data in Project is by sorting.

SORT DATA IN A RESOURCE VIEW

GET READY. Before you begin these steps, launch Microsoft Project. OPEN the Don Funk Music Video 7M from the data fi les for this lesson. SAVE the fi le as Don Funk Music Video 7 in the solutions folder for this lesson as directed by your instructor.

1. Click the View tab, and then click Resource Sheet. The Resource Sheet view appears. The default table in the Resource Sheet view is the Entry table. However, you want to look at the cost per resource, which is not displayed in the Entry table.

2. On the ribbon, click the Tables button in the Data group and then select Summary. The Summary table appears in the Resource Sheet view.

3. Auto fi t the columns so the data can be easily read. Your screen should look similar to Figure 7-2.

Figure 7-1

Sort dialog box

The Sort dialog box enables you to select up to three fi elds for three levels of sorts within sorts, to choose whether the view should be sorted in ascending or descending order, and to indicate whether items should be permanently renumbered according to the sort.

Ascending & Descending sort options for each levelPrimary Sort

Secondary Sort

Tertiary Sort

Permanently renumber resources check box

c07ProjectInformationSortingGroupingandFiltering.indd Page 143 16/09/13 11:54 AM user /208/WB01159/9780470133125/ch07/text_sSoftware OrientationBusiness Scenario

viii | Illustrated Book Tour

Troubleshooting Reader Aid

Summary Skill Matrix

Easy-to-Read Tables

Cross- Reference Reader Aid

20 | Lesson 1

lunch each day. Microsoft Project differentiates between working and nonworking time, so the duration of a task doesn’t always correspond to elapsed time. If you estimate that a task will take 24 hours of working time, you would enter its duration as 3d to schedule the task over three 8-hour workdays. If this task were to start at 8:00 A.M. on Thursday, it would not be completed until 5:00 P.M. on Monday. No work is scheduled on evenings or weekends because these have been defi ned as nonworking times.

You can also schedule tasks to occur over working and nonworking time by assigning an elapsed duration to a task. Elapsed duration is the total length of working and nonworking time you expect it will take to complete a task. Suppose you own an automobile body shop. In the process of repainting a car, you have the tasks “Apply rustproof undercoat” and “Apply fi rst color overcoat.” You also need a task called “Wait for undercoat to dry” because you cannot apply the color paint until the undercoat is dry. The task “Wait for undercoat to dry” will have an elapsed duration because the undercoat will dry over a contiguous range of hours, whether they are working or nonworking. If the undercoat takes 24 hours to cure, you would enter the duration for this task as 1ed (or 1 elapsed day). If you scheduled it to start at 11 A.M. on Wednesday, it would be complete at 11 A.M. on Thursday.

Table 1-1 shows abbreviations and meanings for actual and elapsed times in Microsoft Project.

Table 1-2

Abbreviations and meanings for actual and elapsed times

IF YOU ENTER THIS ABBREVIATION IT APPEARS LIKE THIS AND MEANS

m min minute

h hr hour

d day day

w wk week

mo mon month

em emin elapsed minute

eh ehr elapsed hour

ed eday elapsed day

ew ewk elapsed week

emo emon elapsed month

TROUBLESHOOTING

For most projects, you will use task durations of hours, days, and weeks. When estimating task durations, think carefully about the level of detail you want to apply to your project’s tasks. If you have a multiyear project, it is probably not practical or even possible to track tasks that are measured in minutes or hours. You should measure task durations at the lowest level of detail or control necessary, but no lower.

Although the task durations are supplied for you for the exercises in this book, you and the project team will have to estimate task durations for most real-world projects. There are a number of sources of task duration estimates:

• Information from previous, similar projects

• Estimates from the people who will actually complete the tasks

• Recommendations from people who have managed similar projects

• Professional or industry organizations that deal with the project subject ma t ter

c01ProjectBasics.indd Page 20 31/08/13 6:44 PM user-1 /208/WB01159/9780470133125/ch01/text_s

54 | Lesson 2

S K I L L S U M M A R Y

IN THIS LESSON YOU LEARNED: MATRIX SKILL

To establish people resources Establish individual people resources

Establish a resource that represents multiple people

To establish equipment resources Establish equipment resources

To establish material resources Establish material resources

To establish cost resources Establish cost resources

To establish resource pay rates Enter resource cost information

To adjust resource working times Establish nonworking times for an individual work resource

Establish a specifi c work schedule for a resource

To add resource notes Attach a note to a resource

Knowledge Assessment

Matching

Match the term in column 1 to its description in column 2.

Column 1

1. resource calendar

2. Max. Units

3. material resource

4. project calendar

5. cost resource

6. work resource

7. base calendar

8. availability

9. resources

10. note

Column 2

a. the maximum capacity of a resource to accomplish tasks

b. specifi es default working and nonworking times for a resource, a project, or a task

c. when and how much of a resource’s time can be assigned to work on tasks

d. the people and equipment that do work to accomplish the tasks of the project

e. the people, equipment, money, and materials used to complete the tasks in a project

f. a way of documenting information about resources, tasks, and assignments

g. consumable items used up as the tasks in a project are accomplished

h. a resource that doesn’t depend on the amount of work on a task or the duration of a task

i. the base calendar that provides default working times for an entire project

j. defi nes the working and nonworking time for an individual resource

c02EstablishingResources.indd Page 54 31/08/13 6:46 PM user-1 /208/WB01159/9780470133125/ch02/text_s

184 | Lesson 9

ESTABLISH A PROJECT BASELINE

GET READY. Before you begin these steps, launch Microsoft Project.

1. OPEN the Don Funk Music Video 9 M project schedule from the data fi les for this lesson.

2. SAVE the fi le as Don Funk Music Video 9 in the solutions folder for this lesson as directed by your instructor.

3. Click the Project tab. In the Schedule group, click the Set Baseline button and then select Set Baseline.

4. The Set Baseline dialog box appears. You will accept all of the default settings in this dialog box by clicking OK.

Microsoft Project saves the baseline, although there is no indication in the Gantt Chart view that anything has changed. In the next few steps, you will explore some of the changes caused by saving the baseline.

5. On the ribbon, click the View tab and then click the down-arrow under Gantt Chart. Select More Views, and the More Views dialog box appears.

6. In the More Views box, select Task Sheet and click Apply. Using this view, there is more room to see the fi elds in the table because the Gantt Chart is not shown. Now you will switch to a different table in the Task Sheet view.

7. On the ribbon, click Tables, and then click Variance. The Variance table appears. This table includes both the Scheduled and Baseline columns so that you can compare them easily. Your screen should look similar to Figure 9-2.

You will go deeper into the Set Baseline dialog box in Lesson 11. Cross

Ref

You can save up to eleven baselines in a single project schedule. The baselines are named Baseline (the fi rst baseline you would normally save) and Baseline 1 through Baseline 10. Saving multiple baselines is helpful if your project duration is especially long or if you have approved scope/schedule changes. You can save multiple baselines to record different sets of baseline values and later compare these against each other and against actual values.

TAKE NOTE*

c09ProjectScheduleTrackingFundamentals.indd Page 184 31/08/13 9:43 PM user-1 /208/WB01159/9780470133125/ch09/text_s

Take Note Reader Aid

Illustrated Book Tour | ix

Proficiency Assessment Projects

Knowledge Assessment Questions Knowledge Assessment Fill in the Blank

Complete the following sentences by writing the correct word or words in the blanks provided.

1. enables you to see on your screen what will print on paper before you print it.

2. People or organizations that might be affected by project activities are called .

3. If you have two views displayed in a combination view and want to print the view, only the view in the pane will print.

4. When previewing a view in print preview, you can change the number of pages visible by selecting either the or pages button.

5. A common activity for project managers is to information from the project schedule to share with stakeholders.

6. To add your company name so that it prints at the top of every page, use the dialog box to add the company name to the header.

7. A is a predefi ned format intended for printing Microsoft Project data.

8. A report is used to represent high-level information usually on one page.

9. If subtasks are hidden in a view, reports that contain task lists will include only tasks.

10. In a report, you can only information.

Multiple Choice

Select the best response for the following statements.

1. In a view, you can information.

a. enter

b. edit

c. print

d. All of the above are correct.

2. If assignments are hidden under tasks or resources in a usage view, what will the usage report show?

a. tasks or resources with corresponding assignment details

b. only the tasks or resources

c. only overallocated assignment details

d. it depends on how you set up the report

3. In the Print Preview window, the status bar shows “4 rows by 3 columns.” How many pages will be printed?

a. 7

b. 4

c. 12

d. 3

216 | Lesson 10

c10ProjectReporting.indd Page 216 31/08/13 4:36 PM user /208/WB01159/9780470133125/ch10/text_s

74 | Lesson 3

Project 3-3: Offi ce Remodel Material Resources

You now need to assign material resources to tasks in your offi ce remodel project schedule.

OPEN Offi ce Remodel 3-3 from the data fi les for this lesson.

1. Open the Assign Resources dialog box using the button on the Resource ribbon. 2. Select task 9, Install drywall. 3. In the Assign Resources dialog box, assign drywall as a resource and then assign 50

units for the drywall resource.

4. In the Assign Resources dialog box, assign nails as a resource and then assign 5 units for the nails resource.

5. Close the Assign Resources dialog box. 6. SAVE the project as Offi ce Remodel Material Resources and then CLOSE the fi le.

LEAVE Project open for the next exercise.

Project 3-4: Don Funk Video – Change Project’s Behavior Using Actions tag

Although you have already assigned most of the resources for your music video, you have realized that you need to assign additional resources for a few of the tasks. You can use an Actions tag to do this.

OPEN Don Funk Music Video 3-4 from the data fi les for this lesson.

1. Select task 7, Book Musicians. 2. Activate the Assign Resources dialog box. 3. Click on Brenda Diaz, and then assign her to the task. 4. Use the Actions tag to indicate that you want to reduce the number of hours

resources work per day (units), but keep the same duration and work.

5. Close the Assign Resources dialog box. 6. SAVE the project schedule as Don Funk Actions and then CLOSE the fi le.

LEAVE Project open to use in the next exercise.

Profi ciency Assessment

Project 3-5: Don Funk Cost Resources

In this exercise, you will assign cost resources for the Don Funk Music Video.

OPEN the Don Funk Music Video 3-5 from the data fi les for this lesson.

1. Open the Assign Resources dialog box. 2. For task 6, Identify and reserve locations, assign Travel as a resource at a cost of

5000. 3. For task 18, Scene 1 vocal recording, assign Food as a resource at a cost of 250. 4. Close the Assign Resources dialog box. 5. SAVE the project schedule as Don Funk Cost Resources and then CLOSE the fi le.

LEAVE Project open for the next exercise.

Mastery Assessment

c03ResourceandTaskAssignments.indd Page 74 31/08/13 8:03 PM user-1 /208/WB01159/9780470133125/ch03/text_s

158 | Lesson 7

Competency Assessment

Project 7-1: Sorting by Multiple Criteria

You have some additional setup work that needs to be completed before the shooting of one of the Don Funk Music Video scenes can begin. Because you will need to pay overtime (time and one-half ) for this additional work, you would like to get a volunteer who has a low standard rate. Sort your resources according to Standard Rate and Max Units so that you can make your request from the least-cost group of employees.

GET READY. Launch Microsoft Project if it is not already running.

OPEN Don Funk Music Video 7-1 from the data fi les for this lesson.

1. Click the View ribbon, then in the Resource Views group, click Resource Sheet. 2. On the ribbon, click Sort, and then click Sort by. 3. In the Sort by section select Type from the dropdown menu. Next to that, click

Descending. 4. In the fi rst Then by section, select Standard Rate from the dropdown menu. Next to

that, click Descending. 5. In the last Then by section, select Max Units from the dropdown menu. Next to that,

click on Descending. Make sure the Permanently renumber resources box is not checked. 6. Click the Sort button.

7. SAVE the project schedule as Don Funk Standard Rate Sort and then CLOSE the fi le. LEAVE Project open for the next exercise.

Project 7-2: Apply HR Filter

You are reviewing your project schedule for hiring a new employee. You want to specifi cally review the staff members from the Human Resources (HR) department who are involved with this project. You need to apply a fi lter that will screen out any staff except HR. OPEN Hiring New Employee 7-2 from the data fi les for this lesson.

1. Click the View ribbon and then click Resource Sheet. 2. Click the down-arrow in the Group column heading, point to Filters and then click

[Custom . . .]. 3. In the Group section, select contains from the dropdown list in the fi rst box if it is

not already visible. In the adjacent box, type HR. 4. Click the OK button.

5. SAVE the project schedule as Hiring New Employee HR Filter and then CLOSE the project schedule.

PAUSE. LEAVE Project open to use in the next exercise.

Profi ciency Assessment

Project 7-3: Resource Groups by Standard Rate for Don Funk Music Video

You are working on employee reviews and pay increases for your staff for the upcoming year. You have decided it would be benefi cial to be able to look at the standard rate variation within resource groups working on this project. You need to set up a custom group that will enable you to do this. OPEN Don Funk Music Video 7-3 from the data fi les for this lesson.

c07ProjectInformationSortingGroupingandFiltering.indd Page 158 31/08/13 7:21 PM user-1 /208/WB01159/9780470133125/ch07/text_s

Competency Assessment Projects

x | Illustrated Book Tour

Circling Back Exercises

198 | Lesson 9

Project 9 - 5 : Offi ce Remodel Task Delay

You have just been informed that while the plumber was re-running the pipes for the offi ce lunchroom remodel, a pipe burst and the fl oor was fl ooded with several inches of water. It will take a week to clean and dry the water damage. You need to reschedule the remaining work on incomplete tasks to restart when the cleanup is complete.

OPEN the Offi ce Remodel 9- 5 project schedule from the data fi les for this lesson.

1. Activate the Update Project dialog box. 2 . Reschedule uncompleted work to start after Thursday, October 22, 2016.

3 . SAVE the project schedule as Offi ce Remodel Reschedule , and then CLOSE the fi le. LEAVE Project open to use in the next exercise.

Project 9 - 6 : Tracking the Don Funk Music Video as Scheduled

The last phase of the Don Funk Music Video, Post-Production, is going well. Tasks are being completed on schedule. You want to update the project to show that the tasks are complete through a specifi ed current date.

OPEN the Don Funk Music Video 9- 6 project schedule from the data fi les for this lesson.

1. Activate the Update Project dialog box. 2. Update the project as complete through July 15, 2016.

3. Scroll the Gantt Chart bars so that the task and progress bars on the week of July 10, 2016 are visible.

4. SAVE the project schedule as Don Funk On Schedule , and then CLOSE the fi le. CLOSE Project.

Mastery Assessment

OPEN Don Funk Music Video 9- 4 from the data fi les for this lesson.

1. Activate the Project Statistics box to view the costs for the project. 2. Display the Cost table. 3. Filter the tasks to show only the tasks that are over budget.

4. Collapse all Production Scene summary tasks (hide subtasks) except for the Scene summary task with the greatest cost variance

5. SAVE the project schedule as Don Funk Overbudget , and then CLOSE the fi le. LEAVE Project open to use in the next exercise.

c09ProjectScheduleTrackingFundamentals.indd Page 198 31/08/13 9:44 PM user-1 /208/WB01159/9780470133125/ch09/text_s

Circling Back | 117

Mete Goktepe is a project management specialist at Woodgrove Bank. The management at Woodgrove has recently decided that the eight-year old commercial lending software currently in use is outdated and needs to be replaced. Mete has been assigned as the project manager for the Request For Proposal (RFP) process to evaluate and select new software. This process entails determining needs, identifying vendors, requesting proposals, reviewing proposals, and selecting the software.

Project 1: Entering Tasks

Acting as Mete, you fi rst need to enter project information and then enter and organize the tasks for this project.

GET READY. Launch Project if it is not already running.

1. In the New section of the Backstage area, double-click Blank Project. 2. On the Tasks tab, in the Tasks command group, click the Mode button. From the list,

click Auto Schedule. 3. Click the Project tab, then click Project Information. Set the start date to May 2,

2016. 4. SAVE the project plan as RFP Bank Software Tasks. 5. In the Properties group on the ribbon, click the Change Working Time button. 6. Add the following exception dates:

• Memorial Day to begin on May 30, 2016 and to occur yearly on the last Monday of May for 2 occurrences.

• Independence Day to begin on July 4, 2016 and to occur yearly on July 4 for 2 occurrences.

• Labor Day to begin on September 5, 2016 and to occur the fi rst Monday of September for 2 occurrences

• Thanksgiving Day to begin on November 24, 2016 and to occur on the fourth Thursday of November for 2 occurrences

7. Click OK to close the Change Working Time dialog box. 8. In the Gantt Chart view, enter the following task names and durations (enter all tasks,

even if no duration is listed). [This is a partial list of tasks in the project plan. Additional data will be available in future exercises.]

Circling Back

c05FineTuningTasks.indd Page 117 31/08/13 7:08 PM user-1 /208/WB01159/9780470133125/ch05/text_s

Mastery Assessment Projects

Conventions and Features Used in This Book

This book uses particular fonts, symbols, and heading conventions to highlight important information or to call your attention to special steps. For more information about the features in each lesson, refer to the Illustrated Book Tour section.

| xiwww.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

CONVENTION MEANING

CLOSE Words in all capital letters indicate instructions for opening, saving, or closing files or programs. They also point out items you should check or actions you should take.

Reader aids appear in shaded boxes found in your text. Take Note provides helpful hints related to particular tasks or topics.

Another Way provides an alternative procedure for accomplishing a particular task.

These notes provide pointers to information discussed else- where in the textbook or describe interesting features that are not directly addressed in the current topic or exercise.

Alt + Tab A plus sign (+) between two key names means that you must press both keys at the same time. Keys that you are instructed to press in an exercise will appear in the font shown here.

A shared printer can be used Key terms appear in bold italic. by many individuals on a network.

Key My Name is. Any text you are asked to key appears in blue.

Click OK. Any button on the screen you are supposed to click on or select will also appear in color.

OPEN BudgetWorksheet1 The names of data files will appear in bold, italic font for easy identification.

This icon notifies you that a file is available for download in the accompanying student data files.

ANOTHER WAY

TAKE NOTE*

Cross Ref

Instructor Support Program

The Microsoft Official Academic Course programs are accompanied by a rich array of resources that incorporate the extensive textbook visuals to form a pedagogically cohesive package. These resources provide all the materials instructors need to deploy and deliver their courses. Resources available online for download include:

• The Instructor’s Guide contains solutions to all the textbook exercises as well as chapter summaries and lecture notes. The Instructor’s Guide and Syllabi for various term lengths are available from the Instructor’s Book Companion site (www.wiley.com/college/microsoft).

• The Solution Files for all the projects in the book are available online from our Instructor’s Book Companion site (www.wiley.com/college/microsoft).

• The Test Bank contains hundreds of questions organized by lesson in multiple-choice, true-false, short answer, and essay formats and is available to download from the Instructor’s Book Companion site (www.wiley.com/college/microsoft). A complete answer key is provided.

This title’s test bank is available for use in Respondus’ easy-to-use software. You can download the test bank for free using your Respondus, Respondus LE, or StudyMate Author software.

Respondus is a powerful tool for creating and managing exams that can be printed to paper or published directly to Blackboard, WebCT, Desire2Learn, eCollege, ANGEL, and other eLearning systems.

• A complete set of PowerPoint Presentations and Images is available on the Instructor’s Book Companion site (www.wiley.com/college/microsoft) to enhance classroom presen- tations. Tailored to the text’s topical coverage and Skills Matrix, these presentations are designed to convey key Microsoft Project concepts addressed in the text.

All figures from the text are on the Instructor’s Book Companion site (www.wiley.com/ college/microsoft). You can incorporate them into your PowerPoint presentations, or create your own overhead transparencies and handouts.

By using these visuals in class discussions, you can help focus students’ attention on key elements of Microsoft Project and help them understand how to use it effectively in the workplace.

• The Student Data Files are available online on both the Instructor’s Book Companion Site and for students on the Student Book Companion Site.

• When it comes to improving the classroom experience, there is no better source of ideas and inspiration than your fellow colleagues. The Wiley Faculty Network connects teachers with technology, facilitates the exchange of best practices, and helps to enhance instructional efficiency and effectiveness. Faculty Network activities include technology training and tutorials, virtual seminars, peer-to-peer exchanges of experiences and ideas, personal consulting, and sharing of resources. For details visit www.WhereFacultyConnect.com.

WFN

xii | www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

DreamSpark Premium is designed to provide the easiest and most inexpensive way for schools to make the latest Microsoft developer tools, products, and technologies available in labs, classrooms, and on student PCs. DreamSpark Premium is an annual membership program for departments teaching Science, Technology, Engineering, and Mathematics (STEM) courses. The membership provides a complete solution to keep academic labs, faculty, and students on the leading edge of technology.

Software available through the DreamSpark Premium program is provided at no charge to adopting departments through the Wiley and Microsoft publishing partnership.

Note: Microsoft Project 2013 Professional can be downloaded from DreamSpark Premium for use by students in this course.

Contact your Wiley rep for details.

For more information about the DreamSpark Premium program, go to Microsoft’s DreamSpark website

DREAMSPARK PREMIUM—FREE 3-YEAR MEMBERSHIP AVAILABLE TO QUALIFIED ADOPTERS!

Important Web Addresses and Phone Numbers

To locate the Wiley Higher Education Representative in your area, go to the following Web address and click on the “Contact Us ” link at the top of the page:

www.wiley.com/college

Or call the MOAC toll-free number: 1 + (888) 764-7001 (U.S. & Canada only).

www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

Instructor Support Program | xiii

Student Support Program

Book Companion Web Site (www.wiley.com/college/microsoft)

The students’ book companion site for the MOAC series includes any resources, exercise files, and Web links that will be used in conjunction with this course.

xiv | www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

Wiley Desktop Editions Wiley MOAC Desktop Editions are innovative, electronic versions of printed textbooks. Students buy the desktop version for 50% off the U.S. price of the printed text, and get the added value of permanence and portability. Wiley Desktop Editions provide students with numerous additional benefits that are not available with other e-text solutions.

Students also have access to fully integrated resources within their Wiley Desktop Edition. From highlighting their e-text to taking and sharing notes, students can easily personalize their Wiley Desktop Edition as they are reading or following along in class.

Wiley E-Text: Powered by Vitalsource When you choose a Wiley E-Text you not only save money; you benefit from being able to access course materials and content anytime, anywhere through a user experience that makes learning rewarding.

With the Wiley E-Text you will be able to easily:

• Search

• Take notes

• Highlight key materials

• Have all your work in one place for more efficient studying

In addition, the Wiley E-Text is fully portable. Students can access it online and download to their computer for off line access and access read and study on their device of preference— computer, tablet, or smartphone.

Student Support Program | xv

Student Data Files

All of the practice files that you will use as you perform the exercises in the book are available for download on our student companion site. By using the practice files, you will not waste time creating the samples used in the lessons, and you can concentrate on learning how to use Microsoft Project 2013. With the files and the step-by-step instructions in the lessons, you will learn by doing, which is an easy and effective way to acquire and remember new skills.

Copying the Practice Files

Your instructor might already have copied the practice files before you arrive in class. However, your instructor might ask you to copy the practice files on your own at the start of class. Also, if you want to work through any of the exercises in this book on your own at home or at your place of business after class, you may want to copy the practice files.

OPEN Internet Explorer.

1. In Internet Explorer, go to the student companion site: www.wiley.com.

2. Search for your book title in the upper-right corner.

3. On the Search Results page, locate your book and click the Visit the Companion Sites link.

4. Select Student Companion Site from the pop-up box.

5. In the left-hand column, under “Browse by Resource” select Student Data Files.

6. Now select Student Data Files from the center of the screen.

7. In the File Download dialog box, select Save to save the data files to your external drive (often called a ZIP drive, a USB drive, or a thumb drive) or a local drive.

8. In the Save As dialog box, select from the left-hand panel a local drive that you’d like to save your files to; again, this should be an external drive or a local drive. Remember the drive name that you saved your files to.

www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

Acknowledgments

We would like to thank the many instructors and reviewers who pored over the Microsoft Official Academic Course series design, outlines and manuscript, providing invaluable feedback in the service of quality instructional materials.

Erik Amerikaner, Oak Park Unified

Connie Aragon, Seattle Central Community College

Sue Bajt, Harper College

Gregory Ballinger, Miami—Dade College

Catherine Bradfield, DeVry University

DeAnnia Clements, Wiregrass Georgia Technical College

Mary Corcoran, Bellevue College

Andrea Cluff, Freemont High School

Caroline de Gruchy, Conestoga College

Janis DeHaven, Central Community College

Rob Durrance, East Lee County High School

Janet Flusche, Frenship High School

Greg Gardiner, SIAST

Debi Griggs, Bellevue College

Phil Hanney, Orem Junior High School

Portia Hatfield, Tennessee Technology Center—Jacksboro

Dee Hobson, Richland College

Terri Holly, Indian River State College

Kim Hopkins, Weatherford College

Sandra Jolley, Tarrant County College

Keith Hoell, Briarcliffe College

Joe LaMontagne, Davenport University

Tanya MacNeil, American InterContinental University

Donna Madsen, Kirkwood Community College

Lynn Mancini, Delaware Technical Community College

Edward Martin, Kingsborough Community College—City University of New York

Lisa Mears, Palm Beach State College

Denise Merrell, Jefferson Community and Technical College

Diane Mickey, Northern Virginia Community College

Robert Mike, Alaska Career College

Cynthia Miller, Harper College

Sandra Miller, Wenatchee Valley College

Mustafa Muflehi, The Sheffield College

xvi | www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

Aditi Mukherjee, University of Florida—Gainesville

Linda Nutter, Peninsula College

Diana Pack, Big Sandy Community & Technical College

Bettye Parham, Daytona State College

Tatyana Pashnyak, Bainbridge State College

Kari Phillips, Davis Applied Technical College

Michelle Poertner, Northwestern Michigan College

Barbara Purvis, Centura College

Dave Rotherham, Sheffield Hallam University

Theresa Savarese, San Diego City College

Janet Sebesy, Cuyahoga Community College—Western

Lourdes Sevilla, Southwestern College

Elizabeth Snow, Southwest Florida College

Denise Spence, Dunbar High School

Amy Stolte, Lincoln Land Community College

Linda Silva, El Paso Community College

Dorothy Weiner, Manchester Community College

We would also like to thank the team at Microsoft Learning Xperiences (LeX), including Alison Cunard, Tim Sneath, Zubair Murtaza, Keith Loeber, Rob Linsky, Anne Hamilton, Wendy Johnson, Gene Longo, Julia Stasio, and Josh Barnhill for their encouragement and support in making the Microsoft Official Academic Course programs the finest academic materials for mastering the newest Microsoft technologies for both students and instructors. Finally we would like to thank Jeff Riley and his team at Box Twelve Communications, Laura Town and her team at WilliamsTown Communications, Debbie Collins and Sandy DuBose for their editorial and technical assistance.

We would like to thank the following instructors for their contributions to particular titles in the series as well:

Access 2013

Catherine Bradfield, DeVry University Mary Corcoran, Bellevue College Cynthia Miller, Harper College Elizabeth Snow, Southwest Florida College Aditi Mukherjee, University of Florida—Gainesville

Excel 2013

Catherine Bradfield, DeVry University DeAnnia Clements, Wiregrass Technical College Sandy Jolley, Tarrant County College Dee Hobson, Richland College Joe Lamontagne, Davenport University Edward Martin, Kingsborough Community College-City University of New York Aditi Mukherjee, University of Florida—Gainesville Linda Nutter, Peninsula College Dave Rotherham, Sheffield Hallam University

Acknowledgments | xvii

www.wiley.com/college/microsoft or call the MOAC Toll-Free Number: 1+(888) 764-7001 (U.S. & Canada only)

Outlook 2013

Erik Amerikaner, Oak Park Unified Sue VanLanen, Gwinnett Technical College Robert Mike, Alaska Career College Lourdes Sevilla, Southwestern College—Chula Vista Kari Phillips, Davis Applied Technical College