Microsoft Project Course Exam Guide
Translated by
ScribdTranslationsMicrosoft Project Course Exam Guide
Translated by
ScribdTranslationsBASIC MICROSOFT PROJECT COURSE EXAM
TEACHER: ENG. RICHARD ANYAYPOMA.
SINGLE QUESTION: TO CARRY OUT THE SCHEDULING OF A CONSTRUCTION PROJECT OF A
SINGLE-FAMILY HOUSING WITH ITS RESPECTIVE REPORTS IN PDF AND SEND THE FILES IN
PDF FORMAT AND LNK (PROJECT FILE) TO THE EMAIL OF CERSA ENGINEERS,
TAKING INTO ACCOUNT THE FOLLOWING ITEMS:
PROJECT SETUP
1. Configure MS. Project for this project as follows:
Título: CONSTRUCCIÓN DE VIVIENDA.
Subject: Construction
Author: "Write your Name in this space"
The project should start on December 1, 2016.
Create a new calendar for this project called 'HOUSING PROJECT'.
Change the work schedule as follows:
From Monday to Friday: from 7:00 a.m. to 12:00 p.m. and from 1:00 p.m. to 5:00 p.m.
No work: Set up the calendar from December to July of 2017 with
all the holidays corresponding to our calendar.
Assign the calendar to all resources assigned to the project.
TASK REGISTRATION
2. Ingresar las siguientes tareas con sus respectivas duraciones.
No. TASK NAME DURATION
1 Prepare the ground 1 DAY
2 MAKE THE BASE 5 DAYS
3 COLUMNS AND BEAMS 3 WEEK
4 WALLS 2 WEEKS
5 FLOOR 4 DAYS
6 FORMWORK ROOF 10 DAYS
7 FILLING ROOF 1 DAY
8 PLUMBING 1 WEEK
9 ELECTRICITY 4 DAYS
10 INSTALL DOORS 4 DAYS
11 INSTALL WINDOWS 3 DAYS
12 DECORATION 4 DAYS
3. Insert a task at the beginning and name it 'Foundation Phase'.
4. Insert below the task 'Make the base', the task 'Structural Phase'.
5. Insert under the task "Ceiling Filling", the task "Mechanical Phase".
6. Insert below the task 'Electricity', the task 'Exterior and Interior Finishing Phase'.
At the end of each Phase, there must be a milestone named 'End of the Phase'.
8. Show the task Project Summary and name it 'Construction Project'.
Single-family housing
9. The tasks "Floor" and "Roof Filling" have a fixed duration.
10. Link the tasks in the following way:
Foundation Phase:
o The task 'Making the base' begins when the task 'Preparing the ground' ends.
Structural Phase:
The task 'Walls' begins when the task 'Columns and Beams' ends.
The task "Floor" begins together with the task "Walls".
The task 'Ceiling Formwork' begins when the tasks 'Floor' and 'Walls' have been completed.
completed.
The task 'Roof Filling' begins when the task 'Roof Formwork' has been completed.
Mechanical Phase:
The task 'Plumbing' must have a postponement of 5 days after it is finished.
Task 'Roof Filling'
The task 'Electricity' begins when the task 'Plumbing' ends.
Exterior and Interior Finished Phase:
The tasks "Install Doors" and "Install Windows" start at the same time.
The task "Decoration" starts when the previous task has a 50% completion.
11. Insert a column for the WBS (Work Breakdown Structure) and check that all tasks are linked.
12. Each milestone must be linked to the previous task and the first task of the next phase.
13. Indicate the 'Critical Path'.
14. The resources to be used are shown in the following table:
COST COST
TIPO TRABAJO COST/USE
NORMAL EXTRA
CARPENTERS
luis Soria S/. 5,000.00 S/. 10,000.00
Manuel Peña S/. 4,000.00 $7,000.00
ELECTRICIANS
Juan Salas S/. 5,000.00 $10,000.00
INTERIOR DESIGNER
Rosa Pérez S/. 20,000.00
Workers
Julio Rosas $4,000.00 $7,000.00
Pablo Samaniego S/. 4,000.00 $7,000.00
Mario Hinojoza $4,000.00 S/. 7,000.00
Ricardo Merino S/. 4,000.00 S/. 7,000.00
Masons
Oscar Paredes S/. 5,000.00 $8,000.00
Nicolás Mendoza $3,000.00 $5,000.00
PLUMBERS
Pedro Martinez S/. 5,000.00 $10,000.00
Leoncio Haro $4,000.00 S/. 5,000.00
EQUIPMENT
Mixer S/. 12,000.00 $5,000.00
Computer S/. 50,000.00
MATERIAL TYPE
Cement (bag x 42.5kg) S/. 60,000.00
Bricks (per thousand) S/. 110,000.00
Water pipe (meter) S/. 2,000.00
Electric cable (meter) S/. 2,000.00
Wood (foot2) $4,000.00
Tile (metro2) S/. 10,000.00
Sand (bag x 50 kg) $3,000.00
TIPO COSTO
Transport S/. 20,000.00
Reception S/. 45,000.00
15. Assign the following resources to the respective tasks:
PREPARE THE GROUND MAKE THE BASE
- Julio Rosas - Julio Rosas
- Pablo Samaniego - Pablo Samaniego
- Mario Hinojoza
- Ricardo Merino
- Cement, 80 bags
- Arena, 130 bags
COLUMNS AND BEAMS PLUMBING
- Mario Hinojoza - Pedro Martínez
- Ricardo Merino - Leoncio Haro
- Oscar Paredes - Cement 1.5 bags
- Nicolás Mendoza - Arena 4.5 bags
- Cement: 30 bags - Water pipe 30 m.
- Arena 90 bags
WALLS ELECTRICITY
- Oscar Paredes - Juan Salas
- Nicolás Mendoza - Electric cable 60m
- Cement 20 bags
- Arena 40 Bags
- Bricks, 3 thousand
FLOOR INSTALL DOORS
- Mario Hinojoza - Luis Soria
- Ricardo Merino - Manuel Peña
- Oscar Paredes - Wood 40 feet2
- Tile 110 m2
- Cement, 25 bags
- Arena 80 bags
FORMWORK CEILING INSTALL WINDOWS
- Julio Rosas - Luis Soria
- Pablo Samaniego - Manuel Peña
- Mario Hinojoza - Wood 20 square feet
FILLING CEILING DECORATION
- Julio Rosas - Rosa Pérez.
- Pablo Samaniego - Computer.
- Mario Hinojoza
- Ricardo Merino
- Oscar Paredes
- Nicolás Mendoza
- Cement 40 bags
- Arena 120 bags
- Brick 1 thousand
- Mixer
Mrs. Rosa Pérez (decorator) will only be available 50% of the time for the project.
17. All the people involved in the construction of WALLS (only for this task)
they have a 35% markup on the assigned cost and add this information in a note.
18. The electrician Juan Salas has 4 overtime hours.
OPTIMIZATION
19. Redistribute the over-allocated resources, if any.
FOLLOW-UP
20. Create and save the project baseline.
21. Compare with the actual plan, for this simulate the progress of the project:
Task: Prepare land 100%
Task: Make the base 80%
Task: Columns and beams 50%
22. Highlight the incomplete tasks.
23. Visualize and export the network diagram
24. Show the Costs by Project Phases, and determine which phase consumes
more budget.
25. Generate various types of reports in PDF format to deliver to the project manager as follows:
a. What is the overall cost of the project?
b. What is the resource that has the highest number of assigned hours?
c. What additional costs are there?
d. Discriminate what the value of resources of the Work type is and what the value of the Material type is.
26. In a Word file that you will call [Link], respond clearly and
concise questions 24 and 25.
32. Save the Ms. Project file and send it along with the reports in pdf format and the file.
from Word, the answers to point 26 to the course email(cersaingenieros@[Link]) for your
post-evaluation.