• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 5812

The aim of my project is to make the task of the allocation of seats in a theatre in a much more efficient manner than writing down on a piece of paper,

Extracts from this document...


Chapter 1: Identification The Aim of the Project A The aim of my project is to make the task of the allocation of seats in a theatre in a much more efficient manner than writing down on a piece of paper, which will allow calculations to be taken to show the overall costs against profit for the whole show. This will also allow the spreadsheet to also take into account the fixed costs of show, the projected profits from program sales, confectionery sales and other miscellaneous costs and profits from the show and quickly and efficiently calculate them. Background A Mr Brown, owner of Brown Theatres puts shows on fairly frequently, so he requires a simple solution, that is quick and easy to adapt to and simple to understand. The problems faced by him is that the current solution is to write down all the information by hand and use a calculator to work out costs, expenses and profit. He wants the solution to be able to do all this in and instant, and in a simple, understandable format. Mr Brown also believes that this new system will allow his company to expand, and become more profitable, he believes that this new, efficient way of calculating will allow him to accurately calculate everything he needs in a matter of seconds. Alternative strategies for solving the problem A/B Non-ICT solution The non-ICT solution would be similar to one Mr Brown uses at the moment, that being pen and paper. He could create a notebook in which there is a graph where the person fills in the appropriate box relevant to where the person is sitting and whether he/she is an adult or child. After this has been done, this must all be calculated to the price paid by the person, multiplied by the number of other people of the same type and seating position, then added to all the other seating arrangements and classes of people, and then subtracted from the cost of the show. ...read more.


Yours, Mr. Brown Final design ? See following page. Test plan F Objective Item being tested. Nature of test 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. The formula that looks up the amount of cost it will take for a show when Mr. Brown selects on from the drop down list. The formula specifically looks in the cell above which can be used by Mr Brown to selects whether the show is amateur or professional and then looks in the relevant column depending on his choice. =IF(AI7="amateur",VLOOKUP(AI6,AE29:AG37,3,),VLOOKUP(AI6,AE29:AG37,2,)) We will change first, the quality of the show to professional and the show being put on to film which should cost �1000. We will then change the quality of the show to amateur, which is an invalid range, as there is no input for a professional film, which should display a N/A sign. It will allow the staff to know where everyone is sitting, where there are free seats, and the cost of each of the seating arrangements according to whether the person is an adult, child or concession, and will allow quick and easy calculation of the overall price. The seating area will be tested, which graphically displays the seating arrangements. It also allows the spreadsheet to calculate how much the seating arrangements would cost per adult, child, concession relevant to where they are sat in the audience. The CountIF command is used here to count the number of a's, c's, and n's and display them on the graph next to the plan. The first test done, was to see if all the seating numbers and their income on the table next to graph would be zero, this is done by simply deleting all entries on the plan. ...read more.


If find it extremely user friendly as it allow me to select from drop down menus the show and whether it is professional or amateur. The buttons to quickly and simply input seating arrangements is very useful than putting it in manually. I am pleased to see that you have used a tool to protect the data in sheet from being accidentally edited, however, I would like your to implement a button (like the adult, child, concession button) which will quickly turn off cell protection. Yours sincerely, Mr Brown Response to customer feedback H Mr. Brown suggested the introduction of a macro for quickly turning off cell protection. This could easily be implemented by simply click "record new macro" and simply clicking "unprotect worksheet". We could then save it as a button on the toolbar which would allow Mr. Brown to use it as easily as the "child, adult, concession, clear selected" buttons. Suggestions for further enhancements H Although the spreadsheet can be used as a simple guide to how much profit or loss Mr. Brown has achieved, it probably would be impractical to use in a real situation. The spreadsheet cannot change prices for each individual person, if a concession paid a different price than another than the whole spreadsheet would be inaccurate for calculating it, as there would be no way of implementing that on the spot. To do so would probably require imputing the price in manually, which Mr. Brown would be unable to do so on the spot. Also, if Mr. Brown were to introduce a new show into his theatres he would be unable to implement it into his spreadsheet, and thus may have to try adding it to the fixed costs cell instead, and leaving the drop-lists in a position where the show costs zero. Overall the spreadsheet would probably be useful as a extremely rough guide to how much Mr. Brown had made or lost, but may be slightly impractical for anything more exact. Michael Pittas U4 Holmon 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


    I will then relate the Address - 1st Line field in the find patient's field with the medical history in the medical information field. Query Design The table below has some examples of designs for queries. Description Saved query name Table(s)

  2. AQA GCSE ICT Specification B

    x �0.50 Total Cost = Net Cost + VAT Cost Output 2: Delivery Note Information on Output Inputs Required Processing Required Pre-Programmed Data Entered by User Company Name, Logo and Address Customer Title, Initial and Surname Delivery Address Date of Order Type of Order Order Details Project Dispatch Date Company

  1. spreadsheet project

    To get the total owned column I needed to use the SUMPRODUCT function, inside and IF function. I also had to anchor (using the $ symbol) the cost of each trip. Once I had finally added all of the validation, Vlookup and sumproduct I had to password protect my document to prevent anyone tampering with the data.

  2. Evaluate the benefits of a particular spreadsheet solution and describe potential refinements to improve ...

    Thus, allowing the changes in a spreadsheet to also change automatically in the word document. Method: Step 1: Copy cells required from spreadsheet Step 2: Switch to word document and then click edit Step 3: Choose paste special Step 4: A "paste special dialog box" appears, then choose paste link Step 5: Then choose the document type e.g.

  1. Project 1a. ICT

    the zoo and the animals, to make the search be straight specific to search type.

  2. Payments Spreadsheet task. - formulas and fomatting

    In order for me to workout the average amount per month the function which I used was AVERAGE. For the running total per pupil, a formula is used to workout the amount a pupil has paid throughout the months except December and the running total keeps a record of the

  1. computerised spreadsheet for pupil attendance data

    It should also calculate the maximum, minimum and range scores for each assignment. * Finally the spreadsheet should calculate the final grade for each student. ANALYSIS The information that I will need to collect in order to enter it onto the spreadsheet is as follows: I will need to obtain a list of the student's names from my form tutor.

  2. Selecting the best software for a theatre business.

    her, so she looked back and she has 4 or 5 tickets missing from the order and she re-sells the tickets to other people and then she then has 2 sets of people arriving for the same tickets and then has to refund the money and the theatre will then get bad publicity.

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