Title: Chapter 8 Excel Project
Course: Special Topics in Computer Programming (TEMPLATE) > Section: Competency Modules

Chapter 8 introduced seven metrics for measuring the efficiency or effectiveness of Automated System Testing.  The attached document "UsefulAutomatedTestingMetrics.pdf" was adapted from Chapter 8 of the textbook and puts all of the metrics together in a clear and concise manner with sample supporting graphical analysis.

Your assignment is to create an Excel spreadsheet to calculate ALL of the test metrics introduced in Chapter 8.  Be sure to identify the description of all of the parameters required for input so that when a user enters a value into the spreadsheet they will understand what they need to enter.

Since several parameters are used to calculate more than one test metric, you may find it more useful to have the user enter all of the necessary parameters in one place in your spreadsheet.

NOTE:  The formula for Test Progress (TP) in the book and attached document does not match the definition of Test Progress (TP) as test cases executed (TCE) over time  / Total Number of Test Cases (TC).  The correct formula should be TP = TCE / TC

When you are completed with this assignment, submit 1) your Excel spreadsheet, and 2) a commentary on what you learned from this exercise, via the assignment link.

Attached Files: | - Useful Automated Software Testing Metrics.pdf