{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Test","Sheet1","Feedback","Comments"],"not_rendered":{"charts":0,"images":30,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Test","index":0,"n_rows":332,"n_cols":22,"rows_kept":332,"cut":false,"hidden":false,"merged":[[95,6,95,7],[5,6,5,10],[8,7,8,10],[9,7,9,10],[91,6,91,7],[93,6,93,7],[323,8,323,12],[97,6,97,7],[245,8,245,9],[319,9,319,13],[321,8,321,12]]}
[]
[]
[]
[]
[]
[null,null,"Thirsk School",null,null,null,"Baseline Test",null,null,null,null,null,null,null,null,null,"Q1"]
[]
[]
[null,null,null,null,"Please enter your….",null,"First Name",null,null,null,null,null,null,null,null,null,{"$f":"IF(F14=\"Monitor\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,"Second Name",null,null,null,null,null,null,null,null,null,{"$f":"IF(J14=\"Mouse\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,"Q1.  Label the 10 pieces of equipment pictured below…..",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C23=\"Keyboard\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,"      ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F23=\"Printer\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Mouse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J23=\"Scanner\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Monitor"]
[null,null,null,null,1,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF(C35=\"Speakers\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Scanner"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G35=\"Microphone\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Printer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J35=\"Compact Discs\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Keyboard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E45=\"Web Camera\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Disc Drive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H45=\"Disc Drive\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Speakers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Microphone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compact Discs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Web Camera"]
[]
[null,3,null,null,4,null,null,null,5,null,null,null,null,null,null,null,"Q1 Total"]
[null,null,null,null,null,null,null,null,"     ",null,null,null,null,null,null,null,{"$f":"COUNTIF(Q9:Q18,\"Correct\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,6,null,null,null,7,null,null,8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,9,null,null,10]
[]
[]
[]
[]
[]
[]
[]
[null,"Q2.  In ‘Word’ select what you understand by the following 10 icons….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D56=\"Bold\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G56=\"Underline\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Left Align"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J56=\"Justify\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Centre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D61=\"Italics\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Save"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G61=\"Centre\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Underline"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J61=\"New Document\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Italics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M61=\"Save\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Right Align"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D66=\"Font Colour\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Spell Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G66=\"Spell Check\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Justify"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J66=\"Print Preview\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Backgroud"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q2 Total",null,"Print Preview"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q54:Q64,\"Correct\")","v":0},null,"Font Colour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Document"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bold"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change Font"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q9"]
[null,"Q3.    Select the words that fit the best, to complete the sentences below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H75=\"program\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L75=\"text\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,"A   Word  Processor  is  a  special  type   of   computer ",null,null,null,null,"    that allows you to  work  with ",null,null,null,".",null,null,null,{"$f":"IF(H77=\"keyboard\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"mistakes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N77=\"Word\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"font"]
[null,null,null,"You  can  type  words  into   the   computer   using   the ",null,null,null,null,".     A word processor that is used in school is Microsoft",null,null,null,null,null,".",null,{"$f":"IF(H79=\"mistakes\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"open"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L79=\"saved\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"printed"]
[null,null,null,"Unlike   using  a  typewriter,  it  is   easier   to   corrrect",null,null,null,null,".     After finishing work, it can be",null,null,null,"  as a file and",null,null,null,{"$f":"IF(D81=\"printed\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"edit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I81=\"open\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"landscape"]
[null,null,null,null,"  out.         To   make   changes  to  a  file,   you  can ",null,null,null,null,"   it   and",null,"  the file.",null,null,null,null,{"$f":"IF(K81=\"edit\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"text"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I83=\"font\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"program"]
[null,null,null,"It   is  possible  to  change  the  size  of  the  text  by  changing  the ",null,null,null,null,null,"  size.  The page can be changed so that the paper is ",null,null,null,null,null,null,{"$f":"IF(H85=\"landscape\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Word"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E87=\"portrait\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"keyboard"]
[null,null,null,"sideways  and  is  printed  across,  this  layout  is  called",null,null,null,null,".     The paper is  normally  printed down the  page,  this layout  ",null,null,null,null,null,null,null,{"$f":"IF(K87=\"folder\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"portrait"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q73:Q85,\"Correct\")","v":0},null,"saved"]
[null,null,null,"is  called",null,".    When  saving  your  work,  it  must  be  saved  in  the  correct ",null,null,null,null,null,".",null,null,null,null,null,null,"folder"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q3"]
[null,"Q4.    Give one example that you could use the following programs for….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G92=\"Typing a Letter\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Costing of a Disco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G94=\"A presentation \",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Typing a Letter"]
[null,null,null,"Word  - ",null,"→",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G96=\"4 Page leaflet\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"4 Page leaflet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G98=\"Costing of a Disco\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"A presentation "]
[null,null,null,"Powerpoint - ",null,"→",null,null,null,null,null,null,null,null,null,null,"Q3 Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q90:Q93,\"Correct\")","v":0}]
[null,null,null,"Publisher - ",null,"→"]
[]
[null,null,null,"Excel - ",null,"→",null,null,null,null,null," ",null,null,null,null,null,null,"=E1/E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=B1+B2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=B1-B2"]
[null,"Q5.    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=C1/C2"]
[null,null,"What formulas will be used to ADD the numbers in Row 1 and the numbers in Row 2?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=A1/A2"]
[null,null,"Column A has been done for you. (Put your answers in the boxes on the right)",null,null,null,null,null,null,null,null,null,null,"Answers",null,null,"Q4",null,"=C1-C2"]
[null,null,null,null,null,null,null,null,null,null,null,"→","Column B",null,null,null,{"$f":"IF(N104=\"=B1+B2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"=D1*D2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column C",null,null,null,{"$f":"IF(N105=\"=C1+C2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"=A1*A2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column D",null,null,null,{"$f":"IF(N106=\"=D1+D2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"=B1*B2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column E",null,null,null,{"$f":"IF(N107=\"=E1+E2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"=D1+D2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q104:Q107,\"Correct\")","v":0},null,"=E1*E2"]
[null,null,"What formulas will be used to SUBTRACT the numbers in Row 2 from the numbers in Row 1?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=B1/B2"]
[null,null,null,null,null,null,null,null,null,null,null,"→","Column A",null,null,null,{"$f":"IF(N110=\"=A1-A2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"=E1-E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column B",null,null,null,{"$f":"IF(N111=\"=B1-B2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"=A1-A2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column C",null,null,null,{"$f":"IF(N112=\"=C1-C2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"=C1+C2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column D",null,null,null,{"$f":"IF(N113=\"=D1-D2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"=C1*C2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column E",null,null,null,{"$f":"IF(N114=\"=E1-E2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"=E1+E2"]
[null,null,"What formulas will be used to MULTIPLY the numbers in Row 1 and the numbers in Row 2?",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q110:Q114,\"Correct\")","v":0},null,"=D1-D2"]
[null,null,null,null,null,null,null,null,null,null,null,"→","Column A",null,null,null,{"$f":"IF(N116=\"=A1*A2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"=D1/D2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column B",null,null,null,{"$f":"IF(N117=\"=B1*B2\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column C",null,null,null,{"$f":"IF(N118=\"=C1*C2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"+","-","*","/"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column D",null,null,null,{"$f":"IF(N119=\"=D1*D2\",\"Correct\",\"Wrong\")","v":"Wrong"},null,{"$f":"Test!Q108","v":0},{"$f":"Test!Q115","v":0},{"$f":"Test!Q121","v":0},{"$f":"Test!Q127","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column E",null,null,null,{"$f":"IF(N120=\"=E1*E2\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,"What formulas will be used to DIVIDE the numbers in Row 1 by the numbers in Row 2?",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q116:Q120,\"Correct\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"→","Column A",null,null,null,{"$f":"IF(N122=\"=A1/A2\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column B",null,null,null,{"$f":"IF(N123=\"=B1/B2\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column C",null,null,null,{"$f":"IF(N124=\"=C1/C2\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column D",null,null,null,{"$f":"IF(N125=\"=D1/D2\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Column E",null,null,null,{"$f":"IF(N126=\"=E1/E2\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q122:Q126,\"Correct\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Q6.    Which image would you use for a road sign to the beach?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q108+Q115+Q121+Q127","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q567",null,"A"]
[null,"    A",null,null,null,null,"B",null,null,null,"Answer",null,null,null,null,null,{"$f":"IF(L131=\"B\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L140=\"B\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L152=\"B\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[]
[null,"Q7.    Which image would you use for an article about foot and mouth disease?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q567 Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q131:Q133,\"Correct\")","v":0}]
[]
[]
[null,"      A",null,null,null,null,"B",null,null,null,"Answer"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q8.    Which image would you use in a glossy magazine for a bakery?"]
[]
[null,null,"A ",null,null,null,"B"]
[null,null,null,null,null,null,null,null,null,null,"Answer"]
[]
[]
[]
[]
[null,"Q9.    When using presentation software such as Powerpoint, which of the following good practice?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q8"]
[null,null,null,"\"Yes\" = It is a good idea",null,null,"\"No\" = It is not a good idea",null,null,null,null,null,null,null,null,null,{"$f":"IF(G161=\"Yes\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G163=\"No\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G165=\"No\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,"Using the same background ",null,null,null,null,null,null,"Using animation on every object",null,null,null,null,null,null,{"$f":"IF(M161=\"No\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M163=\"Yes\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"No"]
[null,null,"Using five different fonts on one page ",null,null,null,null,null,null,"Using a consistent layout ",null,null,null,null,null,null,{"$f":"IF(M165=\"Yes\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q158:Q163,\"Correct\")","v":0}]
[null,null,"Using as many different colours as possible ",null,null,null,null,null,null,"Using sound "]
[]
[]
[null,"Q10.   Follow the LOGO instructions and select underneath each question the shape you think will be drawn.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G180=\"Square\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,"  ",null,"KEY",null,null,1,null,2,null,3,null,null,null,null,null,{"$f":"IF(I180=\"Triangle\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,"   FD = FORWARD (cm)",null,"FD 100",null,null,"FD 90",null,"FD 90",null,null,null,null,null,{"$f":"IF(K180=\"Rectangle\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[null,null,null,"   BK = BACKWARDS (cm)",null,"RT 90",null,null,"RT 120",null,"RT 90",null,null,null,null,null,{"$f":"IF(G205=\"Continuous\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Triangle"]
[null,null,null,"   RT = RIGHT TURN (Degrees)",null,"FD 100",null,null,"FD 90",null,"FD 20",null,null,null,null,null,{"$f":"IF(K209=3,\"Correct\",\"Wrong\")","v":"Wrong"},null,"Hexagon"]
[null,null,null,"   LT = LEFT TURN (Degrees)",null,"RT 90",null,null,"RT 120",null,"RT 90",null,null,null,null,null,{"$f":"COUNTIF(Q169:Q173,\"Correct\")","v":0},null,"Rectangle"]
[null,null,null,null,null,"FD 100",null,null,"FD 90",null,"FD 90",null,null,null,null,null,null,null,"Circle"]
[null,null,null,null,null,"RT 90",null,null,"RT 120",null,"RT 90",null,null,null,null,null,null,null,"Square"]
[null,null,null,null,null,"FD 100",null,null,null,null,"FD 20",null,null,null,null,null,null,null,"Steps"]
[null,null,null,null,null,"RT 90",null,null,null,null,"RT 90"]
[]
[]
[]
[]
[null,"Q11.   Follow the FLOWCHARTS and answer the questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Continuous"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"\"Output 1\" is a Light"]
[null,null,null,"In Flowchart 1"]
[null,null,null,"          How many times will the light flash?"]
[]
[]
[null,null,null,null,null,null,null,"In Flowchart 2"]
[null,null,null,null,null,null,null,"     How many times will the light flash?"]
[]
[]
[]
[]
[]
[]
[null,"Q12.   Look at the table below.  It is from a school database.  Answer the questions below."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alexander Cooke","Year Tutor"]
[null,null,null,"Firstname","Surname","Age","Year Group","Year Tutor","Gender",null,null,null,null,null,null,null,null,null,"Mary Corcoran","Gender"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hannah Croft","Year Group"]
[null,null,null,"Alexander","Cooke",15,10,"Miss Williams","Male",null,null,null,null,null,null,null,null,null,"Louise Ellaway","Age"]
[null,null,null,"Mary","Corcoran",12,7,"Mr Jones","Female",null,null,null,null,null,null,null,null,null,"Thomas Greaves","Firstname"]
[null,null,null,"Hannah","Croft",12,7,"Mr Jones","Female",null,null,null,null,null,null,null,null,null,"Louise Heaton","Surname"]
[null,null,null,"Louise","Ellaway",12,7,"Mr Jones","Female",null,null,null,null,null,null,null,null,null,"Joseph Homes"]
[null,null,null,"Thomas","Greaves",14,9,"Mr Burns","Male",null,null,null,null,null,null,null,null,null,"Gerard Johnson"]
[null,null,null,"Louise","Heaton",14,9,"Mr Burns","Female",null,null,null,null,null,null,null,null,null,"Lucy Kay"]
[null,null,null,"Joseph","Homes",16,11,"Mr Smith","Male",null,null,null,null,null,null,null,null,null,"Marie Pickup"]
[null,null,null,"Gerard","Johnson",15,10,"Miss Williams","Male",null,null,null,null,null,null,null,null,null,"Elizabeth Roberts"]
[null,null,null,"Lucy","Kay",11,7,"Mr Jones","Female",null,null,null,null,null,null,null,null,null,"Thomas Ryan"]
[null,null,null,"Marie","Pickup",13,8,"Mrs Holt","Female",null,null,null,null,null,null,null,null,null,"Michelle Simpson"]
[null,null,null,"Elizabeth","Roberts",15,10,"Miss Williams","Female",null,null,null,null,null,null,null,null,null,"Sean Sutton"]
[null,null,null,"Thomas","Ryan",12,8,"Mrs Holt","Male",null,null,null,null,null,null,null,null,null,"Louise Taylor"]
[null,null,null,"Michelle","Simpson",15,11,"Mr Smith","Female",null,null,null,null,null,null,null,null,null,"Jack Walsh"]
[null,null,null,"Sean","Sutton",13,8,"Mrs Holt","Male",null,null,null,null,null,null,null,null,null,"Emma Williams"]
[null,null,null,"Louise","Taylor",12,8,"Mrs Holt","Female",null,null,null,null,null,null,null,null,null,150]
[null,null,null,"Jack","Walsh",14,9,"Mr Burns","Male",null,null,null,null,null,null,null,null,null,6]
[null,null,null,"Emma","Williams",13,9,"Mr Burns","Female",null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q11"]
[null,null,null,null,"a. What is the name of the oldest pupil in this database?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J240=\"Joseph Homes\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Alphabetically - Surname"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alphabetically - Firstname"]
[null,null,null,null,"b. How many records are visible in this database? ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I242=17,\"Correct\",\"Wrong\")","v":"Wrong"},null,"Alphabetically - Year Tutor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numerically - Age"]
[null,null,null,null,"c. How many fields are there in this database? ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I244=6,\"Correct\",\"Wrong\")","v":"Wrong"},null,"Numerically - Year Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,"d. How has the database been sorted?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I246=\"Alphabetically - Surname\",\"Correct\",\"Wrong\")","v":"Wrong"},null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,"e. How many boys are in Year 9?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H248=2,\"Correct\",\"Wrong\")","v":"Wrong"},null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miss Williams"]
[null,null,null,null,"f. Who is the Year Tutor of the male aged 12 with the firstname of Thomas?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K250=\"Mrs Holt\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Mr Jones"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr Burns"]
[null,null,null,null,"g. Which field would you sort to put all the boys before the girls?",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J252=\"Gender\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"Mr Smith"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mrs Holt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q240:Q252,\"Correct\")","v":0}]
[]
[null,"Q13. Look at the spreadsheet below and then answer the questions which follow"]
[]
[null,null,null,null,null,"A","B","C","D"]
[null,null,null,null,1,"Name","Mark for Test 1","Mark for Test 2","Total Mark"]
[null,null,null,null,2]
[null,null,null,null,3,"John",38,31,69]
[null,null,null,null,4,"Helen",12,28,40]
[null,null,null,null,5,"Catherine",27,28,55]
[null,null,null,null,6,"Daniel",29,16,45,null,null,null,null,null,null,null,null,null,"B10"]
[null,null,null,null,7,"George",31,25,56,null,null,null,null,null,null,null,null,null,"B11"]
[null,null,null,null,8,"Susan",19,24,43,null,null,null,null,null,null,null,null,null,"D4"]
[null,null,null,null,9,null,null,null,null,null,null,null,null,null,null,null,null,null,"B"]
[null,null,null,null,10,"Class Total",null,null,null,null,null,null,null,null,null,null,null,null,"C10"]
[null,null,null,null,11,"Class Average",null,null,null,null,null,null,null,null,null,null,null,null,"A4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q12",null,"C "]
[null,"1.  Write the reference for the cell that has ‘Name’ written in it.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H271=\"A1\",\"Correct\",\"Wrong\")","v":"Wrong"},null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D10"]
[null,"2.  Which column contains the total marks for the test?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H273=\"D\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B4"]
[null,"3.  Which row contains 'Class Total' formulas?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G275=10,\"Correct\",\"Wrong\")","v":"Wrong"},null,"A1"]
[]
[null,"4.  Helen’s mark for test 1 has been marked again.  It should be 15.  Which cell needs to be changed?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L277=\"b4\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[null,"5.  Which other cell in the row will change once Helen’s mark for test 1 has changed?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J279=\"d4\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"internet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"find"]
[null,null,"The Teacher of this class wants to add up some of the totals and averages for the class.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fields"]
[null,null,"Write next to the following formulae the name of the cell reference where she should place the formula.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"database"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updating"]
[null,null,null,null,"6.   =Sum(B3:B8)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G286=\"b10\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"sorted"]
[null,null,null,null,"7.   =Sum(C3:C8)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G287=\"c10\",\"Correct\",\"Wrong\")","v":"Wrong"},null,"data"]
[null,null,null,null,"8.   =Sum(D3:D8)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G288=\"d10\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q271:Q288,\"Correct\")","v":0}]
[null,"Q14.    Select the words that fit the best, to complete the sentences below."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q13"]
[null,null,null,null,"Computerised   records   are   kept   in   a ",null,null,null,"     program.",null,null,null,null,null,null,null,{"$f":"IF(H293=\"database\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[null,null,null,null,"Records    can    be",null,null,"     into   order   very   quickly.",null,null,null,null,null,null,null,null,{"$f":"IF(G295=\"sorted\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[null,null,null,null,"Every   record   contains   a   number   of",null,null,null,".",null,null,null,null,null,null,null,{"$f":"IF(H297=\"fields\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[null,null,null,null,"Each    field    contains",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G299=\"data\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[null,null,null,null,"You can",null,"     a  record  very  quickly  in  a  database.",null,null,null,null,null,null,null,null,null,{"$f":"IF(F301=\"find\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[null,null,null,null,null,"     is   very   quick,   simple   and   neat.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E303=\"Updating\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[null,null,null,null,"The",null,"     is   also   known   as   the   world   wide   web.",null,null,null,null,null,null,null,null,null,{"$f":"IF(F305=\"internet\",\"Correct\",\"Wrong\")","v":"Wrong"}]
[]
[]
[null,"Q15.    BMP, GIF and JPG images are made up of tiny dots called:"]
[]
[null,"Q16.    Select Bitmap or Vector to show what type of image each is:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q17.    Choose the main function of RAM (Randon Access Memory) from the list:"]
[]
[null,"Q18.    Choose the main function of the computers Processor from the list:"]
[]
[null,"Q19.    Choose the main function of the computers Motherboard from the list:"]
[]
[null,"Q20.    Choose the strogest computer password from the list:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q293:Q305,\"Correct\")","v":0}]
[null,null,"End of Test",null,"End of Test",null,"End of Test",null,"End of Test",null,"End of Test",null,"End of Test",null,null,null,"TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q24+Q65+Q95+Q108+Q115+Q121+Q127+Q137+Q164+Q86+Q174+Q254+Q290+Q330","v":0}]

{"sheet":"Sheet1","index":1,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,2,14,9],[16,2,20,9],[22,2,35,9],[1,5,1,6],[2,5,4,6],[2,8,4,9],[1,8,1,9],[2,1,3,3]]}
[]
[null,null,null,null,null,"Score",null,null,"Level"]
["Name"]
[]
[]
[]
[null,"www:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"www comments"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ebi:"]
[]
[]
[]
[]
[]
[null,"map:"]

{"sheet":"Feedback","index":2,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[[14,2,14,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[15,2,15,6],[16,2,16,6],[17,2,17,6],[18,2,18,6],[19,2,19,6]]}
[]
[]
[]
[]
[]
[null,null,"Name",{"$f":"B9&Test!H9&B9&Test!H10","v":"  "}]
[]
[null,null,{"$f":"C21","v":0},null,null,null,null,"Your Score","Out   of","Percent"]
[null," ",null,null,null,null,null,"↓","↓","↓"]
["Computer Hardware","─",{"$f":"IF(H10=5,Comments!A1,IF(H10>1,Comments!A2,IF(H10<2,Comments!A3)))","v":"You were not able to identify the parts of a Computer Workstation."},null,null,null,null,{"$f":"Test!Q24","v":0},"(10)",{"$f":"H10/10","v":0}]
["Word Processing","─",{"$f":"IF(H11>8,Comments!A4,IF(H11>3,Comments!A5,IF(H11<4,Comments!A6)))","v":"You were not able to recognise the icons used in Word Processing."},null,null,null,null,{"$f":"Test!Q65","v":0},"(10)",{"$f":"H11/10","v":0}]
["Computer Programs","─",{"$f":"IF(H12=5,Comments!A7,IF(H12>1,Comments!A8,IF(H12<2,Comments!A9)))","v":"You are not aware of what tasks different computer programs should be used for."},null,null,null,null,{"$f":"Test!Q95","v":0},"(4)",{"$f":"H12/4","v":0}]
["Spreadsheet Formulas","─",{"$f":"IF(Test!S119=5,Comments!A10,IF(Test!S119>1,Comments!C10,IF(Test!S119<2,Comments!D10)))&IF(Test!T119=5,Comments!A11,IF(Test!T119>1,Comments!C11,IF(Test!T119<2,Comments!D11)))&IF(Test!U119=5,Comments!A12,IF(Test!U119>1,Comments!C12,IF(Test!U119<2,Comments!D12)))&IF(Test!V119=5,Comments!A13,IF(Test!V119>1,Comments!C13,IF(Test!V119<2,Comments!D13)))","v":"You were not able to create formulas using add (+).  You were not able to create formulas using subtract (-).  You were not able to create formulas using multiply (*).  You were not able to create formulas using divide (/)."},null,null,null,null,{"$f":"Test!Q129","v":0},"(19)",{"$f":"H13/19","v":0}]
["Spreadsheet Model","─",{"$f":"IF(H14>6,Comments!A14,IF(H14>2,Comments!A15,IF(H14<3,Comments!A16)))","v":"You have not yet identified cells on a spreadsheet, and formulas in a model."},null,null,null,null,{"$f":"Test!Q290","v":0},"(8)",{"$f":"H14/8","v":0}]
["Presentation Images","─",{"$f":"IF(H15=3,Comments!A17,IF(H15=2,Comments!A18,IF(H15<2,Comments!A19)))","v":"You have not chose appropriate images for a purpose."},null,null,null,null,{"$f":"Test!Q137","v":0},"(3)",{"$f":"H15/3","v":0}]
["Presentation Good Practice","─",{"$f":"IF(H16>4,Comments!A20,IF(H16>2,Comments!A21,IF(H16<3,Comments!A22)))","v":"You do not yet have an understanding of good practice when presenting work."},null,null,null,null,{"$f":"Test!Q164","v":0},"(6)",{"$f":"H16/6","v":0}]
["Word Processing Terms","─",{"$f":"IF(H17>11,Comments!A23,IF(H17>3,Comments!A24,IF(H17<4,Comments!A25)))","v":"You are not familiar with the computer terms."},null,null,null,null,{"$f":"Test!Q86","v":0},"(13)",{"$f":"H17/13","v":0}]
["Control","─",{"$f":"IF(H18>4,Comments!A26,IF(H18>1,Comments!A27,IF(H18<2,Comments!A28)))","v":"You are not yet able to follow sequenced instructions."},null,null,null,null,{"$f":"Test!Q174","v":0},"(5)",{"$f":"H18/5","v":0}]
["Reading a Database","─",{"$f":"IF(H19>5,Comments!A29,IF(H19>2,Comments!A30,IF(H19<3,Comments!A31)))","v":"You have not been able to read the database and extract the relevent information from it."},null,null,null,null,{"$f":"Test!Q254","v":0},"(7)",{"$f":"H19/7","v":0}]
["Database Terms","─",{"$f":"IF(H20>5,Comments!A32,IF(H20>2,Comments!A33,IF(H20<3,Comments!A34)))","v":"You do not yet know the Database terms."},null,null,null,null,{"$f":"Test!Q330","v":0},"(7)",{"$f":"H20/7","v":0}]
["Licensed to",null,{"$f":"Test!$D$6","v":0},null,null,null,null,"Total",null,{"$f":"SUM(J10:J20)/11","v":0}]

{"sheet":"Comments","index":3,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["You were able to identify all the parts of a Computer Workstation.",1]
["You were able to identify some of the parts of a Computer Workstation."]
["You were not able to identify the parts of a Computer Workstation."]
["You recognised the icons used in Word Processing.",2]
["You recognised some of the icons used in Word Processing."]
["You were not able to recognise the icons used in Word Processing."]
["You are aware of what tasks different computer programs should be used for.",3]
["You are aware of what some tasks different computer programs should be used for."]
["You are not aware of what tasks different computer programs should be used for."]
["You are able to create formulas using add (+).",4,"You were sometimes able to create formulas using add (+).","You were not able to create formulas using add (+)."]
["  You are able to create formulas using subtract (-).",null,"  You were sometimes able to create formulas using subtract (-).","  You were not able to create formulas using subtract (-)."]
["  You are able to create formulas using multiply (*).",null,"  You were sometimes able to create formulas using multiply (*).","  You were not able to create formulas using multiply (*)."]
["  You are able to create formulas using divide (/).",null,"  You were sometimes able to create formulas using divide (/).","  You were not able to create formulas using divide (/)."]
["You have identified cells on a spreadsheet, and formulas in a model.",12]
["You have identified some cells on a spreadsheet, and formulas in a model."]
["You have not yet identified cells on a spreadsheet, and formulas in a model."]
["You can choose appropriate images for a purpose.",567]
["You can usually choose appropriate images for a purpose."]
["You have not chose appropriate images for a purpose."]
["You have an understanding of good practice when presenting work.",8]
["You have some understanding of good practice when presenting work."]
["You do not yet have an understanding of good practice when presenting work."]
["You understanding a range of computer terms.",9,"Reading a model and determine which cells will change."]
["You understanding some of the computer terms."]
["You are not familiar with the computer terms."]
["You are able to follow sequenced instructions.",10]
["You are sometimes able to follow sequenced instructions."]
["You are not yet able to follow sequenced instructions."]
["You are able to read a database and extract the relevent information from it.",11]
["You are able to read a database and extract some of the relevent information from it."]
["You have not been able to read the database and extract the relevent information from it."]
["You understand a variety of Database terms."]
["You understand some of  the Database terms.",13]
["You do not yet know the Database terms."]