{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INSTRUCTIONS","CLASS RECORD","FORMATIVE TEST","Transmutation Table"],"not_rendered":{"charts":0,"images":6,"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":"INSTRUCTIONS","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,9],[10,0,10,9]]}
["K to 12 E-Class Record Manual"]
[1,"Print out this class record in every grading period"]
[2,"Make sure to have a back-up  file with a different file name"]
[3,"It is advisable to save the back-up file in the cloud(e.g. GOOGLE DRIVE,DROP BOX, ECT..)"]
[4,"Avoid computer viruses by using flash drives into different computers   "]
[5,"In cases of virus infections do not reformat the storage device and contact your ICT Coordinator for file recovery"]
[6,"Formulas autimatically adjust to the number of assessments"]
[8,"Copy paste formulas for the succeeding students"]
[9,"If there is a confirmation to enable a MACRO (click ENABLE to activate the Add buttons)"]
[]
["OPEN SOURCE FILE:"]
[1,"You can innovate this file "]
[2,"You can distribute this file"]
[]
[]
[null,"ENJOY!"]
[]
[null,"From: Schools Division of Bacolod City"]
[null,"Website:","gg.gg/depedbacolodcity"]

{"sheet":"CLASS RECORD","index":1,"n_rows":27,"n_cols":32,"rows_kept":27,"cut":false,"hidden":false,"merged":[[25,0,25,3],[23,0,23,3],[24,0,24,3],[26,0,26,3],[3,0,4,0],[1,28,4,28],[2,10,3,10],[2,4,2,8],[2,11,4,11],[2,20,4,20],[2,13,2,17],[2,12,3,12],[2,21,3,21],[2,26,4,26],[0,0,0,1],[3,2,4,2],[3,3,4,3],[1,30,4,30],[1,29,4,29],[2,27,3,27],[2,19,3,19],[2,0,2,3],[3,1,4,1],[0,8,0,31],[0,2,0,3],[0,4,0,7],[1,0,1,1],[1,31,4,31],[1,4,1,27],[2,25,3,25]]}
["Section Counselor:",null,null,null,"SCHOOL:"]
["GRADE & SECTION: ",null,null,null,"Summative Assessment:Written Work(WW),Performance Task(PT),& Quarterly Assessment(QA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial Grade","Transmuted","Remarks"]
["SUBJECT:SCIENCE",null,null,null,"(WW)",null,null,null,null,null,"TOTAL","P.Score","Wt.","(PT)",null,null,null,null,null,"TOTAL","P.Score","Wt.",null,"(QA)",null," (QA) Total","P.Score","Wt."]
[null,"BOYS",null,"ITEM","WW1","WW2","WW3","WW4","WW5",null,null,null,null,"PT1","PT2","PT3","PT4","PT5",null,null,null,null,"Written","Performance"]
[null,null,null,null,40,40,40,40,40,null,{"$f":"SUM(E5:I5)","v":200},null,0.35,40,40,40,40,40,null,{"$f":"SUM(N5:S5)","v":200},null,0.4,50,null,null,{"$f":"SUM(W5:Y5)","v":50},null,0.25]
["No.","LAST NAME","FIRST NAME","M.I.",null,null,null,null,null,"WWEND",null,null,null,null,null,null,null,null,"PTEND",null,null,null,null,null,"QAEND",null,null,null,null,null,null,"No."]
[1,"Dela Cruz","Juan Mario Makisig","R",40,40,20,40,20,null,{"$f":"SUM(E7:I7)","v":160},{"$f":"(K7/($K$5)*100)","v":80},{"$f":"L7*0.35","v":28},32,45,40,20,40,null,{"$f":"SUM(N7:S7)","v":177},{"$f":"(T7/$T$5)*100","v":88.5},{"$f":"U7*0.4","v":35.4},45,null,null,{"$f":"SUM(W7:Y7)","v":45},{"$f":"(Z7/$Z$5*100)","v":90},{"$f":"AA7*0.25","v":22.5},{"$f":"ROUND(M7+V7+AB7,2)","v":85.9},{"$f":"IF(AC7=100,\"100\",IF(AND(AC7>=98.4,AC7<=99.99),\"99\",IF(AND(AC7>=96.8,AC7<=98.39),\"98\",IF(AND(AC7>=95.2,AC7<=96.79),\"97\",IF(AND(AC7>=93.6,AC7<=95.19),\"96\",IF(AND(AC7>=92,AC7<=93.59),\"95\",IF(AND(AC7>=90.4,AC7<=91.99),\"94\",IF(AND(AC7>=88.8,AC7<=90.39),\"93\",IF(AND(AC7>=87.2,AC7<=88.79),\"92\",IF(AND(AC7>=85.6,AC7<=87.19),\"91\",IF(AND(AC7>=84,AC7<=85.59),\"90\",IF(AND(AC7>=82.4,AC7<=83.99),\"89\",IF(AND(AC7>=80.8,AC7<=82.39),\"88\",IF(AND(AC7>=79.2,AC7<=80.79),\"87\",IF(AND(AC7>=77.6,AC7<=79.19),\"86\",IF(AND(AC7>=76,AC7<=77.59),\"85\",IF(AND(AC7>=74,AC7<=75.99),\"84\",IF(AND(AC7>=72.8,AC7<=74.39),\"83\",IF(AND(AC7>=71.2,AC7<=72.79),\"82\",IF(AND(AC7>=69.6,AC7<=71.19),\"81\",IF(AND(AC7>=68,AC7<=69.59),\"80\",IF(AND(AC7>=66.4,AC7<=67.99),\"79\",IF(AND(AC7>=64.8,AC7<=66.39),\"78\",IF(AND(AC7>=63.2,AC7<=64.79),\"77\",IF(AND(AC7>=61.6,AC7<=63.19),\"76\",IF(AND(AC7>=60,AC7<=61.59),\"75\",IF(AND(AC7>=56,AC7<=59.99),\"74\",IF(AND(AC7>=52,AC7<=55.99),\"73\",IF(AND(AC7>=48,AC7<=51.99),\"72\",IF(AND(AC7>=44,AC7<=47.99),\"71\",IF(AND(AC7>=40,AC7<=43.99),\"70\",IF(AND(AC7>=36,AC7<=39.99),\"69\",IF(AND(AC7>=32,AC7<=35.99),\"68\",IF(AND(AC7>=28,AC7<=31.99),\"67\",IF(AND(AC7>=24,AC7<=27.99),\"66\",IF(AND(AC7>=20,AC7<=23.99),\"65\",IF(AND(AC7>=16,AC7<=19.99),\"64\",IF(AND(AC7>=12,AC7<=15.99),\"63\",IF(AND(AC7>=8,AC7<=11.99),\"62\",IF(AND(AC7>=4,AC7<=7.99),\"61\",IF(AND(AC7>=0,AC7<=3.99),\"60\",\"Not Applicable\")))))))))))))))))))))))))))))))))))))))))","v":"91"},{"$f":"IF(AD7>=\"75\",\"Passed\",\"Failed\")","v":"Passed"},1]
[2,"Ibara","Crisostomo","B",30,30,30,40,23,null,{"$f":"SUM(E8:I8)","v":153},{"$f":"(K8/($K$5)*100)","v":76.5},{"$f":"L8*0.35","v":26.774999999999999},35,30,21,21,32,null,{"$f":"SUM(N8:S8)","v":139},{"$f":"(T8/200)*100","v":69.5},{"$f":"U8*0.4","v":27.8},32,null,null,{"$f":"SUM(W8:Y8)","v":32},{"$f":"(Z8/$Z$5*100)","v":64},{"$f":"AA8*0.25","v":16},{"$f":"ROUND(M8+V8+AB8,2)","v":70.58},"81",{"$f":"IF(AD8>=\"75\",\"Passed\",\"Failed\")","v":"Passed"},2]
[3,"Malaya","Pedro","L",32,32,21,12,5,null,{"$f":"SUM(E9:I9)","v":102},{"$f":"(K9/($K$5)*100)","v":51},17.849999999999998,23,11,0,0,35,null,{"$f":"SUM(N9:S9)","v":69},{"$f":"(T9/200)*100","v":34.5},13.8,34,null,null,{"$f":"SUM(W9:Y9)","v":34},{"$f":"(Z9/$Z$5*100)","v":68},17,{"$f":"ROUND(M9+V9+AB9,2)","v":48.65},"72",{"$f":"IF(AD9>=\"75\",\"Passed\",\"Failed\")","v":"Failed"},3]
[]
[]
[]
[]
[]
["No.","GIRLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No."]
[1,"Dela Cruz","Janice","D"]
[2,"Bloom","Cristine","M"]
[3,"Makiling","Maria","D"]
[]
[]
[]
[]
[null,"END","END"]
["No. of students",null,null,null,{"$f":"COUNT(E7:E23)","v":3},{"$f":"COUNT(F7:F23)","v":3},{"$f":"COUNT(G7:G23)","v":3},{"$f":"COUNT(H7:H23)","v":3},{"$f":"COUNT(I7:I23)","v":3},null,null,null,null,{"$f":"COUNT(N7:N23)","v":3},{"$f":"COUNT(O7:O23)","v":3},{"$f":"COUNT(P7:P23)","v":3},{"$f":"COUNT(Q7:Q23)","v":3},{"$f":"COUNT(R7:R23)","v":3},null,null,null,null,{"$f":"COUNT(W7:W23)","v":3}]
["No. of items",null,null,null,{"$f":"E5","v":40},{"$f":"F5","v":40},{"$f":"G5","v":40},{"$f":"H5","v":40},{"$f":"I5","v":40},null,null,null,null,{"$f":"N5","v":40},{"$f":"O5","v":40},{"$f":"P5","v":40},{"$f":"Q5","v":40},{"$f":"R5","v":40},null,null,null,null,{"$f":"W5","v":50}]
["Mean",null,null,null,{"$f":"AVERAGE(E7:E23)","v":34},{"$f":"AVERAGE(F7:F23)","v":34},{"$f":"AVERAGE(G7:G23)","v":23.666666666666668},{"$f":"AVERAGE(H7:H23)","v":30.666666666666668},{"$f":"AVERAGE(I7:I23)","v":16},null,null,null,null,{"$f":"AVERAGE(N7:N23)","v":30},{"$f":"AVERAGE(O7:O23)","v":28.666666666666668},{"$f":"AVERAGE(P7:P23)","v":20.333333333333332},{"$f":"AVERAGE(Q7:Q23)","v":13.666666666666666},{"$f":"AVERAGE(R7:R23)","v":35.666666666666664},null,null,null,null,{"$f":"AVERAGE(W7:W23)","v":37}]
["Proficiency Level(PL)",null,null,null,{"$f":"(SUM(E7:E23)/(E24*E25))*100","v":85},{"$f":"(SUM(F7:F23)/(F24*F25))*100","v":85},{"$f":"(SUM(G7:G23)/(G24*G25))*100","v":59.166666666666664},{"$f":"(SUM(H7:H23)/(H24*H25))*100","v":76.666666666666671},{"$f":"(SUM(I7:I23)/(I24*I25))*100","v":40},null,null,null,null,{"$f":"(SUM(N7:N23)/(N24*N25))*100","v":75},{"$f":"(SUM(O7:O23)/(O24*O25))*100","v":71.666666666666671},{"$f":"(SUM(P7:P23)/(P24*P25))*100","v":50.833333333333329},{"$f":"(SUM(Q7:Q23)/(Q24*Q25))*100","v":34.166666666666664},{"$f":"(SUM(R7:R23)/(R24*R25))*100","v":89.166666666666671},null,null,null,null,{"$f":"(SUM(W7:W23)/(W24*W25))*100","v":74}]

