{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["HOW TO USE THIS WORKBOOK","GRADE BOOK"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"HOW TO USE THIS WORKBOOK","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
[null,"INSTRUCTIONS"]
[null,"Use GRADE BOOK worksheet to calculate grades where each assignment is worth a set number of points. "]
[null,"Instructions: Make sure that you save backup copies of your grades."]
[null,"1. Fill in your school name, class info, student names and student IDs (optional).   "]
[null,"2. Adjust the Grade and Overall mark table to match the typical scoring system you use."]
[null,"3. Fill in the assignment or test names starting in cell G7, along with the percentage that each is worth (e.g. “Final” and “50%”). "]
[null,"4. Fill in the scores for each student on each assignment or test. The “Mark”, “Ltr grade” and “Overall mark” columns are automatically calculated, but you can override them if you wish. The way the grades are computed, the average and final grade are incomplete until all scores are in."]
[null,"Use the “Print area” command on the Page layout menu if you want to change what area prints."]
[null,"Mark, Ltr grade and Overall mark are not valid until 100% of tests and assignments are complete. "]
[null,"Enter each assignment or test and its percentage of the total grade in cells G7 to W8."]

{"sheet":"GRADE BOOK","index":1,"n_rows":20,"n_cols":23,"rows_kept":20,"merged":[[5,1,5,5],[6,1,6,3],[6,4,6,5],[7,1,8,3],[7,4,7,5],[8,4,8,5],[15,1,15,5],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
[null,"YOUR SCHOOL NAME"]
[]
[{"$nulls":6},"Mark",{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.73,"d":"73%"},{"v":0.77,"d":"77%"},{"v":0.8,"d":"80%"},{"v":0.83,"d":"83%"},{"v":0.87,"d":"87%"},{"v":0.9,"d":"90%"},{"v":0.93,"d":"93%"},{"v":0.97,"d":"97%"}]
[{"$nulls":6},"Ltr grade","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":6},"Overall mark",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[null,"Teacher name"]
[null,"Class/Project",null,null,"Assignment or Test name"]
[null,"Year/Semester/Quarter",null,null,"Percentage (should total 100%)"]
[{"$nulls":4},{"$f":"\"Total percentage: \"&SUM(G8:W8)*100&\"%\"","v":"Total percentage: 0%"}]
[null,"Student Name","Student ID","Mark","Ltr grade","Overall mark","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22"]
[{"$nulls":3},{"$f":"(IF(SUM(Grades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$8:$W$8,Grades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(Grades[[#This Row],[Mark]]<>\"\",HLOOKUP(Grades[[#This Row],[Mark]],GradeTable,2),\"\")","v":""},{"$f":"IF(Grades[[#This Row],[Mark]]<>\"\",HLOOKUP(Grades[[#This Row],[Mark]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Grades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$8:$W$8,Grades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(Grades[[#This Row],[Mark]]<>\"\",HLOOKUP(Grades[[#This Row],[Mark]],GradeTable,2),\"\")","v":""},{"$f":"IF(Grades[[#This Row],[Mark]]<>\"\",HLOOKUP(Grades[[#This Row],[Mark]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Grades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$8:$W$8,Grades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(Grades[[#This Row],[Mark]]<>\"\",HLOOKUP(Grades[[#This Row],[Mark]],GradeTable,2),\"\")","v":""},{"$f":"IF(Grades[[#This Row],[Mark]]<>\"\",HLOOKUP(Grades[[#This Row],[Mark]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Grades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$8:$W$8,Grades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(Grades[[#This Row],[Mark]]<>\"\",HLOOKUP(Grades[[#This Row],[Mark]],GradeTable,2),\"\")","v":""},{"$f":"IF(Grades[[#This Row],[Mark]]<>\"\",HLOOKUP(Grades[[#This Row],[Mark]],GradeTable,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Grades[[#This Row],[Column6]:[Column22]]),ROUND(SUMPRODUCT($G$8:$W$8,Grades[[#This Row],[Column6]:[Column22]]),2),\"\"))","v":""},{"$f":"IF(Grades[[#This Row],[Mark]]<>\"\",HLOOKUP(Grades[[#This Row],[Mark]],GradeTable,2),\"\")","v":""},{"$f":"IF(Grades[[#This Row],[Mark]]<>\"\",HLOOKUP(Grades[[#This Row],[Mark]],GradeTable,3),\"\")","v":""}]
[]
[null,"Class summary",null,"Mark","Ltr grade","Overall mark","","","","","","","","","","",""]
[null," Average",null,{"$f":"IFERROR(AVERAGE(Grades[[#All],[Mark]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D18,GradeTable,2),\"\")","v":"F"},{"$f":"IFERROR(AVERAGE(Grades[[#All],[Overall mark]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Highest mark",null,{"$f":"IFERROR(MAX(Grades[[#All],[Mark]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D19,GradeTable,2),\"\")","v":"F"},{"$f":"IFERROR(MAX(Grades[[#All],[Overall mark]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Lowest mark",null,{"$f":"IFERROR(MIN(Grades[[#All],[Mark]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D20,GradeTable,2),\"\")","v":"F"},{"$f":"IFERROR(MIN(Grades[[#All],[Overall mark]]),0)","v":0},"","","","","","","","","","","","","","","","",""]