{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Scores","Results summary"],"not_rendered":{"charts":1,"images":0,"macros":0,"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":"Scores","index":0,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,21,1,22],[38,0,38,3],[1,18,1,19]]}
[]
["Group","ID","First name (s)","Last Name","Attendance",null,null,null,null,null,null,null,null,null,null,null,"Presentation",null,"Exam",null,null,"Final score"]
[null,null,null,null,"L1","L2","L3","L4","L5","L6","L7","L8","L9","Total"," %",null,"%",null,"Raw Score","%",null,"Final score","Grade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"/8","/20",null,"/20",null,"/25","/60",null,"/100"]
["G",5653520014,"JACKY","PECQUEUR",1,1,1,1,1,1,1,1,1,{"$f":"SUM(E5:M5)","v":9},{"$f":"N5/9*20","v":20},null,17.5,null,24,{"$f":"S5/25*60","v":57.599999999999994},null,{"$f":"O5+T5+Q5","v":95.1},{"$f":"IF(V5>=79.5,\"A\",IF(V5>=74.5,\"B+\",IF(V5>=69.5,\"B\",IF(V5>=64.5,\"C+\",IF(V5>=59.5,\"C\",IF(V5>=54.5,\"D+\",IF(V5>=44.5,\"D\",IF(V5<44.5,\"FAIL\"))))))))","v":"A"}]
["J",5653520063,"MARTYN WERNER","KRUGEL",1,1,0,1,1,1,0,1,1,{"$f":"SUM(E6:M6)","v":7},{"$f":"N6/9*20","v":15.555555555555555},null,17,null,23,55.2,null,87.75555555555556,"A"]
["C",5653520097,"JASON DAVID","ALAVI",1,0,1,1,1,0,1,1,1,7,15.555555555555555,null,18.5,null,17,40.800000000000004,null,74.855555555555554,"B+"]
["B",5653520154,"MATTHEW","MURT",1,1,1,1,1,0,1,1,1,8,17.777777777777779,null,19,null,21,50.4,null,87.177777777777777,"A"]
["C",5653520196,"ALASTAIR","PATTERSON",1,1,1,0,1,1,1,1,1,8,17.777777777777779,null,18.5,null,15,36,null,72.277777777777771,"B"]
["K",5653520238,"ALINLADAH","MEEPIEN",1,1,1,1,1,1,1,1,1,9,20,null,13.5,null,13,31.200000000000003,null,64.7,"C+"]
["K",5653520261,"CHUTIKAN","SUKONTASINGHA",1,1,1,1,1,1,0,1,1,8,17.777777777777779,null,13.5,null,17,40.800000000000004,null,72.077777777777783,"B"]
["B",5653520279,"KAPIL","DAYA",1,1,1,0,1,1,1,1,1,8,17.777777777777779,null,19,null,24,57.599999999999994,null,94.377777777777766,"A"]
["C",5753020386,"JAMES LAWRENCE","MALKIN",1,1,1,1,0,1,1,1,1,8,17.777777777777779,null,18.5,null,21,50.4,null,86.677777777777777,"A"]
["A",5753020394,"JONATHAN CRYILL MATTIN","LEPAROUX",1,1,1,1,0,1,1,1,1,8,17.777777777777779,null,13.5,null,18,43.199999999999996,null,74.477777777777774,"B"]
["E",5753020410,"KETSIRI","SINTHOPWICHANON",0,1,1,0,1,1,1,1,1,7,15.555555555555555,null,14.5,null,18,43.199999999999996,null,73.25555555555556,"B"]
["A",5753020444,"SIYABONGA THABO","NTULI",1,1,1,1,1,0,1,1,1,8,17.777777777777779,null,13.5,null,19,45.6,null,76.87777777777778,"B+"]
["C",5753020451,"TIMOTHY LEONARD","KELLEHER",1,1,1,1,1,1,1,1,1,9,20,null,18.5,null,23,55.2,null,93.7,"A"]
["E",5753020469,"UZMA","MALENG",1,1,1,1,0,1,1,1,1,8,17.777777777777779,null,14.5,null,19,45.6,null,77.87777777777778,"B+"]
["H",5853020427,"TADAPA","SIRIPAK",1,1,1,1,1,1,1,1,1,9,20,null,16,null,19,45.6,null,81.599999999999994,"A"]
["H",5853522034,"HONG","ZHANG",0,1,1,1,1,1,1,1,1,8,17.777777777777779,null,16,null,12,28.799999999999997,null,62.577777777777776,"C"]
["D",5853522042,"LALITA","KITTISILPA",0,0,1,1,1,1,1,1,1,7,15.555555555555555,null,15.5,null,15,36,null,67.055555555555557,"C+"]
["H",5853522059,"RIJA","RAZAFIARINOSY",0,1,1,0,0,1,1,1,1,6,13.333333333333332,null,16,null,16,38.4,null,67.733333333333334,"C+"]
["H",5853522067,"RUJIRA","SREEPANARAT",1,1,1,1,1,1,1,1,1,9,20,null,16,null,19,45.6,null,81.599999999999994,"A"]
["F",5953022018,"ANDREW","SMITH",1,1,0,1,1,1,1,1,1,8,17.777777777777779,null,13.5,null,19,45.6,null,76.87777777777778,"B+"]
["I",5953022026,"CHAYAWIN","CHOMNGAM",1,1,1,1,1,1,1,1,1,9,20,null,17.5,null,18,43.199999999999996,null,80.699999999999989,"A"]
["D",5953022034,"CHONLADA","CHAMNAN",1,1,1,1,1,1,1,1,1,9,20,null,15.5,null,21,50.4,null,85.9,"A"]
["F",5953022042,"DONNA RISA BATERINA","BATIAO",1,1,1,0,1,1,1,1,1,8,17.777777777777779,null,13.5,null,22,52.8,null,84.077777777777783,"A"]
["F",5953022067,"JUSTIN OLIVER","PORTER",1,1,1,0,1,0,1,1,1,7,15.555555555555555,null,13.5,null,20,48,null,77.055555555555557,"B+"]
["I",5953022075,"MASARAT","PHWAPHATSIRACHOK",1,1,1,1,1,0,1,1,1,8,17.777777777777779,null,17.5,null,17,40.800000000000004,null,76.077777777777783,"B+"]
["F",5953022091,"MORNE CHOWLES","GROENEWALD",1,1,1,0,1,1,1,1,1,8,17.777777777777779,null,13.5,null,16,38.4,null,69.677777777777777,"B"]
["D",5953022117,"NUNNAPAT","SAISIM",0,0,1,1,1,1,1,1,1,7,15.555555555555555,null,15.5,null,21,50.4,null,81.455555555555549,"A"]
["F",5953022125,"PEYMAN","GOLCHIN",0,1,0,1,1,1,1,1,1,7,15.555555555555555,null,13.5,null,16,38.4,null,67.455555555555549,"C+"]
["D",5953022133,"PICHAYANITH","HONGTHAMAWAT",1,1,1,1,1,1,1,1,1,9,20,null,15.5,null,13,31.200000000000003,null,66.7,"C+"]
["I",5953022141,"PIYALAK","SIRIPEE",1,0,1,1,1,1,1,1,1,8,17.777777777777779,null,17.5,null,15,36,null,71.277777777777771,"B"]
["D",5953022158,"NAN EI EI THWE",null,1,1,1,1,1,1,1,0,1,8,17.777777777777779,null,15.5,null,16,38.4,null,71.677777777777777,"B"]
[]
[]
[]
["            See Results Summary below for analysis"]

{"sheet":"Results summary","index":1,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,13,13,14],[31,1,31,3],[30,1,30,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"RESULTS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"COUNTIF(Scores!W6:W35,\"A\")","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"B+",{"$f":"COUNTIF(Scores!W6:W35,\"B+\")","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"B",{"$f":"COUNTIF(Scores!W6:W35,\"B\")","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"C+",{"$f":"COUNTIF(Scores!W6:W35,\"C+\")","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"C",{"$f":"COUNTIF(Scores!W6:W35,\"C\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"D+",{"$f":"COUNTIF(Scores!W6:W35,\"D+\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"D",{"$f":"COUNTIF(Scores!W6:W35,\"D\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"F",{"$f":"COUNTIF(Scores!W6:W35,\"FAIL\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"I",{"$f":"COUNTIF(Scores!W6:W35,\"I\")","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Average score on the exam (mean)   ",null,null,"N/A"]
[null,"Average course score overall              (out of 100)",null,null,{"$f":"AVERAGE(Scores!V6:V35)","v":76.852962962962962}]
[null,"Score of 0.5 or above will be rounded up to the next score if it results in a higher grade"]