{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["S4G_Homework 5"],"not_rendered":{"charts":0,"images":1,"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 5","index":0,"n_rows":132,"n_cols":59,"rows_kept":132,"cut":false,"hidden":false,"merged":[[131,12,131,13],[125,4,125,9],[131,2,131,4],[119,56,119,57],[119,58,119,59],[120,42,120,43],[120,44,120,45],[120,46,120,47],[120,48,120,49],[120,50,120,51],[120,52,120,53],[120,54,120,55],[120,56,120,57],[120,58,120,59],[119,46,119,47],[119,48,119,49],[119,50,119,51],[119,52,119,53],[119,54,119,55],[121,2,121,3],[119,40,119,41],[120,40,120,41],[119,42,119,43],[119,44,119,45],[37,35,37,37],[52,6,52,7],[52,8,52,9],[45,1,45,2],[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],[120,10,120,11],[120,12,120,13],[120,14,120,15],[120,16,120,17],[120,18,120,19],[64,22,64,24],[64,25,64,27],[79,44,79,46],[80,44,80,46],[86,1,86,4],[41,1,41,2],[41,3,41,5],[41,14,43,31],[41,35,41,37],[43,6,43,7],[43,8,43,9],[45,14,47,31],[45,35,45,36],[47,6,47,7],[47,8,47,9],[45,3,45,5],[45,7,45,8],[49,1,49,2],[49,5,49,6],[49,7,49,8],[49,14,51,31],[49,35,49,36],[86,5,86,7],[64,35,64,37],[66,2,66,31],[67,2,71,31],[2,2,3,5],[2,6,3,32],[5,2,6,5],[5,6,6,32],[8,1,8,32],[37,1,37,2],[37,3,37,4],[37,6,37,7],[37,9,37,10],[37,14,39,31],[12,31,13,32],[19,3,19,30],[20,3,25,30],[27,3,27,30],[28,3,33,30],[39,6,39,7],[39,8,39,9],[10,28,10,30],[10,31,11,32],[131,27,131,32],[76,20,77,22],[76,23,77,26],[78,20,78,22],[78,23,78,26],[115,21,115,32],[116,21,125,32],[95,27,95,30],[96,25,96,26],[101,22,101,26],[82,14,82,31],[83,14,87,31],[93,14,93,15],[79,20,79,22],[79,23,79,26],[79,15,79,19],[79,40,79,42],[127,24,127,25],[103,3,103,19],[104,3,110,19],[120,2,120,3],[94,1,94,8],[94,39,94,40],[98,7,99,19],[79,5,79,7],[93,1,93,8],[80,40,80,42],[101,15,101,16],[119,2,119,3],[119,4,119,5],[119,6,119,7],[119,8,119,9],[119,10,119,11],[78,44,78,46],[75,40,75,42],[76,40,76,42],[77,40,77,42],[75,43,75,45],[56,10,56,11],[58,11,58,12],[60,11,60,12],[60,19,60,20],[78,40,78,42]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 5                                                                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,"Linear Patterns",null,null,null,null,null,null,null,null,null,null,null,21]
[]
[null,null,null,"Simple Percentage & Money",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stem - Leaf"]
[]
[null,null,null,"Time"]
[]
[]
[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()*(20-10)+10,0)","v":14},null,"-",{"$f":"ROUND(RAND()*(6-2)+2,1)","v":3.4},null,"+",{"$f":"ROUND(RAND()*(6-2)+2,2)","v":5.84},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":16.439999999999998}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D38-G38+J38","v":16.439999999999998}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-30)+30,1)","v":37.700000000000003},null,null,"x",{"$f":"ROUND(RAND()*(9-6)+6,0)","v":7},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":263.90000000000003}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D42*H42","v":263.90000000000003}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(8-2)+2,1)*H46","v":1100},null,null,"÷",{"$f":"ROUND(RAND()*(9-3)+3,0)*100","v":500},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":2.2000000000000002}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":2.2000000000000002}]
[]
[null,"(d)",null,null,{"$f":"ROUND(RAND()*(8-2)+2,0)","v":7},"of",null,{"$f":"E51*E50","v":56},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":49}]
[null,null,null,null,{"$f":"E50+1","v":8}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50/E51*E50","v":49},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks )"]
[]
[]
[null,"2.","Georgia has a part time job in a local pottery. She paints designs on coffee mugs.",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()*(39-20)+20,0)*0.25","v":6.25}]
[null,null,"Her basic rate of pay is",null,null,null,null,null,null,null,{"$f":"AN56","v":6.25},null,"per hour."]
[]
[null,null,"She also gets paid an extra",null,null,null,null,null,null,null,null,{"$f":"AN59","v":19},null,"pence for every mug she paints.",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()*(30-12)+12,0)","v":19}]
[]
[null,null,"Last week Georgia worked",null,null,null,null,null,null,null,null,{"$f":"AN61","v":36},null,"hours and painted",null,null,null,null,null,{"$f":"AN62","v":140},null,"mugs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(40-15)+15,0)","v":36}]
[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()*(15-5)+5,0)*10","v":140}]
[]
[]
[null,null,"How much was she paid ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer ",null,null,null,null,null,{"$f":"AJ65","v":251.6},null,null,"( 3 marks )",null,null,null,null,null,null,{"$f":"L61*K57+T61*L59/100","v":251.6}]
[]
[null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","Sandra is going to see a movie. The movie has an evening and a late night showing.",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()*(19-17)+17,0)","v":19},{"$f":"ROUND(RAND()*(11-2)+2,0)*5","v":35},null,null,{"$f":"CONCATENATE(AJ76,\":\",AK76)","v":"19:35"},{"$f":"TIMEVALUE(AN76)","v":0.81597222222222221}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evening showing",null,null,"Late night showing",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(11-2)+2,0)*5","v":20},null,null,{"$f":"CONCATENATE(AJ77,\":\",AK77)","v":"2:20"},{"$f":"TIMEVALUE(AN77)","v":9.7222222222222224E-2}]
[null,"(a)","How long does the movie last?",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":"AJ76+AJ77","v":21},{"$f":"AK76+AK77","v":55},null,null,{"$f":"CONCATENATE(AJ78,\":\",AK78)","v":"21:55"},{"$f":"AO76+AO77","v":"21:55:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Time",null,null,null,{"$f":"AN76","v":"19:35"},null,null,"*****",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(1-0)+0,0)","v":1},{"$f":"ROUND(RAND()*(5-2)+2,0)*5","v":15},null,null,{"$f":"CONCATENATE(AJ79,\":\",AK79)","v":"1:15"},{"$f":"AN79","v":"1:15"},null,null,0,{"$f":"TIMEVALUE(AO79)","v":5.2083333333333336E-2}]
[null,"Answer :",null,null,null,null,null,null,"( Format 1:25 )",null,null,null,null,null,null,"Finishing Time",null,null,null,null,{"$f":"AO78","v":"21:55:00"},null,null,{"$f":"AO80","v":"01:15"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN77","v":"2:20"},{"$f":"CONCATENATE(AR79,AO79)","v":"01:15"},null,null,null,{"$f":"(24+AS79)-AO77","v":23.954861111111111}]
[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,{"$f":"AO79-AN77","v":-4.5138888888888888E-2},null,null,null,{"$f":"AS80","v":23.954861111111111}]
[]
[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,null,null,null,null,null,null,0]
[null,"(b)"]
[null,"When does the late night showing start ?",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":"HOUR(AS81)","v":22}]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),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,null,null,null,null,null,{"$f":"MINUTE(AS81)","v":55},{"$f":"IF(AN86<10,CONCATENATE(AN83,AN86),AN86)","v":55}]
[null,"Answer :",null,null,null,null,null,null,"( Format 21:25 )"]
[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":"CONCATENATE(AN85,\":\",AO86)","v":"22:55"}]
[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,"4.","(a) Complete the following table",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()*(1-0)+0,0)","v":1}]
[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,"b","=",{"$f":"ROUND(RAND()*(9-5)+5,0)","v":7},"m",{"$f":"IF(AP92=0,\"+\",\"-\")","v":"-"},{"$f":"ROUND(RAND()*(4-1)+1,0)","v":2}]
[null,"Number of M-shapes (m)",null,null,null,null,null,null,null,1,2,3,4,5,null,null,{"$f":"ROUND(RAND()*(15-9)+9,0)","v":14}]
[null,"Number of silver bars (b)",null,null,null,null,null,null,null,{"$f":"IF($AP$93=\"+\",J94*$AN$93+$AQ$93,J94*$AN$93-$AQ$93)","v":5},null,{"$f":"IF($AP$93=\"+\",L94*$AN$93+$AQ$93,L94*$AN$93-$AQ$93)","v":19},{"$f":"IF($AP$93=\"+\",M94*$AN$93+$AQ$93,M94*$AN$93-$AQ$93)","v":26},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","=",{"$f":"IF($AP$93=\"+\",Q94*AN93+AQ93,Q94*AN93-AQ93)","v":96}]
[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,"Answer :"]
[null,null,"(b) Write down a formula for calculating the number of bars (b) when you",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b ="]
[null,null,null,"know the number of M-shapes (m).",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,2,{"$f":"IF($AP$93=\"+\",K94*$AN$93+$AQ$93,K94*$AN$93-$AQ$93)","v":12}]
[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,null,null,null,null,null,null,5,{"$f":"IF($AP$93=\"+\",N94*$AN$93+$AQ$93,N94*$AN$93-$AQ$93)","v":33}]
[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,11,{"$f":"AN95","v":96}]
[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,"C","=",{"$f":"IF($AP$93=\"+\",AO101*$AN$93+$AQ$93,AO101*$AN$93-$AQ$93)","v":187},{"$f":"ROUND(RAND()*(30-19)+19,0)","v":27}]
[null,null,"(c) Find the number of M - shapes given",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN101","v":187},null,"silver bars.",null,null,null,null,"Answer   m  =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO101","v":27}]
[]
[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,"( 6 marks )"]
[]
[]
[null,"5.","Each pupil in a science class is growing a plant.",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()*(6-1)+1,0)","v":1},{"$f":"ROUND(RAND()*(2-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(4-3)+3,0)","v":4},{"$f":"ROUND(RAND()*(5-4)+4,0)","v":5},{"$f":"ROUND(RAND()*(9-5)+5,0)","v":8}]
[null,null,"A few weeks later the height of each plant is measured.",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,{"$f":"AO115+1","v":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,{"$f":"AO116+1","v":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":9}]
[null,null,"The heights in centimetres 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":4},{"$f":"ROUND(RAND()*(7-4)+4,0)","v":5},{"$f":"ROUND(RAND()*(9-7)+7,0)","v":7}]
[]
[null,null,{"$f":"AQ120","v":"1.2"},null,{"$f":"AU120","v":"1.5"},null,{"$f":"AY120","v":"2.2"},null,{"$f":"BC120","v":"2.3"},null,{"$f":"AQ121","v":"3.2"},null,{"$f":"AO120","v":"1.2"},null,{"$f":"BE121","v":"4.7"},null,{"$f":"AU121","v":"3.7"},null,{"$f":"AO121","v":"2.8"},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":"1.2"},null,{"$f":"CONCATENATE($AO$115,\".\",AQ115)","v":"1.2"},null,{"$f":"CONCATENATE($AO$115,\".\",AR115)","v":"1.4"},null,{"$f":"CONCATENATE($AO$115,\".\",AS115)","v":"1.5"},null,{"$f":"CONCATENATE($AO$115,\".\",AT115)","v":"1.8"},null,{"$f":"CONCATENATE(AO116,\".\",AP116)","v":"2.2"},null,{"$f":"CONCATENATE(AO116,\".\",AQ116)","v":"2.3"},null,{"$f":"CONCATENATE(AO116,\".\",AR116)","v":"2.3"},null,{"$f":"CONCATENATE(AO116,\".\",AS116)","v":"2.4"},null,{"$f":"CONCATENATE(AO116,\".\",AT116)","v":"2.7"}]
[null,null,{"$f":"AY121","v":"4.2"},null,{"$f":"AS121","v":"3.3"},null,{"$f":"AS120","v":"1.4"},null,{"$f":"BC121","v":"4.5"},null,{"$f":"AW120","v":"1.8"},null,{"$f":"AW121","v":"3.9"},null,{"$f":"BA120","v":"2.3"},null,{"$f":"BA121","v":"4.4"},null,{"$f":"BG120","v":"2.7"},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":"2.8"},null,{"$f":"CONCATENATE(AO117,\".\",AP117)","v":"3.2"},null,{"$f":"CONCATENATE(AO117,\".\",AQ117)","v":"3.3"},null,{"$f":"CONCATENATE(AO117,\".\",AR117)","v":"3.7"},null,{"$f":"CONCATENATE(AO117,\".\",AS117)","v":"3.9"},null,{"$f":"CONCATENATE(AO118,\".\",AP118)","v":"4.2"},null,{"$f":"CONCATENATE(AO118,\".\",AQ118)","v":"4.4"},null,{"$f":"CONCATENATE(AO118,\".\",AR118)","v":"4.5"},null,{"$f":"CONCATENATE(AO118,\".\",AS118)","v":"4.7"}]
[null,null,{"$f":"BE120","v":"2.4"}]
[]
[null,null,"(a) Complete the ordered stem-leaf."]
[]
[null,null,null,null,"Height of Plants"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(b)","Find the median height.",null,null,null,null,null,null,null,null,null,null,"cm",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BG120","v":"2.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,null,null,"( 4 marks )"]
[]
[]
[null,null,"n = 19",null,null,null,"Key ",null,{"$f":"AO115","v":1},{"$f":"AP115","v":2},"means",null,{"$f":"AO120","v":"1.2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total marks 21"]