EVENT DETAILS

Date and Time                  Thursday, December 20, 2018         8:00 AM - 4:00 PM MDT

Location                             LCA Office (1705 – 36 Street North, Lethbridge, AB)

Description:                       Microsoft Excel for Construction Estimating

The ability to produce cost estimates efficiently and accurately is a critical step in many construction career paths, and a high-demand skill throughout the construction industry.

Computer software has become a popular tool for estimating, and Microsoft Excel is the most widely-used option. In this one-day course, learn how to produce your estimates more quickly and accurately by harnessing the power of Microsoft Excel.

Who should attend:

This course is for any estimator who uses (or is considering using) Microsoft Excel for Construction Estimating. Whether you’re a novice or experienced Excel user, you’ll get practice using basic and extended features of Excel for a variety of typical estimating tasks.

Prerequisites

• A general understanding of project management concepts 

• Basic skills with any Windows operating system

Course Objectives

Upon successful completion of this course, participants will be able to:

• Use Excel formulas for typical construction estimating tasks

• Create takeoff sheets for use as templates

• Learn handy shortcuts to streamline estimating

• Link information in worksheets and workbooks

• Accurately calculate profit, overhead, markups, and taxes

• Generate graphs to visually display work product

• Use features such as VLOOKUP and HLOOKUP to access an MS EXCEL Database

• Print work product to PDF

Your Presenter

Phil Perry has 30 plus years in the Construction Industry, most of which was Project Managing Industrial Projects for General Contractors. He has been teaching Post-Secondary Construction Management Courses for the last eight years.

December 20, 2018  |  8:00am - 4:00pm 

LCA Members: $295 (+GST)  |  Non-Members: $390 (+GST)

Other Microsoft Courses Offered:

• December 18 Microsoft Projects 2016: Intermediate

• December 19 Microsoft Projects 2016: Advanced

REGISTER NOW!

This course counts for one Gold Seal Credit. For more information about Gold Seal, click HERE.

EVENT DETAILS

Date and Time                  Wednesday, December 19, 2018         8:00 AM - 4:00 PM MDT

Location                             LCA Office (1705 – 36 Street North, Lethbridge, AB)

Description:                       Microsoft Project 2016 ADVANCED

Description

Gain in-depth understanding of advanced features of Microsoft Project 2016 as a project management tool. This course is for any person who has used Microsoft Project 2016 at the intermediate level and would like to improve their skills.

Prerequisites:

• A general understanding of project management concepts 

• Basic skills with any Windows operating system.

• Intermediate skills with Microsoft Project (any version)

Course Content

1.     Importing and Exporting Data

2.     Working with Multiple Projects

• Master Projects and Subprojects

• Working with Multiple Projects

• Linking Tasks Across Projects

3.     Resource Pools

4.     Customizing Tables, Views, and Reports

5.     Working with Templates 

6.     Tracking and Analyzing Project Data

• Progress Lines

• Earned Value Analysis

• Custom Visual Reports 

Your Presenter

Phil Perry has 30 plus years in the Construction Industry, most of which was Project Managing Industrial Projects for General Contractors. He has been teaching Post-Secondary Construction Management Courses for the last eight years.  

December 19, 2018  |  8:00am - 4:00pm

LCA Members: $295 (+GST)  |  Non-Members: $390 (+GST)

Other MS Project Courses at LCA:

• Intermediate: November 1

REGISTER NOW!

This course counts for one Gold Seal Credit. For more information about Gold Seal, click HERE.

EVENT DETAILS

Date and Time Tuesday, December 18, 2018 8:00 AM - 4:00 PM MDT

Location LCA Office (1705 – 36 Street North, Lethbridge, AB)

Description: Microsoft Project 2016 INTERMEDIATE

Gain an in-depth understanding of Microsoft Project 2016 as a project management tool. This course is for any person who has used Microsoft Project 2016 at the basic level and would like to improve their skills.

Prerequisites:

• A general understanding of project management concepts

• Basic skills with any Windows operating system.

• Basic skills with Microsoft Project (any version)

Course Content

1. Changing Scheduling Methods

• Task Type Settings

• Task Constraints

• Task Relationships (Finish-to-Start, Start-to-Start, Finish-to-Finish, Lags)

• Identifying Factors Affecting Tasks

• Defining the Critical Path

• Formatting the Critical Path

2. Change Project Calendars

