{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["HOW TO USE THIS WORKBOOK","GRADE BOOK"],"not_rendered":{"defined_names":7},"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:   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, quiz, or test names (e.g., \"Quiz 1\") starting in cell H8, along with the points that each assignment is worth. "]
[null,"4. Fill in the scores for each student on each assignment or test. The \"Average\", \"Score,\" \"Ltr Grade,\" and \"GPA\" columns are automatically calculated, but you can override them if you wish. To award extra credit points, simply give more points on an assignment than the total possible points listed for that assignment."]
[null,"Use the \"Print Area\" command on the Page Layout menu if you want to change what prints."]
[null,"Scores for grades are based on a standard percentage scale according to the total number of points assigned in rows 8 and 9.  Adjust each assignment or test to the desired points, then adjust the percent to go with the appropriate grade.  Overwrite the Score cells to manually make changes."]
[null,"Enter each assignment, quiz, or test and the points it is worth in cells H8 to X9."]

{"sheet":"GRADE BOOK","index":1,"n_rows":24,"n_cols":24,"rows_kept":24,"merged":[[2,1,2,6],[3,1,3,6],[4,1,6,6],[7,4,7,6],[8,4,8,6],[10,4,10,6],[11,4,11,6],[20,1,20,2],[20,3,20,4],[21,1,21,2],[21,3,21,4],[22,1,22,2],[22,3,22,4],[23,1,23,2],[23,3,23,4]]}
[null,"Lake Agate High School"]
[]
[null,"Kerstin Mark",{"$nulls":5},"Score",{"$f":"I4*TotalPoints","v":118},120,126,134,140,{"v":145.6666666666666,"d":"146"},154,160,166,174,180,186,194]
[null,"Economics",{"$nulls":5},"%",{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.728333333333333,"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%"}]
[null,"2023 Spring semester",{"$nulls":5},"Ltr Grade","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":7},"GPA",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[{"$nulls":4},"Assignments",null,null,"HW1","HW2","Q1"]
[{"$nulls":4},"Total Available Points",null,null,50,50,100]
[]
[{"$nulls":4},"Total number of assignments and tests:",null,null,{"$f":"COUNTA(H8:AH8)","v":3}]
[{"$nulls":4},"Total possible points:",null,null,{"$f":"SUM(H9:AH9)","v":200}]
[]
[null,"Student Name","Student ID","Average","Score","Ltr Grade","GPA","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22"]
[null,"Devon Torres",null,{"$f":"IFERROR(IF(COUNT(Grades[[#This Row],[Column6]:[Column22]])=0,\"\",SUM(Grades[[#This Row],[Column6]:[Column22]])/TotalPoints),\"\")","v":{"v":0.91,"d":"91.0%"}},{"$f":"IF(COUNT(Grades[[#This Row],[Column6]:[Column22]])=0,\"\",SUM(Grades[[#This Row],[Column6]:[Column22]]))","v":182},{"$f":"IFERROR(IF(Grades[[#This Row],[Average]]<>\"\",HLOOKUP(Grades[[#This Row],[Average]]*TotalPoints,GradeTable,3),\"\"),0)","v":"A-"},{"$f":"IFERROR(IF(Grades[[#This Row],[Average]]<>\"\",HLOOKUP(Grades[[#This Row],[Average]]*TotalPoints,GradeTable,4),\"\"),0)","v":3.67},45,45,92]
[null,"Helen Karu",null,{"$f":"IFERROR(IF(COUNT(Grades[[#This Row],[Column6]:[Column22]])=0,\"\",SUM(Grades[[#This Row],[Column6]:[Column22]])/TotalPoints),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(COUNT(Grades[[#This Row],[Column6]:[Column22]])=0,\"\",SUM(Grades[[#This Row],[Column6]:[Column22]]))","v":200},{"$f":"IFERROR(IF(Grades[[#This Row],[Average]]<>\"\",HLOOKUP(Grades[[#This Row],[Average]]*TotalPoints,GradeTable,3),\"\"),0)","v":"A+"},{"$f":"IFERROR(IF(Grades[[#This Row],[Average]]<>\"\",HLOOKUP(Grades[[#This Row],[Average]]*TotalPoints,GradeTable,4),\"\"),0)","v":{"v":4,"d":"4.00"}},50,50,100]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Grades[[#This Row],[Column6]:[Column22]])=0,\"\",SUM(Grades[[#This Row],[Column6]:[Column22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Grades[[#This Row],[Column6]:[Column22]])=0,\"\",SUM(Grades[[#This Row],[Column6]:[Column22]]))","v":""},{"$f":"IFERROR(IF(Grades[[#This Row],[Average]]<>\"\",HLOOKUP(Grades[[#This Row],[Average]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Grades[[#This Row],[Average]]<>\"\",HLOOKUP(Grades[[#This Row],[Average]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Grades[[#This Row],[Column6]:[Column22]])=0,\"\",SUM(Grades[[#This Row],[Column6]:[Column22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Grades[[#This Row],[Column6]:[Column22]])=0,\"\",SUM(Grades[[#This Row],[Column6]:[Column22]]))","v":""},{"$f":"IFERROR(IF(Grades[[#This Row],[Average]]<>\"\",HLOOKUP(Grades[[#This Row],[Average]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Grades[[#This Row],[Average]]<>\"\",HLOOKUP(Grades[[#This Row],[Average]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Grades[[#This Row],[Column6]:[Column22]])=0,\"\",SUM(Grades[[#This Row],[Column6]:[Column22]])/TotalPoints),\"\")","v":""},{"$f":"IF(COUNT(Grades[[#This Row],[Column6]:[Column22]])=0,\"\",SUM(Grades[[#This Row],[Column6]:[Column22]]))","v":""},{"$f":"IFERROR(IF(Grades[[#This Row],[Average]]<>\"\",HLOOKUP(Grades[[#This Row],[Average]]*TotalPoints,GradeTable,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Grades[[#This Row],[Average]]<>\"\",HLOOKUP(Grades[[#This Row],[Average]]*TotalPoints,GradeTable,4),\"\"),0)","v":""}]
[]
[null,"Class Summary",null,"Average",null,"Ltr Grade","GPA","","","","","","","","","","",""]
[null," Average",null,{"$f":"IFERROR(AVERAGE(Grades[[#All],[Average]]),0)","v":{"v":0.9550000000000001,"d":"95.5%"}},null,{"$f":"IFERROR(HLOOKUP(D22*TotalPoints,GradeTable,3),\"\")","v":"A"},{"$f":"IFERROR(AVERAGE(Grades[[#All],[GPA]]),0)","v":{"v":3.835,"d":"3.84"}},"","","","","","","","","","","","","","","","",""]
[null," Highest Score",null,{"$f":"IFERROR(MAX(Grades[[#All],[Average]]),0)","v":{"v":1,"d":"100.0%"}},null,{"$f":"IFERROR(HLOOKUP(D23*TotalPoints,GradeTable,3),\"\")","v":"A+"},{"$f":"IFERROR(MAX(Grades[[#All],[GPA]]),0)","v":{"v":4,"d":"4.00"}},"","","","","","","","","","","","","","","","",""]
[null," Lowest Score",null,{"$f":"IFERROR(MIN(Grades[[#All],[Average]]),0)","v":{"v":0.91,"d":"91.0%"}},null,{"$f":"IFERROR(HLOOKUP(D24*TotalPoints,GradeTable,3),\"\")","v":"A-"},{"$f":"IFERROR(MIN(Grades[[#All],[GPA]]),0)","v":3.67},"","","","","","","","","","","","","","","","",""]