Quality Checklist Template

By

This package contains (1) a Quality Checklist template in Excel along with (2) instructions in Word. The macro-enabled workbook allows users to create checklist items as drop-down lists. Each drop-down element of a checklist item may be assigned a value and description.

Checklist item : Errors found testing Module 1

Drop-down element for user to select

Value

Description

6 or less errors

5

Acceptable. Please integrate Module 1 for integrated testing post rectified errors.

7-12 errors

3

Tolerable. Please conduct exploratory testing on Module 1 post rectified errors.

More than 12 errors

1

Unacceptable as unusually high number of errors were detected. Please review development process.

 

Table 1: Example of drop-down list elements of a checklist item

This quality checklist enable independent creation and amendment of drop-down lists by simply creating a new worksheet for each checklist item or modifying them. Thus the checklist form may be created and restructured by arranging the sequence of checklist item worksheets, at any time.

Checklist item worksheets are hidden during use. The VBA for Excel macros will validate each checklist item (i.e. the drop-down list elements) upon creation. The macros will tally user-assigned weights for all checklist items and provide a score (%) against the highest possible scoring (score are assigned arbitrarily) on completion of filling the checklist.

A separate workbook will be created from the completed checklist (without formulas or macros), and saved with a date title in XLSX format. This quality checklist template or form may be amended freely to suit your needs.

 

People who downloaded this item also downloaded . . .

Premium Content
PMI Membership
$129 /year
(plus $10 application fee)
Sign up to download this checklist and get unlimited access to our library of webinars, time-saving templates and more.
PMI Membership perks include job opportunities, local chapters, respected publications, and standards.   Learn more
Already a PMI Member? Log in now.

ADVERTISEMENT

5,003
Downloads

Reviews (6)

Login/join to subscribe
ADVERTISEMENTS

No matter how much cats fight, there always seem to be plenty of kittens.

- Abraham Lincoln