Year 9 Project - Ticket System for a Pantomime
 
This is lesson 2
Go to lesson 1 2 3 4 5 6
Last Lesson
Designing a Spreadsheet Model
Next lesson
Lesson Plan
We Are Learning To...
What I'm Looking For...
At the end of the lesson can you..
1. Design and create a simple model using spreadsheet software.

1. A model to show possible ticket costs for the production.

1. Show a spreadsheet model that has calculated ticket prices?

2. Change variables in your model to answer what if questions?
2. Use the model to answer some simple questions.
2. A model that can answer simple questions by changing variables
 
Starter
What you need to do
At the end of lesson...

1. Reminder of the problem presented to us by the Drama Department.

2. What did we do last lesson?

3. What are we expected to make?

4. What is the input, processing and ouput of our system?

Using the Pantomime Model Tasksheet For lesson 2, update your seating plan model and start entering data into your money model.

Carefully think about the rules (formulas) that your models will need.

Experiment with the variables in your models. Try some what if questions to see how this can help you make some decisions about your pricing of ticket sales.

Make sure you have written-up what you have done in your project document. Explain why you need a seating plan model and a money model.

Fully explain your inputs, processing and outputs. Also explain, with examples, what variables you have used.

Write about some of the what if questions you ma have used.
Resources
Resources
Resources
Your Pantomime spreadsheet models
 Your Pantomime spreadsheet models Your document write-up
 		 Pantomime Memo 1 Information Sheet

Interactive White Board: at the end of the lesson, use the IWB to show examples of what if questions you have used and explain any variables you used as well.
 		   Your homework booklet:
Lesson 2 Diary
     
Important Words: Explain what these mean in your document write-up
comment boxes, break even, rules, charge, structure

Extension Work:
Select the Gantt Chart Tab on your spreadsheet model. Fill-in the gantt chart to show haw you think your project will progress.
Homework: Identify and Justify Your Changes:

Explain what changes you have made to your seating plan and money models. Also explain why you made these changes. Annotate your work to show how you answered the questions using your spreadsheet model.
Homework Sheet 2
 
This is lesson 2
Go to lesson 1 2 3 4 5 6