{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["S4G_Homework 1","S4G_Homework 2","S4G_Homework 3","S4G_Homework 4","S4G_Homework 5","S4G_Homework 6","S4G_Homework 7","S4G_Homework 8","S4G_Homework 9","S4G_Homework 10","S4G_Homework 11","S4G_Homework 12"],"not_rendered":{"charts":0,"images":24,"macros":1,"external_links":0,"defined_names":12,"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 1","index":0,"n_rows":130,"n_cols":43,"rows_kept":130,"cut":false,"hidden":false,"merged":[[2,6,3,32],[2,2,3,5],[5,6,6,32],[5,2,6,5],[49,1,49,2],[41,1,41,2],[45,1,45,2],[49,7,49,8],[45,14,47,31],[41,14,43,31],[8,1,8,32],[37,3,37,4],[37,6,37,7],[37,9,37,10],[39,6,39,7],[39,8,39,9],[129,27,129,32],[126,18,126,23],[101,22,101,26],[58,4,58,18],[52,8,52,9],[59,5,59,7],[61,6,61,14],[64,22,64,24],[79,5,79,7],[61,4,61,5],[116,21,124,32],[103,3,103,19],[52,6,52,7],[64,25,64,27],[126,24,126,25],[123,8,123,9],[37,1,37,2],[12,31,13,32],[10,28,10,30],[10,31,11,32],[19,3,19,30],[37,14,39,31],[20,3,25,30],[27,3,27,30],[28,3,33,30],[93,1,93,8],[94,39,94,40],[93,14,93,15],[86,5,86,6],[77,17,78,31],[82,14,82,31],[83,14,87,31],[78,35,78,38],[120,2,120,3],[94,1,94,8],[95,27,95,30],[96,25,96,26],[101,14,101,15],[115,21,115,32],[104,3,110,19],[98,7,99,19],[75,11,75,12],[75,25,75,26],[75,36,75,37],[117,10,117,11],[76,36,76,37],[37,35,37,37],[66,2,66,31],[67,2,71,31],[41,3,41,5],[49,14,51,31],[43,6,43,7],[47,8,47,9],[49,5,49,6],[43,8,43,9],[45,3,45,5],[45,7,45,8],[47,6,47,7],[45,35,45,36],[49,35,49,36],[64,35,64,37],[41,35,41,37]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 1                                                      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,24]
[]
[null,null,null,"Simple Percentage & Money",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linear Patterns"]
[]
[null,null,null,"Scientific Notation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pythagoras Theorem"]
[]
[]
[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":12},null,"-",{"$f":"ROUND(RAND()*(6-2)+2,1)","v":3.8},null,"+",{"$f":"ROUND(RAND()*(6-2)+2,2)","v":3.52},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":11.719999999999999}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D38-G38+J38","v":11.719999999999999}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-30)+30,1)","v":31.1},null,null,"x",{"$f":"ROUND(RAND()*(9-6)+6,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":"I44","v":186.60000000000002}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D42*H42","v":186.60000000000002}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(8-2)+2,1)*H46","v":4400},null,null,"÷",{"$f":"ROUND(RAND()*(9-3)+3,0)*100","v":800},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":5.5}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":5.5}]
[]
[null,"(d)",null,null,{"$f":"ROUND(RAND()*(8-2)+2,0)","v":3},"of",null,{"$f":"E51*E50","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,{"$f":"I53","v":9}]
[null,null,null,null,{"$f":"E50+1","v":4}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50/E51*E50","v":9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks )"]
[]
[]
[null,"2.","The Adams Family want to buy wine for a family party. "]
[null,null,"They see this sign in a shop window."]
[]
[null,null,null,null,"Wine Special"]
[null,null,null,null,null,{"$f":"ROUND(RAND()*(30-10)+10,0)+0.99","v":11.99},null,null,"per bottle"]
[]
[null,null,null,null,{"$f":"ROUND(RAND()*(5-1)+1,0)*5","v":20},null,"% discount when you purchase ",null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-5)+5,0)","v":7},"or more."]
[]
[]
[null,null,"Calculate the cost of ",null,null,null,null,null,null,{"$f":"P62","v":7},"bottles to the nearest penny.",null,null,null,null,null,null,null,null,"Answer :",null,null,null,null,null,{"$f":"ROUND(P62*F60*(100-E62)/100,2)","v":67.14},null,null,"( 4 marks )",null,null,null,null,null,null,{"$f":"Z65","v":67.14}]
[]
[null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3."," A  planet's  temperature is ",null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*((-5)-(-20))+(-20),0)","v":-8},null,"oC",". The earth has temperature of",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*((30)-(8))+(8),0)","v":25},null,"oC.","( 2 marks )",null,null,null,null,null,null,null,{"$f":"L76","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,{"$f":"Z76","v":25}]
[null,null,"What is the difference in temperature",null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[null,null,"between the two planets ?",null,null,null,null,null,null,null,null,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":"Z76-L76","v":33}]
[null,"Answer :",null,null,null,null,null,null,"oC"]
[]
[]
[null,"4."," Solve algebraically the equation.",null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[]
[null,null,{"$f":"ROUND(RAND()*(10-(5))+(5),0)","v":8},"x","+",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":30},"=",{"$f":"ROUND(RAND()*(4-(2))+(2),0)","v":3},"x","+",{"$f":"C86*C85+F85-H85*C86","v":65}]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":7}]
[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,"( 3 marks )"]
[]
[]
[null,"5.","(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":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,"C","=",{"$f":"ROUND(RAND()*(9-5)+5,0)","v":8},"T",{"$f":"IF(AP92=0,\"+\",\"-\")","v":"+"},{"$f":"ROUND(RAND()*(4-1)+1,0)","v":3}]
[null,"Number of tables ( T)",null,null,null,null,null,null,null,1,2,3,4,5,null,null,{"$f":"ROUND(RAND()*(15-9)+9,0)","v":10}]
[null,"Number of chairs (C)",null,null,null,null,null,null,null,{"$f":"IF($AP$93=\"+\",J94*$AN$93+$AQ$93,J94*$AN$93-$AQ$93)","v":11},null,{"$f":"IF($AP$93=\"+\",L94*$AN$93+$AQ$93,L94*$AN$93-$AQ$93)","v":27},{"$f":"IF($AP$93=\"+\",M94*$AN$93+$AQ$93,M94*$AN$93-$AQ$93)","v":35},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":83}]
[null,null,null,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 connecting the number of chairs and tables.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":19}]
[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":43}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":83}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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":235},{"$f":"ROUND(RAND()*(30-19)+19,0)","v":29}]
[null,null,"(c) How many tables are required for ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN101","v":235},null,"chairs ?",null,null,null,null,null,"Answer   T  =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO101","v":29}]
[]
[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,"6.","The diagram below shows the shape of the Langrell's garden. "]
[null,null,"Andrew decides he is going to plant a hedge along side AB.",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,{"$f":"I124+ROUND(RAND()*(6-3)+3,0)","v":13},null,"cm",null,null,null,null,"B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SQRT((C121*C121)+(K118-I124)*(K118-I124)),1)","v":8.5}]
[]
[]
[null,null,{"$f":"ROUND(RAND()*(9-6)+6,0)","v":6},null,"cm",null,null,null,"(NOT TO SCALE)"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"C121+ROUND(RAND()*(3-1)+1,0)","v":7},null,"cm",null,null,null,"A"]
[]
[null,null,null,null,"Calculate the length of AB to 1 decimal place."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer   AB  =",null,null,null,null,null,null,null,"cm",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN118","v":8.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,null,null,"( 4 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 24 "]

{"sheet":"S4G_Homework 2","index":1,"n_rows":130,"n_cols":43,"rows_kept":130,"cut":false,"hidden":false,"merged":[[10,28,10,30],[10,31,11,32],[37,3,37,5],[37,7,37,9],[37,35,37,38],[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,14,39,31],[39,5,39,7],[12,31,13,32],[19,3,19,30],[20,3,25,30],[27,3,27,30],[28,3,33,30],[39,8,39,9],[41,1,41,2],[41,14,43,31],[43,6,43,7],[43,8,43,9],[41,3,41,5],[41,7,41,8],[41,35,41,37],[45,14,47,31],[47,6,47,7],[47,8,47,9],[45,35,45,37],[45,1,45,2],[45,3,45,5],[45,7,45,8],[49,1,49,2],[49,5,49,6],[49,14,51,31],[49,3,49,4],[49,7,49,9],[49,35,49,37],[55,12,55,13],[52,6,52,7],[52,8,52,9],[77,17,78,31],[78,35,78,38],[64,25,64,27],[101,22,101,26],[96,25,96,26],[98,7,99,19],[64,22,64,24],[64,35,64,37],[66,2,66,31],[67,2,71,31],[101,15,101,16],[79,5,79,7],[79,8,79,10],[82,14,82,31],[83,14,87,31],[86,5,86,6],[86,7,86,8],[93,1,93,8],[93,14,93,15],[94,1,94,8],[94,39,94,40],[95,27,95,30],[126,18,126,23],[126,24,126,25],[129,27,129,32],[103,3,103,19],[104,3,110,19],[115,21,115,32],[116,21,124,32],[120,2,120,3],[121,6,121,7],[118,5,118,6]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 2                                                      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,23]
[]
[null,null,null,"Simple Percentage & Money",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linear Patterns"]
[]
[null,null,null,"Negative Numbers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trigonometry"]
[]
[]
[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":784.8},null,null,"-",{"$f":"ROUND(RAND()*(550-330)+330,1)","v":394.4},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":390.4}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D38-H38","v":390.4}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-15)+15,1)","v":17.3},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":1211}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D42*H42","v":1211}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(98-32)+32,1)*H46","v":561.6},null,null,"÷",{"$f":"ROUND(RAND()*(9-4)+4,0)","v":8},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":70.2}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":70.2}]
[]
[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":22},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":19.8}]
[]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50*D50/100","v":19.8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks )"]
[]
[]
[null,"2.","Maura sees a bracelet costing £",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(40-14)+14,0)*5","v":85},null,"in a jeweler's window."]
[]
[null,null,"The jeweler offers Maura a ",null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-1)+1,0)*5","v":10},"% discount."]
[]
[null,null,"Maura decides to buy the bracelet."]
[]
[]
[null,null,"How much does she pay ?",null,null,null,null,null,null,null,null,null,"( NON - CALCULATOR )"]
[]
[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":"M56-L58/100*M56","v":76.5},null,null,"( 3 marks )",null,null,null,null,null,null,{"$f":"Z65","v":76.5}]
[]
[null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","In an experiment Georgia measures the temperature of two liquids.",null,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,"Liquid one's temperture",null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(-6-(-25))+(-25),0)","v":-21},"oC"]
[null,null,"Liquid two's temperature",null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(18-(-5))+(-5),0)","v":0},"oC",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":"I80","v":21}]
[null,"Answer :",null,null,null,null,null,null,{"$f":"K78-K77","v":21}]
[]
[]
[null,"4."," Solve algebraically the equation.",null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[]
[null,null,null,null,null,{"$f":"H87*H85-K85","v":13},"=",{"$f":"ROUND(RAND()*(9-(4))+(4),0)","v":5},"x","-",{"$f":"ROUND(RAND()*(10-(6))+(6),0)","v":7}]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":8}]
[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.","(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,"W","=",{"$f":"ROUND(RAND()*(9-5)+5,0)","v":8},"C",{"$f":"IF(AP92=0,\"+\",\"-\")","v":"-"},{"$f":"ROUND(RAND()*(4-1)+1,0)","v":3}]
[null,"No. of colour tiles (C)",null,null,null,null,null,null,null,1,2,3,4,5,null,null,{"$f":"ROUND(RAND()*(15-9)+9,0)","v":10}]
[null,"No. of white tiles (W)",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":21},{"$f":"IF($AP$93=\"+\",M94*$AN$93+$AQ$93,M94*$AN$93-$AQ$93)","v":29},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":77}]
[null,null,null,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 connecting the number of white and colour tiles.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W ="]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":13}]
[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":37}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":77}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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":205},{"$f":"ROUND(RAND()*(30-19)+19,0)","v":26}]
[null,null,"(c) How many colour tiles are required for ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN101","v":205},null,"white tiles ?",null,null,null,null,"Answer   C  =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO101","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,"( 6 marks )"]
[]
[]
[null,"6.","The shaded part of a garden light is triangular."]
[null,null,null,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(SQRT((C121*C121)+(K118-I124)*(K118-I124)),1)","v":0}]
[null,null,null,null,null,{"$f":"ROUND(RAND()*(40-15)+15,0)","v":32},null,"cm"]
[]
[]
[null,null,null,null,null,null,{"$f":"ROUND(RAND()*(60-45)+45,0)","v":58},null,"o"]
[null,null,null,null,null,null,null,"x","cm"]
[]
[]
[null,null,null,null,"Calculate the value of x to 1 decimal place."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer   x  =",null,null,null,null,null,null,null,"cm",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(F119*COS(G122*PI()/180),1)","v":17}]
[null,null,null,null,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,null,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 23 "]

{"sheet":"S4G_Homework 3","index":2,"n_rows":130,"n_cols":42,"rows_kept":130,"cut":false,"hidden":false,"merged":[[10,28,10,30],[10,31,11,32],[101,28,101,30],[99,23,99,24],[12,31,13,32],[19,3,19,30],[20,3,25,30],[27,3,27,30],[28,3,33,30],[52,6,52,7],[52,8,52,9],[64,22,64,24],[64,25,64,27],[2,2,3,5],[2,6,3,32],[5,2,6,5],[5,6,6,32],[8,1,8,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],[94,39,94,40],[98,12,98,13],[82,14,82,31],[83,14,87,31],[66,2,66,31],[67,2,71,31],[77,17,78,31],[79,5,79,7],[76,6,76,7],[77,6,77,7],[55,36,55,38],[57,36,57,38],[59,36,59,38],[59,12,59,14],[79,9,79,10],[115,21,115,32],[116,21,124,32],[126,24,126,25],[129,27,129,32],[57,16,57,18],[126,17,126,23],[104,3,110,32],[103,3,103,32],[122,7,122,8],[122,12,122,13],[120,2,120,3]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 3                                                      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,"Simple Percentage & Money",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area"]
[]
[null,null,null,"Negative Numbers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pythagoras Theorem"]
[]
[]
[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":769.3},null,null,"-",{"$f":"ROUND(RAND()*(550-330)+330,1)","v":415.2},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":354.09999999999997}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D38-H38","v":354.09999999999997}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-15)+15,1)","v":31.5},null,null,"x",{"$f":"ROUND(RAND()*(9-3)+3,0)*10","v":60},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":1890}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D42*H42","v":1890}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(98-32)+32,1)*H46","v":347.90000000000003},null,null,"÷",{"$f":"ROUND(RAND()*(9-4)+4,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":"I48","v":49.7}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":49.7}]
[]
[null,"(d)",null,{"$f":"ROUND(RAND()*(9-1)+1,0)*5","v":35},null,"% of",null,{"$f":"ROUND(RAND()*(9-2)+2,1)*10","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":19.600000000000001}]
[]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50*D50/100","v":19.600000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks )"]
[]
[]
[null,"2.","Caitlin travels between Glasgow and Edinburgh.",null,null,null,null,null,null,null,null,null,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-13)+13,1)","v":14.9}]
[]
[null,null,"She buys a  monthly  TravelPass   which costs ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK61","v":261.8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK62*AK56","v":298}]
[]
[null,null,"A daily return ticket would cost",null,null,null,null,null,null,null,null,null,{"$f":"AK56","v":14.9},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()*(25-12.5)+12.5,1)*2","v":36.200000000000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK58-AK60","v":261.8}]
[null,null,"Last month Caitlin made ",null,null,null,null,null,null,null,{"$f":"AK62","v":20},"return journeys.",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()*(13-6)+6,0)*2","v":20}]
[]
[null,null,"How much did she save by buying the TravelPass ?"]
[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":"AK60","v":36.200000000000003},null,null,"( 3 marks )",null,null,null,null,null,null,null,{"$f":"AK60","v":36.200000000000003}]
[]
[null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","What is the difference in height between Ben Nevis and the bottom of Loch Ness. ",null,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,"Ben Nevis is ",null,null,null,{"$f":"AK78","v":1318},null,"m   above sea level"]
[null,null,"Loch Ness",null,null,null,{"$f":"AK79","v":208},null,"m   below sea level",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,{"$f":"ROUND(RAND()*(1400-1300)+1300,0)","v":1318}]
[null,null,null,null,null,null,null,null,null,null,null,null,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()*(240-182)+182,0)","v":208}]
[null,"Answer :",null,null,null,null,null,null,"m",{"$f":"AK78+AK79","v":1526},null,null,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":"J80","v":1526}]
[]
[]
[null,"4."," Simplify",null,null,null,{"$f":"ROUND(RAND()*((-2)-(-9))+(-9),0)","v":-3},"(",{"$f":"ROUND(RAND()*(9-(2))+(2),0)","v":8},{"$f":"CHAR(RAND()*(122-97)+97)","v":"o"},"-",{"$f":"ROUND(RAND()*(9-(2))+(2),0)","v":4},")",null,"Working :"]
[]
[null,null,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,{"$f":"G83*I83","v":-24},{"$f":"J83","v":"o"},"+",{"$f":"-G83*L83","v":12}]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":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,"5.","A semi-circular window in the school assembly hall is made from three",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"identical panes of glass."]
[null,null,"During a recent storm one pane of glass was damaged."]
[]
[]
[]
[]
[null,null,"The semi-circle has a radius of",null,null,null,null,null,null,null,null,null,{"$f":"AK99","v":35},null,"centimetres.",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-7)+7,0)*5","v":35}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK99","v":35},null,"cm"]
[null,null,"Calculate the area of the damaged pane of glass.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( to 1 decimal place )"]
[null,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,null,null,null,"cm2",null,null,null,null,{"$f":"ROUND(1/6*PI()*M99*M99,1)","v":641.4}]
[]
[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,"6.","A steel plate in the shape of an isosceles triangle is used to strengthen a bridge."]
[null,null,null,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(SQRT((C121*C121)+(K118-I124)*(K118-I124)),1)","v":0}]
[null,null,"The dimensions of the isosceles triangle are shown below."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,1)","v":2.6},"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"h"]
[null,null,null,null,null,null,null,{"$f":"K120+ROUND(RAND()*(2-0.8)+0.8,1)","v":4.5},null,"m",null,null,{"$f":"H123","v":4.5},null,"m"]
[]
[]
[null,null,"Calculate the height of the steel plate to 1 decimal place."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer   h  =  ",null,null,null,null,null,null,null,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SQRT(H123*H123-K120*K120),1)","v":3.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,null,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 "]

{"sheet":"S4G_Homework 4","index":3,"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":765.5},null,null,"-",{"$f":"ROUND(RAND()*(550-330)+330,1)","v":373},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":392.5}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D38-H38","v":392.5}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-15)+15,1)","v":31.4},null,null,"x",{"$f":"ROUND(RAND()*(9-3)+3,0)*10","v":60},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":1884}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D42*H42","v":1884}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(98-32)+32,1)*H46","v":317.60000000000002},null,null,"÷",{"$f":"ROUND(RAND()*(9-4)+4,0)","v":8},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":39.700000000000003}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":39.700000000000003}]
[]
[null,"(d)",null,{"$f":"ROUND(RAND()*(9-2)+2,0)*10","v":70},null,"% of",null,{"$f":"ROUND(RAND()*(9-2)+2,1)*10","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,{"$f":"I53","v":18.2}]
[]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50*D50/100","v":18.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":24}]
[null,null,"A",{"$f":"AJ58","v":19.2},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":19.2}]
[]
[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":24},null,null,"( 3 marks )",null,null,null,null,null,null,{"$f":"Z65","v":24}]
[]
[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":8},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":32},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":-24}]
[null,"Answer :",null,null,null,null,null,null,{"$f":"ROUND(T76-R77,0)","v":-24}]
[]
[]
[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":5},"(",{"$f":"CHAR(RAND()*(122-97)+97)","v":"q"},"+",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":7},")","+",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":6},"(",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":7},"-",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":8},{"$f":"D85","v":"q"},")"]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":5}]
[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":-43},{"$f":"N85","v":"q"},"+",{"$f":"F85*B85+I85*K85","v":77}]
[]
[null,null,null,null,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":68},"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":0},null,null,null,null,null,{"$f":"AJ97","v":15},null,null,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":15},{"$f":"AJ97*C97","v":0}]
[null,null,{"$f":"C97+1","v":1},null,null,null,null,null,{"$f":"AJ98","v":16},null,null,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":16},{"$f":"AJ98*C98","v":16}]
[null,null,{"$f":"C98+1","v":2},null,null,null,null,null,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,9,18]
[null,null,3,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,51]
[null,null,4,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},20]
[null,null,5,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,{"$f":"ROUND(RAND()*(7-2)+2,0)","v":3},15]
[null,null,6,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,18]
[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":138}]
[]
[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":2},null,null,null,null,null,null,null,null,null,null,{"$f":"Y111","v":2}]
[]
[null,null,null,null,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":4200},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":2},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":84}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.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":"M120/100*G116","v":159.6}]
[]
[]
[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":4200},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":75.599999999999994},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB128","v":75.599999999999994}]
[null,null,null,null,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 "]

{"sheet":"S4G_Homework 5","index":4,"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":16},null,"-",{"$f":"ROUND(RAND()*(6-2)+2,1)","v":4.9000000000000004},null,"+",{"$f":"ROUND(RAND()*(6-2)+2,2)","v":4.45},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":15.55}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D38-G38+J38","v":15.55}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-30)+30,1)","v":36.6},null,null,"x",{"$f":"ROUND(RAND()*(9-6)+6,0)","v":8},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":292.8}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D42*H42","v":292.8}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(8-2)+2,1)*H46","v":3300},null,null,"÷",{"$f":"ROUND(RAND()*(9-3)+3,0)*100","v":600},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":5.5}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":5.5}]
[]
[null,"(d)",null,null,{"$f":"ROUND(RAND()*(8-2)+2,0)","v":6},"of",null,{"$f":"E51*E50","v":42},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":36}]
[null,null,null,null,{"$f":"E50+1","v":7}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50/E51*E50","v":36},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":5.75}]
[null,null,"Her basic rate of pay is",null,null,null,null,null,null,null,{"$f":"AN56","v":5.75},null,"per hour."]
[]
[null,null,"She also gets paid an extra",null,null,null,null,null,null,null,null,{"$f":"AN59","v":13},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":13}]
[]
[null,null,"Last week Georgia worked",null,null,null,null,null,null,null,null,{"$f":"AN61","v":25},null,"hours and painted",null,null,null,null,null,{"$f":"AN62","v":120},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":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":"ROUND(RAND()*(15-5)+5,0)*10","v":120}]
[]
[]
[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":159.35},null,null,"( 3 marks )",null,null,null,null,null,null,{"$f":"L61*K57+T61*L59/100","v":159.35}]
[]
[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":18},{"$f":"ROUND(RAND()*(11-2)+2,0)*5","v":35},null,null,{"$f":"CONCATENATE(AJ76,\":\",AK76)","v":"18:35"},{"$f":"TIMEVALUE(AN76)","v":0.77430555555555547}]
[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":35},null,null,{"$f":"CONCATENATE(AJ77,\":\",AK77)","v":"2:35"},{"$f":"TIMEVALUE(AN77)","v":0.1076388888888889}]
[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":20},{"$f":"AK76+AK77","v":70},null,null,{"$f":"CONCATENATE(AJ78,\":\",AK78)","v":"20:70"},{"$f":"AO76+AO77","v":"21:10: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":"18:35"},null,null,"*****",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(1-0)+0,0)","v":0},{"$f":"ROUND(RAND()*(5-2)+2,0)*5","v":25},null,null,{"$f":"CONCATENATE(AJ79,\":\",AK79)","v":"0:25"},{"$f":"AN79","v":"0:25"},null,null,0,{"$f":"TIMEVALUE(AO79)","v":1.7361111111111112E-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:10:00"},null,null,{"$f":"AO80","v":"00:25"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN77","v":"2:35"},{"$f":"CONCATENATE(AR79,AO79)","v":"00:25"},null,null,null,{"$f":"(24+AS79)-AO77","v":23.909722222222221}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":-9.027777777777779E-2},null,null,null,{"$f":"AS80","v":23.909722222222221}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[null,"(b)"]
[null,"When does the late night showing start ?"]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":7}]
[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":"AS81","v":23.909722222222221}]
[null,null,null,null,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":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,"b","=",{"$f":"ROUND(RAND()*(9-5)+5,0)","v":7},"m",{"$f":"IF(AP92=0,\"+\",\"-\")","v":"+"},{"$f":"ROUND(RAND()*(4-1)+1,0)","v":3}]
[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":10}]
[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":10},null,{"$f":"IF($AP$93=\"+\",L94*$AN$93+$AQ$93,L94*$AN$93-$AQ$93)","v":24},{"$f":"IF($AP$93=\"+\",M94*$AN$93+$AQ$93,M94*$AN$93-$AQ$93)","v":31},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":73}]
[null,null,null,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":17}]
[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":38}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":73}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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":136},{"$f":"ROUND(RAND()*(30-19)+19,0)","v":19}]
[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":136},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":19}]
[]
[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":5},{"$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":4},{"$f":"ROUND(RAND()*(5-4)+4,0)","v":5},{"$f":"ROUND(RAND()*(9-5)+5,0)","v":6}]
[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":6},{"$f":"ROUND(RAND()*(2-1)+1,0)","v":1},{"$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()*(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":7},{"$f":"ROUND(RAND()*(2-1)+1,0)","v":1},{"$f":"ROUND(RAND()*(4-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(7-4)+4,0)","v":4},{"$f":"ROUND(RAND()*(9-7)+7,0)","v":8}]
[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,8,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":1},{"$f":"ROUND(RAND()*(4-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(7-4)+4,0)","v":7},{"$f":"ROUND(RAND()*(9-7)+7,0)","v":8}]
[]
[null,null,{"$f":"AQ120","v":"5.3"},null,{"$f":"AU120","v":"5.5"},null,{"$f":"AY120","v":"6.1"},null,{"$f":"BC120","v":"6.4"},null,{"$f":"AQ121","v":"7.1"},null,{"$f":"AO120","v":"5.2"},null,{"$f":"BE121","v":"8.8"},null,{"$f":"AU121","v":"7.4"},null,{"$f":"AO121","v":"6.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":"5.2"},null,{"$f":"CONCATENATE($AO$115,\".\",AQ115)","v":"5.3"},null,{"$f":"CONCATENATE($AO$115,\".\",AR115)","v":"5.4"},null,{"$f":"CONCATENATE($AO$115,\".\",AS115)","v":"5.5"},null,{"$f":"CONCATENATE($AO$115,\".\",AT115)","v":"5.6"},null,{"$f":"CONCATENATE(AO116,\".\",AP116)","v":"6.1"},null,{"$f":"CONCATENATE(AO116,\".\",AQ116)","v":"6.2"},null,{"$f":"CONCATENATE(AO116,\".\",AR116)","v":"6.4"},null,{"$f":"CONCATENATE(AO116,\".\",AS116)","v":"6.5"},null,{"$f":"CONCATENATE(AO116,\".\",AT116)","v":"6.7"}]
[null,null,{"$f":"AY121","v":"8.1"},null,{"$f":"AS121","v":"7.3"},null,{"$f":"AS120","v":"5.4"},null,{"$f":"BC121","v":"8.7"},null,{"$f":"AW120","v":"5.6"},null,{"$f":"AW121","v":"7.8"},null,{"$f":"BA120","v":"6.2"},null,{"$f":"BA121","v":"8.2"},null,{"$f":"BG120","v":"6.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":"6.8"},null,{"$f":"CONCATENATE(AO117,\".\",AP117)","v":"7.1"},null,{"$f":"CONCATENATE(AO117,\".\",AQ117)","v":"7.3"},null,{"$f":"CONCATENATE(AO117,\".\",AR117)","v":"7.4"},null,{"$f":"CONCATENATE(AO117,\".\",AS117)","v":"7.8"},null,{"$f":"CONCATENATE(AO118,\".\",AP118)","v":"8.1"},null,{"$f":"CONCATENATE(AO118,\".\",AQ118)","v":"8.2"},null,{"$f":"CONCATENATE(AO118,\".\",AR118)","v":"8.7"},null,{"$f":"CONCATENATE(AO118,\".\",AS118)","v":"8.8"}]
[null,null,{"$f":"BE120","v":"6.5"}]
[]
[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":"6.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":5},{"$f":"AP115","v":2},"means",null,{"$f":"AO120","v":"5.2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total marks 21"]

{"sheet":"S4G_Homework 6","index":5,"n_rows":130,"n_cols":42,"rows_kept":130,"cut":false,"hidden":false,"merged":[[77,17,80,31],[126,24,126,25],[129,27,129,32],[116,12,116,13],[117,11,117,12],[121,13,122,14],[121,15,122,15],[115,21,115,32],[116,21,124,32],[82,14,82,31],[83,14,87,31],[120,2,120,3],[121,7,121,8],[104,3,110,27],[103,3,103,27],[94,9,94,10],[95,12,95,13],[97,21,97,23],[86,5,86,6],[86,7,86,8],[93,26,93,27],[100,20,100,22],[84,10,84,11],[66,2,66,31],[67,2,71,31],[78,35,78,38],[79,5,79,7],[52,6,52,7],[52,8,52,9],[64,22,64,23],[64,17,64,18],[59,7,59,11],[59,12,59,15],[60,12,60,15],[59,16,59,19],[60,16,60,19],[60,35,60,36],[75,13,75,15],[76,15,76,17],[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],[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],[10,28,10,30],[10,31,11,32],[58,7,58,19],[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]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 6                                                      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,21]
[]
[null,null,null,"Distance Speed Time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perimeter"]
[]
[null,null,null,"Percentage & Money",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trigonometry"]
[]
[]
[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":865.2},null,null,"-",{"$f":"ROUND(RAND()*(550-330)+330,1)","v":332.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":"I40","v":532.6}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D38-H38","v":532.6}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-15)+15,1)","v":46.5},null,null,"x",{"$f":"ROUND(RAND()*(9-3)+3,0)*10","v":30},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":1395}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D42*H42","v":1395}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(98-32)+32,1)*H46","v":270.5},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.1}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":54.1}]
[]
[null,"(d)",null,{"$f":"ROUND(RAND()*(9-2)+2,0)*10","v":40},null,"% of",null,{"$f":"ROUND(RAND()*(9-2)+2,1)*10","v":23},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":9.1999999999999993}]
[]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50*D50/100","v":9.1999999999999993},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks )"]
[]
[]
[null,"2.","Liam's new car has an on-board computer."]
[null,null,"At the end of a journey the car’s computer displays the information below."]
[]
[null,null,null,null,null,null,null,"Journey information"]
[null,null,null,null,null,null,null,"Distance",null,null,null,null,{"$f":"AJ61*AJ63","v":239.16666666666666},null,null,null,"miles"]
[null,null,null,null,null,null,null,"Averaage Speed",null,null,null,null,{"$f":"AJ61","v":70},null,null,null,"miles/hour",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(14-6)+6,0)*5","v":70}]
[null,null,null,null,null,null,null,null,null,null,null,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":"AK65/60","v":0.41666666666666669}]
[null,null,"Use the information above to calculate the time he has taken for his journey.",null,null,null,null,null,null,null,null,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":"AJ65+AJ62","v":3.4166666666666665}]
[null,null,"Give your answer in hours and minutes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",null,null,null,null,null,"hrs",null,null,null,null,"mins",null,null,null,"( 3 marks )",null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3-1)+1,0)","v":3},{"$f":"ROUND(RAND()*(11-1)+1,0)*5","v":25}]
[]
[null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","Gordon buys an antique teapot for",null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(19-1)+1,0)*5","v":80},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 3 marks )"]
[null,null,"He sells it on an Internet auction site for",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N76+AJ79/100*N76","v":120}]
[null,null,"Calculate his percentage profit.",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,{"$f":"ROUND(RAND()*(19-1)+1,0)*5","v":50}]
[null,"Answer :",null,null,null,null,null,null,"%"]
[]
[]
[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":"t"},"-",{"$f":"ROUND(RAND()*(5-2)+2,0)","v":5},"=",{"$f":"ROUND(RAND()*(4-2)+2,0)","v":3},{"$f":"D85","v":"t"},"+",{"$f":"(C85*H87-F85)-H85*H87","v":15}]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":5}]
[null,"Answer :",null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+(2),0)","v":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,null,null,null,null,null,{"$f":"H87","v":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,null,null,"( 3 marks )"]
[]
[]
[null,"5.","Jordan is making a sign for Capaldi’s Ice Cream Parlour.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"The sign will have two equal straight edges and a semi-circular edge."]
[null,null,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(AN95,AO95)","v":"0.7m"}]
[null,null,"Each straight edge is",null,null,null,null,null,null,{"$f":"V98","v":2.5099999999999998},null,"metres long and",null,null,null,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()*(0.9-0.3)+0.3,1)","v":0.7},"m"]
[null,null,"the radius of the semi-circle is",null,null,null,null,null,null,null,null,null,{"$f":"AN95","v":0.7},null,"metres.",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(AN95,AO95)","v":"0.7m"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,2)","v":2.5099999999999998},null,null,"m"]
[null,null,"Calculate the perimeter of the sign to 1 decimal place."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perimeter = ",null,null,null,null,null,null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(V98+V98+(0.5*PI()*2*AN95),1)","v":7.2}]
[]
[]
[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,"( 4 marks )"]
[]
[]
[null,"6.","A boat elevator is used to take a boat from the lower canal to the upper canal."]
[null,null,"The boat elevator is in the shape of a triangle.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[null,null,"The length of the hypotenuse is",null,null,null,null,null,null,null,null,null,{"$f":"AN122","v":79.860390655688306},null,"metres."]
[null,null,"The height of the triangle is",null,null,null,null,null,null,null,null,{"$f":"N122","v":26},null,"metres.",null,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((C121*C121)+(K118-I124)*(K118-I124)),1)","v":0}]
[null,null,null,null,null,{"$f":"ROUND(RAND()*(40-15)+15,0)","v":33}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"AN122","v":79.860390655688306},null,"m",null,null,null,{"$f":"ROUND(RAND()*(40-15)+15,0)","v":26},null,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N122/SIN(AN127*PI()/180)","v":79.860390655688306}]
[]
[null,null,null,null,null,null,null,null,null,"xo"]
[]
[]
[null,null,"Calculate the size of the shaded angle x °to the nearest degree.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"o",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(20-10)+10,0)","v":19}]
[null,null,null,null,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 21 "]

{"sheet":"S4G_Homework 7","index":6,"n_rows":131,"n_cols":42,"rows_kept":131,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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]]}
[]
[]
[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 "]

{"sheet":"S4G_Homework 8","index":7,"n_rows":133,"n_cols":43,"rows_kept":133,"cut":false,"hidden":false,"merged":[[132,27,132,32],[57,5,57,9],[58,5,58,9],[59,5,59,9],[60,5,60,9],[62,6,62,10],[107,3,107,19],[108,3,114,19],[118,21,118,32],[119,21,127,32],[97,1,97,8],[98,27,98,30],[99,25,99,26],[64,22,64,25],[129,18,129,23],[129,24,129,25],[49,35,49,36],[66,2,66,31],[67,2,71,31],[77,35,77,37],[78,35,78,37],[62,35,62,39],[64,35,64,39],[45,1,45,2],[45,3,45,5],[45,7,45,8],[49,1,49,2],[49,5,49,6],[49,7,49,8],[45,35,45,36],[47,6,47,7],[47,8,47,9],[37,35,37,37],[39,6,39,7],[39,8,39,9],[41,1,41,2],[41,3,41,5],[41,14,43,31],[41,35,41,37],[43,6,43,7],[43,8,43,9],[37,1,37,2],[37,3,37,4],[37,6,37,7],[37,9,37,10],[37,14,39,31],[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],[77,13,77,14],[78,13,78,14],[77,21,79,31],[12,31,13,32],[19,3,19,30],[20,3,25,30],[27,3,27,30],[28,3,33,30],[45,14,47,31],[52,6,52,7],[52,8,52,9],[49,14,51,31],[123,16,123,17],[81,35,81,37],[104,7,104,8],[84,35,84,37],[85,35,85,37],[86,35,86,37],[101,7,102,19],[104,22,104,26],[81,5,81,7],[83,14,83,31],[84,14,88,31],[87,5,87,6],[96,1,96,8],[96,14,96,15],[87,36,87,37],[117,39,117,41],[118,39,118,40],[119,39,119,40],[84,2,84,4],[84,6,84,8],[117,8,117,9],[118,8,118,9],[97,39,97,40]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 8                                                      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,"Money & Percentages",null,null,null,null,null,null,null,null,null,null,null,22]
[]
[null,null,null,"Simple Percentage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linear Patterns"]
[]
[null,null,null,"Negative Numbers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perimeter & Area"]
[]
[]
[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":17},null,"-",{"$f":"ROUND(RAND()*(6-2)+2,1)","v":4.5},null,"+",{"$f":"ROUND(RAND()*(6-2)+2,2)","v":2.92},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":15.42}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D38-G38+J38","v":15.42}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-30)+30,1)","v":36.700000000000003},null,null,"x",{"$f":"ROUND(RAND()*(9-6)+6,0)","v":8},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":293.60000000000002}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D42*H42","v":293.60000000000002}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(8-2)+2,1)*H46","v":3360},null,null,"÷",{"$f":"ROUND(RAND()*(9-3)+3,0)*100","v":800},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":4.2}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":4.2}]
[]
[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.","In the “Fame Show”, the percentage of telephone votes cast for each act is shown below."]
[]
[null,null,null,null,null,"Plastik Money",null,null,null,null,{"$f":"ROUND(RAND()*(12-9)+9,0)*2","v":20},"%"]
[null,null,null,null,null,"Brian Martins",null,null,null,null,{"$f":"ROUND(RAND()*(17-13)+13,0)*2","v":26},"%"]
[null,null,null,null,null,"Starshine",null,null,null,null,{"$f":"ROUND(RAND()*(16-10)+10,0)*2","v":26},"%"]
[null,null,null,null,null,"Carrie Gordon",null,null,null,null,{"$f":"100-(K58+K59+K60)","v":28},"%"]
[]
[null,null,"Altogether",null,null,null,{"$f":"AJ63","v":18000000},null,null,null,null,"votes were cast.",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()*(12-7)+7,0)*2*1000000","v":18000000}]
[]
[null,null,"How many votes did Starshine receive?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer ",null,null,null,null,null,null,"votes",null,"( 3 marks )",null,null,null,null,null,null,{"$f":"AJ63*K60/100","v":4680000}]
[]
[null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","One day last February, Paige compared the temperature in Edinburgh",null,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," with the temperature in Montreal."]
[null,null,"The temperature in Edinburgh was",null,null,null,null,null,null,null,null,null,null,{"$f":"AJ78","v":14},null,"oC",null,"Working :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(15-(4))+(4),0)","v":14}]
[null,null,"The temperature in Montreal was",null,null,null,null,null,null,null,null,null,null,{"$f":"AJ79","v":-14},null,"oC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(-5-(-20))+(-20),0)","v":-14}]
[]
[null,null,"Find the difference between these temperatures."]
[null,"Answer :",null,null,null,null,null,null,"oC",null,null,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":"AJ78-AJ79","v":28}]
[]
[null,"4.","The price of a laptop is reduced from",null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[null,null,{"$f":"AJ86","v":800},null,null,"to ",{"$f":"AJ87","v":680},null,null,null,null,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)*5","v":15}]
[null,null,"Calculate the percentage reduction in the",null,null,null,null,null,null,null,null,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-(4))+(4),0)*100","v":800}]
[null,null,"price of the laptop.",null,null,null,null,null,null,null,null,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":"(100-AJ85)/100*AJ86","v":680}]
[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,{"$f":"AJ85","v":15}]
[]
[null,null,null,null,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.","Maura is laying a path in a nursery school.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"She is using a mixture of alphabet tiles and coloured tiles.",null,null,null,null,null,null,null,null,null,null,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":"ROUND(RAND()*(9-5)+5,0)","v":5},"A",{"$f":"IF(AP93=0,\"+\",\"-\")","v":"-"},{"$f":"ROUND(RAND()*(4-1)+1,0)","v":4}]
[]
[null,null,"(a) Complete the table below."]
[null,"Number of alphabet tiles (A)",null,null,null,null,null,null,null,1,2,3,4,5,null,null,{"$f":"ROUND(RAND()*(15-9)+9,0)","v":12}]
[null,"Number of coloured tiles (C)",null,null,null,null,null,null,null,{"$f":"IF($AP$94=\"+\",J97*$AN$94+$AQ$94,J97*$AN$94-$AQ$94)","v":1},null,{"$f":"IF($AP$94=\"+\",L97*$AN$94+$AQ$94,L97*$AN$94-$AQ$94)","v":11},{"$f":"IF($AP$94=\"+\",M97*$AN$94+$AQ$94,M97*$AN$94-$AQ$94)","v":16},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$94=\"+\",Q97*AN94+AQ94,Q97*AN94-AQ94)","v":56}]
[null,null,null,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 connecting the number of chairs and tables.","Write down a formula for calculating the number of coloured tiles (C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C ="]
[null,null,null,"when you know the number of alphabet tiles (A).",null,null,null,null,null,null,null,null,null,null,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$94=\"+\",K97*$AN$94+$AQ$94,K97*$AN$94-$AQ$94)","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,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF($AP$94=\"+\",N97*$AN$94+$AQ$94,N97*$AN$94-$AQ$94)","v":21}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AN98","v":56}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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$94=\"+\",AO104*$AN$94+$AQ$94,AO104*$AN$94-$AQ$94)","v":106},{"$f":"ROUND(RAND()*(30-19)+19,0)","v":22}]
[null,null,"(c) How many tables are required for ","Maura uses ",null,null,null,{"$f":"AN104","v":106},null,"coloured tiles to make the path.",null,null,null,null,null,null,null,null,null,null,null,null,"Answer   A  =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AO104","v":22}]
[null,null,null,"How many alphabet tiles will be in the path?"]
[]
[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,"6.","A tennis court is",null,null,null,null,null,{"$f":"AN118","v":10},null,"metres wide.",null,null,null,null,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()*(16-(9))+(9),0)","v":10}]
[null,null,"It has an area of",null,null,null,null,null,{"$f":"AN119","v":230},null,"square metres.",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,{"$f":"AN118*(AN118+ROUND(RAND()*(16-9)+9,0))","v":230}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AN119/AN118","v":23}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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((C124*C124)+(K121-I127)*(K121-I127)),1)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN118","v":10},null,"metres"]
[]
[]
[]
[]
[]
[null,null,"Calculate the perimeter of the tennis court.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer  =   ",null,null,null,null,null,null,null,"metres",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2*(AN120+AN118)","v":66}]
[null,null,null,null,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 22"]

{"sheet":"S4G_Homework 9","index":8,"n_rows":130,"n_cols":42,"rows_kept":130,"cut":false,"hidden":false,"merged":[[10,28,10,30],[10,31,11,32],[61,11,61,13],[58,14,60,15],[12,31,13,32],[19,3,19,30],[20,3,25,30],[27,3,27,30],[28,3,33,30],[49,14,51,31],[52,6,52,7],[52,8,52,9],[2,2,3,5],[2,6,3,32],[5,2,6,5],[5,6,6,32],[8,1,8,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],[78,35,78,38],[79,5,79,7],[64,17,64,18],[66,2,66,31],[75,21,75,22],[79,35,79,38],[67,2,71,31],[77,17,80,31],[80,35,80,38],[82,14,82,31],[83,14,87,31],[84,10,84,11],[86,5,86,6],[86,7,86,8],[121,7,121,8],[100,20,100,22],[103,3,103,27],[104,3,110,27],[126,24,126,25],[124,9,124,10],[120,2,120,3],[129,27,129,32],[91,29,91,31],[115,21,115,32],[116,21,124,32],[94,21,94,22]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 9                                                      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,22]
[]
[null,null,null,"Pythagoras Theorem",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Money Hire Purchase"]
[]
[null,null,null,"Money Exchange Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trigonometry"]
[]
[]
[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":736.7},null,null,"-",{"$f":"ROUND(RAND()*(550-330)+330,1)","v":452.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":284.20000000000005}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D38-H38","v":284.20000000000005}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-15)+15,1)","v":24.1},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":1687}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D42*H42","v":1687}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(98-32)+32,1)*H46","v":353.4},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":58.9}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":58.9}]
[]
[null,"(d)",null,{"$f":"ROUND(RAND()*(9-2)+2,0)*10","v":40},null,"% of",null,{"$f":"ROUND(RAND()*(9-2)+2,1)*10","v":23},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":9.1999999999999993}]
[]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50*D50/100","v":9.1999999999999993},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks )"]
[]
[]
[null,"2.","An earring in the shape of an isosceles triangle is made from silver wire."]
[null,null,"The dimensions of the earring are shown on the diagram below."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN62","v":"9cm"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,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()*(8-3)+3,0)","v":6},"cm",null,null,{"$f":"CONCATENATE(AJ61,AK61)","v":"6cm"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN61","v":"6cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ61+ROUND(RAND()*(5-2)+2,0)","v":9},"cm",null,null,{"$f":"CONCATENATE(AJ62,AK62)","v":"9cm"}]
[null,null,null,null,null,null,null,null,null,null,null,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(2*SQRT((AJ62*AJ62)+(AJ61*AJ61))+AJ61,1)","v":27.6}]
[null,null,"Calculate the length of silver wire needed to make a pair of earrings to 1 decimal place."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",null,null,null,null,null,"cm",null,null,null,null,null,null,null,null,"( 4 marks )"]
[]
[null,null,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","When on holiday in Spain, Connor sees a pair of jeans priced at ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ79","v":90},null,"euros.",null,null,null,null,"( 3 marks )"]
[null,null,"Connor knows that he gets ",null,null,null,null,null,null,null,null,{"$f":"AJ80","v":18},"euros for £10."]
[null,null,"What is the price of the jeans",null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[null,null,"in pounds to the nearest pence ?",null,null,null,null,null,null,null,null,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-10)+10,0)*5","v":90}]
[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,{"$f":"ROUND(RAND()*(19-10)+10,0)","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,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AJ79/AJ80*10,2)","v":50}]
[]
[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":9},{"$f":"CHAR(RAND()*(122-97)+97)","v":"m"},"-",{"$f":"ROUND(RAND()*(5-2)+2,0)","v":4},"=",{"$f":"ROUND(RAND()*(4-2)+2,0)","v":3},{"$f":"D85","v":"m"},"+",{"$f":"(C85*H87-F85)-H85*H87","v":50}]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":7}]
[null,"Answer :",null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+(2),0)","v":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,null,null,null,{"$f":"H87","v":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,"( 3 marks )"]
[]
[]
[null,"5.","Liam buys a new stereo using the monthly payment plan.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The cash price of the stereo is",null,null,null,null,null,null,null,null,null,{"$f":"AN92","v":700},null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,0)*100","v":700},null,{"$f":"ROUND(RAND()*(1-0)+0,0)","v":1}]
[null,null,"The total cost of the monthly payment plan is",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN93","v":10},"% more than the cash price.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3-1)+1,0)*5","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AN92+AN92*0.05","v":735}]
[null,null,"Liam pays a deposit of one fifth of the cash price followed by ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN95","v":18},null,"equal monthly payments.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(6-1)+1,0)*6","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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN92/5","v":140}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AN94-AN96","v":595}]
[]
[]
[null,null,"How much will Liam pay each month"]
[null,null,"to the nearest pence ?",null,null,null,null,null,null,null,null,null,null,null,null,null,"Payments =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AN97/AN95,2)","v":33.06}]
[]
[]
[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,"( 4 marks )"]
[]
[]
[null,"6.","Chris is making a frame to strengthen a stairway in a shopping centre."]
[null,null,"He needs to know the angle the stairway makes with the floor,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working :"]
[null,null,"as shown in the diagram below."]
[null,null,"The hypotenuse of the frame is 5·2m",null,null,null,null,null,null,null,null,null,null,null,null,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((C121*C121)+(K118-I124)*(K118-I124)),1)","v":0}]
[null,null,"and the horizontal distance is 4·5m."]
[]
[]
[null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8.2-5.4)+5.4,1)","v":6.1},null,"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,{"$f":"ROUND(ACOS(J125/H122)*180/PI(),0)","v":42}]
[]
[null,null,null,null,null,null,null,null,null,"xo"]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4.9-4.1)+4.1,1)","v":4.5},null,"m"]
[]
[null,null,"Calculate the size of the shaded angle x º to the nearest degree.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"o",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN122","v":42}]
[null,null,null,null,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 22 "]

{"sheet":"S4G_Homework 10","index":9,"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"]

{"sheet":"S4G_Homework 11","index":10,"n_rows":133,"n_cols":59,"rows_kept":133,"cut":false,"hidden":false,"merged":[[10,28,10,30],[10,31,11,32],[12,31,13,32],[19,3,19,30],[2,2,3,5],[2,6,3,32],[5,2,6,5],[5,6,6,32],[8,1,8,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],[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],[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],[77,2,78,2],[77,4,78,4],[77,3,78,3],[76,36,77,36],[43,8,43,9],[52,6,52,7],[52,8,52,9],[64,17,64,19],[66,2,66,31],[67,2,71,31],[49,1,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,9],[49,14,51,31],[55,16,55,17],[116,21,116,32],[83,15,83,31],[84,15,88,31],[79,35,79,38],[80,9,80,10],[80,35,80,38],[77,17,80,31],[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],[120,50,120,51],[121,58,121,59],[132,27,132,32],[121,46,121,47],[121,48,121,49],[121,50,121,51],[121,52,121,53],[121,54,121,55],[121,56,121,57],[121,40,121,41],[121,42,121,43],[121,44,121,45],[130,15,130,16],[125,10,125,11],[120,1,121,2],[120,3,121,3],[92,23,92,30],[93,23,93,27],[94,23,94,27],[95,23,95,27],[93,28,93,30],[94,28,94,30],[95,28,95,30],[98,23,98,26],[117,21,126,32],[101,20,101,22],[104,3,104,27],[105,3,111,27]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 11                                                      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,"Speed Distance Time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Money"]
[]
[null,null,null,"Fractions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pythagoras Theorem"]
[]
[]
[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":823.2},null,null,"-",{"$f":"ROUND(RAND()*(550-330)+330,1)","v":380.9},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":442.30000000000007}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D38-H38","v":442.30000000000007}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-15)+15,1)","v":20.8},null,null,"x",{"$f":"ROUND(RAND()*(9-3)+3,0)*10","v":60},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":1248}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D42*H42","v":1248}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(98-32)+32,1)*H46","v":328.5},null,null,"÷",{"$f":"ROUND(RAND()*(9-4)+4,0)","v":9},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":36.5}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":36.5}]
[]
[null,"(d)",null,{"$f":"ROUND(RAND()*(9-2)+2,0)*10","v":60},null,"% of",null,{"$f":"ROUND(RAND()*(9-2)+2,1)*10","v":31},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":18.600000000000001}]
[]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"H50*D50/100","v":18.600000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks )"]
[]
[]
[null,"2.","A Sprinter train travels at an average speed",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ58","v":90},null,"kilometres per hour.",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}]
[null,null,null,null,null,null,null,null,null,null,null,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":18}]
[null,null,"The train takes ",null,null,null,null,null,{"$f":"AJ56","v":1},"hours",null,{"$f":"AJ57","v":18},"minutes to travel between Dingwall and Aberdeen.",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-6)+6,0)*10","v":90}]
[]
[null,null,"Calculate the distance between Dingwall and Aberdeen."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer",null,null,null,null,null,null,"Km",null,null,null,null,null,null,null,"( 2 marks )",null,null,null,null,null,null,{"$f":"AJ58*(AJ56+AJ57/60)","v":117}]
[]
[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()*(9-5)+5,0)","v":5}]
[null,"3.","Calculate",null,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()*(4-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,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":4},{"$f":"ROUND(RAND()*(9-2)+2,0)","v":5}]
[null,null,{"$f":"AK75","v":5},"x",{"$f":"AK76","v":4},{"$f":"AL77","v":5},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,{"$f":"AL77+1","v":6}]
[null,null,null,null,null,{"$f":"AL78","v":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,null,null,null,null,null,null,null,{"$f":"AK75*(AL78*AK76+AL77)/AL78","v":24.166666666666668}]
[]
[]
[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":"p"},"+",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":8},")","+",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":4},"(",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":4},"-",{"$f":"ROUND(RAND()*(9-2)+2,0)","v":6},{"$f":"D86","v":"p"},")"]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":7}]
[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":"B86+(I86*-M86)","v":-17},{"$f":"N86","v":"p"},"+",{"$f":"F86*B86+I86*K86","v":72}]
[]
[null,null,null,null,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.","The Duff family owns two dogs and a cat.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vet Rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(40-30)+30,1)","v":37.5},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,"Dogs",null,null,null,null,{"$f":"AN93","v":37.5},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(19-11)+11,1)","v":16.100000000000001}]
[null,null,"Last year each dog had ",null,null,null,null,null,null,null,{"$f":"AN95","v":3},"check-ups at Belmont Vets.",null,null,null,null,null,null,null,null,null,null,null,"Cat",null,null,null,null,{"$f":"AN94","v":16.100000000000001},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rabbits",null,null,null,null,{"$f":"AN97","v":21.4},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-1)+1,0)","v":4}]
[null,null,"The family cat also had check-ups last year.",null,null,null,null,null,null,null,null,null,null,null,null,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()*(29-20)+20,1)","v":21.4}]
[]
[null,null,"The Duff’s total check-up fees for the two dogs and the cat were ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN95*AN93+AN96*AN94","v":176.9}]
[]
[]
[null,null,"How often did the cat have a check-up?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"checkups",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN96","v":4}]
[]
[]
[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,"( 4 marks )"]
[]
[]
[null,"5.","A rectangular metal grill for a window is 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,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":3},{"$f":"ROUND(RAND()*(5-4)+4,0)","v":4},{"$f":"ROUND(RAND()*(9-5)+5,0)","v":6}]
[null,null,"Two diagonal metal bars strengthen the grill.",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,{"$f":"ROUND(RAND()*(20-10)+10,0)","v":17},2,{"$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":4},{"$f":"ROUND(RAND()*(5-4)+4,0)","v":4},{"$f":"ROUND(RAND()*(7-5)+5,0)","v":6},{"$f":"ROUND(RAND()*(9-7)+7,0)","v":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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN117-ROUND(RAND()*(6-3)+3,0)","v":12},3,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":1},{"$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":6},{"$f":"ROUND(RAND()*(8-7)+7,0)","v":8},{"$f":"ROUND(RAND()*(9-8)+8,0)","v":9}]
[]
[null,{"$f":"AN118","v":12},null,"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,{"$f":"CONCATENATE($AO$116,AP116)","v":"12"},null,{"$f":"CONCATENATE($AO$116,AQ116)","v":"12"},null,{"$f":"CONCATENATE($AO$116,AR116)","v":"13"},null,{"$f":"CONCATENATE($AO$116,AS116)","v":"14"},null,{"$f":"CONCATENATE($AO$116,AT116)","v":"16"},null,{"$f":"CONCATENATE(AO117,AP117)","v":"21"},null,{"$f":"CONCATENATE(AO117,AQ117)","v":"23"},null,{"$f":"CONCATENATE(AO117,AR117)","v":"24"},null,{"$f":"CONCATENATE(AO117,AS117)","v":"24"},null,{"$f":"CONCATENATE(AO117,AT117)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AO117,AU117)","v":"29"},null,{"$f":"CONCATENATE(AO118,AP118)","v":"31"},null,{"$f":"CONCATENATE(AO118,AQ118)","v":"34"},null,{"$f":"CONCATENATE(AO118,AR118)","v":"35"},null,{"$f":"CONCATENATE(AO118,AS118)","v":"37"},null,{"$f":"CONCATENATE(AO119,AP119)","v":"42"},null,{"$f":"CONCATENATE(AO119,AQ119)","v":"43"},null,{"$f":"CONCATENATE(AO119,AR119)","v":"46"},null,{"$f":"CONCATENATE(AO119,AS119)","v":"48"},null,{"$f":"CONCATENATE(AO119,AT119)","v":"49"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AN117","v":17},null,"cm"]
[]
[null,null,"Find the length of one of the metal bars."]
[null,null,"Round your answer to the nearest centimetre."]
[null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SQRT((K126*K126)+(B121*B121)),0)","v":21}]
[]
[null,null,null,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"]

{"sheet":"S4G_Homework 12","index":11,"n_rows":130,"n_cols":42,"rows_kept":130,"cut":false,"hidden":false,"merged":[[117,20,118,20],[115,17,115,18],[117,12,117,13],[116,7,116,8],[126,24,126,25],[129,27,129,32],[80,5,80,7],[100,20,100,22],[103,3,103,27],[104,3,110,27],[115,21,115,32],[116,21,124,32],[120,2,120,3],[82,14,82,31],[83,14,87,31],[84,10,84,11],[86,5,86,6],[86,7,86,8],[117,11,118,11],[67,2,71,31],[77,17,80,31],[78,35,78,38],[79,35,79,38],[80,35,80,38],[75,17,75,19],[76,7,76,8],[75,35,75,38],[76,35,76,38],[77,35,77,38],[66,2,66,31],[49,1,49,2],[49,14,51,31],[52,6,52,8],[55,7,55,9],[55,23,55,24],[57,17,57,18],[57,24,57,31],[58,24,58,31],[59,24,59,31],[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,3,50,3],[49,4,50,4],[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],[2,2,3,5],[2,6,3,32],[5,2,6,5],[5,6,6,32],[8,1,8,32],[61,35,61,36],[59,37,59,38],[64,17,64,20],[62,35,62,38],[10,28,10,30],[10,31,11,32],[12,31,13,32],[19,3,19,30],[20,3,25,30],[27,3,27,30],[28,3,33,30],[37,35,37,38],[39,5,39,7],[39,8,39,9]]}
[]
[]
[null,null,"Name :"]
[]
[]
[null,null,"Teacher :"]
[]
[]
[null,"General Official Homework 12                                                      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,22]
[]
[null,null,null,"Money & Percentages",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perimeter & Area"]
[]
[null,null,null,"Money",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trigonometry"]
[]
[]
[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":748},null,null,"-",{"$f":"ROUND(RAND()*(550-330)+330,1)","v":486.1},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":261.89999999999998}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D38-H38","v":261.89999999999998}]
[]
[null,"(b)",null,{"$f":"ROUND(RAND()*(50-15)+15,1)","v":46.6},null,null,"x",{"$f":"ROUND(RAND()*(9-3)+3,0)*10","v":50},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":2330}]
[]
[null,null,"Answer",null,null,null,null,null,{"$f":"D42*H42","v":2330}]
[]
[null,"(c) ",null,{"$f":"ROUND(RAND()*(98-32)+32,1)*H46","v":581.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":96.90000000000002}]
[]
[null,null,"Answer :",null,null,null,null,null,{"$f":"D46/H46","v":96.90000000000002}]
[]
[null,"(d)",null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":2},"x",{"$f":"ROUND(RAND()*(8-2)+2,0)","v":5},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,{"$f":"D50*F50/F51","v":1.6666666666666667}]
[null,null,null,null,null,{"$f":"F50+1","v":6}]
[]
[null,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,"( 5 marks )"]
[]
[]
[null,"2.","Maura invests",null,null,null,null,{"$f":"AJ62","v":3200},null,null,"in the Platinum Saver Account which pays",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL60","v":"3.6%"},null,"interest per annum."]
[]
[null,null,"How much simple  interest  will  she  receive  after",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ61","v":9},null,"months?",null,null,null,null,"Platinum Saver Account"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest Rate"]
[null,null,"Round your answer to the nearest pence.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL60","v":"3.6%"},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-3)+3,1)","v":3.6},"%",{"$f":"CONCATENATE(AJ60,AK60)","v":"3.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,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(11-7)+7,0)","v":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,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(987-165)+165,0)*10","v":3200}]
[null,null,null,null,null,null,null,null,null,null,null,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(AJ62*AJ60/100/12*AJ61,2)","v":86.4}]
[]
[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,"Working :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3.","Mr Lafferty is a bricklayer. He builds a wall using ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ76","v":9000},null,null,"bricks: ",null,null,null,null,null,null,null,"( 3 marks )",null,null,null,null,null,null,{"$f":"ROUND(RAND()*(19-10)+10,0)*500","v":9000}]
[null,null,"• a charge of ",null,null,null,null,{"$f":"AJ77","v":130},null,"is made for every 500 bricks he lays.",null,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-13)+13,0)*10","v":130}]
[null,null,"• each brick costs",null,null,null,null,null,{"$f":"AJ78","v":16},"pence",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,{"$f":"ROUND(RAND()*(30-15)+15,0)","v":16}]
[]
[null,"What is the total cost of building the wall?"]
[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,{"$f":"AJ76/500*AJ77+AJ76*AJ78/100","v":3780}]
[]
[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":9},{"$f":"CHAR(RAND()*(122-97)+97)","v":"r"},"-",{"$f":"ROUND(RAND()*(5-2)+2,0)","v":4},"=",{"$f":"ROUND(RAND()*(4-2)+2,0)","v":4},{"$f":"D85","v":"r"},"+",{"$f":"(C85*H87-F85)-H85*H87","v":31}]
[null,null,{"$f":"ROUND(RAND()*(9-(1))+(1),0)","v":8}]
[null,"Answer :",null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+(2),0)","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,null,null,null,null,null,{"$f":"H87","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,null,null,"( 3 marks )"]
[]
[]
[null,"5.","A supermarket has a canopy over its entrance.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 edge of the canopy has 6 semicircles as shown below."]
[]
[null,null,"Each semicircle has a diameter of",null,null,null,null,null,null,null,null,null,{"$f":"AN96","v":8},"metres.",null,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)","v":8}]
[]
[]
[]
[null,null,"Find the length of the curved edge of canopy"]
[null,null,"Round answer to 1 decimal place.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"metres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(3*PI()*AN96,1)","v":75.400000000000006}]
[]
[]
[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,"( 4 marks )"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E"]
[null,"6.","DEFG is a kite:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN116","v":19},null,"cm",null,"Working :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(30-10)+10,0)","v":19}]
[null,null,"• angle DEG =",null,null,null,null,{"$f":"AN117","v":66},null,"o",null,null,null,null,null,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()*(70-50)+50,0)","v":66},"o"]
[null,null,"• EF =",null,null,{"$f":"AN116","v":19},"centimetres.",null,null,null,null,"D",{"$f":"AN117","v":66},null,"o",null,null,null,null,null,"F"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,"Calculate the length of DF to 1 decimal place.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cm",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(2*(AN116*COS(AN117*PI()/180)),1)","v":15.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,null,null,"( 4 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 22 "]