In this exercise you will create a seating plan for a performance of a school play.
Create a spreadsheet that records seat numbers for a theatre. Each seat should be uniquely identifiable and its number should be printed on the ticket.
Use a separate worksheet for each performance - copy the first worksheet, when it is finished, into new worksheets.
As seats are sold you should enter the price of the ticket sold, £8 for a child and £12 for an adult. You should also change the colour of a cell where the seat has been sold so it is easy to see which seats are available.
Add formulae at the end of each row (or column, but not both!) to find the total value of the seats sold.
Add formulae at the top of the spreadsheet to show the total number of seats sold, the total income and the total number of seats still available.
This is a simple rectangle for the ground floor and another rectangle for the balcony but there is still plenty of formatting we can add, along with some formulae and functions besides.
View the PowerPoint presentation.
This has a more complex layout than the Great Hall. A typical seating plan in the Studio Theatre is as follows:
Balcony:
left: three rows of benches seating 3 each
right: front row of 3 seats, a gap and 4 more seats on the right; behind that, 4 rows of 8
seats, arranged in pairs
Downstairs:
left: at the back, one row of 12 seats with 5 rows of 10 seats in front, with an aisle
dividing them into 5 & 5; two further rows of 5 benches, each seating 2 people
right: 6 rows of four seats, arranged in 2 benches seating 2 each
Simulate the action of selling tickets by entering 3 or 6 in the seat cells.
View the presentation.
Use the Back Button to Return to the previous page