Software Testing Templates

Excel software testing templates for model building

Excel Software Testing Templates

Rate this solution:

(3/5 from 4 votes)

Software Testing Templates for Excel are provided along with Word templates as a complete set of tools for software testing processes, checklists and logs. The standardized software testing solution includes 27 Excel templates and 50 Word templates that save time and ensure efficiency for software development and the testing process.

Change Control Log - Identifies the basis for the change and confirms whether it is disapproved or approved. Includes The Software Change Request Number (SCR) #, Requirements #, date submitted and whether it is approved/not approved, on hold, in progress, or canceled.

Change History Log - Describes the date, author and history.

Data Access Control - Identifies the individuals or groups who have access to the test cases and their status.

Deviation Control Form - Records minor adjustments (i.e. deviations) that must be made to the system in order for testing to proceed.

Document Control Form - Identifies, track and monitors test scripts.

Failed Scripts - Identifies where test scripts have failed and provide details of the error and its severity.

Issue Submission Form - Describes Errors/issues that must be addressed for testing to proceed.Usually sent by users or testers to the Line Manager.

Log Status - Identifies Log ID for each log, the nature of the risk/issue, and whether it is Open or Closed.

Open Issues - Identifies all open issues by number, date created and tester with descriptions of Target Date,Category, Status, Resolution and Date.

Project Costs - Determines the cost of running all test related activities throughout the software development life cycle.

Risk Log - Identifies the Risk Number, its Date, Type(e.g. Business/Project/Stage) a brief description, Likelihood percentage,Severity, Impact, Action Required, who was assigned to it and its Status.

Roles and Responsibilities Descriptions and Matrix - Identifies all the roles on the project, with details of their responsibilities with contact names and email addresses.

Status Report - Identifies the function that is under test with specification of business value on a scale of 1-5 with 1 the lowest value and 5 the highest (or whichever numbering system desired) and details of the problem severity broken out by a factor of 1 to 5.

Test Preparation - Identifies all activities that must be performed before testing commences, such as reviewing specifications and prioritizing test items.

Test Case - Tests a specific part of the system as per the Test Plan.

Test Validation Log - Tracks the results of the test cases.

Test Script - Provides input for the Area under test, its Set and whether it has Passed or Failed with a Description of the Error And its Severity.