Year 9 Project - Ticket System for a Pantomime
 
This is lesson 3
Go to lesson 1 2 3 4 5 6
Last Lesson
Improving The Spreadsheet Model
Next lesson
Lesson Plan
We Are Learning To...
What I'm Looking For...
At the end of the lesson can you..
1. Develop the model to use new information that we get.
1. Show that you have entered new information into your model?
1. A model the includes new information.

2. Your model can be used to answer questions about ticket prices.
2. Use the models to answer more questions.
2. Answer more questions and give answers using your model to help you?
 
Starter
What you need to do
At the end of lesson...

Reminder and quick review of previous lesson. What structure have you developed in your models?

Review: labels, formula, variables, inputs, process, outputs, new data

 Update your models with the new information that has been provided on the Memo 2 information sheet.

Make sure you have written-up what you have done in your project document.

Explain what data you have input into your models.

Expalin what questions you have answered using you models and how you did this.

Discuss your progress with your teacher. You will be asked some questions so make sure you can explain what you have done
Resources
Resources
Resources
Teachers completed spreadsheet model to show examples
 Your pantomime spreadsheet models Your document write-up
Memo 2 information sheet Your homework booklet:
Lesson 3 Diary
 		     
     
Important Words: Explain what these mean in your document write-up
totals, development

Extension Work:
Select the GANTT chart tab at the bottom of your spreedsheet and update your project plan. When you have done this, select the mailing list tab and find out how to put AutoFilters onto the labels. Once you have put AutoFilters on, use the extension task sheet to filter for information and find answers to the questions asked on the sheet.
Homework: More Questions For Your Spreadsheet Models

Think of 3 new questions you could use your models to answer. Bring these questions to the next lesson with any annotated work.
Homework Sheet 3
 
This is lesson 3
Go to lesson 1 2 3 4 5 6