Courses

Microsoft Excel for Construction (NOVICE) Webinar

Register
Duration Fee Facilitator
2 Parts Member
$399.00
Not Member
$499.00
Ms. Anne Leroux, ES Computer Training

Perequiste: Microsoft Excel for Construction (NOVICE) Webinar is a perequiste for Microsoft Excel for Construction (ADVANCED) Webinar

Date & Location

Webinar

Course description

Do you calculate production rates? Keep track of costs or budgets? Excel makes these tasks easy, and it gives you a record of all your calculations (unlike your calculator). Excel makes it easy to verify your work and enter changes.

This instructor-led webinar is delivered in two 3 hours sessions.

Objectives

The Construction Professional will be able to use Excel to create estimates, track expenses, calculate overruns, track production rates, calculate materials usages.

1. Create better financial estimates of projects

2. Calculate and create records of production rates

3. Maintain better financial records of business expenses

4. Be able to do tracking of expenses and revenues by job

Topics Covered

Basic spreadsheets for simple estimates

  • Numerical calculations using excel
  • Incorporating financial information (estimates) into Word documents
  • Creating simple estimates
  • Using formulas
  • Creating Budgets
  • Charting
  • Calculating Production Rates

Tracking Expenses

  • Simple calculations overtime – expense tracking
  • Record-Keeping – jobs and equipment
  • Subtotals – tracking by job or location
  • Filters – analyzing results
  • If Statements
  • Multiple books and Links – job tracking

Year over Year comparisons

Reporting

  • Formatting
  • Linking
  • Exporting
  • Conditional Formatting

 

Microsoft Excel for Construction (ADVANCED) Webinar

Register
Duration Fee Facilitator
2 Parts Member
$399.00
Not Member
$499.00
Ms.Anne Leroux, ES Computer Training

Date & Location

Webinar

Course description

Is running or analyzing a business or individual jobs important for you? We will demonstrate tools to help you better calculate your business metrics, profitability of jobs, plan budgets and examine business scenarios all through the use of Microsoft Excel. This advanced level course will give you a better comprehension of how to analyze data to create what-if scenarios (what if conditions changes…. how will these affect the cost of the job).

- Learn how to create simple Gantt charts and timelines in Excel.

- We will show you how to use Excel with other programs to quickly and easily make presentation materials from spreadsheets containing estimates and schedules.

- Discover the capacity to manipulate and analyze information (via pivot tables) to create management analysis reports.

This instructor-led webinar is delivered in two 3 hours sessions.

Course Topics

Project Cost Estimation

  • Industry Best Practices for Creating Professional Estimates
  • Developing “what if” analysis for project plans

Scheduling using Gantt Charts

File Security

  • Locking Cells
  • Protecting Worksheets
  • Protecting Data
  • Creation of estimating and job costing forms

Analyzing Data

  • Filters
  • Pivot Tables
  • Data Validation
  • Analyze multiple scenarios using filters, pivot tables and data validation

Project Bidding

  • Incorporating Excel spreadsheets in other documents
  • Linking and Automatic Updates
  • Auditing information

Expense Tracking

Analyzing Budgets and Business Metrics

Microsoft Project for Construction (Webinar)

Register
Duration Fee Facilitator
4 Parts Member
$800.00
Not Member
$900.00
Ms. Anne Leroux, ES Computer Training

Date & Location

Webinar

Course description

This course will be held virtually in 4 parts beginning February 23, 25, March 2 and 4 from 1:00pm to 4:00pm.

Every project manager understands scope creep, pressure on the schedule, and the necessity for cost control. One of the most effective tools for scheduling and cost control is MS Project. It is a communication tool that provides the project manager with a road map for project execution. It is a tool for managing deadlines and minimizing cost overruns.

This is why, increasingly, government organizations require MS Project schedules as part of the bidding process. Even subcontractors are being requested to provide such schedules.

Learn to utilize MS Project effectively.

The typical PM must juggle dozens of functions and hundreds of tasks while staying on budget, meeting deadlines, and keeping every stakeholder informed. This instructor-led webinar will demonstrate how to use MS Project to meet these challenges. Participants will learn to:

  • Translate estimates into schedules in MS Project and verify accuracy.
  • Submit electronic project plans and Gantt charts with bids.
  • Manage workloads and workflow.

 

This webinar is delivered in four 3 hour sessions and will give you a comprehensive understanding of how Microsoft Project can be used as a practical approach to project management.

What differentiates this course from other generic MS Project courses:

1. MS Project has vast capabilities applicable to a multitude of industries. Our course covers those features that a member of the Canadian Construction Association will utilize.

2. We use terminology specific to the construction industry.

3. Our work with numerous construction companies over the years allows us to present a conglomeration of industry best practices.

