{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["S4G_Homework 10"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"S4G_Homework 10","index":0,"n_rows":132,"n_cols":59,"rows_kept":132,"cut":false,"hidden":false,"merged":[[131,27,131,32],[121,4,121,5],[77,4,77,5],[77,2,77,3],[77,6,77,7],[77,8,77,9],[77,10,77,11],[78,2,78,3],[78,4,78,5],[78,6,78,7],[78,8,78,9],[78,10,78,11],[80,9,80,10],[91,20,91,21],[95,6,95,7],[121,2,121,3],[125,4,125,9],[131,2,131,4],[131,12,131,13],[120,10,120,11],[120,12,120,13],[120,14,120,15],[120,16,120,17],[120,18,120,19],[120,50,120,51],[120,52,120,53],[120,54,120,55],[120,56,120,57],[120,58,120,59],[120,40,120,41],[120,42,120,43],[120,44,120,45],[120,46,120,47],[120,48,120,49],[119,52,119,53],[119,54,119,55],[119,56,119,57],[119,58,119,59],[119,40,119,41],[119,42,119,43],[119,44,119,45],[119,46,119,47],[119,48,119,49],[28,3,33,30],[52,6,52,7],[52,8,52,9],[66,2,66,31],[56,10,56,12],[86,5,86,6],[86,7,86,8],[67,2,71,31],[119,50,119,51],[93,19,93,20],[74,40,74,41],[74,42,74,43],[74,44,74,45],[75,36,75,37],[75,38,75,39],[75,40,75,41],[75,42,75,43],[75,44,75,45],[78,35,78,38],[79,35,79,38],[80,35,80,38],[74,36,74,37],[74,38,74,39],[77,17,80,31],[2,2,3,5],[2,6,3,32],[5,2,6,5],[5,6,6,32],[8,1,8,32],[12,31,13,32],[19,3,19,30],[20,3,25,30],[27,3,27,30],[10,28,10,30],[10,31,11,32],[37,35,37,38],[39,5,39,7],[39,8,39,9],[41,1,41,2],[41,3,41,5],[41,7,41,8],[41,14,43,31],[41,35,41,37],[43,6,43,7],[43,8,43,9],[37,1,37,2],[37,3,37,5],[37,7,37,9],[37,14,39,31],[49,35,49,37],[45,1,45,2],[45,3,45,5],[45,7,45,8],[45,14,47,31],[45,35,45,37],[47,6,47,7],[47,8,47,9],[49,1,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,9],[49,14,51,31],[64,17,64,19],[100,16,100,18],[100,20,100,22],[103,3,103,27],[104,3,110,27],[120,2,120,3],[82,14,82,31],[83,14,87,31],[84,10,84,11],[115,21,115,32],[116,21,125,32],[119,2,119,3],[119,4,119,5],[119,6,119,7],[119,8,119,9],[119,10,119,11],[119,12,119,13],[119,14,119,15],[119,16,119,17],[119,18,119,19],[120,4,120,5],[120,6,120,7],[120,8,120,9]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 10                                                      Created by Mr Lafferty                                                                                                                                                                                                 St. Ninian's High School"]
[]
[null,null,null,"This homework covers topics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score"]
[]
[null,null,null,"Basic Number Operations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Algebraic Equations",null,null,null,null,null,null,null,null,null,null,null,19]
[]
[null,null,null,"Money",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Speed Distance Time"]
[]
[null,null,null,"Statistics",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stem-Leaf"]
[]
[]
[null,null,null,"Teacher Comments :"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Pupil's Comment :"]
[]
[]
[]
[]
[]
[]
[]
[null,"1. ","Carry out the following instructions.",null,null,null,null,null,null,null,null,null,null,null,"( NON - CALCULATOR QUESTION )"]
[]
[null,"(a)",null,{"$f":"ROUND(RAND()*(950-730)+730,1)","v":935.6},null,null,"-",{"$f":"ROUND(RAND()*(550-330)+330,1)","v":534},null,null,null,"Working : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I40","v":401.6}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D38-H38","v":401.6}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-15)+15,1)","v":25.6},null,null,"x",{"$f":"ROUND(RAND()*(9-3)+3,0)*10","v":80},null,null,null,"Working : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I44","v":2048}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D42*H42","v":2048}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(98-32)+32,1)*H46","v":521.40000000000009},null,null,"÷",{"$f":"ROUND(RAND()*(9-4)+4,0)","v":6},null,null,null,"Working : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I48","v":86.90000000000002}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":86.90000000000002}]
[]
[null,"(d)",null,{"$f":"ROUND(RAND()*(9-2)+2,0)*10","v":50},null,"% of",null,{"$f":"ROUND(RAND()*(9-2)+2,1)*10","v":66},null,null,null,"Working : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I53","v":33}]
[]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50*D50/100","v":33},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks )"]
[]
[]
[null,"2.","Rowan wants to buy",null,null,null,null,null,null,{"$f":"AJ56","v":22},"theatre tickets.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(10-2)+2,0)*3+1","v":22}]
[null,null,"The price of one ticket is",null,null,null,null,null,null,null,{"$f":"AJ57","v":24.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(50-12)+12,0)*0.5","v":24.5}]
[null,null,"The theatre has a special online offer of four tickets for the price of three."]
[]
[null,null,"Rowan makes use of the special online offer."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ56/4","v":5.5}]
[null,null,"How much does Rowan pay for the",null,null,null,null,null,null,null,null,null,null,{"$f":"AJ56","v":22},"theatre tickets?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUNC(AJ61,0)","v":5}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 3 marks )",null,null,null,null,null,null,{"$f":"AJ62*3*AJ57+AJ57","v":392}]
[]
[null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(210-200)+200,0)","v":203},null,{"$f":"ROUND(RAND()*(220-210)+210,0)","v":214},null,{"$f":"ROUND(RAND()*(220-210)+210,0)","v":213},null,{"$f":"ROUND(RAND()*(220-210)+210,0)","v":216},null,{"$f":"ROUND(RAND()*(230-220)+220,0)","v":220}]
[null,"3.","Ten people were asked to guess the number of coffee beans in a jar.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 2 marks )",null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(240-230)+230,0)","v":233},null,{"$f":"ROUND(RAND()*(240-230)+230,0)","v":240},null,{"$f":"ROUND(RAND()*(310-300)+300,0)","v":308},null,{"$f":"ROUND(RAND()*(310-300)+300,0)","v":303},null,{"$f":"ROUND(RAND()*(320-310)+310,0)","v":319}]
[null,null,"Their guesses were:"]
[null,null,{"$f":"AS76","v":319},null,{"$f":"AQ76","v":303},null,{"$f":"AM75","v":214},null,{"$f":"AO75","v":213},null,{"$f":"AQ75","v":216},null,null,null,"Working :"]
[null,null,{"$f":"AS75","v":220},null,{"$f":"AK76","v":233},null,240,null,308,null,{"$f":"AK75","v":203}]
[]
[null,null,"Find the median",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AS75+AK76)/2","v":226.5}]
[]
[null,"4."," Solve algebraically the equation.",null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[]
[null,null,{"$f":"ROUND(RAND()*(9-5)+5,0)","v":7},{"$f":"CHAR(RAND()*(122-97)+97)","v":"a"},"-",{"$f":"ROUND(RAND()*(5-2)+2,0)","v":4},"=",{"$f":"ROUND(RAND()*(4-2)+2,0)","v":2},{"$f":"D85","v":"a"},"+",{"$f":"(C85*H87-F85)-H85*H87","v":16}]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":4}]
[null,"Answer :",null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+(2),0)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H87","v":4}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 3 marks )"]
[]
[]
[null,"5.","For safety reasons the speed limit in London city centre is ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN92","v":20},null,"miles per hour.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)*10","v":20},null,{"$f":"ROUND(RAND()*(1-0)+0,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-1)+1,0)*6","v":36}]
[null,null,"The distance between two particular speed limit signs is ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN97","v":15.6},null,"miles.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(35-10)+10,0)","v":26}]
[]
[null,null,"A van took ",null,null,null,{"$f":"AN93","v":36},null,"minutes to travel between these signs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN93/60*AN94","v":15.6}]
[]
[]
[]
[null,null,"What was the speed of the van ?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Speed",null,null,null,null,null,null,"mph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN94","v":26}]
[]
[]
[null,null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 3 marks )"]
[]
[]
[null,"5.","Caitlin asked her class to note the number of songs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":1},{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(4-3)+3,0)","v":3},{"$f":"ROUND(RAND()*(5-4)+4,0)","v":5},{"$f":"ROUND(RAND()*(9-5)+5,0)","v":9}]
[null,null,"they downloaded to their phones in the last month.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(4-3)+3,0)","v":3},{"$f":"ROUND(RAND()*(5-4)+4,0)","v":4},{"$f":"ROUND(RAND()*(7-5)+5,0)","v":7},{"$f":"ROUND(RAND()*(9-7)+7,0)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(4-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(7-4)+4,0)","v":7},{"$f":"ROUND(RAND()*(9-7)+7,0)","v":8}]
[null,null,"The answers are shown below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(4-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(7-4)+4,0)","v":5},{"$f":"ROUND(RAND()*(8-7)+7,0)","v":7},{"$f":"ROUND(RAND()*(9-8)+8,0)","v":9}]
[]
[null,null,{"$f":"AQ120","v":"13"},null,{"$f":"AU120","v":"15"},null,{"$f":"AY120","v":"22"},null,{"$f":"BC120","v":"23"},null,{"$f":"AQ121","v":"32"},null,{"$f":"AO120","v":"11"},null,{"$f":"BE121","v":"47"},null,{"$f":"AU121","v":"37"},null,{"$f":"AO121","v":"28"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE($AO$115,AP115)","v":"11"},null,{"$f":"CONCATENATE($AO$115,AQ115)","v":"13"},null,{"$f":"CONCATENATE($AO$115,AR115)","v":"13"},null,{"$f":"CONCATENATE($AO$115,AS115)","v":"15"},null,{"$f":"CONCATENATE($AO$115,AT115)","v":"19"},null,{"$f":"CONCATENATE(AO116,AP116)","v":"22"},null,{"$f":"CONCATENATE(AO116,AQ116)","v":"23"},null,{"$f":"CONCATENATE(AO116,AR116)","v":"23"},null,{"$f":"CONCATENATE(AO116,AS116)","v":"24"},null,{"$f":"CONCATENATE(AO116,AT116)","v":"27"}]
[null,null,{"$f":"AY121","v":"42"},null,{"$f":"AS121","v":"33"},null,{"$f":"AS120","v":"13"},null,{"$f":"BC121","v":"45"},null,{"$f":"AW120","v":"19"},null,{"$f":"AW121","v":"38"},null,{"$f":"BA120","v":"23"},null,{"$f":"BA121","v":"43"},null,{"$f":"BG120","v":"27"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AO116,AU116)","v":"28"},null,{"$f":"CONCATENATE(AO117,AP117)","v":"32"},null,{"$f":"CONCATENATE(AO117,AQ117)","v":"33"},null,{"$f":"CONCATENATE(AO117,AR117)","v":"37"},null,{"$f":"CONCATENATE(AO117,AS117)","v":"38"},null,{"$f":"CONCATENATE(AO118,AP118)","v":"42"},null,{"$f":"CONCATENATE(AO118,AQ118)","v":"43"},null,{"$f":"CONCATENATE(AO118,AR118)","v":"45"},null,{"$f":"CONCATENATE(AO118,AS118)","v":"47"},null,{"$f":"CONCATENATE(AO118,AT118)","v":"49"}]
[null,null,{"$f":"BE120","v":"24"},null,{"$f":"BG121","v":"49"}]
[]
[null,null,"Display these answers in an ordered stem and leaf diagram."]
[]
[null,null,null,null,"Number of Songs"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 3 marks )"]
[]
[]
[null,null,"n = 19",null,null,null,"Key ",null,{"$f":"AO115","v":1},{"$f":"AP115","v":1},"means",null,{"$f":"AO120","v":"11"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total marks 19"]