Theatre Booking System Lesson 4

50 %
50 %
Information about Theatre Booking System Lesson 4

Published on December 6, 2007

Author: mrbelshaw



Lesson 4 in a series of lessons creating a Theatre Booking System with Year 8 ICT students.

Theatre Booking System Lesson 3: Using functions with a theatre booking system

1 1. Open up your spreadsheet. 2. In the Number column use the COUNTIF function. This counts how many of a certain number there are in a certain range – e.g. =COUNTIF(B2:H11,1)

2 The function I have entered is = COUNTIF(B2:H11,1) Range Criteria The first part of the function is the range. In the example above it is B2:H11. The second part of the function is the criteria. In the example above it is 1.

3 Now that we have worked out the number of each type of ticket sold, it is time to work out how many we have sold altogether. To do this we use the SUM function. This is what has been entered in cell M9 in the above example.

4 The function I have entered is = SUM(M3:M6) Range If you enter a function similar to the one above you should find that your spreadsheet adds up and displays the total for the range you have specified. Make sure your SUM function adds up the number of tickets sold!

5 Now that we know how many of each type of ticket we have sold and how many in total, it is time to find out how much we have earned! Revenue is a term which means the amount of money made.

6 The formula I have entered is = M3*L3 + (add) - (subtract) * (multiply) / (divide) To work out the revenue for each category, simply enter the Price multiplied by the Number of tickets sold. Do the same for the Total.

6 Make sure your ‘money’ cells are formatted according to currency: Format -> Cells -> Number

Add a comment

Related pages

2012 Theatre Booking System - Google Sites

Gr.11-Lesson Plans. Gr.12-Lesson Plans Project; HL Only. P2 - News Article Analysis; Strand 2: Application to specific ... 2012 Theatre Booking System ...
Read more

Online Booking System & Appointment ... - bookitlive

Learn how with the bookitlive complete appointment booking system. bookitlive ... 4.5 stars. How to Book a ... or contacts you via bookitlive’s online ...
Read more

Access :: Seat Booking System For Theatre - Bigresource

Seat Booking System For Theatre ... The database contains 4 tables: ... but when i a customer to book a lesson, i want the booking to be not booked twice.
Read more

Best Reservations Software | 2016 Reviews of the Most ...

Find and compare Reservations software. ... The most owner-friendly solution for doing 4 things: ... Travel booking system for travel agents, ...
Read more

ASL-Interpreted: Guide to Buying Tickets, Pt. 2 - YouTube

ASL-Interpreted: Guide to Buying Tickets, ... Theatre booking system 3 ... "Buying a plane ticket"talk show in Mandarin Lesson - Duration: ...
Read more

Enrolment: Friendship & Enrolment | Mauao Performing Arts ...

Friendship & Enrolment ... BELOW INFORMATION RELATES TO OUR UPCOMING ONLINE BOOKING SYSTEM FOR PAYMENT. ... Group Music or Theatre lesson casual rate $20:
Read more

The Book of Mormon on Broadway | Official Site

The Book of Mormon, ... Eugene O'Neill Theatre Running Time 2.5 hrs, one intermission Ticket Prices From $99 ...
Read more

Fares & Ticketing Training Courses | IATA Training

... 4 días) Enfocado a ... for Travel Agents and the range of Billing Reports issued by BSP in the BSP system. ... Systems Fares and Ticketing Course ...
Read more