• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  • Level: GCSE
  • Subject: ICT
  • Word count: 7121

Spreadsheet for a basketball company

Extracts from this document...


MS Excel Project 1. Identify 1.1. Introduction 'RoSup' is a company that organises basketball matches. It has one basketball court, which is situated in Surrey and has been operating for nearly a year. They are struggling because the methods they are using appear to be very inapt. I have been requested to undertake the problem with an attempt to introduce an easier but effective scheme, by Mrs Suprabha, the manager. 1.2. The Real User The actual problem is the method they are using to book seats, gather, and enter information such as customer information. They are using a paper-based system and so the process is very slow as information is slightly different every match. The employees have to keep drawing a new booking system for every match. They would have to keep counting stocks left. The other problems caused from this manual system are that the documents get lost, damaged, can prove to be very difficult in altering, mistakes due to illegible handwriting and forgetting to add or delete data. These files also take up a lot room, as they require being stored in file cabinets and finding certain data will be very much time consuming. Categorising data in lists would be a great burden. As a result, of all these drawbacks from the current scheme, the manager wants a solution that will speed up the process, which would ultimately allow them to focus on other business aspects such as establishing good customer service. 1.3. Problem Definition All of the users will need access to the system, however, only partially should be allowed to edit the data. Here are the three real users: * Mrs Suprabha, the manager will require full access particularly the profit, sales and income data so she can scrutinize the company's status e.g. on each match. Her decisions on behalf of the company will reflect upon these results. * Mrs Supru, the accountant for the company, will want access to the sales, income and profit information to provide the ...read more.


3. Implementation 3.1. Test Results 1. Available and occupied seats A B C D E F G H I J K 1 Adult Adult Adult Adult Adult 2 Adult Adult Adult Adult Adult 3 Child Child Adult Adult Adult Adult Adult 4 Child Child Child Child Child Adult Adult Child 5 Adult Adult Adult Child Child Adult Adult Child Child 6 Adult Adult 7 Child Adult 8 Child Adult 9 Adult Child 10 Adult Child 11 Child Adult Child 12 Child Adult Adult 13 Child Adult VIP VIP VIP VIP Adult 14 Child Adult Adult Adult Adult Adult Child Child Child Child 15 Child Child Child Adult Adult Adult Child Child Child 16 Adult Adult Adult Adult Adult Adult Adult 17 Adult Adult Child Child Child Adult Adult 18 Adult Adult Adult Adult Adult Adult The formula =COUNTIF(E17:K17, "VIP") counts all the cells within the orange coloured of the seating plan that has the text 'VIP'. This orange section is exclusively made for only VIPs. The formula =COUNTIF(C5:M22, "Adult") counts all the cells within the seating plan that has the text 'Adult'. The formula =COUNTIF(C5:M22, "Child") does the same as the previous one except it counts all the cells with the text 'Child'. Seat Details: Seat Type Seats Booked Total Seats Booked Seats Available VIP 4 96 53 Adult 58 Child 34 The formula =SUM(P12:P14) adds the total number of VIP, adult and child seats that are booked, and gives the total number of seats booked. From that specific value you subtract it with 149, the total number seats that are actually available. The formula =SUM(149-Q12) where Q12 is the cell that contains the value of the total number of seats booked. Consequently, everything seems to be correct. 2. Macros All these macro buttons link to the particular worksheets. However, when I clicked on the expenditure button, it leads to a different sheet. Hence, I will examine this error. ...read more.


So the cell that contains the value for the number of VIP ticket sold will have the formula =Bookings!P12, where Bookings is the page from where the information was collected from and P12 is the cell reference. Similarly the cell that contains the value for the number of adult ticker will have the formula dult ticket sold =Bookings!P14 and for the amount of child ticket sold the formula will be =Bookings!P15. In addition, the scroll bar in the income page can be deleted to adjust the number of adult or child ticket sold. 2. Could you add validation when selecting the seat reference in the bookings page to display a customer's information. In addition, I inferred that the drop-down list would make it much easier for the user. The cell in which you have to enter the seat reference will have to be validated. The drop-down list should contain all the seat reference, which has to be copied in the bookings page from the customer details page. This leaves out the user from entering an unknown seat reference like E13 since this is the cell that represents the court and is not a seat. The E column cells that do have seats are E8 to E12 and E21 to E25. If the validation was not added and the user typed in E13 than the result will show always show that no one has occupied the seat since it is blank but the user will still not know that it is not a seat reference. 3. The bookings for each match are going to be different and so there needs to a command that clears the seating plan A new macro has to be recorded. Record a new macro and highlight all the cells within the seating plan. Than clear all the content and stop the macro. ?? ?? ?? ?? Roshan Rai MS Excel Project Mr Thomson 1 ...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


    Purpose Test Data Expected Result Actual Result Screenshots To see if patient is added. Kulvinder Singh I expect to see Kulvinder Singh added to the database. He is added. One and two To see if patient is deleted Kulvinder Singh I expect to see Kulvinder Singh removed from the database.


    going for it and that is that it is free to use online with no installation needed which can save valuable space on your computer and you wouldn't have to worry about accidentally deleting your work neither would you have to worry about losing it if your system crashes or goes down.

  1. What is a computer registry?

    Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk. You can use Registry Editor to do the following: * Locate a subtree, key, subkey, or value * Add a subkey or a value * Change a value * Delete a subkey or a value * Rename a subkey or a value The navigation area of Registry Editor displays folders.

  2. AQA GCSE ICT Specification B

    Address3 Table 1 - Yes - - - Address4 Table 1 - Yes - - - Postcode Table 1 - Yes - - - PhoneHome Table 1 - Yes - - - PhoneMobile Table 1 - Yes - -

  1. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    it and selected, 'Assign Macro', to open up a dialogue box (shown below). In the 'Macro Name' box, I typed 'Printmacro' and then selected the 'Record' tab. In the following dialogue box that appeared, I clicked 'Ok'. I then highlighted the payslip as this is the part of the sheet

  2. Evaluating a relational database solution

    I could change what text I could have in the text boxes and change the orientation of the whole page. I could also choose different colours and fonts etc for the writing, text boxes and background.

  1. The aim of my project is to make the task of the allocation of ...

    Details of the calculations A/B The spreadsheet will calculate the amount of children, adults and concessions sitting in the various blocks of seating and multiply it with the income that was given with the brief. It will then Vlookup the price of the various shows and takes that away from the grand total.

  2. Payments Spreadsheet task. - formulas and fomatting

    payments made, so the formula entered adds all monthly payments together to gives the running total. The formula used for overall total collected is needed to workout the total of all the pupils each month so you add each monthly payment made by pupils.

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