{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["S4G_Homework 7"],"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 7","index":0,"n_rows":131,"n_cols":42,"rows_kept":131,"cut":false,"hidden":false,"merged":[[102,2,102,7],[102,8,102,13],[102,14,102,23],[102,33,102,34],[102,36,102,37],[103,2,103,7],[103,8,103,13],[103,14,103,23],[103,33,103,34],[103,36,103,37],[127,18,127,23],[127,24,127,26],[130,27,130,32],[120,5,121,6],[120,15,121,16],[110,35,110,37],[116,21,116,32],[117,21,125,32],[107,2,107,5],[107,6,108,16],[110,16,110,19],[110,20,110,23],[110,24,110,26],[110,32,110,34],[119,2,119,3],[119,7,119,9],[120,10,121,11],[119,12,119,14],[100,33,100,34],[100,36,100,37],[101,2,101,7],[101,8,101,13],[101,14,101,23],[101,33,101,34],[101,36,101,37],[98,2,98,7],[98,8,98,13],[98,14,98,23],[98,33,98,34],[98,36,98,37],[99,2,99,7],[99,8,99,13],[99,14,99,23],[99,33,99,34],[99,36,99,37],[100,2,100,7],[100,8,100,13],[100,14,100,23],[96,2,96,7],[96,8,96,13],[96,14,96,23],[96,33,96,34],[96,36,96,37],[97,2,97,7],[97,8,97,13],[97,14,97,23],[97,33,97,34],[97,36,97,37],[79,5,79,7],[82,15,82,31],[83,15,87,31],[94,39,94,40],[95,2,95,7],[95,8,95,13],[95,14,95,23],[64,35,64,37],[66,2,66,31],[67,2,71,31],[77,17,78,31],[78,35,78,38],[75,6,75,8],[64,25,64,26],[92,9,92,10],[75,36,75,37],[77,8,77,9],[76,36,76,37],[43,8,43,9],[52,6,52,7],[52,8,52,9],[64,22,64,24],[59,6,60,7],[49,1,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,9],[49,14,51,31],[60,13,61,14],[62,9,63,11],[20,3,25,30],[27,3,27,30],[28,3,33,30],[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],[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],[2,2,3,5],[2,6,3,32],[5,2,6,5],[5,6,6,32],[8,1,8,32],[10,28,10,30],[10,31,11,32],[12,31,13,32],[19,3,19,30]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 7                                                      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,22]
[]
[null,null,null,"Pythagoras Theorem",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean from Frequency Table"]
[]
[null,null,null,"Conversion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length & Circle"]
[]
[]
[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":738.3},null,null,"-",{"$f":"ROUND(RAND()*(550-330)+330,1)","v":500.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":"I40","v":237.59999999999997}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D38-H38","v":237.59999999999997}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-15)+15,1)","v":17.5},null,null,"x",{"$f":"ROUND(RAND()*(9-3)+3,0)*10","v":70},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":1225}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D42*H42","v":1225}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(98-32)+32,1)*H46","v":273},null,null,"÷",{"$f":"ROUND(RAND()*(9-4)+4,0)","v":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":"I48","v":54.6}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":54.6}]
[]
[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":25},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":12.5}]
[]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50*D50/100","v":12.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks )"]
[]
[]
[null,"2.","Lewis is designing a bird box for his garden.",null,null,null,null,null,null,null,null,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)*2","v":16},"cm",null,null,{"$f":"CONCATENATE(AJ56,AK56)","v":"16cm"}]
[null,null,"The dimensions for the side of the box are shown in the diagram 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,{"$f":"AJ56+ROUND(RAND()*(10-5)+5,0)","v":24},"cm",null,null,{"$f":"CONCATENATE(AJ57,AK57)","v":"24cm"}]
[null,null,null,null,null,null,null,null,"P",null,null,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":"AJ57+ROUND(RAND()*(10-5)+5,0)","v":33},"cm",null,null,"33cm"]
[]
[null,null,null,null,null,null,{"$f":"AN57","v":"24cm"},null,null,null,null,null,"S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN56","v":"16cm"}]
[]
[null,null,null,null,null,null,null,null,"Q",{"$f":"AN58","v":"33cm"},null,null,"R"]
[]
[null,null,"Calculate the length of side PS to 1 decimal place.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",null,null,null,null,null,"cm",null,null,"( 4 marks )",null,null,null,null,null,null,{"$f":"ROUND(SQRT((AJ57-AJ56)*(AJ57-AJ56)+(AJ58*AJ58)),1)","v":34}]
[]
[null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","Ben needs",null,null,null,{"$f":"AK76","v":300},null,null,"grams of flour to bake two small loaves of bread.",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()*(10-5)+5,0)*50","v":300}]
[null,null,"How many kilograms of flour",null,null,null,null,null,null,null,null,null,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-11)+11,0)","v":15}]
[null,null,"will he need for",null,null,null,null,null,{"$f":"AK77","v":15},null,"small loaves?",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,null,{"$f":"AK76/1000*AK77","v":4.5}]
[null,"Answer :",null,null,null,null,null,null,"kg"]
[]
[]
[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":7},"(",{"$f":"CHAR(RAND()*(122-97)+97)","v":"s"},"+",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":8},")","+",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":5},"(",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":3},"-",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":9},{"$f":"D85","v":"s"},")"]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":4}]
[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":-38},{"$f":"N85","v":"s"},"+",{"$f":"F85*B85+I85*K85","v":71}]
[]
[null,null,null,null,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.","Danielle wanted to know the average number of hours cars were parked in a car park.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"She did a survey of",null,null,null,null,null,null,{"$f":"AJ104","v":68},null,"cars which were parked in the car park on a particular day."]
[null,null,"Her results are shown below."]
[]
[null,null,"Parking time (Hours)",null,null,null,null,null,"Frequency",null,null,null,null,null,"Parking Time x frequency"]
[null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":2},null,null,null,null,null,{"$f":"AJ97","v":11},null,null,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":11},{"$f":"AJ97*C97","v":22}]
[null,null,{"$f":"C97+1","v":3},null,null,null,null,null,{"$f":"AJ98","v":18},null,null,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":18},{"$f":"AJ98*C98","v":54}]
[null,null,{"$f":"C98+1","v":4},null,null,null,null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,72]
[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,6,30]
[null,null,6,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,{"$f":"ROUND(RAND()*(7-2)+2,0)","v":5},30]
[null,null,7,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},49]
[null,null,8,null,null,null,null,null,3,null,null,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,24]
[null,null,"Totals =  ",null,null,null,null,null,68,null,null,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":68},{"$f":"SUM(AK97:AL103)","v":281}]
[]
[null,null,"Complete the above table and find the mean parking time per car."]
[]
[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,"hours",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AK104/AJ104,1)","v":4.0999999999999996}]
[]
[null,null,null,null,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.","Circular tops for yoghurt cartons are cut from a strip"]
[null,null,"of metal foil as shown below.",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,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-3)+3,0)","v":6},"cm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(2-1)+1,0)","v":1},"cm"]
[null,null,{"$f":"AN121","v":"1cm"},null,null,null,null,{"$f":"AT121","v":0},null,null,null,null,{"$f":"AY121","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,{"$f":"CONCATENATE(AN118,AO118)","v":"6cm"}]
[null,null,null,null,null,{"$f":"AN120","v":"6cm"},null,null,null,null,{"$f":"AS120","v":0},null,null,null,null,{"$f":"AX120","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,{"$f":"CONCATENATE(AN119,AO119)","v":"1cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-6)+6,0)","v":9},"m"]
[]
[]
[null,null,"The radius of each top is",null,null,null,null,null,null,null,{"$f":"AN118","v":6},"centimetres."]
[null,null,"The gap between each top is",null,null,null,null,null,null,null,null,{"$f":"AN119","v":1},"centimetre."]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN(AN122*100/(AN119+AN118+AN118),0)","v":69}]
[null,null,null,null,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,"How many tops can be cut from a strip of foil ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN122","v":9},"metres long ?"]
[null,null,null,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 22 "]