• Explore Default Calendars (Standard, Night Shift, 24 Hour)

• Create Project Specific Calendars (e.g. 6 day x 10 hour/day)

• Assign a special Calendar to a specific task

• Assign a special Calendar to a specific resource

• 3. Tracking Project Progress

• Saving the Baseline

• Tracking Task Progress

• Updating Tasks

• Updating the Remaining Schedule

• Comparing Baseline and Actual Data

4. Resolving Resource Conflicts

• Assigning Resources

• Editing Resource Assignments

• Resource Overallocations

• Locating Resource Overallocations

• Resolving Resource Overallocations

• Applying Preset Contours to Resources

• 5. Sorting, Filtering and Grouping

• Sorting Views

• Filtering Views

• Grouping Tasks and Resources

6. Formatting the Project Environment

• Formatting Views

• Formatting the Gantt Chart

Your Presenter

Phil Perry has 30 plus years in the Construction Industry, most of which was Project Managing Industrial Projects for General Contractors. He has been teaching Post-Secondary Construction Management Courses for the last eight years.

December 18, 2018 | 8:00am - 4:00pm

LCA Members: $295 (+GST) | Non-Members: $390 (+GST)

Other MS Project Courses at LCA:

Advanced: December 19

REGISTER NOW!

This course counts for 1 (one) Gold Seal Credit. For more information about Gold Seal, click HERE.

Place: LCA Classroom

Time: 3:00 p.m.– 5:00 p.m.

Classroom Course

This two-day course will assist managers and supervisors to integrate health and safety into their everyday planning and to create and promote safe and healthy work environments. Course material is geared toward management and supervisory positions.

This two-level program consists of a two-day course (Certificate of Completion) and documentation submission (Certificate of Proficiency).

COURSE TOPICS INCLUDE:

• The role of the supervisor

• Safety responsibilities of managers, supervisors and workers

• The scope and significance of hazard assessments

• Company culture

• Inspections, reporting and follow-up

• Incident investigations

• Training and orientations

Classroom Course

This two-day course will assist managers and supervisors to integrate health and safety into their everyday planning and to create and promote safe and healthy work environments. Course material is geared toward management and supervisory positions.

This two-level program consists of a two-day course (Certificate of Completion) and documentation submission (Certificate of Proficiency).

COURSE TOPICS INCLUDE:

• The role of the supervisor

• Safety responsibilities of managers, supervisors and workers

• The scope and significance of hazard assessments

• Company culture

• Inspections, reporting and follow-up

• Incident investigations

• Training and orientations

Classroom Course

This two-day course will assist managers and supervisors to integrate health and safety into their everyday planning and to create and promote safe and healthy work environments. Course material is geared toward management and supervisory positions.

This two-level program consists of a two-day course (Certificate of Completion) and documentation submission (Certificate of Proficiency).

COURSE TOPICS INCLUDE:

• The role of the supervisor

• Safety responsibilities of managers, supervisors and workers

• The scope and significance of hazard assessments

• Company culture

• Inspections, reporting and follow-up

• Incident investigations

• Training and orientations

Classroom Course

This two-day course will assist managers and supervisors to integrate health and safety into their everyday planning and to create and promote safe and healthy work environments. Course material is geared toward management and supervisory positions.

This two-level program consists of a two-day course (Certificate of Completion) and documentation submission (Certificate of Proficiency).

COURSE TOPICS INCLUDE:

• The role of the supervisor

• Safety responsibilities of managers, supervisors and workers

• The scope and significance of hazard assessments

• Company culture

• Inspections, reporting and follow-up

• Incident investigations

• Training and orientations

Classroom Course

This two-day course provides information and resources for individuals developing, implementing, and monitoring traffic control strategies for the construction industry in Alberta. All topics covered in the one-day Alberta Traffic Control - Field Application course are addressed throughout this two-day course.

COURSE TOPICS INCLUDE:

• Temporary traffic control best practices

• Developing temporary traffic control strategies

• Hazard assessments and creating safer work zones

• Maintaining temporary traffic control strategies

• Erecting and removing signage and/or barricades

• Loading and transporting traffic control devices

• Device maintenance and recordkeeping practices

• Temporary traffic control standards throughout Alberta

Classroom Course

This two-day course provides information and resources for individuals developing, implementing, and monitoring traffic control strategies for the construction industry in Alberta. All topics covered in the one-day Alberta Traffic Control - Field Application course are addressed throughout this two-day course.

