Test Matrix User Manual
Contents
1. 1 Compatibility Mode Microsoft Excel X Home Insert Page Layout Formulas Data Review View A ao n A N ee aA Si Wrap Text zenera ai gt x Fei Autosum p B Ga Siza s A eam r Wap Te at 5 a Fill th Paste r D A gt s BS ES ESS ne amp Center Yay E Conditional Format Tell Insert Delete Format Sot amp Find amp x F Bie eres a gt la s Formatting as Table Style z 7 2 Clear Filter Select Clipboard amp Font Alignment Number Styles Cells Editing H11 f A B G D E F G ee J K L M N Fa 7 8 9 Date Information Testing Information 10 ead 10 13 2011 TESTING CONDITION _ 12 13 Expected Test Start Date 01 00 1900 lt lt TOTAL FOR ALL TESTS PERFORMED gt gt 14 Expected Test Completion Date 01 00 1900 of Test Cases 15 of Test Cases Completed Fo 16 Total Testing Days for Project 0 Percentage Completed 17 of Test Cases Passed xe 18 Total Days Since Start 29164 19 Total Days Before Completion of Test Cases Failed 0 20 21 Date at 1 4 point lt lt Total For All HIGH Tests Performed gt gt 22 Total of HIGH Test Cases 0 23 ofTest Cases Completed 0 24 Percentage Completed 25 of HIGH Test Cases Passed 0 26 of HIGH Test Cases Failed 0 27 28 29 Total of MEDIUM Test Cases 0 30 of Test Cases Completed 0 4 4 gt gt Purpose Scope Test Grid Results Special N2. 2 M ES A ENA ee See ee EL E a ee TESTING CONDITION x Dags Left before 73 work dags This test grid can accommodate test cases up to row 262 Completion 3 ip w 4 BA off 7 Tester Name a l E ae 1 x jM 4 gt m Purpose Scope Test Grid Results Special Note Ready 2 1 In the test scenario column number the Test Scenario s and provide a brief description of the Test Scenario in the Test Case Description column The example shown above uses A as a label for Test Scenario The description of the Test Scenario is Partial Withdrawal The Test Scenario information row is highlighted for formatting reason so that it stands out from the Test Case information 2 2 In the test case column number the Test Case s and provide the following information about each Test Case a Test Case Description exact detail of how this test case should be executed Test Matrix User Manual 8 b Priority select the priority from the drop down box High testing not complete until executed and signed off items critical to complete the project implement the modification or correct the problem include items that are high frequency high dollar impact or immediate impact Medium testing not complete until executed and signed off must still be completed before move to production may not have immediate implementation impact Low may not be completed prior to moving to production d
3. TION the Priority Field must be selected as a test caseis ERROR2 created For accurate calculation of of Test Cases there must be either number alpha character or some ERROR 3 labeling in the Test Case column For accurate calculation of RESULTS Page Test Scenario row should have not any Test Case or ERROR 4 Priority or P F selected Special Note Factor 1 and Factor 2 are freeform fields and they can be customized 26 27 30 31 33 34 35 3T 40 u 42 a 44 45 46 Test Matrix User Manual 6 How to use the Test Grid Tab The recommended Test Matrix is located on the Ameritas Intranet Technology Center page Below is a path to this Test Matrix Under the Technology Center page Project and Maintenance Methodology Templates Test Matrix Intranet Home Page Windows Internet Explorer provided by Ameritas G P Eel https unificompanies com EITS ttx ay File Edit View Favorites Tools Help Snagit ea w Favorites B e iD Fall Products Release m IT BT PLANNING amp STATUS m Open Reports 2D Planfile monthly status m WR 7204 YUL Intranet Home Page fp gt Pager Safety Tools Home Page Human Resources Shared Services Technology Center Communities J PeopleSoft RPConnect Templates Initiative Value Statement Cost Benefit Analysis Worksheet Project Charter Risk Management Plan Work Plan Tool Project Plan Small Project Plan Medium Proj
4. Test Matrix User Manual January 5 2012 Revision 2 Test Matrix User Manual Table of Contents Overview of this training manual ccccseeecececeeeeeeceeeeeeeceeeeeeeseeeeeesseeuceessuaeeeeessaneeesseeeeeseas 3 OVERVIEW OF TING TeSt MaN oisin Schoen ttn detcteslucsin ce epeteneh Matesbvedsbecssnattsies 4 PUNDOSE SCODE tess tenis nes siaese iinet eatbeteh a a A 4 TESE ONGe rete mee er erent eaten rece ne omen are nace OT nome gets Soe ne ato wee ene Ree Peer ee ern eee 4 SSUES anre pana teelcwdacsintsuat aroma bb ar cca bestia buen wucanunceute nde mites Smaatenaameadueiadacume eae 4 SPeClal NOLS seessiicct ctebiceeereyaersig ea ceatiuiatinse E 4 How to use te heSt GIG AO acta tiet cis ticccuesannconsut a aa aa aii 6 Resu Tapies ERE E EEEE EE REEE 8 ROIO Festung COOKOIMNGLOF seams a e E a Erai 9 QSA eraai ieraesametiatteatsit Test Matrix User Manual Overview of this training manual This document serves as a supplement and guide to the recommended Test Matrix It provides a summary of functionality and features available It provides detailed information on how to use this recommended Test Matrix lf there are any questions after reviewing this manual please contact the IT Application Quality Team using the Lotus Notes Group IT Application Quality Test Matrix User Manual 4 Overview of the Test Matrix The test matrix is an excel document that is made up of 4 tabs 1 Purpose Scope 2 Test Grid 3 Resul
5. ect Plan Large Status Report Issues List Change Request Training Plan Tool Implementation Plan Lessons Learned Tool Final Status Report Business Requirements Functional Specifications Technical Design Technical Design Exemption Test Master Plan Traceability Matrix Test Matrix Test Matrix Summary Use Case Index Use Case Test Case https secure unificompanies com OCM GetFile doc 171619 a Local intranet f 100 1 Complete the title section of the test grid Move the cursor to the field highlighted in gray to enter the information Project Region Environment Test Type Testing Start Date 05 01 2011 Testing Completion Date 12 34 2011 Testing Signoff Tester Name Project Name of the project and project number Test Matrix User Manual 7 Region Environment Name of the environment or region that this test matrix is being executed in Testing Type Type of testing i e Unit Integration CAT Performance or Regression Testing Testing Start Date Date that the execution of this Test Matrix will start Testing Completion Date Date that this Test Matrix should be completed Testing sign off Date that the tester signed off on this Test Matrix Tester Name Name of the tester executing this Test Matrix 2 Complete the Test Matrix Planning El Microsoft Excel Kat s Test Matrix Sep 2011 fel ba File Edit view Insert Format Tools Data Window Help Type a question for help amp X i b
6. h individual Test Matrix results tab using Data2 3 and so on The Testing Coordinator Test Matrix Summary is set up to accommodate a total of 7 different Test Matrix results starting with the Data1 tab If additional tabs are needed for a project please contact IT Application Quality Team for assistance The Master Summary tab provides a summary of various Test Matrix results which can be used to simplify status reporting This summary information is automatically calculated for the project by the test matrix spreadsheet See sample below EJ Microsoft Excel Testing Coordinator Summary SEE rea File Edit View Insert Format Tools Data Window Help Type a question for help Gl X E EEN U S ai Ss gt E Ar Date Information Testing Information Today s Date 09 21 2011 STING CONDITION YELLOW pd Test Start Date 05 01 2011 OTAL FOR ALL TESTS PERFORM Completion Date 12 31 2011 of Test Cases 11 Camnlatad 8 y Days for Project 175 Percentage Days Since Start 103 Percentage efore Completion 73 work days of Test Cases Date at 1 4 point 44 days lt lt Total For All HIGH Tests T A 2 Nate at 1 noint AB daye otal of HICH M 4 gt H Datal Data2 Data3 Datad Data5 Data6 Data ABER Cee Ready 5 6 EA E3 9 10 11 12 13 14 15 16 17 18 19 20 21 EFN Q amp A Q1 Ifthe testing completion date of the project changes after the te
7. lect Copy Highlight the inserted row s Right click and select Paste gt o By following this procedure the newly inserted row s has the formula and validation required on the Test Grid page Q4 Can delete any rows between row 11 and row 500 How Ans4 Yes To delete any rows please use the following procedure a Highlight the entire row that you would like to delete b Right click and select Delete
8. ote 3 A yy ll Ready 3 Note A summary of the Results Tab information is also displayed in the upper right hand corner of the Test Grid tab for a quick reference Role of Testing Coordinator Using the Testing Coordinator Test Matrix Summary the Testing Coordinator can gather Results information from each individual tester and determine a testing status for the entire project 1 Go to the Intranet Technology tab In the UNIFI IT Flow section find the Testing Coordinator Test Matrix Summary 2 Open and save this template to the project folder This template consists of the following tabs a Data 1 through Data 7 Contains copies of the results tab from each Individual test matrix for the project b Master Summary Provides a summary page of Results for the entire project Nate at 157 Te mpm ee Tatal of HIGH A M Datal Data Data3 Datad DataS Datad Data ABBE eels 3 Copy the Results tab from each individual test matrix using the following procedure a Click on the Results tab of an individual Test Matrix Test Matrix User Manual 10 b Left click on the top far left hand corner of the spreadsheet The entire spreadsheet is now selected highlighted c Right click and select copy 4 Paste the Results tab to Testing Coordinator Test Matrix Summary a Click Datai tab b Right click on the top far left hand corner of the tab and select Paste Continue copying and pasting eac
9. sting starts should update the Test Matrix Testing Completion Date Ans1 Yes The Testing Completion Date field on the Test Matrix should accurately represent the date that the testing of this project is scheduled to be completed Test Matrix User Manual 11 Q2 Can this Test Matrix accommodate multiple testers Ans2 Yes The Testers Initial column is used to track different testers executing various Test Scenario A list of multiple tester names can be input in Tester Name field of the Test Matrix The testing sign off field can have multiple sign off dates based on different testers See an example below Total Tests Passed ox Total HIGH Completed sd This test grid can accommodate test cases up to row 500 Days Left before _ Please con tact IT Application Quality Team if you need to add rows beyond line 500 or have any questions about this test matrix Completion Q3 How can insert rows in the Test Matrix Ans3 The Test Matrix is formulated to row 500 Column K has a formula that must be present in all rows in order for the RESULTS Page to calculate accurately When inserting rows between row 11 and 500 please use the following procedure Highlight the entire row below the location where you want to insert the row Right click and select Insert This will insert an empty row above your highlighted row Highlight the entire row above your newly inserted row s Right click and se
10. ts 4 Special Note HA Purpose Scope f Test Grid Results Special Note Purpose Scope The Purpose tab is a place for the user to enter any testing information that outlines the scope and procedures of the testing that will be completed using the test grid This helps everyone involved with the testing to understand what it is they are trying to accomplish and how they are expected to do it Test Grid The Test Grid tab contains the actual test matrix including the details for the test scenarios and test cases Results This tab contains the summary information from the testing completed on the test matrix tab This Summary information includes the overall testing condition Green Yellow Red the number of test cases completed the percentage completed the number of cases passed and the number failed as well as identifying progress on high priority test cases Special Note This provides information on what the user should be aware when using the Test Matrix to ensure that the calculation in the Result tab is correct This tab is not usually changed by the Testing Coordinator but is used as a user guide and or trouble shooting guide See sample below Test Matrix User Manual 4 Save and the error should be corrected 5 Ifthe error still has not been fixed try exiting and re opening this grid and give a couple seconds to allow the changes to take hold For accurate calculation of TESTING CONDI
11. ue to time constraints does not have large impacts or dollar expense end user is willing to accept the risk c Expected Results provide description on what you expect the pass result to be 3 Complete the Test Matrix Execution When you are ready to execute the Test Matrix the following fields should be completed 3 1 Process Date This is the date that the particular Test case was executed 3 2 P F This is the result of the executed test case Select either P or F from a drop down box 3 3 Notes This is an optional field that a tester can use for their own notes 3 4 PLOG Remedy This field is used to track any PLOG or remedy number associated with the Test Case 3 5 Tester Initial This is the field used to track each tester initial This is used in the event that there are multiple testers using the same test matrix and each test case may be executed by a different tester 3 6 Factor 1 and Factor 2 These fields are free form fields and can be customized to fit the needs of a specific Test Matrix 3 7 Traceability This column is used to track traceability between test scenario test cases and requirement The test matrix can be further customized by adding additional Columns after Column N Results Tab 1 Results Tab displays testing status information which is automatically calculated 2 Here is a picture of Results Tab Test Matrix User Manual Ca E Ea Kat s Test Matrix Sep 201
Download Pdf Manuals
Related Search