Confidence in test coverage comes with traceability of test artifacts to requirements. Traceability also provides the capability of regression test selection for interim (and final) software releases. While there are sophisticated tools that provide these capabilities, this article outlines a simple creation, analysis and reporting capability for traceability using MS-Excel and MS-Query. MS-Query comes standard with the Microsoft Office suite of applications.
Establishing Traceability of Software Test Coverage Using MS-Excel
A Simple Approach