Menu Bar

Wednesday, January 23, 2013

Financial Modelling Review

 1) How would you describe the success of  your model?  

Did it show the amount of money the park will make over a 12 month period (1 March to 28 Feb *game year).

Did it help you to accurately show how your park is operating now, and possibly predict what may happen in the future?

Did you include all of the necessary features into the model including;

·         Absolute and Relative Cell Referencing
·         Conditional Formatting
·         Formula
·         IF Statement
·         Validation 

2) How does your model work. Describe two main variables in your model (inputs) and two main outputs giving examples?

3) Evaluate the decision to build a new rollercoaster/ride based on the results of your model. Would this be a sensible thing to do?

If not, what could be done to improve the success of your model

___________________________________________________________________

Describe
Provide characteristics and features of something (giving examples)

Evaluate

Make a judgement based on criteria; determine the value of something.
>Does the finished solution meet its requirements?
>Does it solve the problem

Wednesday, January 9, 2013

Modelling Roller Coaster Tycoon


Step 1 Vanilla Hills: You are going to create a spreadsheet to accurately show the amount of money the park will make over a 12 month period (1 March to 28 Feb *game year). Incorporate the following features into your model.
  • Absolute and Relative Cell Referencing
  • Conditional Formatting
  • Formula
  • IF Statement
  • Validation 
Your model should allow you to accurately show how your park is operating now, and possibly predict what may happen in the future.

Your model should allow you to make decisions about what Roller Coasters it is possible to build



.