OVERVIEW

Microsoft Project for Construction will show the project manager how to plan, monitor, and schedule projects using resources such as people, equipment, time, and money. This course will demonstrate how to effectively track and analyze projects with a better understanding of the impact of changes. Construction business management is improved with better information such as current and interactive project status and financial data.

The instructor-led webinar is delivered in four 3 hours sessions covering the following topics.

1. Scheduling

  • Create a basic project plan including Work Breakdown Schedule and dependencies o Incorporate Milestones and Significant dates
  • Identify/Manage the Critical Path o Incorporate Job Deadlines o Identify slack and project float o Create an ‘Early Start’ and ‘Early Finish’ Schedule
  • Create a ‘Late Start’ and ‘Late Finish’ Schedule
  • Create a basic Impact Analysis using the Network Diagram
  • Add a tolerance to the Critical Path o Create a Trade Tracking Resource Schedule
  • Incorporate changes to the Project Start Date

2. Resources

  • Create work assignments for trades, employees, subcontractors.
  • Add costing and availability information.
  • Incorporate the work quantities from estimates.
  • Assign and manage overtime at overtime rates.
  • Re-distribute and re-assign actual work.
  • Resolve over-allocated personnel, equipment issues. Adjust individual workloads.
  • Share heavy equipment or specialized personnel over multiple projects and monitor availability
  • Assign Saturday or off-hours work by trade or task
  • Monitor resources by tasks, work completion rates, availability, costs, projects

3. Trade Tracking o Update projects and tasks.

  • Record actual starts, work durations, finish dates.
  • Record a delay and demonstrate the effect of the delay on other tasks.
  • Record splits in work.
  • Postpone or move work to alternate times.
  • Create a 2, 3, or 4 week look ahead.
  • Create a delay report.
  • Compare actuals to planned dates and costs.
  • Re-assign work.
  • Accelerate schedules and note the effects on costs and time.
  • Compare costs and schedules between projects.

4. Cost Control

  • Create weekly and monthly cash flow reports - Including subcontractor pricing and variable cost rates for trades, personnel, and equipment
  • Monitor budgeted Costs, Price, Profit Margins, Actual Costs and projected costs
  • Identify Project status when ahead or behind schedule and/or over or under budget
  • Reassign work and identify the effect on costing.
  • Reschedule work and identify an effect on costs.
  • Create cost reports showing weekly performance from a cost perspective.
  • Compare costs between projects.

 

ONLINE - Communication, Negotiation, Conflict Resolution

Register
Duration Fee Facilitator
4 Hours Member
$150.00
Not Member
$150.00
Online

Date & Location

Online

Course description

The Communication, Negotiation and Conflict Resolution course has been designed to help improve written, oral and negotiating skills within the construction industry.  The course contains interactive elements, case studies, practical examples, a search function, course glossary and reference library. 

The information presented in this course will help you to improve your communication skills both written nd oral, your negotiating skills and conflict resolution abilities alongside co-workers and on the job site every day.

 

Upon completing this course, you will be able to:

  • Define a conflict
  • Identify the stages of conflict
  • Describe the importance of communication
  • Apply assertiveness techniques to get a point across
  • Deal with difficult pepople more effectively
  • Recognize the criteria for an effective negotiator
  • Describe how power can be used/abused in negotiation
  • Identify when to close negotiations

Part 2 - MANDATORY CREDIT - Construction Industry Ethics (In-class Component)

Register
Duration Fee Facilitator
0 Days Member
$0.00
Not Member
$0.00
-

Date & Location

TBD

Course description

If you are interested in registering for the Construction Industry Ethics, In-class component, please contact the Association Office at 905.629.7766.

Claims Management (M1)

Register
Duration Fee Facilitator
3 Hours Member
$825.00
Not Member
$925.00
Mr.Ron Fernandez, Fernandez Construction Claims Experts

Perequiste: Claims Management (M1) is a perequiste for Claims Management (M2)

Date & Location

Webinar

Course description

This course will be held virtually in 2 parts on March 22 and 23 from 1:00pm to 4:00pm.

Module 1 consists of a 3 hour Claims Preparation and Management Course, which is accredited by the Canadian Construction Association. This course will provide essential fundamental information to all participants at a basic level, including introductory material, fundamentals of risk management, and a basic understanding of the structure of contracts.

It will provide basic fundamentals of construction planning and scheduling and delay analysis. The course is designed around a mixture of lectures and interactive workshop type classroom activities.

Course Analysis

Claims Management (M2)

Register
Duration Fee Facilitator
3 Hours Member
$825.00
Not Member
$925.00
Mr. Ron Fernandez, Fernandez Construction Claims Experts

Date & Location

Webinar

Course description

