Excel 6-Sigma Quality Tools Part-1 - a PDH Online Course for Engineers, Surveyors and Architects

Excel 6-Sigma Quality Tools Part-1

Course Outline

This 8 PDH course includes essential Six-Sigma quality control problem solving methods applicable to the statistics and technology of the: industrial, chemical, mechanical, electrical, and production engineering disciplines. The focus is on solving basic product and process quality problems using Excel math tools.

Any value of an input parameter can be found for a target value of an Excel calculated item by using the “Goal Seek” tool in Excel.

This online course describes basic Six-Sigma quality calculations. Major topics are:

1. Quality Defined
2. Decision Making
3. Math Tools
4. Process design
5. Product Design
6. Reliability
7. Manufacturing
8. Inspection

The course includes a multiple-choice quiz at the end, which is designed to enhance the understanding of the course materials.

Learning Objective

At the conclusion of this course the student will:

Increase knowledge of product design for Six Sigma;
Calculate the probability of a chemical process exceeding specification limits;
Use the Excel spread sheets provided to make basic statistical calculations;
Use Excel to estimate process parameter quality;
Acknowledge the, "Voice of the customer";
Compare process run charts of differing quality;
Know the three phases of the life cycle of a typical product;
Calculate product reliability;
Consider basic quality elements of a factory;
Perform Six-Sigma quality calculations using Excel;
Use Excel to calculate probabilities under the normal distribution curve;
Use a spread sheet to calculate: Mean values, Sigma, and Z-Score;
Make numbers of defective parts calculations;
Examine the effect of time on quality;
Use, “Utility” to compare values in decision making;
Evaluate alternatives with a decision matrix;
Determine upper and lower dimension limits to achieve desired quality levels;
Adjust parameters to optimize a process;
Use Excel to calculate present values of investments;
Understand the importance of product dimensions in relation to quality;
Plot 3 process variables in a three dimensional response surface;
Use the, “Root Sum of Squares” method for determining the effect of dimension tolerances on quality;
Use Excel to calculate gage reliability and repeatability, (G.R&R.); and
Obtain several web links to Six-Sigma related WEB sites.

Intended Audience

The information will be especially useful to students, entrepreneurs, engineers, and innovators who want to update their knowledge base concerning some of the most important elements of Six sigma applied to manufacturing and process quality control.

Benefit to Attendees

Attendee of this course will be able to use Excel to optimize many product and process parameters for quality and reliability.

Course Introduction

The market place for industrial products today demands innovation, improved designs, high reliability, quality, and low prices. This means rapid prototyping and production systems that are agile and able to change more rapidly. The basic components of manufacturing system quality elements are outlined in the course.

Course Content

You need to download and study the following spreadsheet:

Excel 6-Sigma Quality Tools Part-1

DISCLAMER: "This spreadsheet is provided for illustrative teaching purpose only, and is not intended for use in any specific project. Anyone making use of theinformation contained in this spreadsheet does so at his/her own risk and assumes any and all resulting liability arising therefrom."

Course Summary

A brief and to the point summary of basic quality control analysis is provided in these notes and spreadsheet calculations that will provide information that can be applied to real world applications.

Related Links

A. Six Sigma Summary: http://en.wikipedia.com/wiki/Six_Sigma.

B. Six Sigma started at Motorola: http://www.motorola.com/motorolauniversity.jsp

C. The Six Sigma Forum offers opportunities for you to learn from other Six Sigma professionals and share your own knowledge and solutions. http://www.asq.com/sixsigma/

D. The United States Patent and Trademark Office Home Page at www.uspto.gov provides links to information about all aspects pertaining to invention patents.

Quiz

Once you finish studying the above course content, you need to take a quiz to obtain the PDH credits.

DISCLAIMER: The materials contained in the online course are not intended as a representation or warranty on the part of PDH Center or any other person/organization named herein. The materials are for general information only. They are not a substitute for competent professional advice. Application of this information to a specific project should be reviewed by a registered architect and/or professional engineer/surveyor. Anyone making use of the information set forth herein does so at their own risk and assumes any and all resulting liability arising therefrom.