Construction quality officer with Excel

This course provides professional knowledge in the application of the ISO DIN EN 9001 standard as well as in the planning, introduction, maintenance and effectiveness control of a QM system. It also covers all central aspects of quality management, especially in the construction industry: from basics such as ISO 9001 to topics such as risk management, quality assurance and digital documentation. It also covers basic spreadsheet topics using Excel.
  • Certificates: Microsoft Excel" certificate
    Certificate "Construction Quality Officer"
  • Additional Certificates: Certificate "Quality representative with TÜV Rheinland-certified qualification"
    "Quality Management in the Construction Industry" Certificate
  • Examination: Praxisbezogene Projektarbeiten mit Abschlusspräsentationen
    Qualitätsbeauftragte:r mit TÜV Rheinland geprüfter Qualifikation
  • Teaching Times: Full-time
    Monday to Friday from 8:30 a.m. to 3:35 p.m. (in weeks with public holidays from 8:30 a.m. to 5:10 p.m.)
  • Language of Instruction: German
  • Duration: 8 Weeks

Spreadsheet calculation with Microsoft Excel

Spreadsheet calculation with Excel (full-time 10 days/part-time 20 days)

Basics of table editing

Working with formulas and functions

Formatting cells, editing and printing tables

Filling, moving and copying (auto-fill, flash preview)

Sorting and filtering data

Calculating with date and time

Creating and editing charts

Chart templates and chart layouts

Manage workbooks (sheet protection, workbook protection)

Use individual print settings

Using Excel templates

Formula help and troubleshooting with AI

Quality officers with TÜV Rheinland-certified qualifications

Fundamentals of Quality Management (approx. 1 day)

Terms and Definitions

Quality Management

Quality Management Systems

Standards and Guidelines

Structure of the Standard According to the Harmonized Structure


Fundamentals of Litigation (approx. 1 day)

What Is a Process?

Process Management According to ISO 9001

Identification of Processes

ISO 9001 Process Model

AI-Supported Process Analysis and Optimization


Organizational Context (approx. 1 day)

Organizational Context

Organizational Context with Climate Change Aspects

Stakeholders 

Scope of Application


Management (approx. 1.5 days)

Commitment to the QM system

Quality policy

Responsibilities and powers


Planning (approx. 1 day)

Managing Risks, Opportunities, and Actions

Quality Objectives and Planning

Planning for Changes

Opportunities and Risks in the Use of AI in Quality Management


Support (approx. 2.5 days)

Resources

Competence

Awareness

A culture of quality and ethical behavior as an integral part of awareness

Communication

Organizational Knowledge, Knowledge Management

Use of AI applications to support competency development and knowledge management

Documentation of the Quality Management System

Requirements for documented information as evidence of effectiveness and implementation


Operations (approx. 2 days)

Operational Planning

Requirements for Products and Services

Development

Proactive defect prevention using FMEA, QFD, and Poka Yoke

AI-supported methods for predictive defect detection (Predictive Quality)

External Provision

Supply Chain Act (LkSG) and EU Sustainability Directive (CSDDD)

Production and Service Delivery

Approval of products and services

Management of Non-Conforming Results


Performance Evaluation (approx. 1.5 days)

Monitoring and Measurement

AI-powered data analysis and evaluation

Internal audit

Management review


Improvement (approx. 1 day)

Non-conformity and corrective actions

Continuous improvement


Auditing and Certification (approx. 1 day)

Fundamentals of Auditing 

Internal Audits

Audit Process

Auditing External Providers or Third Parties

Certification Audit


Communication (approx. 1.5 days)

Building Blocks of Communication

The Iceberg Principle of Communication

The Four-Ears Model

Communication Behavior in Audits


Project management (approx. 1 day)

Definition of project

Managing projects successfully


Total Quality Management (approx. 1 day)

Quality in an Organization

ISO 9004: Guidance on Achieving Sustainable Success

EFQM Model for Excellence


Project work, certification preparation and certification examination "Quality Officer with TÜV Rheinland certified qualification" (approx. 3 days)

Quality management in the construction industry

Fundamentals of Quality Management in the Construction Industry (approx. 1.5 days)

The Importance of Quality Management in the Construction Industry

Standards: ISO 9001, DIN EN 1090, VOB/B, Overview of ESG/ISO 14001/ISO 45001

