8SF+23rd+November

8SF - 23rd November ‍ ‍‍‍‍‍This week you will learn how to


 * Develop a model to make it more accurate
 * Develop a model to make it more realistic
 * Add drop down lists
 * Use IF statements

‍ ‍‍‍‍‍Starter Activity

Play the "Beat the Bomb" quiz....

‍ ‍‍‍‍‍Task
As a class we will work though the text on page 54 of the interactive textbook

Activity
Watch the demo below on creating a drop down box



Task

 * 1) Open the spreadsheet [[file:concert hall with figures.xls]]
 * 2) Add a Row
 * 3) Create a drop down box for Seated or standing
 * 4) Save the spreadsheet to your area (keep it open!)

Activity
Watch the video below on creating an IF statement



Task
‍ Task Open the document below and follow the instructions. DO NOT delete anything on the document! []
 * 1) Add an IF statement to your spreadsheet to change the number of people evacuated per minute
 * 2) Save and close your spreadsheet

‍ ‍‍‍‍‍Activity Open the spreadsheet here Save it to your area

Add a drop down box to choose between - Contract and PAYG
 * Add a row for monthly charge
 * == Add IF Statements for ==
 * Monthly charge
 * Cost of texts
 * Cost of calls

Our Word Cloud! media type="custom" key="11428452"
 * Plenary **