Project Quality Management Using Excel

Project Quality Management Using Excel 
Project Quality Management Using Excel 
Quality assurance (QA)/quality control (QC) engineers are responsible for ensuring the quality of products and services produced by their company.  They oversee the manufacturing of products and they are involved in every stage of making a product–from development and manufacturing to packaging. 
QA/QC engineers must make sure that their product complies with industry standards set by state and federal law as well as the standards of the company for whom they work.  Another responsibility they have is to make sure that the processes and machinery or materials used to make their products are also safe for the employees.  When there is any kind of quality issue, they must take the steps to fix the problem, even if this means halting production.  They try to work out any issues that may arise while in development, but they must still be able to handle any issues that happen during production.  QA/QC engineers observe production and they usually report to an operating supervisor or a production manager.  They generally work in the factories or plants where the products are made but they also may have offices as well.
Total Training Hours : 22 Hours
Training Duration      : 1 Week
Total Training  Days  : 4-5 Working Days
Weekdays (Sunday to Thursday)
Regular Sessions : 4 – 6 Hrs Per day (9am to 2pm or 3.00pm to 9.00 pm)
Food & refreshments Included
Weekends (Friday & Saturday)
Fast Track Sessions: 8 Hours per day (9am to 5pm)
Food & refreshments Included
Globally recognized certificate from “Kings Global Career Academy”
Hard & Soft Copies of Study Material
1. Email
2. Social Media (For Emergency requirements)
1. Passport Copy
2. Curriculum Vitae
3. Passport size photographs
4. Course Fee
Cash / Cheque / Credit Card / Bank Transfer.
Managers, executives, supervisors and management staff who want to gain knowledge and staff who are likely or currently involved in implementing and maintaining  and key personnel assigned for internal audits, management representatives (MR), etc
  • Perform and coordinate inspections and determine quality assurance testing models of raw materials and finished products.
  • Prepare, document, and execute detailed test plans, test cases, and defect reports.
  • Review and approve quality requirements for manufacturing planning, supplier purchase orders, and engineering specifications to ensure contract compliance.
  • Develop, document, and audit practices, program quality, and metrics reporting system.
  • Define quality and quality management
  • Differentiate between quality planning, quality assurance, and quality control
  • Explain the cost of quality and its categories
  • Describe the Project Quality Management processes
  • Explain the seven basic tools of quality
  • Explain Six Sigma

Project Management Process Map
47 processes in project management


Quality-Related Terms
It is important to discuss a few terms to understand the concept of quality better.

Customer satisfaction is defined as “conformance to requirements and fitness for use”. It is important to understand the subtle distinction between quality and grade.

The grade is a classification based on technical characteristics. Low quality is always a problem, but low grade may not be a problem – rather it would be a matter of choice. Similarly, it is important to understand the distinction between precision and accuracy.

Precision is the granularity of measurement, i.e., how fine-grained can you measure the outcome. Accuracy is how correct you are, i.e., how close you are to the desired value. In the next section, let us understand the concept of an optimal level of quality.
Optimal Level of Quality

Quality Management

  • Quality planning is the first step when quality related activities of the project are planned
  • Quality assurance is the stage of implementing those quality plans
  • Quality control is the stage when periodic checks are done to see if project quality is improving

Quality Planning vs. Quality Assurance vs. Quality Control

  • Quality Management Concepts
  • Total quality management or TQM is a quality management philosophy that involves holistic thinking about meeting the objectives of an organization. It places the responsibility of quality squarely on the management.
  • Kaizen is a Japanese term that stands for “change for better.” Kaizen philosophy is one that should always be looking for small and continuous improvements in the process.
  • Deming cycle or PDCA cycle
  • Kanban is a pull-based management system
  • Cost of Quality
  • Cost Of Conformance
  • Cost Of Non-Conformance
  • Internal failure costs
  • External failure costs

    Project Quality Management Processes
  • plan quality management – which is done as part of the planning process group
  • perform quality assurance – which is done as part of the executing process group
  • control quality – which is done as part of the monitoring and controlling process group
  • Perform Quality Assurance
  • Control Quality
  • quality control measurements
  • the verified deliverables
  • validated changes
  • information about the work being performed
  • recommended changes
  • updates to the organizational process assets, project management plan, and other project documents

Business Scenario—Problem Statement

  • Business Scenario—Solution

Seven Basic Quality Tools
There are seven basic quality control tools and they are:

  • Control charts
  • Cause and effect diagram
  • Flowcharting
  • Histogram
  • Pareto diagram
  • Check sheets
  • Scatter diagram
  • Cause and effect diagram