UTeM BMFR Google Search Engine
How to make automated Check Sheet Using Microsoft Excel? | Macam mana hendak buat Check Sheet menggunakan Microsoft Excel?
Posted by BMFRGuru at 10:46 AMInstallation Guide. Click Here.
Definition: A simple data collection form consisting of multiple categories with definitions. Data are entered on the form with a simple tally mark each time one of the categories occurs.
Purpose: To facilitate the collection and analysis of data.
A check sheet is a simple means of data collection. The most straightforward check sheet is simply to make a list of items that you expect will appear in a process and to mark a check beside each item when it does appear. This type of data collection can be used for almost anything, from checking off the occurrence of particular types of defects to the counting of expected items (e.g., the number of times the telephone rings before being answered).
How to Construct:
- Clearly define the objective of the data collection.
- Determine other information about the source of the data that should be recorded, such as shift, date, or machine.
- Determine and define all categories of data to be collected.
- Determine the time period for data collection and who will collect the data.
- Determine how instructions will be given to those involved in data collection.
- Design a check sheet by listing categories to be counted.
- Pilot the check sheet to determine ease of use and reliability of results.
- Modify the check sheet based on results of the pilot.
Tips:
- Use Ishikawa diagrams or Brainstorming to determine categories to be used on the check sheet.
Construct an operational definition of each category to ensure data collected is consistent.
Make check sheet as clear and easy to use as possible.
Spend adequate time explaining the objective of the data collection to those involved in recording the data to ensure the data will be reliable.
Data collected in this format facilitates easy Pareto analysis.