• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  • Level: GCSE
  • Subject: ICT
  • Word count: 1196

I have been asked to create this spreadsheet to help staff at World Club Travel be more efficient in recording customer's holiday bookings.

Extracts from this document...

Introduction

I have been asked to create this spreadsheet to help staff at World Club Travel be more efficient in recording customer's holiday bookings. The aims of this spreadsheet are to make holiday prices quicker and easier to calculate and to make the process more time efficient. The database will achieve this by making the information faster to access and by cutting down on the amount of paper used. The user won't need to do any of the working out, as the spreadsheet does this automatically. The spreadsheet will be linked with a database that will contain and log information about the holidays and customers. The database and the spreadsheet will work together to provide a fast and reliable service to the company. One of the more advanced features of the spreadsheet is to break down and display all of the individual fragments of the final price. The spreadsheet will display the VAT, which can be altered to cater for any changes the government make, the profit, which is set at 5% but can also be edited, the cost of travel insurance, the final price and the holiday details. ...read more.

Middle

The data from that column, and all of the information for that holiday, is then displayed along the bottom row of the spreadsheet by more VLookup formulae that look at all of the other columns. In my spreadsheet I have used absolute cell referencing for applying different VAT percentages. The formulae under the 'VAT' column all look at cell G1, which contains the number '0.175'. This means that all of the formulae under the VAT column multiply the original price of their assigned holiday by whatever number is in cell G1. The VAT percentage in the spreadsheet is variable to fit in with the current real-world VAT percentage. Here is an example of a change in VAT down to 15%. This is displayed on the spreadsheet as 0.15. I predict that this increase in VAT percentage will not make very much difference to holiday prices. My prediction was correct, as there was no large price increase. In the screenshot below I have changed the VAT percentage to 50% to show what a drastic impact a VAT percentage rise like this would have on holiday prices. ...read more.

Conclusion

To do this, I had to create a new reference cell underneath the VAT reference cell. All of the formulae in the 'Profit' column now multiply the original price by whatever is in the reference cell, which in this screenshot is G2. The final modification to the column was to rename it from '5% profit' to 'Profit', as the profit percentage is now controlled by the reference cell. Another small modification I have chosen to implement is to rename the column header 'For how long' to 'Duration (Days)', as this is shorter, and is a more relevant phrase. The screenshot below shows my final completed spreadsheet. The total time it took to complete, including this report, was about four months. Originally, this spreadsheet had a user interface, comprising of a customer interface, a booking sheet and a customer invoice, all of which were linked by macros, but half way through the chapter we had a teacher change and the user interface was deemed unnecessary. If I could do this project again, I wouldn't have made a user interface, as this wasted a lot of time. I would have done more research before hand, as I didn't do very much research. GNVQ Spreadsheet Report Adrian Parsons Page 1 14/10/02 ...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 Software 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 Software essays

  1. ICT: Long Project Design - Travel Agency

    This way, the user only needs to click on the buttons on the forms for their processes to be carried out. The buttons and logo will be at the same place for each of the forms. The bookings form will be a sub-form within a form.

  2. Reviewing different multimedia presentations.

    This is because the body when you are putting the bogy parts on is blue and all the writing is also blue, but a different shade of blue. There is also a use of grey in the section where there is writing in the Multimedia Presentation, and finally there is

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    This then displayed the amount of percentages which met this requirement, in the cell I selected at the start. I then followed these steps to count the number of ambers, and how many student met or exceeded their targets, and the amount of parents that need to be informed if

  2. ICT BTEC UNIT 2 - REPORT

    you pay for the quality and quantity of this computer whereas the other computer system is a mere �3,672 but you do get enough for the money you pay. If I had the money I would definitely go with the Dell Precision T7400 as I think it will be quick

  1. Powerpoint review project

    Output The output will be a whiteboard and a projector so that everyone can see the presentation clearly and that I will not have to print the presentation out for this reason. The whiteboard will present the information clearly like a TV screen and a projector will show the information

  2. Spreadsheet for a basketball company

    Restrict users from entering any anonymous value in the seating area 6. Calculate the company's income and expenditure for every match and based on these results, calculate the total profit for that specific match 7. Automate graphs relative to the company's income, expenditure and both of them in opposition to each other automatically 8.

  1. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    The information I derived from my questionnaire is that: * The best design for a filing system is a computerised system as it is more efficient and approved of. * That the present filing system is tiring and inefficient. To help this cause I will need to produce a computerised

  2. implementation report

    to refer back to it Appendix 16 Appendix 16 shows how my form looked after I clicked on modify the forms design Appendix 17 Appendix 17 shows the form after I made a few changes. Appendix 19 Appendix 19 shows that I added the same title and format of the

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