{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Programme 2_PART A","Programme 2_PART B"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":2,"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":"Programme 2_PART A","index":0,"n_rows":117,"n_cols":37,"rows_kept":117,"cut":false,"hidden":false,"merged":[[3,26,3,29],[3,30,3,31],[1,26,1,29],[1,30,1,31],[2,1,2,25],[2,26,2,29],[2,30,2,31],[44,1,44,4],[4,1,4,25],[4,26,4,29],[4,30,4,31],[5,26,5,29],[5,30,5,31],[10,1,10,4],[12,2,15,31],[21,1,21,4],[23,2,26,31],[32,1,32,4],[34,2,37,31],[46,2,49,31],[57,5,58,5],[57,6,58,6],[60,2,63,31],[74,1,74,4],[74,5,74,7],[102,2,105,31],[109,3,109,6],[109,7,109,9],[111,2,114,31],[77,2,80,31],[84,1,84,4],[84,5,84,7],[86,2,89,31],[100,3,100,6],[100,7,100,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,"EF 1.1a"]
[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,"EF 1.1c"]
[null,null,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.2a"]
[null,"PROGRAMME 2 ASSESSMENT 1   ( PART 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,"R 1.1c"]
[null,null,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.1d"]
[null,"Q.1   Expand the brackets:",null,null,null,null,null,null,null,null,null,null,null,null,null,"( 1 mark EF 1.1a )"]
[]
[null,"(a)",null,{"$f":"ROUND(RAND()*(9-(2))+(2),0)","v":7},"(",{"$f":"ROUND(RAND()*(9-(2))+(2),0)","v":3},{"$f":"CHAR(RAND()*(122-116)+116)","v":"x"},"+",{"$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,{"$f":"D9*F9","v":21},{"$f":"G9","v":"x"},{"$f":"H9","v":"+"},{"$f":"D9*I9","v":49}]
[]
[null,"answer ="]
[]
[]
[]
[]
[]
[]
[null,"(b)","(b)","Expand the brackets and simplify:"]
[]
[null,null,null,{"$f":"ROUND(RAND()*(9-(5))+(5),0)","v":6},"(",{"$f":"ROUND(RAND()*(9-2)+(2),0)","v":8},{"$f":"CHAR(RAND()*(106-97)+97)","v":"f"},"-",{"$f":"ROUND(RAND()*(9-5)+(5),0)","v":6},")","+",{"$f":"ROUND(RAND()*(9-2)+(2),0)","v":2},{"$f":"G20","v":"f"},null,null,null,null,null,null,null,"( 2 marks EF 1.1a )",null,null,null,null,null,null,null,null,null,null,null,{"$f":"D20*F20+L20","v":50},{"$f":"G20","v":"f"},{"$f":"H20","v":"-"},{"$f":"D20*I20","v":36}]
[]
[null,"answer ="]
[]
[]
[]
[]
[]
[]
[null,"Q.2",null,"Solve the following equation: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 2 marks R 1.1c )"]
[]
[null,null,null,{"$f":"ROUND(RAND()*(9-(2))+(2),0)","v":4},{"$f":"CHAR(RAND()*(122-116)+116)","v":"v"},"+",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":6},"=",{"$f":"D31*AG31+G31","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,{"$f":"ROUND(RAND()*(9-2)+(2),0)","v":3}]
[]
[null,{"$f":"\"answer \"&E31&\" =\"","v":"answer v ="}]
[]
[]
[]
[]
[]
[]
[]
[null,"Q.3",null,"Simplify:"]
[]
[null,null,null,{"$f":"ROUND(RAND()*(9-(2))+(2),0)","v":8},{"$f":"CHAR(RAND()*(122-116)+116)","v":"v"},"+",{"$f":"ROUND(RAND()*(15-8)+(8),0)","v":14},{"$f":"CHAR(RAND()*(106-97)+97)","v":"c"},"+",{"$f":"ROUND(RAND()*(9-(2))+(2),0)","v":6},{"$f":"E43","v":"v"},"-",{"$f":"ROUND(RAND()*(6-(2))+(2),0)","v":5},{"$f":"H43","v":"c"},null,null,null,null,null,null,"( 1 mark  EF 1.1c )",null,null,null,null,null,null,null,null,null,null,null,{"$f":"D43+J43","v":14},{"$f":"E43","v":"v"},"+",{"$f":"G43-M43","v":9},{"$f":"N43","v":"c"}]
[]
[null,"answer ="]
[]
[]
[]
[]
[]
[]
[null,"Q.4",null,"A Formula is given expressed in the form"]
[null,null,null,null,null,null,null,null,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":"UPPER(CHAR(RAND()*(122-118)+118))","v":"Y"}]
[null,null,null,{"$f":"AG53","v":"Y"},"=",{"$f":"AG54","v":"A"},{"$f":"AG55","v":"M"},null,null,null,null,null,null,null,null,null,null,null,null,null,"( 2 marks R 1.1d )",null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(RAND()*(104-97)+97))","v":"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,{"$f":"UPPER(CHAR(RAND()*(110-105)+105))","v":"M"}]
[null,null,null,{"$f":"\"Change the subject of the formula to \"&AG55&\".\"","v":"Change the subject of the formula to 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,"="]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q. 5",null,{"$f":"\"In a sale a TV costs £ \"&AG69&\" + VAT @ \"&AH69&\" %\"","v":"In a sale a TV costs £ 540 + VAT @ 20 %"},null,null,null,null,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()*(60-(30))+(30),0)*10","v":540},20]
[]
[]
[]
[null,"(a) What is the cost of  the VAT ?",null,null,null,null,null,null,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":"AH69/100*AG69","v":108}]
[]
[null,"Answer £",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 2 marks R 1.1d )"]
[]
[]
[]
[]
[]
[]
[]
[null,"(b) What is the total cost of the TV ?",null,null,null,null,null,null,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":"AG69+AG73","v":648}]
[]
[null,"Answer £",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 2 marks R 1.1d )"]
[]
[]
[]
[]
[]
[]
[null,"Q. 6",null,"The diagram shows a drum in the shape of a circle.",null,null,null,null,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-(20))+(20),0)*2","v":48}]
[null,null,null,{"$f":"\"The diameter of the circle is \"&AG92&\" cm.\"","v":"The diameter of the circle is 48 cm."}]
[]
[]
[]
[]
[]
[null,"(a) Calculate the circumference of the front of the drum. "]
[]
[null,null,null,"Answer C =",null,null,null,null,null,null,"cm ( 1 d.p.)",null,null,null,null,null,null,null,null,null,"( 2 marks  EF 1.2a )",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(PI()*AG92,1)","v":150.80000000000001}]
[]
[]
[]
[]
[]
[]
[null,"(b) Calculate the area of the front of the drum. "]
[]
[null,null,null,"Answer A =",null,null,null,null,null,null,"cm2 ( 1 d.p.)",null,null,null,null,null,null,null,null,null,"( 2 marks  EF 1.2a )",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(PI()*POWER(AG92/2,2),1)","v":1809.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,"Total 16 marks"]

{"sheet":"Programme 2_PART B","index":1,"n_rows":141,"n_cols":49,"rows_kept":141,"cut":false,"hidden":false,"merged":[[75,44,75,45],[76,44,76,45],[77,44,77,45],[84,4,84,7],[84,8,84,13],[81,14,81,20],[82,14,82,20],[83,14,83,20],[84,14,84,20],[81,4,81,7],[81,8,81,13],[82,4,82,7],[82,8,82,13],[83,4,83,7],[83,8,83,13],[75,40,75,41],[74,40,74,41],[74,42,74,43],[77,21,77,22],[74,4,74,7],[75,4,75,7],[76,4,76,7],[77,4,77,7],[74,8,74,13],[75,8,75,13],[76,8,76,13],[77,8,77,13],[74,21,74,22],[75,19,75,20],[75,21,75,22],[76,19,76,20],[76,21,76,22],[75,42,75,43],[76,40,76,41],[76,42,76,43],[77,40,77,41],[77,42,77,43],[74,19,74,20],[77,19,77,20],[131,1,131,4],[108,5,108,7],[109,5,109,7],[110,5,110,7],[111,5,111,7],[112,5,112,7],[113,5,113,7],[114,5,114,7],[108,8,108,10],[2,1,2,25],[4,1,4,25],[19,3,19,5],[20,3,20,5],[21,3,21,5],[36,2,39,31],[43,22,43,24],[43,25,43,27],[64,2,67,31],[62,4,62,31],[18,3,18,5],[15,6,15,8],[16,6,16,8],[18,6,18,8],[19,6,19,8],[9,37,9,38],[10,37,10,38],[11,37,11,38],[12,37,12,38],[13,37,13,38],[1,26,1,29],[2,26,2,29],[3,26,3,29],[4,26,4,29],[1,30,1,31],[2,30,2,31],[3,30,3,31],[4,30,4,31],[20,6,20,8],[21,6,21,8],[46,2,49,31],[22,6,22,8],[22,3,22,5],[33,22,33,24],[33,25,33,27],[14,37,14,38],[15,3,15,5],[16,3,16,5],[17,3,17,5],[17,6,17,8],[136,27,136,28],[142,27,142,28],[114,8,114,10],[108,11,108,13],[109,11,109,13],[110,11,110,13],[111,11,111,13],[112,11,112,13],[113,11,113,13],[114,11,114,13],[109,8,109,10],[110,8,110,10],[111,8,111,10],[112,8,112,10],[113,8,113,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,"EF 1.3a"]
[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,"EF 1.3b (A 2.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,"EF 1.3 c"]
[null,"PROGRAMME 2 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.4a (A 2.3)"]
[]
[null,"Q.7   The number of visitors to a local library was recorded each day for two  weeks.",null,null,null,null,null,null,null,null,null,null,null,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()*(89-30)+30,0)","v":89},{"$f":"ROUND(RAND()*(89-30)+30,0)","v":34},83,78,88,80,{"$f":"ROUND(RAND()*(89-30)+30,0)","v":58}]
[null,null,"   The results 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,{"$f":"ROUND(RAND()*(89-30)+30,0)","v":53},60,51,51,58,48,{"$f":"ROUND(RAND()*(89-30)+30,0)","v":62}]
[]
[null,null,null,{"$f":"AL7","v":89},{"$f":"AM7","v":34},83,78,88,80,58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30 - 39",null,null,{"$f":"COUNTIF($AL$7:$AR$8,\"<40\")","v":1}]
[null,null,null,{"$f":"AL8","v":53},{"$f":"AM8","v":60},{"$f":"AN8","v":51},{"$f":"AO8","v":51},{"$f":"AP8","v":58},{"$f":"AQ8","v":48},{"$f":"AR8","v":62},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40 - 49",null,null,{"$f":"COUNTIF($AL$7:$AR$8,\"<50\")-COUNTIF($AL$7:$AR$8,\"<40\")","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,"50 - 59",null,null,{"$f":"COUNTIF($AL$7:$AR$8,\"<60\")-COUNTIF($AL$7:$AR$8,\"<50\")","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,null,null,null,null,"60 - 69",null,null,{"$f":"COUNTIF($AL$7:$AR$8,\"<70\")-COUNTIF($AL$7:$AR$8,\"<60\")","v":2}]
[null,null,null,"Complete the frequency table for these results.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70 - 79",null,null,{"$f":"COUNTIF($AL$7:$AR$8,\"<80\")-COUNTIF($AL$7:$AR$8,\"<70\")","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,"80 - 89",null,null,{"$f":"COUNTIF($AL$7:$AR$8,\"<90\")-COUNTIF($AL$7:$AR$8,\"<80\")","v":4}]
[null,null,null,"Score",null,null,"Frequency",null,null,null,null,null,null,null,null,null,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(AO10:AO15)","v":14}]
[null,null,null,"30 - 39"]
[]
[]
[]
[]
[]
[null,null,null,"Total = ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 2 marks EF 1.3a )"]
[]
[]
[null,"Q.8   Eight people were timed running 5 kilometres. ",null,null,null,null,null,null,null,null,null,null,null,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-13)+13,0)","v":26},{"$f":"ROUND(RAND()*(30-13)+13,0)","v":25},15,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,{"$f":"ROUND(RAND()*(30-13)+13,0)","v":15},29,22,28]
[null,null,"   The time, in minutes, each person took was recorded and the results are shown below."]
[]
[null,null,null,{"$f":"AL26","v":26},{"$f":"AM26","v":25},15,23]
[null,null,null,{"$f":"AL27","v":15},{"$f":"AM27","v":29},{"$f":"AN27","v":22},{"$f":"AO27","v":28},null,null,null,null,null,null,null,null,null,null,null,null,null,"( 2 marks EF 1.3b (A 2.2) )"]
[]
[]
[null,null,null,"(a)   Calculate the mean time taken to 1 decimal place.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AVERAGE(AL26:AO27),1)","v":22.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,null,{"$f":"AO34-(ROUND(RAND()*(5-1)+1,1))","v":21.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"(b)   Calculate the range.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AL26:AO27)-MIN(AL26:AO27)","v":14}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AO44-(ROUND(RAND()*(5-1)+1,0))","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 1 mark EF 1.3b (A 2.2) )"]
[]
[]
[]
[]
[]
[]
[null,null,null,"(c)   Each person then followed a training programme for 6 weeks."]
[null,null,null,null," At the end of the training programme they were timed running 5 kilometres again."]
[]
[null,null,null,null,"After training: "]
[]
[null,null,null,null,{"$f":"\"the mean was \"&AO35&\" minutes, and \"","v":"the mean was 21.5 minutes, and "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 2 marks EF 1.3b (A 2.2) )"]
[null,null,null,null,{"$f":"\"the range was \"&AO45&\".\"","v":"the range was 12."}]
[]
[null,null,null,null,"Write two comments comparing the results before training with the results after training."]
[]
[null,null,null,null,"( You need to LEARN and UNDERSTAND both statements for exam )"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q.9   \"&AO79&\" pupils were asked how they travelled to school.\"","v":"Q.9   72 pupils were asked how they travelled to school."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 3 marks  EF 1.3 c)"]
[null,null,"   The table below shows the results.  "]
[]
[null,null,null,null,"Travel Method",null,null,null,"Number of pupils",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel Method",null,"Number of pupils"]
[null,null,null,null,{"$f":"AO76","v":"Cycle"},null,null,null,{"$f":"AQ76","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,"Cycle",null,{"$f":"AS76/5","v":21},null,{"$f":"5*ROUND(RAND()*(24-10)+10,0)","v":105}]
[null,null,null,null,{"$f":"AO77","v":"Walk"},null,null,null,{"$f":"AQ77","v":13},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Walk",null,{"$f":"AS77/5","v":13},null,{"$f":"5*ROUND(RAND()*(24-6)+6,0)","v":65}]
[null,null,null,null,"Car",null,null,null,{"$f":"AQ78","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,"Car",null,38,null,{"$f":"360-AS76-AS77","v":190}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AQ76:AR78)","v":72}]
[null,null,"   To help you to construct a pie chart for this information, fill in the blanks in the 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,null,null,{"$f":"AO76","v":"Cycle"},{"$f":"AO77","v":"Walk"},{"$f":"AO78","v":"Car"}]
[null,null,null,null,"Travel Method",null,null,null,"Number of pupils",null,null,null,null,null,"Angle at the Centre",null,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":"AQ76","v":21},{"$f":"AQ77","v":13},{"$f":"AQ78","v":38}]
[null,null,null,null,{"$f":"AO76","v":"Cycle"},null,null,null,{"$f":"AQ76","v":21}]
[null,null,null,null,{"$f":"AO77","v":"Walk"},null,null,null,{"$f":"AQ77","v":13}]
[null,null,null,null,"Car",null,null,null,38]
[]
[null,null,"   Now construct an accurate pie chart for this information."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q.10  A class of students sat two tests in the same subject.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( 5 marks R 1.4a (A 2.3) )"]
[null,null,"   Here are the marks for six of the students who sat the tests:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Student","Test A","Test B",null,null,null,{"$f":"ROUND(RAND()*(1-0.4)+0.4,1)","v":0.5},{"$f":"ROUND(RAND()*(9-4)+4,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,null,null,null,null,null,null,null,null,null,null,"Allan",{"$f":"AV108","v":28},{"$f":"AW108","v":19},null,null,null,{"$f":"ROUND(RAND()*(45-10)+10,0)*2","v":28},{"$f":"ROUND(AV108*$AV$107+$AW$107,0)","v":19}]
[null,null,null,null,null,{"$f":"AP107","v":"Student"},null,null,{"$f":"AQ107","v":"Test A"},null,null,{"$f":"AR107","v":"Test B"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Margaret",{"$f":"AV109","v":74},{"$f":"AW109","v":42},null,null,null,{"$f":"ROUND(RAND()*(45-10)+10,0)*2","v":74},{"$f":"ROUND(AV109*$AV$107+$AW$107,0)","v":42}]
[null,null,null,null,null,{"$f":"AP108","v":"Allan"},null,null,{"$f":"AQ108","v":28},null,null,{"$f":"AR108","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,null,"Kirandeep",46,28,null,null,null,46,28]
[null,null,null,null,null,"Margaret",null,null,{"$f":"AQ109","v":74},null,null,{"$f":"AR109","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,null,"Ahmed",62,36,null,null,null,62,36]
[null,null,null,null,null,"Kirandeep",null,null,46,null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Simon",46,28,null,null,null,46,28]
[null,null,null,null,null,"Ahmed",null,null,62,null,null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Susan",50,30,null,null,null,50,30]
[null,null,null,null,null,"Simon",null,null,46,null,null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,42]
[null,null,null,null,null,"Susan",null,null,50,null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-0)+0,0)","v":1},{"$f":"IF(AU116=0,AV115+3,IF(AU116=1,AV115-3,AV115))","v":21}]
[null,null,"(a)   Draw a scattergraph of these marks and fit line for the data.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AU116=2,\"Yes\",\"No\")","v":"No"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"(b)   Karen scored \"&AV114&\" marks for Test A.\"","v":"(b)   Karen scored 74 marks for Test A."}]
[null,null,null,"  Use your line to estimate the number of marks she scored in Test B.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"marks"]
[]
[]
[null,null,{"$f":"\"(c)   Brian scored  \"&AW115&\" for Test B but was absent for test A.\"","v":"(c)   Brian scored  17 for Test B but was absent for test A."}]
[null,null,null,{"$f":"\"  His teacher estimated his mark to be \"&AV116&\" for Test A. Is this a reasonable estimate ?\"","v":"  His teacher estimated his mark to be 21 for Test A. Is this a reasonable estimate ?"}]