Prerequiste: Claims Management (M1) is a prerequiste for Claims Management (M2)

This course will be held virtually in 2 parts on March 29 and 30 from 1:00pm to 4:00pm.

 

Module 2 consists of a 3 hour Claims Preparation and Management Course, which is accredited by the Canadian Construction Association. This course will continue to provide basic fundamentals of construction planning and scheduling and delay analysis.

The course is designed around a mixture of lectures and interactive workshop type classroom activities.

 

 

ONLINE - Construction Law

Register
Duration Fee Facilitator
4 Hours Member
$150.00
Not Member
$150.00
Online

Date & Location

Online

Course description

This course is designed to teach and familiarize owners, managers, supervisors and project managers with construction contracts and contract law, liabilities and responsibilities of all parties to a contract, compiling and submitting proper extras and claims, and ways and means for leaders to avoid conflict with contracts, owners, trades and labour.

 

Upon completion of this course, you will be able to:

  • Understand the origins of law
  • Understand what a contract is and what makes a contract valid or invalid
  • Understand the roles in the construction industry as they apply to contract law
  • Know the different types of construction contracts
  • Interpret contracts
  • Understand what a custom contract consists of
  • Understand the principles of surety and the different types of bonds that are used 
  • Know what type of insurance is required in the construction industry
  • Understand claims, the reasons for claims and the process of making a claim
  • Know the acts and regulations that are relevant to the construction industry

ONLINE - Construction Project Management

Register
Duration Fee Facilitator
4 Hours Member
$150.00
Not Member
$150.00
Online

Date & Location

Online

Course description

This training program will provide you with the knowledge and skills to help you plan and administer projects from start to finish.

The information presented in this course will help you to understand what you can do to successfully administer projects and will provide you with the necessary tools to help manage a project.

 

After completing this course, you will be able to:

  • Develop business cases
  • Develop scope of projects
  • Manage project procurement
  • Manage project risk
  • Manage change process

ONLINE - Introduction to Construction Estimating

Register
Duration Fee Facilitator
4 Hours Member
$150.00
Not Member
$150.00
Online

Date & Location

Online

Course description

This training program will provide you with the knowledge and skills to visulaize the scope and mangitude of a construction project and produce reliable estimates.  This is accomplished by reviewing drawings through various phases of a project with the aim of determining the quantity and type of materials required for the project.

OBJECTIVES

After completing this course, you will:

  • Have a good understanding of estimating practices
  • Know site-specific conditions and requlatory requirements
  • Know how to handle the purchasing and logistics associated with materials on the job
  • Know hoe to manage materials on site
  • Organize cost data in a clear and logical manner
  • Have the ability to keep historical information related to costs (including those associated with labour, material, overhead, equipment and availability of required items)
  • Know how and when to update historical information related to costs
  • Assemble bids and meet bid closure deadlines
  • Provide on-site solutions to work-related problems in relation to equipment and material placement

ONLINE - First Level Supervisor Training Program

Register
Duration Fee Facilitator
14 Hours Member
$400.00
Not Member
$400.00
Online

Date & Location

Online

Course description

Supervisors play a key role in ensuring that job gets done on time, on budget and safely.  This course will introduce you to all aspects of supervision, beginning with a discussion of the supervisor's role and the skills required.  Then, the supervision basics are covered: leadership vs. management, due diligence, communication skills, meetings, and handling disagreements and problems.

The course then examines the supervisor's role with respect to safety, looking at inspections, investigation and training.  Human resource management comes next, including addressing personal problems and performances issues.  The course introduces you to planning and scheduling, followed by productivity and quality, including problem solving for quality outcomes.

The final section teaches you how to lead an effective work team by discussing concepts, motivation and team performance.

OBJECTIVES

  • Build your supervisory skills
  • Lead a work crew
  • Communicate effectively
  • Understand the supervisor's role in safety and due diligence
  • Develop and motivate teams
  • Address performance issues

ONLINE - Confined Spaces Safety Awareness

Register
Duration Fee Facilitator
3 Hours Member
$100.00
Not Member
$100.00
Online

Date & Location

Online

Course description

Confined spaces can be hazardous if not approached with an understanding of how to prepare for entry, how to enter and work safely, and what to do if an incidence occurs.

This course will introduce you to the types of confined spaces and the associated hazards.  You will learn about the activities within a confined space and codes of practice.  Different types of hazard controls are presented, including engineering, administrative and protective equipment.

Confined space entry procedures, including the rescue plan and evacuation (escape) plan, are explained.

Your roles and responsibilities in post-entry inspections and retention of records are also explained.

OBJECTIVE

After completing this course, you will be able to:

  • Identify the types of confines spaces
  • Recognize the potential hazards
  • Assess and control the hazards
  • Understand your roles and responsibilities prior to entry, while working and on leaving a confined space

