The test team can take advantage of the Office Excel reports in the Test Team Management folder to monitor progress and identify the volume, status, and effectiveness of their test activities. The test management reports display team-project information that is stored in the data warehouse. The four Office Excel workbooks provide 17 reports, and each report appears in on its own worksheet.
Most of these reports are available only when the team creates test cases and test plans and starts to run tests by using Microsoft Test Manager. For more information, see Testing the Application.
All reports are provided for both Microsoft Solution Framework (MSF) process templates: MSF for Agile Software Development v5.0 and MSF for CMMI Process Improvement v5.0.
Note
You can access the Test Team Management folder from the Excel Reports folder for the team project in Team Explorer. You can access this folder only if your team project portal has been enabled and is provisioned to use SharePoint Products. For more information, see Access a Team Project Portal or Process Guidance.
Test Team Tasks
Task
Related topics
Monitor the success or failure rate of test activities with each build. The Build Quality workbook provides the following two reports, which show the test results for all build definitions for a team project.
Build Verification Testing: Helps the team monitor the quality of builds by showing test results for all automated tests that are marked as Build Verification Tests (BVT) and that are run during the build process.
Test Activity Per Build: Helps the team monitor the quality of builds by showing test results for all tests that have been run against the build for all or selected test plans.
The count of test results in these reports represents a cumulative count of the most recent version of each test result in a particular build.
Monitor the overall productivity and effectiveness of the test team's test and bug generation activities. The Test Team Productivity workbook provides the following four reports, which show test and bug activity.
Test Activity: Helps the team monitor the volume of tests that they have run over the past four weeks.
Test Activity Per User: Helps the team track the volume of tests that each team member has run over the past eight weeks. The team can use this to help load balance the test activity across team members.
Bugs Created By User: Helps the team track how many bugs each team member has created.
Bug Effectiveness: Supports the team in determining how effective they are in defining bugs that are useful and help build a quality product.
Determine where the test plans, test configurations, and test coverage are deficient. The Testing Gaps workbook provides the following five reports, which are based on test results and builds that have been defined and run for a team project.
User Story Status or Requirement Status: Helps the team identify gaps in test coverage for each user story or requirement.
User Story Status by Config or Requirement Status by Config: Helps the team identify gaps in test coverage for each test configuration for each user story or requirement.
Test Status by Area: Helps the team identify gaps in test coverage of product areas. This report requires that team members assign test cases to product areas.
Tests Not Executed: Helps the team identify test cases that have never been run for each test configuration.
Code Coverage: Helps the team determine which builds and build assemblies have low or high code coverage.
The count of test results in these reports represents a cumulative count of the most recent version of each test result in a particular build. If a test is run multiple times against a build, the count includes the most recent result for that test for that build.