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

Test Plan Spreadsheet portfolio 3

Extracts from this document...


Test Description Reason What do you expect to happen to the spreadsheet IF you carry out the test? What did happen to the spreadsheet when you carried out the test? 1 Create Chart To see if my items in my shop are making a profit against each other. I expect a chart to appear on my spreadsheet. The chart appeared on my spreadsheet. 2 Change Data The price of My chemical romance - The Black Parade CD from the suppliers has gone up from �10.00 ...read more.


The price of buying this item went up and profit went down. 3 Change Formula To change the amount of VAT on an item has gone up from 15% to 25% and the formulas need to be changed the with VAT column. The column 'with VAT' the price within this column should go up by 10% The formula changed and the price went up. 4 Change data The quantity of My Chemical romance - The Black Parade sold has gone up from 68 items to 70 items; this was because of a new magazine advert in a popular teenage music magazine. ...read more.


I should be able to sort the profits from highest to lowest. I have been able to sort the profits from high to low. This is the chart created after test 1. Before test 2 After test 2 the price to buy of My Chemical Romance - The Black Parade has changed to �12.00 instead of �10.00 and also the profit has changed to a lower profit Before Test 3 After Test 3 Before Test 4 After Test 4 Before Test 5 After Test 5 ?? ?? ?? ?? ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Communications 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 GCSE Communications essays

  1. task2-report-template 3

    How do you deal with them? What do you except from the new system do to? Results of Interview Mr Philip told me that they find it difficult to organise their work as this shop is growing than before as a result he decided to look into better methods of organising the work and keeping it up to date.

  2. Model Price Chart.

    and delete any that is irrelevant, making the chart look as simple as possible. This also gives me access to more background knowledge of the type of system that I am being asked to produce.

  1. ICT (double award) - Business systems portfolio.

    It can also be very useful for communication; messages can be sent via the network to a specific computer or through an email service. Since the company sells large amounts of goods and services (such as repair by an engineer)

  2. Develop a spreadsheet application for the Ibis Hotel.

    Your help is highly appreciated. Thank you Your faithfully Anjum Kohli Student from year 11 The reply The manager of Ibis Hotel has accepted my proposal to assist me to help with the improvements on the hotel. The letter on the next page was sent to me, from the manager

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