OCR Nationals in ICT 2010 Unit 06 Design

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 7–Testing your spreadsheet OCR Nationals in ICT Unit 06: Design a Spreadsheets AO 7 – Testing your spreadsheet Pupil Name

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 7 – Test your spreadsheet Testing the spreadsheet. What is being tested? Describe how the test will be carried out What is the outcome of carrying out this test? What changes (if any) are needed following the test results? TEST 1 Is the final product fit for the intended purpose? TEST 2 Is the spreadsheet user friendly? Page 2

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 7 – Test your spreadsheet Test 3: Testing formulas. Using before and after screen prints show testing of the formulae using normal, abnormal and extreme data. q Copy as necessary Page 3

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 7 – Test your spreadsheet Test 4: Testing validation. Using before and after screen prints show testing of validation using correct and incorrect data. q Copy as necessary Page 4

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 7 – Test your spreadsheet Test 5 Testing graphs. Using before and after screen prints to show the graphs work correctly. q Copy as necessary Page 5

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 7 – Test your spreadsheet Test 6: Testing macro. Using screen prints show the macro works as intended. q Copy as necessary Page 6

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 7 – Test your spreadsheet Test 7: Testing conditional formatting. Using before and after screen prints show testing of conditional formatting using correct and incorrect data. q Copy as necessary Page 7

OCR Nationals in ICT (2010) : Unit 06: Design a Spreadsheets AO 7 – Test your spreadsheet Test 8: Testing worksheet protection. Using screen prints show the worksheet protection works correctly. q Copy as necessary Page 8