{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["N4_Prog_4 Assess_Practice_Sheet"],"not_rendered":{"charts":3,"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":"N4_Prog_4 Assess_Practice_Sheet","index":0,"n_rows":204,"n_cols":45,"rows_kept":204,"cut":false,"hidden":false,"merged":[[80,33,80,34],[80,35,80,36],[83,33,83,34],[83,35,83,36],[81,5,81,7],[83,5,83,7],[83,13,83,18],[81,13,81,18],[1,26,1,29],[2,26,2,29],[222,2,226,31],[38,2,48,31],[97,18,106,31],[74,13,74,15],[77,18,77,20],[76,5,76,8],[6,26,6,29],[6,30,6,31],[76,13,76,15],[2,1,2,25],[4,1,4,25],[1,30,1,31],[2,30,2,31],[87,0,87,31],[76,33,76,34],[76,35,76,36],[73,33,73,34],[73,35,73,36],[3,26,3,29],[4,26,4,29],[5,26,5,29],[3,30,3,31],[4,30,4,31],[5,30,5,31],[8,14,8,15],[11,14,11,15],[14,14,14,15],[17,14,17,15],[8,4,8,5],[8,7,8,8],[11,4,11,5],[11,7,11,8],[14,7,14,8],[17,4,17,5],[17,8,17,9],[36,19,36,21],[74,5,74,8],[14,4,14,5],[21,2,28,31],[108,10,108,13],[108,14,108,15],[99,9,100,10],[100,3,101,4],[104,8,105,9],[130,10,130,13],[130,14,130,15],[120,12,121,14],[124,7,125,9],[138,17,138,20],[203,8,203,11],[203,12,203,13],[138,21,138,22],[132,2,136,31],[141,2,145,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,null,null,"EF 1.2e  (A 2.1)"]
[null,"NATIONAL 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,"R1.3a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R1.1a"]
[null,"PROGRAMME 4 ASSESSMENT 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,"R 1.2e (A2.1)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*((-2)-(-9))+(-9),0)","v":-7},{"$f":"ROUND(RAND()*((-2)-(-9))+(-9),0)","v":-3},null,{"$f":"CONCATENATE(\"(\",AK5,\")\")","v":"(-7)"},{"$f":"CONCATENATE(\"(\",AL5,\")\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*((9)-(4))+(4),0)","v":5},{"$f":"ROUND(RAND()*((-2)-(-9))+(-9),0)","v":-6},null,{"$f":"AK6","v":5},{"$f":"CONCATENATE(\"(\",AL6,\")\")","v":"(-6)"}]
[null,"Q1   Evaluate the following :"]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AL8*ROUND(RAND()*((-3)-(-20))+(-20),0)","v":-133},{"$f":"ROUND(RAND()*((9)-(3))+(3),0)","v":7},null,{"$f":"ROUND(RAND()*((-2)-(-5))+(-5),0)","v":-5},{"$f":"ROUND(RAND()*((-1)-(-5))+(-5),0)","v":-5},{"$f":"ROUND(RAND()*((9)-(6))+(6),0)","v":7}]
[null,null,"(a)",null,{"$f":"AN5","v":"(-7)"},null,"+",{"$f":"AO5","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,null,null,{"$f":"AK5+AL5","v":-10},null,null,{"$f":"CONCATENATE(\"(\",AK8,\")\")","v":"(-133)"},null,null,{"$f":"CONCATENATE(\"(\",AN8,\")\")","v":"(-5)"},{"$f":"CONCATENATE(\"(\",AO8,\")\")","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,null,null,{"$f":"AK6*AL6","v":-30}]
[null,null,"(b)",null,{"$f":"AN6","v":5},null,"x",{"$f":"AO6","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,{"$f":"AK8/AL8","v":-19}]
[]
[null,null,"(c)",null,{"$f":"AK9","v":"(-133)"},null,"÷",{"$f":"AL8","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,{"$f":"AN8*(AO8+AP8)","v":-10}]
[]
[]
[null,null,"(d)",null,{"$f":"AN9","v":"(-5)"},null,"x","(",{"$f":"AO9","v":"(-5)"},null,"+",{"$f":"AP8","v":7},")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 4 marks )"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q2  To cover an area of  \"&AL32&\" square metres Jack, the painter, needs \"&AK32&\" litres of paint.\"","v":"Q2  To cover an area of  45 square metres Jack, the painter, needs 5 litres of paint."},null,null,null,null,null,null,null,null,null,null,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()*((5)-(2))+(2),0)","v":5},{"$f":"AK32*ROUND(RAND()*(10-4)+4,0)","v":45}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AL32/AK32","v":9}]
[null,null,{"$f":"\"How much paint would be needed to cover an area of \"&AL34&\" square metres.\"","v":"How much paint would be needed to cover an area of 135 square 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,null,null,null,null,null,null,null,null,{"$f":"AK33+ROUND(RAND()*(4+1)+1,0)","v":15},{"$f":"AK34*AK33","v":135}]
[null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"litres"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q3  F & F Bikes want a new logo to go on the wheels of their bicycles. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EF 1.2e  (A 2.1)"]
[]
[null,null,"Part of the design for the logo 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,"( 2 marks )"]
[]
[null,null,"Complete this shape so that it has rotational symmetry of order 4, about point."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q4",null,"(a)   Write the following numbers in scientific notation."]
[null,null,null,null,null,null,null,null,null,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":"AJ74*POWER(10,AN74)","v":28500},null,{"$f":"ROUND(RAND()*(9-1)+1,2)","v":2.85},null,"x",10,{"$f":"ROUND(RAND()*(6-3)+3,0)","v":4}]
[null,null,null,"(i)",null,{"$f":"AH74","v":28500},null,null,null,null,null,null,null,null,null,null,"x",10]
[]
[null,null,null,"(ii)",null,{"$f":"AH77","v":181900},null,null,null,null,null,null,null,null,null,null,"x",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ77*POWER(10,AN77)","v":181900},null,{"$f":"ROUND(RAND()*(9-1)+1,3)","v":1.819},null,"x",10,{"$f":"ROUND(RAND()*(9-4)+4,0)","v":5}]
[]
[]
[null,null,null,"(b)   Write the following numbers in full."]
[null,null,null,null,null,null,null,null,null,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":"AJ81*POWER(10,AN81)","v":338000},null,{"$f":"ROUND(RAND()*(9-1)+1,2)","v":3.38},null,"x",10,{"$f":"ROUND(RAND()*(6-3)+3,0)","v":5}]
[null,null,null,"(i)",null,{"$f":"AJ81","v":3.38},null,null,"x",10,{"$f":"AN81","v":5}]
[]
[null,null,null,"(ii)",null,{"$f":"AJ84","v":3.0640000000000001},null,null,"x",10,{"$f":"AN84","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ84*POWER(10,AN84)","v":3064000},null,{"$f":"ROUND(RAND()*(9-1)+1,3)","v":3.0640000000000001},null,"x",10,{"$f":"ROUND(RAND()*(9-4)+4,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,"( 4 marks )"]
[]
["CALCULATOR ALLOWED FOR THESE QUESTIONS",null,null,null,null,null,null,null,null,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-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,{"$f":"ROUND(RAND()*(40-20)+20,0)","v":21}]
[null,"Q5",null,"The position of three ships are given 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,{"$f":"IF(AH88=1,AH97,\"x\")","v":27}]
[]
[null,null,null,{"$f":"\"The distance between Ship A and B is \"&AH97&\" km.\"","v":"The distance between Ship A and B is 27 km."}]
[]
[null,null,null,{"$f":"\"The distance between Ship A and C is \"&AH99&\" km.\"","v":"The distance between Ship A and C is 45 km."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 3 marks R 1.3a )"]
[null,null,null,null,null,"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,{"$f":"AI97*$AJ$97","v":27},3,{"$f":"ROUND(RAND()*(12-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,null,null,{"$f":"AI98*$AJ$97","v":36},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,45,5]
[null,null,null,null,null,null,null,null,null,{"$f":"AH99&\" km\"","v":"45 km"}]
[null,null,null,{"$f":"AH97&\" km\"","v":"27 km"},null,null,null,null,null,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":"SQRT(AH99*AH99-AH97*AH97)","v":36}]
[]
[]
[]
[null,null,null,null,null,"B",null,null,"x km",null,null,null,null,"C"]
[]
[null,null,null,"Calculate the distance between ships B and C."]
[]
[null,null,null,null,null,null,null,null,null,null,"Answer x =",null,null,null,null,null,"m"]
[]
[]
["Qs. 6",null,"Brendan is designing a new roof for a house.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EF 1.1f (A 2.2)"]
[]
[null,null,"Regulations state that the gradient of the slope "]
[null,null,{"$f":"\"must be \"&AH124&\" or more.\"","v":"must be 0.725 or more."}]
[]
[null,null,"Part of the design 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,{"$f":"ROUND(RAND()*(15-6)+6,0)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH122&\" m\"","v":"6.4 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(19-12)+12,0)*0.05","v":0.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,{"$f":"AH120*AH121","v":6.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,{"$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,{"$f":"IF(AH123=1,AH121+ROUND(RAND()*(4-1),1)*0.05,AH121-ROUND(RAND()*(4-1),1)*0.05)","v":0.72500000000000009}]
[null,null,null,null,null,null,null,{"$f":"AH120&\" m\"","v":"8 m"}]
[]
[]
[]
[null,null,"(a)   Calculate the gradient of the slope."]
[]
[null,null,null,null,null,null,null,null,null,null,"Answer m ="]
[]
[]
[]
[]
[]
[]
[]
[null,null,"(b)   Does this slope meet the regulations?  ",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,{"$f":"IF(AH121>AH124,\"Yes\",\"No\")","v":"Yes"}]
[null,null,null,"( Remember in the exam you must give a reason for your answer )"]
[]
[]
[]
[]
[]
[]
[]
[]
["Qs. 7",null,{"$f":"\"(a)   Complete the table below for y = \"&AH149&\"x - \"&AH150","v":"(a)   Complete the table below for y = 4x - 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,"(R1.1a)",null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,0)*0.5","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,{"$f":"ROUND(RAND()*(9-1)+1,0)","v":7}]
[null,null,null,null,null,{"$f":"AH151","v":"x"},{"$f":"AI151","v":1},2,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,"x",1,2,3]
[null,null,null,null,null,{"$f":"AH152","v":"y"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y",{"$f":"AI151*$AH$149-$AH$150","v":-3},{"$f":"AJ151*$AH$149-$AH$150","v":1},5]
[]
[]
[null,null,null,{"$f":"\"(b)   Draw the line  y = \"&AH149&\"x - \"&AH150&\" on a coordinate grid.\"","v":"(b)   Draw the line  y = 4x - 7 on a coordinate grid."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",-3,-2,-1,0,1,2,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,null,null,null,null,null,null,null,"y",{"$f":"AI155*$AH$149-$AH$150","v":-19},{"$f":"AJ155*$AH$149-$AH$150","v":-15},-11,-7,-3,1,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,null,null,{"$f":"CONCATENATE(AH156,\" = \",AH149,\"x\",\" - \",AH150)","v":"y = 4x - 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,"( 3 marks )"]
[]
["Qs. 8",null,"Write down the equation of the line AB.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x",-5,-4,-3,-2,-1,0,1,2,3,4,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,null,null,"y",{"$f":"ROUND(RAND()*(9-(-9))+(-9),0)","v":7},{"$f":"AI180","v":7},{"$f":"AJ180","v":7},7,7,7,7,7,7,7,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,{"$f":"AH180","v":"y"},"=",{"$f":"AI180","v":7}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Qs.9   On the grid shown, the end-points of a line are ( \"&AH200&\" , \"&AH201&\" ) and ( \"&AI200&\" , \"&AI201&\" ) .\"","v":"Qs.9   On the grid shown, the end-points of a line are ( 7 , 9 ) and ( 4 , 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,"R 1.2e (A2.1)",null,null,null,null,null,"x",{"$f":"ROUND(RAND()*(9-5)+5,0)","v":7},{"$f":"ROUND(RAND()*(4-0)+0,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,"y",{"$f":"ROUND(RAND()*(9-5)+5,0)","v":9},{"$f":"ROUND(RAND()*(4-0)+0,0)","v":4}]
[null,null,"Calculate the length of the line 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,null,null,null,null,null,{"$f":"AH201-AI201","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,null,null,{"$f":"AH200-AI200","v":3}]
[null,null,null,null,null,null,null,null,"Distance =",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(AH202*AH202+AH203*AH203),1)","v":5.8}]