Roles, Responsibilities, and Project Phases

Harmonized Structure (HS) as the common framework for ISO management system standards (including ISO 9001, ISO 14001, and ISO 45001)


Quality Planning (approx. 1.5 days)

Create a Project Quality Management Manual

Risk Management and Failure Mode and Effects Analysis (FMEA)

Supplier and Subcontractor Qualification

Integration of sustainability and ESG criteria

Incorporating climate risks and climate change considerations into quality planning


Quality control (approx. 2 days)

Checklists, test documents, acceptance protocols

Dealing with defects and rework

Quality assurance during construction (BQÜ)


Documentation and Construction Site Digitization (approx. 1 day)

Construction Log, Documentation, and Archiving Requirements

Documented information as evidence of the effectiveness of quality management measures

Digital documentation systems and cloud solutions

Mobile apps, QR/NFC-based checklists

Introduction to CDE and BIM integration


Communication (approx. 1.5 days)

Interface management between planning, construction management, trades

Communication with clients, authorities, subcontractors

Conflict avoidance and negotiation training

Change management through new QM methods


Audits and Internal Quality Controls (approx. 0.5 days)

Internal Audits vs. External Certification

Creating audit checklists and audit reports

Tracking corrective actions and lessons learned

Transition periods for standard revisions and their impact on current certifications


AI and Future Trends in Construction Quality Management (approx. 0.5 days)

Use of AI in Construction Supervision (Image Analysis, Drones)

Predictive Quality Management

Legal Aspects and Data Protection in AI Applications

Future Trends: Automation, Sustainability, and ESG in the Construction Industry

Further Development of ISO Management System Standards (Harmonized Structure) and Their Significance for the Construction Industry


Project work (approx. 1.5 days)

To consolidate the content learned

Presentation of the project results



Changes are possible, the course content is updated regularly.

Knowledge of quality-related activities is recommended.

Once you have completed the course, you will be able to plan, implement, and maintain a quality management system and monitor its effectiveness. You’ll also gain professional expertise in applying the DIN EN ISO 9001 standard, planning internal quality audits, and making effective use of AI-powered tools in quality management.

You will also have basic knowledge of planning, documenting and monitoring quality standards throughout the construction phase.

You will also understand the concept of spreadsheets and master the use of Excel quickly and confidently in order to achieve optimal and accurate work results.

The course is aimed at people with knowledge of (civil) engineering or architecture as well as specialists from related sectors with appropriate professional experience.

After the course, a wide range of career opportunities will open up in the field of construction management, project management or quality management at construction companies. You can work for engineering firms or as a consultant for construction companies that focus on sustainable and quality-oriented construction processes.

Didactic concept

Your lecturers are highly qualified both professionally and didactically and will teach you from the first to the last day (no self-study system).

You will learn in effective small groups. The courses usually consist of 6 to 25 participants. The general lessons are supplemented by numerous practical exercises in all course modules. The practice phase is an important part of the course, as it is during this time that you process what you have just learned and gain confidence and routine in its application. The final section of the course involves a project, a case study or a final exam.

 

Virtual classroom alfaview®

Lessons take place using modern alfaview® video technology - either from the comfort of your own home or at our premises at Bildungszentrum. The entire course can see each other face-to-face via alfaview®, communicate with each other in lip-sync voice quality and work on joint projects. Of course, you can also see and talk to your connected trainers live at any time and you will be taught by your lecturers in real time for the entire duration of the course. The lessons are not e-learning, but real live face-to-face lessons via video technology.

 

The courses at alfatraining are funded by Agentur für Arbeit and are certified in accordance with the AZAV approval regulation. When submitting a Bildungsgutscheinor Aktivierungs- und Vermittlungsgutschein, the entire course costs are usually covered by your funding body.
Funding is also possible via Europäischen Sozialfonds (ESF), Deutsche Rentenversicherung (DRV) or regional funding programs. As a regular soldier, you have the option of attending further training courses via Berufsförderungsdienst (BFD). Companies can also have their employees qualified via funding from Agentur für Arbeit (Qualifizierungschancengesetz).

We will gladly advise you free of charge.

0800 3456-500 Mon. - Fri. from 8 am to 5 pm
free of charge from all German networks.

Contact

We will gladly advise you free of charge. 0800 3456-500 Mon. - Fri. from 8 am to 5 pm free of charge from all German networks.