The Construction Project Planning & Project Scheduling course is designed to equip participants with the necessary skills to efficiently plan and schedule construction projects using Microsoft Excel. This comprehensive course covers a wide range of topics related to project planning, scheduling, and cost estimation. Participants will gain an understanding of the fundamental principles of project planning and scheduling, including the scope and nature of construction projects. They will learn about various types of task dependencies, such as start-to-start and finish-to-start links, and how to apply them in project scheduling.
The course focuses on preparing a baseline schedule for different stages of a construction project, from foundation works to finishing activities. Participants will learn how to create monthwise quantity sheets and bill of quantities (BOQ) using Excel, enabling them to accurately calculate the material requirements for each stage of the project. Furthermore, participants will explore the process of preparing monthwise invoices to track the project’s financial aspects. They will learn to determine average rates for the project and generate invoices for excavation, concreting, and shuttering works for both substructures and superstructures.
In addition, the course covers the preparation of bulk materials requirement for the entire project. Participants will learn how to calculate coefficients for PCC, concrete, plastering, and flooring works, as well as determine the quantities of cement, sand, aggregate, steel, cement blocks, and red bricks required on a monthly basis. Finally, the course includes assignments to reinforce the learned concepts and provide hands-on practice with Excel sheets specifically designed for construction projects.
By the end of the course, participants will have gained the necessary skills to effectively plan, schedule, and estimate costs for construction projects using Microsoft Excel, enabling them to enhance their project management capabilities and contribute to successful project delivery.
What Will You Learn?
- The fundamentals of project planning and scheduling.
- How to prepare a baseline schedule for various stages of a construction project.
- Understanding different types of task dependencies in project scheduling.
- How to create monthwise quantity sheets and bill of quantities (BOQ) using Excel.
- Calculating material requirements for each stage of the project.
- Preparing monthwise invoices for tracking project costs.
- Determining average rates for the project.
- Generating invoices for excavation, concreting, and shuttering works.
- Preparing bulk materials requirement for the entire project.
- Calculating coefficients for PCC, concrete, plastering, and flooring works.
- Determining monthly quantities of cement, sand, aggregate, steel, cement blocks, and red bricks.
- Completing assignments to reinforce learning and practice using Excel sheets.
- Enhancing your project management capabilities in construction projects.
- Effectively contributing to successful project delivery through efficient planning and scheduling.
Who Should Take The Course?
- Construction project managers and supervisors.
- Construction professionals involved in project planning and scheduling.
- Architects, engineers, and designers working in the construction industry.
- Contractors and subcontractors responsible for project coordination.
- Estimators and quantity surveyors involved in cost estimation.
- Students and graduates pursuing careers in construction management.
- Individuals seeking to enhance their skills in construction project planning and scheduling.
- Anyone interested in learning how to use Microsoft Excel for construction project management.
- Professionals looking to expand their knowledge and improve their career prospects in the construction industry.
- Individuals involved in construction project procurement and contract management.
Course Features
- Lectures 35
- Quiz 0
- Duration 5h 50m
- Skill level All levels
- Language English
- Students 5
- Certificate Yes
- Assessments Yes
