20 Does the spread sheet have password protection It should be able to stop any changes from being made and ask for a password to change the sheet I will test the software by assigning a password to a spreadsheet and prohibiting the changes that can be made to it. 21 Does the spread sheet close when asked to. The spread sheet will close down when the correct button is pressed I will test the software by closing down the spread sheet when I have finished and I have saved the work. 22 Does the software perform the correct calculations for example addition It should add up certain numbers when the calculation is added into a certain cell I will be adding the appropriate calculation into the right cell and then checking is it done the sum correctly 23 Does the software preform the correct calculations for example subtraction It should subtract certain numbers when the calculation is into a certain cell I will be adding the appropriate calculation into the cell and then checking is it done the sum correctly 24 Does the software preform the correct calculations for example multiplication It should multiply certain numbers when the calculation is added into a certain cell I will be adding the appropriate calculation into the right cell and then checking is it done the sum correctly 25 Does the software preform the correct calculations for example division It should divide certain numbers when the calculation is added into a certain cell I will be adding the appropriate calculation into the right cell and then checking is it done the sum correctly 26 Can you make a chart/graph out of all the data It should take all my data and put it into a or a graph I will be highlighting some specific data and making it into a chart or graph and then putting the chart or graph on a different sheet. 27 Can you make a table out of all the data It should take all my data and put it into a table I will be highlighting some specific data and making it into a table and putting it on a different sheet. 28 Does the conditional formatting work for example more than It should show a certain colours when the amount shown in the cell is more than a specific number I will be assigning a certain colour for more than example orange or to a whole range of cells to make it easier to see who has made more than their target 29 Does the conditional formatting work for example less than It should show a certain colours when the I will be assigning a certain colour for
amount shown in the cell is less than a specific number example orange or green when the amount shown in the cell is less than the target to make it easier to see who hasn’t reached the target. 30 Does the conditional formatting work for example equal to It should show a certain colours when the amount shown in the cell is equal to a specific number I will be assigning a certain colour for example yellow when the amount shown in the cell is equal to their target. This makes it easier to see who gets exactly their target. 31 Turn on the computer The computer will turn on when the button is presses I will test it by pressing the required button and the right information should load up. 32 Check whether the monitor will turn on The monitor should turn on when the button is pressed I will test it by pressing the ‘on’ button situated on the edge of the monitor. 33 Check whether the software will load up-Microsoft Word The software, Microsoft Word should load when the right icon is pressed with the pointer I will test it by the mouse pointer and clicking on the right icon, which displays the caption of Word 34 Check whether the software is able to save a file The word document should be able to save by clicking the save icon I will test it by using the mouse pointer and clicking file and then save as the title I am going to use 35 Check if the word document can enter text into it The word processing software should be able to enter into it text I will test the software’s ability to actually process and enter textual data. 36 Check whether the Word document will be able to copy and paste When I want to copy something, which is important off the internet the word document should be able to copy and paste I will test it by copying the school’s logo into the header of my letter. It should be able to perform this action easily. 37 Check whether formatting of text can be changed If I want to make something a headline then I will make it stand out by formatting text and it should work when the icons are clicked I will test it by emboldening parts of the text to see if the software is able to do this. 38 Check whether the header and footer can be inserted When clicked the header and footer icons should create a separate margin for the details I will test it by clicking and inserting my name, headline of the task and
17 ✓ 18 ✓ 19 ✓ Could not screenshot this as it required a shutdown of the computer for the auto-save function to happen. 20 ✓ 21 ✓ 22 ✓ 23 ✓ 24 ✓ 25 ✓ 26  This feature was not included within the solution. 27 ✓ 28 ✓ 29 ✓ 30 ✓ Already tested within the previous test 31 ✓ Hardware test – cannot screenshot 32 ✓ Hardware test – cannot screenshot 33 ✓ 34 ✓ 35 ✓
(D) Presenting the Solution (D) (i) Presenting your work My Presentation I have used Microsoft PowerPoint 2010 to create a PowerPoint presentation about the solution that I have designed that will be presented to Holly. The presentation looks at the many features that have been used within the solution, and also how these features help solve the problems and requirements of both Holly (user) and the task. Follow this link to open the presentation: (E) Evaluation (E) (i) Work log My Work Log Date & Time Planned task(s) Achieved ( or ) Reason not achieved Changes from plan 03/11/2011 – 1 hour Introduction & preparation to the task  - - 08/11/2011 – 1 hour Investigating a need – Research Mail Merge  - - 10/11/2011 – 1 hour Put together group research from last lesson. Begin Design Brief.  One member of our group did not finish their research. We will put the group work together next lesson whilst finishing the design brief. 10/11/2011 – 1 hour Merge group research together from last lesson. Finish design brief and start producing the system specification.  - -
15/11/2011 – 1 hour Finish system specification. Create a test plan for Database – put together the group test plan next lesson  - - 16/11/2011 – 1 hour Merge together group test plan and edit.  - - 17/11/2011 – 1 hour making spreadsheet– formulas and conditional formatting  - - 22/11/2011 – 1 hour Continue making spreadsheet – record macros and create User Interface  - - 24/11/2011 – 1 hour Continue making spreadsheet – add ‘submenus’ to the UI and create fundraising sheets  - - 29/11/2011 – 1 hour Finish making spreadsheet and review screenshots – explaining them  - - 01/12/2011 – 1 hour Begin creating database – tables, forms, queries, reports  - - 06/12/2011 – 1 hour Continue making database – import and export data between applications, create relationships and calculated fields in tables  - - 08/12/2011 – 1 hour Finish making database – add a user interface and review the database objects  - -
13/12/2011 – 1 hour Begin creating Mail Merge letter – link with database and add fields into the message  I had run into an error with linking the mail merge document with the query from my database and had spent the lesson successfully fixing the problem. I managed to link the document with the database and will finish the mail merge next lesson. 05/01/2012 – 1 hour Finish mail merge letter – add logo in header and add footer. Use formatting tools and preview the final letters  - - 10/01/2012 – 1 hour creating the presentation to Holly – create master slide settings and use styles  - - 12/01/2012 – 1 hour Finish creating the presentation – add screenshots and hyperlinks to the parts of solution  - - 17/01/2012 – 1 hour Test the solution, review and make amendments as necessary  - - 19/01/2012 – 1 hour Create an evaluation of the solution produced and the work done – identify strengths and weaknesses etc.  - - 25/01/2012 – 1 hour Review all work done and make any changes needed.  - I had time left over and so I decided to review another person’s work to see how theirs differed from mine.