• 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
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 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...

Introduction

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.

Middle

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.

Conclusion

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

  1. Database design for a games shop.

    game if it is in stock, and I check the database, the database will tell me that one copy is available however from my own knowledge I know that I have just rented it out hence it is not in stock, the games in stock should update automatically once a game has been loaned out but it does not.

  2. Selecting the best software for a theatre business.

    on more and more filing cabinets this is just a waste of money he could use on more important things and trying to get the theatre looking its best and costume and makeup for shows. When in the long run a computer based system will be cheaper.

  1. Reviewing different multimedia presentations.

    Not so good features of the multimedia product: With this Multimedia Presentation I found it to be really hard to find bad points with it as it is so good and professionally done but I found some minor problems.

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

    Total Income: This is calculated by the sum of the income gained from the sales of the individual products. This is the money made from all the products over the past week without subtracting the total buying-in price.

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

    Once I had created a new workbook, I started working on worksheet 2 instead of 1; this was because I had left the first worksheet blank to begin with, as I was later going to turn it into my front page and menu.

  2. AQA GCSE ICT Specification B

    I will regularly ask the staff about their views on the system, if there's anything that can be improved, etc. Evaluation I will compare the requirements laid out at the start to the end result and establish whether or not the project was a success.

  1. Project 1a. ICT

    This search type was not very specific so the search came up with animals from the wild, zoo signs, and animals you would find in everyday zoos. As shown as below. I learnt that to make the search more specific you will need to put a plus sign in between

  2. Graphics Review - Unit 21 OCR

    Allows user to go forward and back through content. Suitability to purpose Suitable. There is a 'next' button which allows users to go on to the next page. Page numbers are underlined and linked to. Almost like a recorder. '>' means to go forwards; '<' is to go back and ':' is to pause.

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