7 Quality Tools with Minitab & Excel for Quality Management
3.9 (51 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
160 students enrolled

7 Quality Tools with Minitab & Excel for Quality Management

Mastercourse: 7 Basic Quality Tools with Minitab,Excel,Case Studies for Quality Management,Sixsigma & Project Management
3.9 (51 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
160 students enrolled
Created by Gunjan Subedi
Last updated 4/2020
English
English
Current price: $20.99 Original price: $29.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 3 articles
  • 33 downloadable resources
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Define and understand seven quality tools and their functions in quality.
  • How to use Minitab and excel to solve quality problems.
  • How to find the problems, solutions and improve the process for future business endeavors.
  • How to extract important information from data.
  • How to use the findings for future improvements.
  • How to drive a sense of continuous improvement in an organization through Quality tools.
Requirements
  • Enthusiasm to learn and discover new stuff in the quality sector.
  • Basic mathematics.
  • Basic working with excel.
Description

About course-  7 Quality Tools with Minitab & Excel for Quality Management

"As much as 95% of quality related problems in the factory can be solved with seven fundamental quantitative tools", Kaoru Ishikawa (Professor at the Faculty of Engineering at The University of Tokyo, also known as father of Japanese Quality Control/ father of the scientific analysis of the causes of problems in industrial processes).

Are you looking for a course that serves as a foundation of problem-solving, improvements and root cause analysis? Are you manufacturing, business, service or quality based professional or do you have an interest in these fields? Do you want to walk with professional problem-solving issues that matter for a lifetime? If so, congratulations, this course is definitely for you!

Walking through various journeys as a formulation scientist, Quality Management, Lean, six sigma and quality assurance specialist I felt my skills must be transformed to a learning platform that can help students solve the most basics of the quality problems. Seven Quality Tools will help you walk with skills applicable daily in business and quality management sectors.

Who should be taking this course?

This course could be useful for any professionals and students looking for improving their skills in quality sectors or have an interest in quality management in business fields. The content of the course would also be equally valuable for students anticipating six sigma or lean sigma belt examinations (Particularly Basics, Yellow or Green belts).

The content of the course would also be helpful for PMP certifications and students appearing in Certified Quality Engineer (CQE) and Certified Quality Technician (CQT) exams.

The 7 tools that we would be learning are:

  1. Fishbone for root cause analysis and looking for potential causes of the problem.

  2. Flowchart for process mapping where we study simple flowcharts or top-down flowchart for logical process flow, swim-lane maps or deployment maps where we will study the process flow along with interrelation among the different departments and value stream maps which will give us an eagle-eye view of the process.

  3. Pareto Analysis or Pareto chart based on 80:20 principle meaning 80 percent of results are due to 20% of the causes.

  4. Histogram for the visual representation of data, trends, and variations.

  5. Control Chart to understand how a process changes over time.

  6. Check sheets for collecting and organizing measured or counted data.

  7. Scatterplot (with stratification) for finding the relationship among the data

What do you learn in this course ?

· Define and understand seven quality tools and their functions in quality.

· How to use Minitab and Excel to solve quality problems.

· How to find the problems, solutions and improve the process for future business endeavours.

· How to extract important information from data.

· How to use the findings for future improvements.

· How to drive a sense of continuous improvement in an organization through quality tools.

And What’s New and Extra in this particular course?

· Real life and simulated case studies to showcase actual use of these tools.

· Minitab and excel templates to work out

· Quizzes, pdf handouts and a lot more!

· 7+(1) unique tools and approaches to handling quality issues.

Who this course is for:
  • Any professionals and students thinking of improving their skills in quality sectors and have an interest in quality management fields.
  • Other than these following professionals may find the course more useful.
  • Students appearing in Certified Quality Engineer (CQE), Certified Quality Technician (CQT) exams.
  • Students anticipating for six sigma or lean sigma belt examinations (Particularly Basics, Yellow or Green belts) and PMP certifications.
Course content
Expand all 55 lectures 02:34:00
+ Introduction
5 lectures 19:52
Introduction
01:47
Benefits of seven quality tools in different sectors
07:45

This is the first quiz session of this course. You will encounter many other quizzers and one final 'Practice Quiz' at the end of the course. You can skip the quizzes but I highly recommend you to go through them as they contain answer descriptions and unit revising points !

QUIZ TIME
1 question
+ MODULE 2: CAUSE AND EFFECT DIAGRAM
9 lectures 27:00
Introduction and types of Cause & Effect/fishbone diagram
03:53
Steps of Drawing a Fishbone/Cause and Effect Diagram
01:46
Fishbone with EXCEL
00:38
Fishbone Intro Minitab
01:38
MINITAB TUTORIAL: 4S FISHBONE
06:30
MINITAB TUTORIAL: 6M FISHBONE
04:44
MINITAB TUTORIAL: 8P FISHBONE
01:39
SIMULATED CASE STUDY 2: FINDING CAUSES FOR LOW NUMBER OF VISITING CUSTOMERS
02:33
Intermission !
03:39

This is a simulated case study quiz. You will encounter many such quizzes in between and one final 'Practice Quiz' at the end of the course. You can skip the quizzes but I highly recommend you to go through them as they contain descriptions and unit revising points !

SOLVE THESE PROBLEMS-SCENARIO 1 & 2
2 questions
+ MODULE 3: FLOWCHART AND PROCESS MAPPING
9 lectures 26:14
Flowcharts in excel
01:47
Top down flowchart
01:54
How to draw a Swimlane Maps ?
02:08
SIMULATED CASE STUDY 3: ORGANIZING WORK FLOW IN DIFFERENT DEPARTMENTS
04:58
Value Stream Maps
04:42
Icons in value stream maps
05:05
SIMULATED CASE STUDY 5: OVERVIEW OF A PIZZA SERVICE
02:44
Excel Tutorial: Value Stream Mapping
01:26

This is a simulated case study quiz. You will encounter many such quizzes in between and one final 'Practice Quiz' at the end of the course. You can skip the quizzes but I highly recommend you to go through them as they contain descriptions and unit revising points !

SOLVE THESE PROBLEMS- SCENARIO 3,4,5 and 6
2 questions
+ MODULE 4: CHECKSHEETS
5 lectures 08:36
Introduction of Checksheets
01:01
Steps of drawing Checksheets
01:15
Different Kinds of Checksheets
01:47
SIMULATED CASE STUDY: DEFECT CONCENTRATION DIAGRAM
03:49
Making checksheets in EXCEL
00:44
+ MODULE 5: PARETO CHART AND PARETO ANALYSIS
4 lectures 09:33
Introduction to Pareto Analysis
02:34
Pareto Analysis with Excel
01:43
Pareto Analysis with Minitab
02:43
SIMULATED CASE STUDY 6: REDUCE WORKING CYCLE IN RETAIL FOR BETTER SERVICE
02:33

This is a simulated case study quiz. You will encounter many such quizzes in between and one final 'Practice Quiz' at the end of the course. You can skip the quizzes but I highly recommend you to go through them as they contain descriptions and unit revising points !



QUIZ TIME FOR SCENARIO 7
1 question
+ MODULE 6: CONTROL CHARTS
6 lectures 19:31
Control Chart and Types
03:05
Observing stability of data with run and control charts
02:50
Control chart with Minitab (X bar R chart)
05:41
Control Chart for Individuals
01:55
Control Chart before and after improvements
02:29
Control Chart and process capability
03:31

This is a simulated case study quiz. You will encounter many such quizzes in between and one final 'Practice Quiz' at the end of the course. You can skip the quizzes but I highly recommend you to go through them as they contain descriptions and unit revising points !

QUIZ TIME FOR SCENARIO 8,9,10
3 questions
+ MODULE 7: HISTOGRAM
5 lectures 12:54
What is histogram and what are the benefits?
01:53
Histogram with Excel
01:02
Histogram with Minitab
06:00
Histogram for making comparisons
02:20
Histogram with Fit
01:39

This is a simulated case study quiz. You will encounter many such quizzes in between and one final 'Practice Quiz' at the end of the course. You can skip the quizzes but I highly recommend you to go through them as they contain descriptions and unit revising points !

QUIZ TIME FOR SCENARIO 11 and 12
2 questions
+ MODULE 8: SCATTERPLOT AND STARTIFICATION
9 lectures 24:28
What is a Scatterplot?
04:47
Correlation
01:29
Using scatterplot with EXCEL
01:21
Using scatterplot with MINITAB
05:11
Individual Value Plot
01:51
Time Series Scatterplot
02:10
Scatterplot with Regression
03:20
What is Stratification?
01:50
Stratification with Minitab
02:29

This are the final simulated case study quizzes.

QUIZ TIME FOR SCENARIO 13 and 14
2 questions
+ WRAP UP: WHAT HAVE YOU LEARNT SO FAR?
1 lecture 00:54

As you have learned many things together so far, now it's time to check your knowledge. Please answer the following Multiple Choice Questions (which may contain single or multiple right answers) and check your score at the end of the test to understand which area you need to improve further...

FINAL EXAM: TEST YOUR KNOWLEDGE !
15 questions
How to download the Udemy Certificate?
00:54