{"sheet":"FORMATIVE TEST","index":2,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[57,0,57,3],[2,0,2,3],[0,0,0,3],[1,0,1,3],[1,4,1,23],[68,0,68,3],[69,0,69,3],[0,4,0,5],[0,6,0,23],[58,0,58,3],[59,0,59,3],[62,1,62,3],[63,0,63,3],[66,0,66,3],[67,0,67,3],[3,1,4,1],[3,2,4,2],[3,3,4,3],[60,0,60,3],[3,0,4,0],[2,4,2,23]]}
["Section Counselor:",null,null,null,"SCHOOL:"]
["GRADE & SECTION:",null,null,null,"Formative Assessment"]
["SUBJECT:"]
[null,"LAST NAME","FIRST NAME","M.I.","FT1","FT2","FT3","FT4","FT5","FT6","FT7","FT8","FT9","FT10","FT11","FT12","FT13","FT14","FT15","FT16","FT17","FT18","FT19","FT20"]
[null,null,null,null,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10]
["No.","BOYS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No."]
[1,"Dela Cruz","Juan","R",4,6,9,6,8,3,7,7,9,8,9,7,8,8,8,10,8,8,7,8,1]
[2,"Ibara","Crisostomo","B",5,8,3,5,7,7,8,9,7,7,7,6,8,5,10,9,8,8,6,5,2]
[3,"Makiling","Maria","L",6,7,7,5,7,9,9,8,8,7,8,8,8,4,6,7,9,9,8,4,3]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,5]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
["No.","GIRLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No."]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,3]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,5]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
["No. of students",null,null,null,{"$f":"COUNT(E7:E57)","v":3},3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
["No. of items",null,null,null,{"$f":"E5","v":10},{"$f":"F5","v":10},10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10]
["Mean",null,null,null,{"$f":"AVERAGE(E7:E57)","v":5},{"$f":"AVERAGE(F7:F57)","v":7},6.333333333333333,5.333333333333333,7.333333333333333,6.333333333333333,8,8,8,7.333333333333333,8,7,8,5.666666666666667,8,8.6666666666666661,8.3333333333333339,8.3333333333333339,7,5.666666666666667]
["Proficiency Level(PL)",null,null,null,{"$f":"(SUM(E7:E57)/(E58*E59))*100","v":50},{"$f":"(SUM(F7:F57)/(F58*F59))*100","v":70},63.333333333333329,53.333333333333336,73.333333333333329,63.333333333333329,80,80,80,73.333333333333329,80,70,80,56.666666666666664,80,86.666666666666671,83.333333333333343,83.333333333333343,70,56.666666666666664]

{"sheet":"Transmutation Table","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Initial Grade","Transmuted Grade"]
[92,{"$f":"IF(A2=100,\"100\",IF(AND(A2>=98.4,A2<=99.99),\"99\",IF(AND(A2>=96.8,A2<=98.39),\"98\",IF(AND(A2>=95.2,A2<=96.79),\"97\",IF(AND(A2>=93.6,A2<=95.19),\"96\",IF(AND(A2>=92,A2<=93.59),\"95\",IF(AND(A2>=90.4,A2<=91.99),\"94\",IF(AND(A2>=88.8,A2<=90.39),\"93\",IF(AND(A2>=87.2,A2<=88.79),\"92\",IF(AND(A2>=85.6,A2<=87.19),\"91\",IF(AND(A2>=84,A2<=85.59),\"90\",IF(AND(A2>=82.4,A2<=83.99),\"89\",IF(AND(A2>=80.8,A2<=82.39),\"88\",IF(AND(A2>=79.2,A2<=80.79),\"87\",IF(AND(A2>=77.6,A2<=79.19),\"86\",IF(AND(A2>=76,A2<=77.59),\"85\",IF(AND(A2>=74,A2<=75.99),\"84\",IF(AND(A2>=72.8,A2<=74.39),\"83\",IF(AND(A2>=71.2,A2<=72.79),\"82\",IF(AND(A2>=69.6,A2<=71.19),\"81\",IF(AND(A2>=68,A2<=69.59),\"80\",IF(AND(A2>=66.4,A2<=67.99),\"79\",IF(AND(A2>=64.8,A2<=66.39),\"78\",IF(AND(A2>=63.2,A2<=64.79),\"77\",IF(AND(A2>=61.6,A2<=63.19),\"76\",IF(AND(A2>=60,A2<=61.59),\"75\",IF(AND(A2>=56,A2<=59.99),\"74\",IF(AND(A2>=52,A2<=55.99),\"73\",IF(AND(A2>=48,A2<=51.99),\"72\",IF(AND(A2>=44,A2<=47.99),\"71\",IF(AND(A2>=40,A2<=43.99),\"70\",IF(AND(A2>=36,A2<=39.99),\"69\",IF(AND(A2>=32,A2<=35.99),\"68\",IF(AND(A2>=28,A2<=31.99),\"67\",IF(AND(A2>=24,A2<=27.99),\"66\",IF(AND(A2>=20,A2<=23.99),\"65\",IF(AND(A2>=16,A2<=19.99),\"64\",IF(AND(A2>=12,A2<=15.99),\"63\",IF(AND(A2>=8,A2<=11.99),\"62\",IF(AND(A2>=4,A2<=7.99),\"61\",IF(AND(A2>=0,A2<=3.99),\"60\",\"Not Applicable\")))))))))))))))))))))))))))))))))))))))))","v":"95"}]
["Insert Initial grade with two decimal palces"]
[]
[]
["NOTE: Initial Grade must have two decimal for it to be transmuted transmuted"]