A test plan is used to provoke a system to fail in order to be able to make improvements to the system to prevent these mistakes from happening again. By testing the main aspects of my spreadsheet, I am able to prove that my spreadsheet works or fails and make amends to my spreadsheet to prevent errors in the future.
|TEST NO |TESTS |EXPECTED RESULT |OUTCOME | |1 |When the user needs to access the |The spreadsheet loads with no |Successful | | |spreadsheet, does it load with no |difficulty. |The spreadsheet loads with no | | |difficulty? To complete this test I will | |difficulty as shown in print screen| | |attempt to load the spreadsheet. | |number 1 at the bottom of this | | | | |document. It is vital that the | | | | |spreadsheet meets this test as | | | | |without it, the user cannot access | | | | |any of the data on the spreadsheet.| |2 |Is the content on the spreadsheet all spelt|All the spelling is Correct on the |Unsuccessful | | |correctly? To complete this test I will |spreadsheet. |When completing the spell check on | | |use the spellchecker tool on the content of| |the spreadsheet the word | | |my spreadsheet | |“importance” was found as spelt | | | | |incorrectly as shown in print | | | | |screen number 2 at the bottom of | | | | |this document. To rectify this | | | | |mistake I changed the spelling and | | | | |so when completing a second | | | | |spelling check, there is no error. | |3 |Do all of the average formulas used in the |All the average Formulas work and |Successful | | |data analysis work correctly? |so all of the analysis data is |The average formula used in my | | | |correct. |document meets with the data for | | | | |that question and when looking into| | | | |the data selected to make this | | | | |average – it is all correct | | | | | | | | | |...
Please join StudyMode to read the full document