{"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 the grade book worksheet to calculate grades where each assignment is worth a set number of points. "]
[null,"Instructions:   Be sure to 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 & GPA 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 \"Score\", \"Ltr Grade\" and \"GPA\" 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,"Score, Ltr Grade and GPA are not valid until 100% of tests & 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],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
[null,"Upper Talbot High School"]
[]
[{"$nulls":6},"Score",{"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},"GPA",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[null,"Ayano Harada"]
[null,"World History II",null,null,"Assignment"]
[null,"2023 Spring semester",null,null,"Percentage (should total 100%)"]
[{"$nulls":4},{"$f":"\"Total percentage: \"&SUM(G8:BZ8)*100&\"%\"","v":"Total percentage: 0%"}]
[null,"Student Name","Student ID","Score","Ltr Grade","GPA","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22"]
[null,"Gianni Castiglione",654987,{"$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],[Score]]<>\"\",HLOOKUP(Grades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(Grades[[#This Row],[Score]]<>\"\",HLOOKUP(Grades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[null,"Nat Rattanakoson",134698,{"$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],[Score]]<>\"\",HLOOKUP(Grades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(Grades[[#This Row],[Score]]<>\"\",HLOOKUP(Grades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[null,"Juan Morgan",613467,{"$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],[Score]]<>\"\",HLOOKUP(Grades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(Grades[[#This Row],[Score]]<>\"\",HLOOKUP(Grades[[#This Row],[Score]],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],[Score]]<>\"\",HLOOKUP(Grades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(Grades[[#This Row],[Score]]<>\"\",HLOOKUP(Grades[[#This Row],[Score]],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],[Score]]<>\"\",HLOOKUP(Grades[[#This Row],[Score]],GradeTable,2),\"\")","v":""},{"$f":"IF(Grades[[#This Row],[Score]]<>\"\",HLOOKUP(Grades[[#This Row],[Score]],GradeTable,3),\"\")","v":""}]
[]
[null,"Class Summary",null,"Score","Ltr Grade","GPA","","","","","","","","","","",""]
[null," Average",null,{"$f":"IFERROR(AVERAGE(Grades[[#All],[Score]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D18,GradeTable,2),\"\")","v":"F"},{"$f":"IFERROR(AVERAGE(Grades[[#All],[GPA]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Highest Score",null,{"$f":"IFERROR(MAX(Grades[[#All],[Score]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D19,GradeTable,2),\"\")","v":"F"},{"$f":"IFERROR(MAX(Grades[[#All],[GPA]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Lowest Score",null,{"$f":"IFERROR(MIN(Grades[[#All],[Score]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D20,GradeTable,2),\"\")","v":"F"},{"$f":"IFERROR(MIN(Grades[[#All],[GPA]]),0)","v":0},"","","","","","","","","","","","","","","","",""]