ONLINE - Pipeline Construction Safety Training

Register
Duration Fee Facilitator
4 hours Member
$100.00
Not Member
$100.00
-

Date & Location

Online

Course description

Construction safety is not to be taken lightly, and it is something that the pipeline construction industry takes very seriously.  This course is intended to familiarize you, the worker, with how to recognize, assess and control hazards on the work site.  It has been designed to complement other safety-related courses offered by the industry.

 

Objectives

  • Know how to recognize hazards
  • Know how to assess hazards
  • Know how to control hazards
  • Know how to operate a vehicle safely
  • Know how to operate equipment safely
  • Know how to respond to emergencies 

Supervisor Due Diligence

Register
Duration Fee Facilitator
1 Day Member
$349.00
Not Member
$449.00
Mr. Kevin Brown, Cobalt Safey Consutling Inc.

Date & Location

Ontario Sewer & Watermain Construction Association (OSWCA)

Course description

Who should take this course?

  • Owners of companies
  • Directors, VP's, Executives
  • Project Managers
  • Supervisors
  • Lead Hands
  • Foremen

 

All of the above can be classified as "supervisors" under the Occupational Health and Safety Act.

Course Description

  • The Real Costs of Safety
  • Actual WSIB Incident and Accident statistics
  • The Internal Responsibility System and How an Inspector sees your workplace
  • Employer responsibilities
  • Supervisor responsibilities
  • Supervisor Due Diligence what is it and hot to achieve it
  • Worker Rights and Reprisal laws
  • Roles of the Ministry of Labour and partner organizations
  • OHSA fines and penalties including the criminal code
  • Supervisor legal note taking
  • Hazard identification and control methods
  • Progressive discipline, union environments and subcontractor management
  • Power of the Ministry of Labour and tips on dealing with them successfully

Utility Infrastructure Awareness

Register
Duration Fee Facilitator
One Day - Date TBA Member
$295.00
Not Member
$395.00
Mr. Grant Piraine, Own Your Safety

Date & Location

TBA

Course description

This Utility Infrastructure Awareness training program is designed for everyone involved on an excavation project so that they know their role in the process:

  • Utility Owners
  • Private Land Owners
  • Excavation Company Owners
  • Corporate Level Management
  • Project Managers
  • Supervisors
  • Locate Coordinators
  • Field Technicians
  • Excavators
  • Public Locators, and
  • Private Locators

 

The topics of the training program focus on everyone taking ownership of their safety to understand the entire locate process with regards to excavating around buried utility infrastructure in Ontario:

  • Knowing Before You Dig - consequences, risks, definitive roles, communications, etc.;
  • Legislation, Guidelines and Best Practices (including lessons learned);
  • Identifying Utility Structures;
  • Public Utility Infrastructure;
  • Private Utility Infrastructure;
  • Locating and Marking;
  • Subsurface Utility Engineering; and
  • Review and Test

 

*Upon completion of the UIA training program and test, attendees will receive a certificate that is valid for 1 year. 

Part 1 - MANDATORY CREDIT - Construction Industry Ethics (Online Component)

Register
Duration Fee Facilitator
4 Hours Member
$200.00
Not Member
$200.00
Online

Date & Location

Online

Course description

Ethical behaviour is paramount in the construction industry.  By maintaining high ethical standards, and being consistent in our practices, we thrive both personally and professionally.

The Construction Industry Ethics course has been designed to help you understand ethics as it relates to the construction industry.  The course contains interactive elements, case studies, practical examples, videos, and a course glossary.  This course can help your employees navigate the ethical grey areas they face every day. 

 

 

PLEASE NOTE:  There is a mandatory in-class component to this course that must be completed as a prerequisite to writing the Gold Seal exam.  The OSWCA does not yet offer this component, but will later in 2017.

 

Courses Winter Spring Summer Fall Course Date Registration Deadline

Communications

Microsoft Excel for Construction (NOVICE) Webinar
Microsoft Excel for Construction (ADVANCED) Webinar
Microsoft Project for Construction (Webinar)
ONLINE - Communication, Negotiation, Conflict Resolution
Part 2 - MANDATORY CREDIT - Construction Industry Ethics (In-class Component)

Management

Claims Management (M1)
Claims Management (M2)
ONLINE - Construction Law
ONLINE - Construction Project Management
ONLINE - Introduction to Construction Estimating
ONLINE - First Level Supervisor Training Program

Health & Safety

ONLINE - Confined Spaces Safety Awareness
ONLINE - Pipeline Construction Safety Training
Supervisor Due Diligence
Utility Infrastructure Awareness

Ethics

Part 1 - MANDATORY CREDIT - Construction Industry Ethics (Online Component)