COURSE TOPICS INCLUDE:

• Temporary traffic control best practices

• Developing temporary traffic control strategies

• Hazard assessments and creating safer work zones

• Maintaining temporary traffic control strategies

• Erecting and removing signage and/or barricades

• Loading and transporting traffic control devices

• Device maintenance and recordkeeping practices

• Temporary traffic control standards throughout Alberta

Place: LCA Classroom

Time: 3:00 p.m.– 5:00 p.m.

Classroom Course

This one-day course is designed for owners, managers, administration, and safety personnel who are directly involved in the contractor management process. This course includes a basic contractor management process for small to medium sized companies that manage contractors or who work as contractors.

COURSE TOPICS INCLUDE:

Certification

• Overview of prime contractor requirements and obligations

• Contractor pre-qualification and selection

• Pre-project meeting requirements

• Project safety plan requirements

• Contractor monitoring, evaluation, and feedback

This course has a written test and skills check components. Participants must achieve a minimum score of 80% on a closed-book written test and complete eight skills checks for course certification.

Prerequisites

None required at this time.

Classroom Course

This one-day course is designed for company trainers who are responsible for providing WHMIS worker education and site-specific training.

COURSE TOPICS INCLUDE:

• Overview of WHMIS 2015

• WHMIS 2015 worker education (generic)

• WHMIS 2015 site-specific training requirements

• Overview of WHMIS programs and planning considerations

• Resources for trainers

• Certification

  This course has a written test and skills check component. Participants must achieve a minimum score of 70% on a closed-book written test and complete four skill checks for course certification. Certification allows participants to use ACSA's materials to deliver WHMIS worker education at their work sites. Trainers must re-certify in this course every three (3) years.

  Prerequisites

  None required at this time.

Classroom Course

The Auditor Training Program is a three-day course designed for individuals who will be evaluating the effectiveness of a company's Health & Safety Program. Participants will be shown how quality audits reduce risk and incidents through a systems approach. This program consists of a three-day course (Certificate of Completion) and a voluntary Qualification Audit submission (Certified Peer Auditor Certificate).

Course Topics

• Introduction to the auditing process
• Responsibilities of all parties involved
• Chronological steps of an Audit process
• How to use the ACSA Audit Document
• Workshop

Certification
Certificate of Completion

This course has a written test and an in-depth workshop. Participants must achieve a minimum score of 80% on a closed-book written test and demonstrate an understanding of the practical auditing procedure.

Certified Peer Auditor Certificate

Participants may submit a qualification/self-audit (individually conducted) within three months after completing the three-day course. If the qualification/self-audit is approved by the ACSA COR department, an ACSA Peer Auditor Certificate will be issued.

Prerequisites

Pricinples of Health and Safety Management (PHSM) must be completed before taking the Auditor Training Program (ATP).

Classroom Course

The Auditor Training Program is a three-day course designed for individuals who will be evaluating the effectiveness of a company's Health & Safety Program. Participants will be shown how quality audits reduce risk and incidents through a systems approach. This program consists of a three-day course (Certificate of Completion) and a voluntary Qualification Audit submission (Certified Peer Auditor Certificate).

Course Topics

• Introduction to the auditing process
• Responsibilities of all parties involved
• Chronological steps of an Audit process
• How to use the ACSA Audit Document
• Workshop

Certification
Certificate of Completion

This course has a written test and an in-depth workshop. Participants must achieve a minimum score of 80% on a closed-book written test and demonstrate an understanding of the practical auditing procedure.

Certified Peer Auditor Certificate

Participants may submit a qualification/self-audit (individually conducted) within three months after completing the three-day course. If the qualification/self-audit is approved by the ACSA COR department, an ACSA Peer Auditor Certificate will be issued.

Prerequisites

Pricinples of Health and Safety Management (PHSM) must be completed before taking the Auditor Training Program (ATP).

Classroom Course

The Auditor Training Program is a three-day course designed for individuals who will be evaluating the effectiveness of a company's Health & Safety Program. Participants will be shown how quality audits reduce risk and incidents through a systems approach. This program consists of a three-day course (Certificate of Completion) and a voluntary Qualification Audit submission (Certified Peer Auditor Certificate).

Course Topics

