Establishing Traceability of Software Test Coverage Using MS-Excel

A Simple Approach
Member Submitted

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.

About the author

Venkat Moncompu's picture Venkat Moncompu

Venkataraman "Venkat" Moncompu is a Director with Cognizant Technology Solutions. Having a Master's degree in Engineering, he has over 17 years of IT industry experience. He has worked in various capacities as a Developer, Solution Designer, Business Analyst, Project Testing Coordinator and Project Manager. Currently, he leads the test automation center of excellence.

AgileConnection is one of the growing communities of the TechWell network.

Featuring fresh, insightful stories, is the place to go for what is happening in software development and delivery.  Join the conversation now!