Overview

Comprehensive Project Management with Primavera and ExcelThis course is designed to provide participants with a thorough understanding of project management processes, tools, and techniques using Primavera and Microsoft Excel. Covering a wide range of essential topics, this course ensures participants are equipped to handle efficient project execution, scheduling, resource management, and cost control.Course Topics1. Critical Path Method (CPM)Participants will learn about the Critical Path Method (CPM), a crucial project management technique used to identify the longest sequence of activities and determine the project's minimum duration. This module will cover:Understanding the concept of the critical pathIdentifying critical and non-critical activitiesCalculating float and slack2. Organizational Breakdown Structure (O.B.S) and Enterprise Project Structure (EPS)This module covers the Organizational Breakdown Structure (O.B.S) and Enterprise Project Structure (EPS), explaining how to organize and manage projects within a hierarchical framework. Topics include:Defining O.B.S and EPSCreating and structuring the O.B.S and EPSAssigning responsibilities and roles within the O.B.S and EPS3. Calendar in PrimaveraLearn how to create and manage calendars in Primavera, essential for accurate scheduling and time management. This module includes:Setting up project calendarsDefining workdays, holidays, and exceptionsAssigning calendars to projects and activities4. Creating Project W.B.S and ActivitiesParticipants will learn how to create a project Work Breakdown Structure (W.B.S) and define activities, including how to assign durations to each activity. This module covers:Developing a W.B.SBreaking down the project into manageable activitiesEstimating activity durations5. Assigning Relationships to ActivitiesThis module covers how to assign relationships to activities in Primavera, ensuring a logical sequence and interdependency among tasks. Topics include:Defining different types of activity relationshipsSetting up dependencies between activitiesUnderstanding the impact of relationships on the schedule6. Types of RelationshipsLearn about the different types of relationships in project scheduling, such as Finish-to-Start, Start-to-Start, Finish-to-Finish, and Start-to-Finish, and how to apply them in Primavera. This module includes:Exploring each relationship typePractical examples of when to use each relationshipManaging complex activity relationships7. Scheduling the ProjectParticipants will learn how to schedule the project in Primavera, including running the scheduling process to determine project timelines and critical paths. This module covers:Running the scheduleUnderstanding schedule calculationsAnalyzing the schedule output8. Creating and Assigning ResourcesThis module covers how to create resource lists and assign resources to project activities in Primavera, ensuring effective resource management. Topics include:Defining different types of resources (labor, material, equipment)Creating resource dictionariesAssigning resources to activities9. Creating and Assigning BaselinesLearn how to create and assign baselines in Primavera, allowing for comparison between planned and actual project performance. This module includes:Setting up project baselinesAssigning baselines to projectsComparing baseline data with actual progress10. Updating the ProjectParticipants will learn how to update the project schedule in Primavera, incorporating actual progress and adjusting future projections. This module covers:Recording actual start and finish datesUpdating activity progressAnalyzing the impact of updates on the schedule11. Resource and Activity Usage ProfileThis session covers how to create and analyze resource and activity usage profiles in Primavera, providing insights into resource allocation and activity performance. Topics include:Generating usage profilesInterpreting usage dataIdentifying resource overallocation and underallocation12. Creating ReportsLearn how to generate and customize reports in Primavera, essential for project tracking, performance analysis, and stakeholder communication. This module includes:Setting up report templatesCustomizing report contentGenerating and distributing reports13. Global ChangeParticipants will learn how to use the Global Change feature in Primavera to make bulk changes to project data, saving time and ensuring consistency. This module covers:Setting up global change parametersApplying global changes to projectsVerifying and validating changes14. Material Procurement in PrimaveraThis module covers the process of managing material procurement in Primavera, ensuring timely and efficient acquisition of project materials. Topics include:Setting up material procurement schedulesTracking material orders and deliveriesManaging material inventories15. Generating Financial S-CurveLearn how to generate a financial S-curve in Primavera, a graphical representation of cumulative costs over time, useful for tracking project expenditures. This module includes:Setting up cost dataGenerating S-curvesAnalyzing cost performance16. Resource HistogramParticipants will learn how to create a resource histogram in Primavera, visually representing resource allocation and identifying potential overallocation issues. This module covers:Creating resource histogramsInterpreting histogram dataAdjusting resource allocation based on histogram insights17. Create Activity List in ExcelLearn how to develop a detailed activity list in Excel. This list will serve as a foundation for creating a project schedule. Topics will include defining activities, establishing durations, and setting dependencies.18. Read and Understand Bill of Quantities (B.O.Q)Understanding the Bill of Quantities (B.O.Q) is crucial for project costing and planning. This module will teach participants how to read and interpret B.O.Q documents, which detail the quantities and costs of materials and labor for construction projects.19. Create W.B.S According to B.O.Q or CSIParticipants will learn how to create a Work Breakdown Structure (W.B.S) in line with the B.O.Q or CSI standards. A W.B.S is a hierarchical decomposition of the total scope of work to accomplish project objectives and create deliverables.20. Create Cost Loading Sheet in ExcelThis session will cover the creation of a cost loading sheet in Excel, which links project costs to the project schedule. Participants will learn how to allocate costs to various activities and phases of the project.21. Import Cost and Activities from Excel to PrimaveraParticipants will be guided through the process of importing cost and activity data from Excel into Primavera. This integration allows for seamless project management and ensures all data is centralized in Primavera.22. Link Complete Activities in ScheduleLearn how to link all project activities in Primavera to create a cohesive and logically sequenced project schedule. This includes setting up dependencies and constraints to ensure a realistic timeline.23. Calculate Manpower Based on ProductivityUnderstanding manpower requirements is key to project planning. This module will teach participants how to calculate manpower needs based on productivity rates and project scope.24. Import and Assign Resources to ActivitiesParticipants will learn how to import resource data into Primavera and assign these resources to project activities. This includes managing labor, equipment, and materials required for project completion.25. Create Shop Drawing Submittal and Approval in PrimaveraThis session focuses on managing shop drawing submittals and approvals within Primavera. Participants will learn how to track and manage the submission and approval process efficiently.26. Create Material Submittal and Approval in PrimaveraSimilar to shop drawings, managing material submittals and approvals is crucial. This module will cover the process of submitting, tracking, and approving materials in Primavera.27. Create Shop Drawing Log and Material Tracking Chart in ExcelParticipants will be taught how to create and maintain a shop drawing log and material tracking chart in Excel. These tools are essential for monitoring the status of drawings and materials throughout the project lifecycle.28. Estimate Daily Manpower in ExcelAccurate manpower estimation is vital for project success. This module will guide participants on estimating daily manpower requirements using Excel, ensuring that labor needs are met efficiently.29. Review Primavera Time ScheduleThe final module will focus on reviewing and analyzing the project time schedule in Primavera.Course OutcomesBy the end of this course, participants will have a solid understanding of using Primavera and Excel for comprehensive project management. They will be proficient in creating detailed project schedules, managing resources and costs, and ensuring efficient project execution from start to finish.

Skills

Reviews