• Introduction to the auditing process
• Responsibilities of all parties involved
• Chronological steps of an Audit process
• How to use the ACSA Audit Document
• Workshop

Certification
Certificate of Completion

This course has a written test and an in-depth workshop. Participants must achieve a minimum score of 80% on a closed-book written test and demonstrate an understanding of the practical auditing procedure.

Certified Peer Auditor Certificate

Participants may submit a qualification/self-audit (individually conducted) within three months after completing the three-day course. If the qualification/self-audit is approved by the ACSA COR department, an ACSA Peer Auditor Certificate will be issued.

Prerequisites

Pricinples of Health and Safety Management (PHSM) must be completed before taking the Auditor Training Program (ATP).

Place: LCA Classroom

Time: 3:00 p.m.– 5:00 p.m.

Classroom Course

This is a one-day course designed to give participants a solid understanding of the basic structure of Alberta's Occupational Health and Safety legislation. Participants will learn to successfully locate information in the OHS Handbook by completing individual exercises and participating in group work. Each participant will receive an OHS Handbook as part of the course materials.

COURSE TOPICS INCLUDE:

• Overview of the different types of legislation that may impact a workplace

• Structure and content of Alberta's OHS Act, Regulations, and Code

• Locating information in Alberta's OHS Legislation Handbook

• Overview of the OHS compliance and enforcement tools used in Alberta

• Certification

  This course has a written test and skills check component. Participants must achieve a minimum score of 70% on a closed-book written test and complete one case study for course certification. An Alberta OHS Legislation handbook is permitted during the written test.

  Prerequisites

  None required at this time.

Classroom Course

ACSA Peer Auditors are required to take this one-day course every three years to maintain their auditor certification. This course will cover updates relating to any recent changes to the audit document and/or process, and will clarify any issues that auditors have encountered while evaluating health and safety programs.

COURSE TOPICS INCLUDE:

• Reinforcing the rationale for conducting effective health and safety audits

• Updates relating to revisions in the audit document/process

• Professional standards for performing effective interviews, communicating audit findings, and preparing and delivering the auditor's executive summary report

• Refining previously developed auditing skills through a simulated limited scope audit workshop

Certification

There is no written test for this course.

Once a certificate has been issued, the auditor must maintain certification by completing and submitting a minimum of one annual internal, maintenance or external audit, in addition to attending a recertification course every three (3) years (before the expiry date on their certificate).

Prerequisites

Must be a current ACSA Certified Peer Auditor.

Classroom Course

This newly formatted two-day program now incorporates the Small Employer Certificate of Recognition (SECOR) Course, opening the door for small employers to receive the same training as the rest of the industry. This new approach will help improve their health and safety performance, create a culture of proactive workplace health and safety and reduce the risk and costs associated with workplace incidents.

The new two-day course includes a comprehensive step-by-step guide, which includes more than 40 free resources with workable templates, providing employers with the tools and ability to build an effective health and safety manual, plus much more.

COURSE TOPICS INCLUDE:

• the purpose and benefits of a Health & Safety Program
• required elements of an effective, company-specific Health & Safety Program
• review of applicable sections of the OH&S Act, Regulation and Code
• due diligence, responsibility and accountability
• resources available for use in developing a Health & Safety manual
• tools to develop, promote and implement a Safe Driving Program
• strategies for communicating and implementing your safety program

Classroom Course

This newly formatted two-day program now incorporates the Small Employer Certificate of Recognition (SECOR) Course, opening the door for small employers to receive the same training as the rest of the industry. This new approach will help improve their health and safety performance, create a culture of proactive workplace health and safety and reduce the risk and costs associated with workplace incidents.

The new two-day course includes a comprehensive step-by-step guide, which includes more than 40 free resources with workable templates, providing employers with the tools and ability to build an effective health and safety manual, plus much more.

COURSE TOPICS INCLUDE:

• the purpose and benefits of a Health & Safety Program
• required elements of an effective, company-specific Health & Safety Program
• review of applicable sections of the OH&S Act, Regulation and Code
• due diligence, responsibility and accountability
• resources available for use in developing a Health & Safety manual
• tools to develop, promote and implement a Safe Driving Program
• strategies for communicating and implementing your safety program

Place: LCA Classroom

Time: 3:00 p.m.– 5:00 p.m.

Classroom Course

