Six Sigma Certificate Series
Tools and Templates
General
- QFD.xls
Excel template for creating House of Quality matrix used in QFD – multiple worksheet workbook - FMEA.xls
Excel template for performing Failure Modes Effects Analysis (FMEA) - Fishbone.xls
Excel template for creating Ishikawa or fishbone diagram - VOC.xls
Excel template for Voice of Customer (VOC) weighted ranking - Activity Analysis.xls
Excel template for time/activity analysis. It helps to collect the time spent in everyday work schedules, programs, or project activities. See activity analysis directions for more details on tool - Activity Analysis Directions.doc
Support document for tool above - Activity Cost Matrix.xls
Excel template for Activity Based Costing (ABC) analysis. It’s a useful cost data collection tool for the purpose of planning and budget preparation. See activity cost matrix directions for more details on the tool. - Activity Cost Matrix Directions.doc
Support document for tool above - Value-NonValue Added Cycle Time Chart.pdf
A value/non-value-added cycle time chart displays all activities and the cycle time required from the start point to the stop point of a process. The intent of this tool is to identify non-value-added activities such as lengthy delays, redundant or time wasting activities, or excessive reviews and approvals.
Course Specific
Six Sigma Data Measurement, Analysis, and Tools
- Analyze On-line Assign Soln.xls
- Sigma Level Calculator.xls
- Catapult DOE
- Control Phase
- Hypothesis Testing
- Define VOC On-line
- Key Statist Concepts
- Gage R&R short method.xls
Excel template for simple Gage R&R tests. Doesn’t separate reproducibility or repeatability. - DPMO calculator.xls
Excel template for calculating defects per million opportunities (DPMO) - Discrete data sample size.xls
Excel template that calculates sample size needed for discrete variables to verify corrective action has had an impact - Discrete Gage RR.xls
Excel template that calculates Gage R&R effectiveness on discrete data, up to 100 samples, up to 3 operators - DOE example.ppt
Powerpoint slides describing steps needed to perform Design of Experiments using Minitab - Staffing cycle type slides.ppt
Powerpoint slides describing steps needed to perform hypothesis testing in Minitab
Six Sigma for Service and Healthcare Industries
- QTP Add-in template.xls – A MS Excel spreadsheet setup to analyze process queues using the QTP Add-in (http://www.business.ualberta.ca/aingolfsson/QTP/ )
- Queuing Template-variation.xls - A MS Excel spreadsheet built to analyze process queues that have variation in arrival rate and service rate. Adapted from the template provided in the resource book “Microsoft Excel Data Analysis and Business Modeling,” W. Winston, copyright 2004, Microsoft Press, ISBN 0-7356-1901-8
Independent Project
- Affidavit.doc – A MS Word document that contains the template that all projects must submit. Note that if UW mentoring is requested, the project description and charter sections need to be completed and reviewed with your UW mentor prior to working on the project.
- Project Selection Criteria.doc – A MS Word document with suggestions for process improvement projects
- Sample A3 project report out form
- DMAIC logbook
- Sample Project Dashboard
Need more info?