{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["S4G_Homework 4"],"not_rendered":{"charts":0,"images":2,"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 4","index":0,"n_rows":131,"n_cols":42,"rows_kept":131,"cut":false,"hidden":false,"merged":[[96,36,96,37],[97,36,97,37],[98,36,98,37],[99,36,99,37],[100,36,100,37],[101,36,101,37],[102,36,102,37],[103,36,103,37],[110,35,110,37],[10,28,10,30],[10,31,11,32],[75,19,75,20],[76,17,76,18],[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],[28,3,33,30],[45,1,45,2],[45,3,45,5],[45,7,45,8],[45,14,47,31],[66,2,66,31],[67,2,71,31],[45,35,45,37],[47,6,47,7],[47,8,47,9],[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],[83,15,87,31],[82,15,82,31],[77,17,78,31],[78,35,78,38],[79,5,79,7],[79,8,79,10],[64,35,64,37],[49,1,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,9],[49,14,51,31],[49,35,49,37],[52,6,52,7],[52,8,52,9],[64,22,64,24],[64,25,64,27],[59,6,59,7],[57,3,57,4],[110,24,110,26],[94,39,94,40],[127,18,127,23],[117,39,117,40],[95,2,95,7],[95,8,95,13],[95,14,95,23],[96,2,96,7],[97,2,97,7],[98,2,98,7],[99,2,99,7],[100,2,100,7],[96,33,96,34],[97,33,97,34],[98,33,98,34],[99,33,99,34],[100,33,100,34],[101,33,101,34],[102,33,102,34],[103,33,103,34],[110,32,110,34],[107,2,107,5],[107,6,108,16],[102,14,102,23],[130,27,130,32],[116,21,116,32],[117,21,125,32],[121,2,121,3],[115,6,115,8],[117,12,117,13],[123,8,123,10],[127,24,127,26],[119,12,119,13],[127,27,127,29],[103,8,103,13],[103,14,103,23],[110,16,110,19],[110,20,110,23],[102,2,102,7],[103,2,103,7],[96,8,96,13],[97,8,97,13],[98,8,98,13],[99,8,99,13],[100,8,100,13],[101,8,101,13],[102,8,102,13],[101,2,101,7],[96,14,96,23],[97,14,97,23],[98,14,98,23],[99,14,99,23],[100,14,100,23],[101,14,101,23]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 4                                                      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 Brackets",null,null,null,null,null,null,null,null,null,null,null,20]
[]
[null,null,null,"Distance Speed Time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean from Frequency Table"]
[]
[null,null,null,"Negative Numbers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percentages & Money"]
[]
[]
[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":761.4},null,null,"-",{"$f":"ROUND(RAND()*(550-330)+330,1)","v":411.5},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":349.9}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D38-H38","v":349.9}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-15)+15,1)","v":27.7},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":2216}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D42*H42","v":2216}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(98-32)+32,1)*H46","v":414.59999999999997},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":69.099999999999994}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":69.099999999999994}]
[]
[null,"(d)",null,{"$f":"ROUND(RAND()*(9-2)+2,0)*10","v":90},null,"% of",null,{"$f":"ROUND(RAND()*(9-2)+2,1)*10","v":88},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":79.2}]
[]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50*D50/100","v":79.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks )"]
[]
[]
[null,"2.","Michael drives from Dumfries to Manchester.",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-2)+2,0)*6","v":48}]
[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()*(39-28)+18,0)","v":18}]
[null,null,"A",{"$f":"AJ58","v":14.4},null,"mile part of his journey is affected by roadworks.",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*AJ57/60","v":14.4}]
[]
[null,null,"It takes him",null,null,null,{"$f":"AJ56","v":48},null,"minutes to drive this part of his journey."]
[]
[null,null,"Calculate his average speed for this part of his journey."]
[]
[null,null,"Give your answer in miles per hour."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",null,null,null,null,null,{"$f":"AJ57","v":18},null,null,"( 3 marks )",null,null,null,null,null,null,{"$f":"Z65","v":18}]
[]
[null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","In July the average temperature in Anchorage, Alaska is",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(15-7)+7,0)","v":9},null,"oC",null,null,null,null,null,null,"( 2 marks )"]
[null,null,"By January the average temperature has fallen by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(35-26)+26,0)","v":28},null,"oC"]
[null,null,"What is the average temperature in",null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[null,null,"Anchorage in January?",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":"I80","v":-19}]
[null,"Answer :",null,null,null,null,null,null,{"$f":"ROUND(T76-R77,0)","v":-19}]
[]
[]
[null,"4."," Simplify",null,null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[]
[null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":3},"(",{"$f":"CHAR(RAND()*(122-97)+97)","v":"f"},"+",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":8},")","+",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":9},"(",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":3},"-",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":3},{"$f":"D85","v":"f"},")"]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":9}]
[null,"Answer :",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":"B85+(I85*-M85)","v":-24},{"$f":"N85","v":"f"},"+",{"$f":"F85*B85+I85*K85","v":51}]
[]
[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.","Last week Lewis asked",null,null,null,null,null,null,null,{"$f":"AJ104","v":46},"students to record how many hours they spent doing homework.",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()*(1-0)+0,0)","v":0}]
[]
[null,null,"The results are shown below."]
[]
[null,null,"Homework hours",null,null,null,null,null,"Frequency",null,null,null,null,null,"Homework hours x frequency"]
[null,null,{"$f":"ROUND(RAND()*(1-0)+0,0)","v":1},null,null,null,null,null,{"$f":"AJ97","v":7},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()*(20-5)+5,0)","v":7},{"$f":"AJ97*C97","v":7}]
[null,null,{"$f":"C97+1","v":2},null,null,null,null,null,{"$f":"AJ98","v":7},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()*(20-5)+5,0)","v":7},{"$f":"AJ98*C98","v":14}]
[null,null,{"$f":"C98+1","v":3},null,null,null,null,null,6,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,6,18]
[null,null,4,null,null,null,null,null,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,8,32]
[null,null,5,null,null,null,null,null,6,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()*(7-2)+2,0)","v":6},30]
[null,null,6,null,null,null,null,null,7,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()*(7-2)+2,0)","v":7},42]
[null,null,7,null,null,null,null,null,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,null,null,5,35]
[null,null,"Totals =  ",null,null,null,null,null,46,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":"SUM(AJ97:AJ103)","v":46},{"$f":"SUM(AK97:AL103)","v":178}]
[]
[null,null,"Complete the above table and find the mean time spent on homework last week."]
[]
[null,null,"Working :"]
[]
[]
[null,null,"Round your answer to 1 decimal place.",null,null,null,null,null,null,null,null,null,null,null,null,null,"mean =",null,null,null,null,null,null,null,{"$f":"ROUND(AK104/AJ104,1)","v":3.9},null,null,null,null,null,null,null,null,null,null,{"$f":"Y111","v":3.9}]
[]
[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 marks )"]
[]
[]
[null,"6.","Nicole has",null,null,null,{"$f":"ROUND(RAND()*(90-32)+32,0)*100","v":7800},null,null,"in her Clydeside Bank account."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[null,null,"Clydeside Bank pays interest at",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,1)","v":1.8},null,"% per annum.",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":"M118/100*G116","v":140.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,null,null,null,null,null,null,null,null,{"$f":"ROUND(SQRT((C122*C122)+(K119-I125)*(K119-I125)),1)","v":0}]
[null,null,"Highland Bank pays interest at",null,null,null,null,null,null,null,null,null,{"$f":"M118+ROUND(RAND()*(2-1)+1,1)","v":3},null,"% per annum.",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":"M120/100*G116","v":234}]
[]
[]
[null,null,"How much more money would Nicole get in interest"]
[null,null,"if she moved her",null,null,null,null,null,{"$f":"G116","v":7800},null,null,"to the Highland Bank"]
[null,null,"for one year?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer  =",null,null,null,null,null,null,null,null,{"$f":"AN120-AN118","v":93.6},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB128","v":93.6}]
[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,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,"Total marks 20 "]