{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Home","Extended Diploma Grading Sheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Home","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,5,10,15],[17,8,17,12],[21,4,21,15],[3,5,7,15],[8,5,8,15]]}
[]
[]
[]
[null,null,null,null,null,"Level 3 (QCF) Grade Calculator"]
[]
[]
[]
[]
[null,null,null,null,null,"For 2010 specifications"]
[null,null,null,null,null,"To begin, select a qualification from the options below:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"You can click the BTEC logo to return to this page"]
[]
[]
[]
[null,null,null,null,"Created by Lee Murphy © 2014 via TES Resources| This is in no way endorsed by Edexcel or BTEC | Logos © ™ Pearson Education Ltd | V1.2"]

{"sheet":"Extended Diploma Grading Sheet","index":1,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,1,15,2],[14,1,14,2],[0,0,1,0],[0,1,1,2],[0,3,1,3],[8,1,8,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[0,4,1,5],[0,6,0,7],[0,13,23,15],[1,6,1,7],[2,1,2,2],[2,4,2,5],[2,6,2,7],[3,1,3,2],[3,4,3,5],[3,6,3,7],[0,8,1,8],[4,1,4,2],[4,4,4,5],[4,6,4,7],[5,1,5,2],[5,4,5,5],[6,1,6,2],[6,4,6,5],[6,6,6,7],[7,1,7,2],[7,4,7,5],[7,6,7,7],[8,4,8,5],[8,6,8,7],[9,1,9,2],[9,4,9,5],[9,6,9,7],[21,1,21,2],[21,4,21,5],[21,6,21,7],[10,1,10,2],[10,4,10,5],[10,6,10,7],[11,4,11,5],[11,6,11,7],[12,4,12,5],[12,6,12,7],[17,4,17,5],[18,4,18,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[24,0,25,13],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7],[18,6,18,7],[22,0,23,0],[22,1,23,1],[22,2,23,2],[22,3,23,4],[22,5,23,5],[22,6,23,6],[19,4,19,5],[19,6,19,7],[20,4,20,5],[22,7,23,7],[22,8,23,8],[22,11,23,12],[20,6,20,7],[0,9,23,10],[0,11,2,12],[14,11,14,12],[5,6,5,7],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2]]}
["Unit Number","Unit Name",null,"Credit Value","Grade Achieved    (Drop Down List)",null,"Grade Value",null,"Points per Unit",null,null,"<-- MACROS MUST BE ENABLED"]
[null,null,null,null,null,null,"P=7 / M=8 / D=9"]
["Unit 1","Pre-production Techniques",null,5,null,null,{"$f":"IF(E3=\"Pass (P)\", \"7\",IF(E3=\"Merit (M)\", \"8\",IF(E3=\"Distinction (D)\", \"9\",0)))","v":0},null,{"$f":"SUM(D3*G3)","v":0}]
["Unit 2","Communication Skills",null,5,null,null,{"$f":"IF(E4=\"Pass (P)\", \"7\",IF(E4=\"Merit (M)\", \"8\",IF(E4=\"Distinction (D)\", \"9\",0)))","v":0},null,{"$f":"SUM(D4*G4)","v":0},null,null,"Total Points:","Overall Grade:"]
["Unit 3","Research Techniques",null,10,null,null,0,null,0,null,null,"1299 or Less","PPP"]
["Unit 13","Understanding the Game Industry",null,10,null,null,0,null,0,null,null,"1300-1339","PPM"]
["Unit 20","Comp Game Platform & Tech",null,10,null,null,0,null,0,null,null,"1340-1379","PMM"]
["Unit 72"," Computer Games Design",null,10,null,null,0,null,0,null,null,"1380-1419","MMM"]
["Unit 73","Sound for Computer Games",null,10,null,null,0,null,0,null,null,"1420-1459","MMD"]
["Unit 74","Story Development",null,10,null,null,0,null,0,null,null,"1460-1499","MDD"]
["Unit 71","Digital Graphics",null,10,null,null,0,null,0,null,null,"1500-1529","DDD"]
["Unit 77","Designing Tests for Computer Games",null,10,null,null,{"$f":"IF(E12=\"Pass (P)\", \"7\",IF(E12=\"Merit (M)\", \"8\",IF(E12=\"Distinction (D)\", \"9\",0)))","v":0},null,{"$f":"SUM(D12*G12)","v":0},null,null,"1530-1559","DDD*"]
[null,null,null,null,null,null,null,null,null,null,null,"1560-1589","DD*D*"]
["Unit 4","Creative Media Production Management Project",null,10,null,null,{"$f":"IF(E14=\"Pass (P)\", \"7\",IF(E14=\"Merit (M)\", \"8\",IF(E14=\"Distinction (D)\", \"9\",0)))","v":0},null,0,null,null,"1590 or More","D*D*D*"]
["Unit 5","Working to a brief in Media",null,10,null,null,{"$f":"IF(E15=\"Pass (P)\", \"7\",IF(E15=\"Merit (M)\", \"8\",IF(E15=\"Distinction (D)\", \"9\",0)))","v":0},null,0,null,null,"Extra rows provided to accommodate 5 credit Units"]
["Unit 6","Critical Approaches to Media",null,10,null,null,0,null,0]
["Unit 66","3 D Modelling",null,10,null,null,0,null,0]
["Unit 67","3 D Animation",null,10,null,null,0,null,0]
["Unit 71","Object Oriented Design",null,10,null,null,0,null,0]
["Unit 69","Drawing Concept Art",null,10,null,null,0,null,0]
["Unit 70","Computer Games Engines",null,10,null,null,0,null,0]
["Unit 68","3D Environments",null,10,null,null,0,null,0]
["Candidate Number:",null,"Candidate Name:",null,null,"Overall Grade:",{"$f":"IF(I23<1260,\"Fail\",IF(I23<=1299,\"PPP\",IF(I23<=1339,\"PPM\",IF(I23<=1379,\"PMM\",IF(I23<=1419,\"MMM\",IF(I23<=1459,\"MMD\",IF(I23<=1499,\"MDD\",IF(I23<=1529,\"DDD\",(IF(I23<=1559,\"DDD*\",IF(I23<=1589,\"DD*D*\",IF(I23>=1590,\"D*D*D*\",\"Fail\"))))))))))))","v":"Fail"},"Total Points:",{"$f":"SUM(I3:I22)","v":0}]
[]
["This is in no way endorsed by Edexcel or BTEC | Logos © Pearson Education Ltd"]
[]
[]
[null,null,null,null,null,null,"Pass (P)"]
[null,null,null,null,null,null,"Merit (M)"]
[null,null,null,null,null,null,"Distinction (D)"]