• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Spreadsheet Internal Beta Testing

Extracts from this document...


Internal Beta Testing In this section I give various results for tests that I have performed on my spreadsheet system. I am going to carry out "x" amount of tests on my system. These tests will include going through the spreadsheet system just like the user would do from start to finish. User form 1 [Login Box] The first test is to make sure the password entrance to the spreadsheet is functioning. First I have to test that this part of the system works by entering the correct username and passwords. When I entered the username "user" and the password "poke" the "ok" button appeared I repeated this test several times to make sure that this part of the system was working. The next test that had to be carried out on this part of the system was if I was to modify either the username or the password from the textboxes provided on the form that the "ok" button would disappear. Once again this part of the system worked correctly. The last part of testing this system was to enter the username and password into the form and then close this form by using the "X" in the top right of the form which is the equivalent to ALT+F4 ...read more.


Other information on this sheet is the date feature. This is put there from an include on sheet 1 I adjusted the system clock several times and reopened the spreadsheet to test that it changed date correctly. The only other tests that where needed on this page were to make sure that the menu on the right hand side of this sheet were functioning. The several link buttons to the other sheets were all working correctly as were the save, quit and print buttons. Next in order to test was sheet 4. This sheet is one of the more complex sheets in the system it is the invoice sheet. This is basically sheet 5 and sheet 6 put together in a different form. The easiest thing to do on this sheet was to make sure the right handed menu was working and performed correctly. So I tested all the link buttons and the print, save and quit buttons and they all functioned correctly. The next thing to test was to make sure the content was correct the first part of the invoice is the customer information address, name phone number and the date. ...read more.


Sheet 1 left till last this sheet stored the =now() function for the date which was tested earlier on. It also contains link buttons to transfer easily between sheets without remembering sheet number. All these functions work correctly the last test was to make sure that the "clear all" button worked correctly and it did clear all the information it was programmed to do. It has been good to test these sheets even though there was only two errors. Now I will show some screenshot proof of the testing that has taken place. Login box: When both are entered correctly the "ok" button shows up. When password is deleted the "ok" button disappears. Userform: This is before I entered the blank products as you can see it would display #N/A which was causing problems with the other sheets. As you can see in this screenshot there is no sign of #N/A so my editing to the system during the internal beta testing proved to be successful. Although I have tested everything to my needs in the internal beta testing the release candidate of my spreadsheet system will need to be sent to eclipse computers for the company to beta test and give feedback on the system. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level ICT in Business essays

  1. A description of the use of ICT for internal and external communications of the ...

    * Electronic data interchange (EDJ) this allows users to exchange business documents and information (such as orders and invoices) directly through the telephone network and other, more sophisticated, electronic communication systems. * Internal communications: Before examining the sorts of communications that need to take place within the organisation, it is

  2. A proposal to modify "Exercisco Fitness Club" in Pokfulam, the location has been proposed ...

    As seen now the forms are kept in cabinets which are not safe, so it is really easy to vandalize the member personal information and course information. Input Processing Output Customer's Personal Information Record the information on the member form and file it.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work