This one-day course is designed to provide the participant with the knowledge and skills to be able to analyze a basic worksite incident, determine incident causes, and complete an investigation report. The theory component of the course is completed in the morning session. The practical component of the course is completed during an investigation workshop in the afternoon session. Attendance at both sessions is required.

COURSE TOPICS INCLUDE:

• Reasons for performing investigations
• Importance of investigating near misses
• Legislation requirements under Alberta OHS
• Elements of an investigation policy
• Simplified Investigation Process (SIP)
• Loss Causation Model (LCM)
• SMART corrective actions
• Investigation documentation and reporting

Classroom Course

This two-day course will assist managers and supervisors to integrate health and safety into their everyday planning and to create and promote safe and healthy work environments. Course material is geared toward management and supervisory positions.

This two-level program consists of a two-day course (Certificate of Completion) and documentation submission (Certificate of Proficiency).

COURSE TOPICS INCLUDE:

• The role of the supervisor
• Safety responsibilities of managers, supervisors and workers
• The scope and significance of hazard assessments
• Company culture
• Inspections, reporting and follow-up
• Incident investigations
• Training and orientations

Classroom Course

This two-day course will assist managers and supervisors to integrate health and safety into their everyday planning and to create and promote safe and healthy work environments. Course material is geared toward management and supervisory positions.

This two-level program consists of a two-day course (Certificate of Completion) and documentation submission (Certificate of Proficiency).

COURSE TOPICS INCLUDE:

• The role of the supervisor
• Safety responsibilities of managers, supervisors and workers
• The scope and significance of hazard assessments
• Company culture
• Inspections, reporting and follow-up
• Incident investigations
• Training and orientations

Classroom Course

This two-day course provides information and resources for individuals developing, implementing, and monitoring traffic control strategies for the construction industry in Alberta. All topics covered in the one-day Alberta Temporary Traffic Control – Filed Application course are addressed throughout this two-day course. This course was developed in partnership with the American Traffic Safety Services Association (ATSSA).

COURSE TOPICS INCLUDE:

• Temporary traffic control best practices
• Developing temporary traffic control strategies
• Hazard assessments and creating safer work zones
• Maintaining temporary traffic control strategies
• Erecting and removing signage and/or barricades
• Loading and transporting traffic control devices
• Device maintenance and recordkeeping practices
• Temporary traffic control standards throughout Alberta

Classroom Course

This two-day course provides information and resources for individuals developing, implementing, and monitoring traffic control strategies for the construction industry in Alberta. All topics covered in the one-day Alberta Temporary Traffic Control – Filed Application course are addressed throughout this two-day course. This course was developed in partnership with the American Traffic Safety Services Association (ATSSA).

COURSE TOPICS INCLUDE:

• Temporary traffic control best practices
• Developing temporary traffic control strategies
• Hazard assessments and creating safer work zones
• Maintaining temporary traffic control strategies
• Erecting and removing signage and/or barricades
• Loading and transporting traffic control devices
• Device maintenance and recordkeeping practices
• Temporary traffic control standards throughout Alberta

Classroom Course

This two-day course provides information and resources for individuals developing, implementing, and monitoring traffic control strategies for the construction industry in Alberta. All topics covered in the one-day Alberta Temporary Traffic Control – Filed Application course are addressed throughout this two-day course. This course was developed in partnership with the American Traffic Safety Services Association (ATSSA).

COURSE TOPICS INCLUDE:

• Temporary traffic control best practices
• Developing temporary traffic control strategies
• Hazard assessments and creating safer work zones
• Maintaining temporary traffic control strategies
• Erecting and removing signage and/or barricades
• Loading and transporting traffic control devices
• Device maintenance and recordkeeping practices
• Temporary traffic control standards throughout Alberta

Classroom Course

This two-day course provides information and resources for individuals developing, implementing, and monitoring traffic control strategies for the construction industry in Alberta. All topics covered in the one-day Alberta Temporary Traffic Control – Filed Application course are addressed throughout this two-day course. This course was developed in partnership with the American Traffic Safety Services Association (ATSSA).

COURSE TOPICS INCLUDE:

• Temporary traffic control best practices
• Developing temporary traffic control strategies
• Hazard assessments and creating safer work zones
• Maintaining temporary traffic control strategies
• Erecting and removing signage and/or barricades
• Loading and transporting traffic control devices
• Device maintenance and recordkeeping practices
• Temporary traffic control standards throughout Alberta