{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["S4G_Homework 9"],"not_rendered":{"charts":0,"images":4,"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 9","index":0,"n_rows":130,"n_cols":42,"rows_kept":130,"cut":false,"hidden":false,"merged":[[129,27,129,32],[91,29,91,31],[115,21,115,32],[116,21,124,32],[94,21,94,22],[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],[82,14,82,31],[83,14,87,31],[84,10,84,11],[86,5,86,6],[86,7,86,8],[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],[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],[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],[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],[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]]}
[]
[]
[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,{"$f":"\"The hypotenuse of the frame is \"&H122&\"m\"","v":"The hypotenuse of the frame is 6.1m"},null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"\"and the horizontal distance is \"&J125&\"m.\"","v":"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 "]