• 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

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

# Related GCSE Software essays

1. ## 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.

2. ## Database design for a games shop.

what genre people like the most hence I can buy that sort of game and rent it out to increase sales. Secondly I would like to tell you the things which I don't like too much: There are a lot of minor problems which take time and we all know

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

This error would also be hard to identify. If JEM Bookshop made an error like this, it would cause a lot of trouble; Profit could Decrease, Reputation would bad, losing customers etc. furthermore, to avoid this you need training or employing new staff, which could increase the expenses.

2. ## What is a computer registry?

file Use Windows Script Host The Windows Script Host lets you run VBScript and JScript scripts directly in the operating system. You can create VBScript and JScript files that use Windows Script Host methods to delete, to read, and to write registry keys and values.

1. ## Reviewing different multimedia presentations.

click the section that you want to so to and it is quite self explanatory what to do and how to make your way through the Multimedia Presentation. 5. Improvements to the multimedia website/product to help meet the product's aims.

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.