• 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

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

    The objectives of the solution C 1) It will allow Mr Brown to simply and easily input data, and view the results already in a format that shows whether or not he gained money or lost it in the show, and where he must improve to achieve peak profit in order to gain more money.

  2. What is a computer registry?

    Administrators can modify the registry by using Registry Editor (Regedit.exe or Regedt32.exe), Group Policy, System Policy, Registry (.reg) files, or by running scripts such as VisualBasic script files. Use the Windows user interface We recommend that you use the Windows user interface to change your system settings instead of manually editing the registry.

  1. Reviewing different multimedia presentations.

    Another improvement that needs to be made to the Multimedia Presentation is that they sort out the way that you go back as it took me some time to realise that you had to press the word car to go back so they need to make a clear button for

  2. Appropriate Software To do this project I am going to use excel because ...

    E.g. British Gas Expenditure Gas, Electricity, Products The companies that supply each of the utilities. E.g. British Gas Week Validation- list where I can select Week1, Week2, Week3 The end user: Mr. Robert Annual Target The target that my end user would like to achieve by the end of the year.

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

    Once I had clicked on "Rename", the tab turned black and allowed you to type in your preferred name. The tab then turned back to white, once I had finished typing the name "menu" and had pressed enter. Step 5 Next, I decided I wanted three tables which included the headings I required, in worksheet 2.

  2. AQA GCSE ICT Specification B

    Skills of end users Knowledge of Excel and Word, competent with all programs. Hardware constraints Seven computers, a printer and a scanner. Software constraints Access, Word, Powerpoint and Excel. The new system will be compatible with Access. Business rules 25p per letter of personalization, �15.99 per duck Technical support requirements Email contact, a telephone number and a user guide.

  1. Graphics Review - Unit 21 OCR

    Source: www.aol.com Date: 12th Sep 08 Web Icons Source http://www.dettol.co.uk/home.shtml http://www.google.co.uk/ (Personale) www.aol.com www.sky.com Target Audience Teachers; HC professionals; kids. People with the Gemini Horoscope People wanting to find out the weather in their area People wanting to either: check their email, chat or 'Store & Share'.

  2. A02 Implementation Commentary

    * USB Drive - This is a reasonable new method of portable storage, and they normally have a much larger free space than a floppy disk. I created a presentation on Microsoft PowerPoint. I did this by adding a background picture into all the slides.

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