Back to homepage Contact us  
List of training courses View trainer's profile

Course Details

 
 
 
 
 
 
 
 
STATISTICAL PROCESS CONTROL (SPC 1 )
(Using Microsoft® Excel)
   
iNTRODUCTION :
 
"Reduce those boring and tedious tasks to just a few clicks of a button on the computer keyboard. Automate charting to improve on accuracy and speed. Spend more time analyzing what your data is telling you about the process and take corrective actions.. These are some advantages this course has over traditional SPC course."
 

Statistical Process Control (SPC) is a worldwide standard and a proven technique used extensively in the manufacturing and service industry, especially for process control and quality improvement initiatives. This training program will explore a smarter and a more effective way of learning SPC program in a faster and painless manner. It provides the foundational skills and tools for quality improvement team leaders and members who need a good grasp the basic principles and concepts of SPC to execute correctly the process improvement projects in their daily work.

What differentiates this training program from “traditional” SPC course is that it helps to “accelerate” the participant’s learning curve. By utilizing the common computer spreadsheet techniques, we can reduce meticulous tasks such as tedious calculations, graphing and searching of statistical tables into just “a few easy clicks of buttons on the computer keyboard”. By doing so, it will allow participants to have more time to focus on the more important skills (such as the analysis/interpretation of the control charts/patterns, establishing action plans to reduce process variances and improve process stability) rather than on calculations or charting activities.

Computerized simulation techniques are also used throughout the course to will help explain the workings of statistics and reveals the power of SPC techniques to assist with problem solving and process control. This training program combines various teaching methods (group discussions, case studies, demonstration, computer simulations, etc) that will definitely help accelerate and reinforce the participant’s understanding of the control charts functionalities with an emphasis on participation throughout. This training program is a must for those who are serious about acquiring Statistical Process Control skills using an effective and accelerated learning method.

NOTE: Value-add MS Excel working templates will be given to participants after completion of this course. These working templates can save participants hundreds of hours in creating charts and building tables. With this valuable tool, participants can transfer all that is taught into their workplace immediately.

COURSE OBJECTIVES:

At the end of the course, participants will..

  • Understand the overall concepts, principles and methods using “Statistical Process Control” as an important tool in performing Quality Control activities.
  • Acquire knowledge in selecting the right control charts for their manufacturing and servicing activities.
  • Sharpen the skills to quickly construct control charts using the MS Excel templates.
  • Acquire the basic knowledge of analyzing control charts and its patterns.
  • Identify practical hands-on opportunities – explore and develop Process Capability Studies
course contents:


Introduction:

  • Why use MS Excel as a statistical tool?
  • Computerized statistical calculations & graphing techniques.
  • Benefits of charting presentations.
  • What is SPC & why use SPC?
  • Systematic Problem Solving process

Using computer spreadsheet to construct Control Charts:

  • Concepts, constraints and techniques
  • Demonstration and exercises.

Understanding Data & Basic Statistics

  • Data availability and presentation
  • Frequency distribution and measurements
  • Histograms and Normal Curve
  • Normal Distribution
  • Central Limit theorem

Introduction to Statistical Process Control

  • Prevention vs Detection
  • A Process Control System
  • Variation: Common and Special (Assignable) causes
  • Process Control and Process Capability

Introduction to Control Charts

  • Basic principle
  • Process model simulations.
  • Variables and Attribute charts
  • Selection of control charts

Control Charts for Variables

  • Xbar-R chart
  • Interpretation of control chart
  • Control limits vs Specification limits
  • Calculation of process capability: Cp, Cpk
  • Xbar-S chart
  • XmR chart

MS Excel Exercises

  • Accelerated method of constructing all the Control charts using MS Excel.
  • Interpretation of what the data/pattern reveals.
  • Stratifications and making decisions based on interpretation of data

Control Charts For Attributes

  • Proportion defective charts (p-chart, np-chart)
  • Number Defect charts (c-chart, u-chart)

Practical Procedures

  • Process capability study
  • Using MS Excel working templates
  • Case studies
  • Control Charts Benefits

**SPECIAL NOTE ** :

1). Computer spreadsheet program will be utilized throughout the course to demonstrate the power of the tools used and to significantly reduce the time required for calculation and graphing activities. Participant with prior knowledge of basic computer spreadsheet (e.g. MS Excel: using formula, edit graphs, printing, etc) will help complement the accelerated learning objectives of this course. MS Excel working templates will also be provided to equip participants for immediate transfer of training to their workplace

If the participant would like to have prior training on Microsoft® Excel basics before attending this course, please click here to find out more.

2). Class setup must include making computers preloaded with MS Excel 2000 (and above) licensed software available for participants to work.

 

who should attend:
  • Managers, Executives, Engineers, Supervisors, Technicians
  • Team (Project/SGA/QCC/WIT) Leaders & Members
administrative details :
Duration : 2 days
Time : 9.00am - 5.00pm
Venue : In-house or public program
Language medium : English
 
 
Trainer :
Nelson Kok (please click here to see trainer's profile)
 
 
 
 

Click on the above banner to find out more about other Accelerated Learning Courses
Back to Top
 
Home | Courses | Trainer Profile | Contact Us
Train for Personal Effectiveness and Organizational Growth
© 2006 MyTrainingProvider.com, All Rights Reserved.