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

{"sheet":"S4G_Homework 8","index":0,"n_rows":133,"n_cols":43,"rows_kept":133,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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,35,45,36],[47,6,47,7],[47,8,47,9],[37,35,37,37],[39,6,39,7],[39,8,39,9],[45,1,45,2],[45,3,45,5],[45,7,45,8],[49,1,49,2],[49,5,49,6],[49,7,49,8],[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],[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]]}
[]
[]
[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"]