GUIDE TO USING MICROSOFT PROJECT 2007
A.89 APPENDIX A
5. Project Communications Management
e. Administer the survey.
a. Print a Gantt chart for this project. Use a timescale that enables the
f. Solicit qualified volunteers to teach the courses.
chart to fit on one page. Then paste a copy of the Gantt chart in
g. Review resumes, interview candidates for teaching the courses, and
PowerPoint and print out the slide.
develop a list of preferred instructors.
b. Print a *To-do List" report for each team member.
h. Coordinate with the Facilities department to build two classrooms with
c. Create a "Who Does Report" and print it out.
20 personal computers in each, a teacher station, and an overhead pro-
jection system (assume that the Facilities department will manage this
Exercise A-2: Software Training Program
part of the project).
i. Schedule courses.
ABC Company has 50,000 employees at its headquarters. The company wants
j. Develop a fair system for signing up for classes.
to increase employee productivity by setting up an internal software applica-
k. Develop a course evaluation form to assess the usefulness of each
tions training program for its employees. The training program will teach
course and the instructor’s teaching ability.
employees how to use Microsoft software programs such as Vista, Word 2007,
1. Offer classes.
Excel 2007, PowerPoint 2007, Access 2007, and Project 2007. Courses will be
2. Project Time Management
offered in the evenings and on Saturdays and will be taught by qualified volun-
a. Enter realistic durations for each task and then link appropriate tasks.
teer employees. Instructors will be paid $40 per hour. In the past, various
Be sure that all tasks are linked in some fashion to the start and end of
departments sent employees to courses offered by local vendors during com-
he project. Use the Project Tracking Database as an example. Assume
pany time. In contrast to local vendors’ programs, this internal training pro-
that you have six months to complete the entire project.
gram should save the company money on training as well as make its people
b. Print the Gantt Chart view and Network Diagram view for the project.
more productive. The Human Resources department will manage the program,
and any employee can take the courses. Employees will receive a certificate for
c. Print the Schedule table to see key dates and slack times for each task.
completing courses, and a copy of the certificate will be put in their personnel
3. Project Cost Management
files. The company has decided to use off-the-shelf training materials, but is not
a. Assume that you have four people from various departments available
sure which vendor’s materials to use. The company needs to set up a training
part time to support the full-time Human Resources person, Terry, on
classroom, survey employees on what courses they want to take, find qualified
the project. Assume that Terry’s hourly rate is $40. Two people from
volunteer instructors, and start offering courses. The company wants to offer
the Information Technology department will each spend up to 25 per-
the first courses within six months. One person from Human Resources is
cent of their time supporting the project. Their hourly rate is $50. One
assigned full time to manage this project, and top management has pledged its
person from the Marketing department is available 25 percent of the
support of the project.
time at $40 per hour, and one person from Corporate is available
30 percent of the time at $35 per hour. Enter this information about
1. Project Scope Management
time and hourly wages into the Resource Sheet. Assume that the cost to
Create a WBS for this project and enter the tasks in Project 2007. Create
build the two classrooms will be $100,000, and enter it as a fixed cost.
milestones and summary tasks. Assume that some of the project manage-
b. Using your best judgment, assign resources to the tasks.
ment tasks you need to do are similar to tasks from the Project Tracking
Database example. Some of the tasks specific to this project will be to:
c. View the Resource Graphs for each person. If anyone is overallocated,
a. Review off-the-shelf training materials from three major vendors and
decide which materials to use.
d. Print the budget report for the project.
b. Negotiate a contract with the selected vendor for its materials.
4. Project Human Resource Management
c. Develop communications information about this new training program.
a. Assume that the Marketing person will be unavailable for one week,
Disseminate the information via department meetings, e-mail, the com-
two months into the project, and for another week, four months into
the project. Make adjustments to accommodate this unavailability, so
pany’s intranet, and flyers to all employees.
1. Create a survey to determine the number and type of courses needed
the schedule does not slip and costs do not change. Document the
changes from the original plan and the new plan.
and employees’ preferred times for taking courses.
GUIDE TO USING MICROSOFT PROJECT 2007