Check Sheet in 7 QC Tools  Different Types  Excel Template

What is a Check Sheet?

→ It is a systematic method of collecting, recording, and presenting the relevant data in a simple manner for analysis of the process and it is also known as a "Tally_Sheet".
→ It can collect qualitative and quantitive data also.
→ It is one of the most popular tools of 7 QC Tools for process improvement.

What is a Check Sheet used for?

  • Data collection
  • Monitoring the manufacturing process performance
  • It is also used for traceability purpose

5 Basic Types of Check Sheets

→ Dr. Kaoru Ishikawa identified five different types which are mentioned below.
  1. Process performance, 
  2. Defect item,  
  3. Defect location, 
  4. Task conformation (Related to traceability) etc...
  5. Defect cause

5 Basic Types of Check_Sheets

👉 Check Sheet Excel Template Download

How do I make a Check Sheet?

→ The five steps are mentioned below.
  1. Establish what information is needed.
  2. Determine 5W and 2H.
  3. Construction.
  4. Testing.
  5. Take the final approval for Use.

How do I make a Check_Sheet?

Step 1. Establish what information is needed

→ Define what information is needed?
→ Sometimes this is known as record form, data form, etc....

Step 2. Determine 5W 2H:

→ Why is the data_needed?
→ What type of information collection is required?
→ Where the data_should be collected from? (Plant/machine/place)
→ Who has to collect the data?  (Operator/ supervisor/manager)
→ When will the information be collected?  (Every hour/ at the time of receipt)
→ How the data_should be measured? (Instrument/clock)
→ How much data_is essential?

Step 3. Construction of the Sheet:

➝ CheckSheet has three types of information.
     [1] Title
     [2] Source information
           ⇢ Name of the project/ problem theme.
           ⇢ Location of data_collection.
           ⇢ Date and/or time.
           ⇢ Name of the person recording_data.
     [3] Content information
           ⇢ Column/Raw with defect/event name.
           ⇢ Then Column/Raw to record frequency.
           ⇢ And Column/Raw to record total.

Step 4. Testing of Sheet:

➝ Test the_Sheet with at least three different collectors.
➝ Reconfirm that the columns/ rows are relevant and required.
➝ Check if the_Sheet is easy to record and use.
➝ Make changes based on the feedback.

Step 5. Final approval for using this_sheet:

➝ Explain the use of this_sheet to the data collector.
➝ Ensure that the data_collector understands the reason for which the data is being collected.
➝ Collect_data.
➝ Standardize its use to assure consistency.

Defect Cause Check Sheet Example:

➝ For a better understanding refer below the picture.
➝ In this example, we have mentioned the day-wise count of the defect and at the end of the week analyze the defect to take appropriate action to eliminate those.

Defect Cause Check_Sheet Example

➝ The example of the defect collection tally_sheet is mentioned below.
➝ In this example, we have counted the frequency of various defects at the time of checking the product in ongoing production.

Example of Tally Sheet

Benefits of CheckSheet:

➝ By using this we can make data gathering simple, systematic, easy and effective
➝ We can save time and get easily data collection in regular Manufacturing Process
➝ It is used for monitoring process performance
➝ We can use this for different purposes like counting, tracking, etc.
➝ It is also very helpful for traceability

👉 Also Read:
      2. Cause & Effect Diagram (Fishbone or Ishikawa)

👉 For a regular update :   
Join us (Telegram Group)
Join us (WhatsApp Group)

👉 See Also:


  1. Good bro ...Easy to understand

  2. Good sir ji ,but can u provide Excel sheet formats for better practice

  3. How can i use checksheet in service industry?

    1. You can use check sheet for data collection for any regular or project related activity.

  4. Hello sir,
    Which type of check sheet can help in PPGL and GC sheet cold rolling process for detecting foul length cut? Or how cani Implement it?

    1. You can prepare check sheet as per your specific requirement that you need to monitor. Thanks!!!


Post a Comment

Previous Post Next Post