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

{"sheet":"HOW TO USE THIS WORKBOOK","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[]
[null,"Use this gradebook to calculate grades when all assignments contribute equally to the final grade."]
[null,"Instructions: Make sure to save back up copies of your grades, just in case."]
[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 names (e.g. \"Quiz 1\") and grades starting in cell H7 in GRADEBOOK worksheet, go as far right as you want. The \"Average\", \"Ltr Grade\", \"GPA\" and \"Missing\" columns are automatically calculated, but you can override them if you wish. The \"Missing\" column indicates the number of assignments where the student has no grade yet."]
[null,"Note: The print area is dynamic and will not show the grade table or assignments area.  Use the Print Area command on the PAGE LAYOUT tab if you want to change what area prints. "]

{"sheet":"GRADEBOOK","index":1,"n_rows":9,"n_cols":21,"rows_kept":9,"merged":[[1,1,3,3],[1,4,1,6],[2,4,2,6],[3,4,3,6]]}
[{"$nulls":7},"Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14"]
[null,"Rowan Vista High School",null,null,"2022/Autumn/Q2",null,null,"Average",0,0.6,0.63,0.67,0.7,0.73,0.77,0.8,0.83,0.87,0.9,0.93,0.97]
[{"$nulls":4},"Social Studies/Senior project",null,null,"Ltr Grade","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":4},"Instructor: Vishakha Ranade",null,null,"GPA",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[null,"Student Name","Student ID","Average","Grade","GPA","Missing","Assignment 1","Assignment 2","Quiz 1","Quiz 2","Test 1","Assignment 3","Assignment 4","Quiz 3","Test 2","Column10","Column11","Column12","Column13","Column1"]
[null,"Jozi Kos",1234,{"$f":"IFERROR(AVERAGE(Data[[#This Row],[Assignment 1]]:INDEX(Data[],ROW(Data[[#This Row],[Assignment 1]])-ROW(Data[[#Headers],[Average]]),COUNTA(Data[#Headers]))),\"\")","v":{"v":0.9166666666666666,"d":"0.92"}},{"$f":"LOOKUP(Data[[#This Row],[Average]],GradeAvg,GradeLetter)","v":"A-"},{"$f":"LOOKUP(Data[[#This Row],[Average]],GradeAvg,GradeGPA)","v":3.67},{"$f":"IF(COUNTA(Data[[#This Row],[Assignment 1]]:INDEX(Data[],ROW(Data[[#This Row],[Assignment 1]])-ROW(Data[[#Headers],[Average]]),COUNTA(Data[#Headers])))=0,\"\",COUNTA(Data[[#Headers],[Assignment 1]]:INDEX(Data[#Headers],1,COUNTA(Data[#Headers])))-COUNTA(Data[[#This Row],[Assignment 1]]:INDEX(Data[],ROW(Data[[#This Row],[Assignment 1]])-ROW(Data[[#Headers],[Average]]),COUNTA(Data[#Headers]))))","v":11},0.88,0.95,0.92]
[null,"Guy Oz",5678,{"$f":"IFERROR(AVERAGE(Data[[#This Row],[Assignment 1]]:INDEX(Data[],ROW(Data[[#This Row],[Assignment 1]])-ROW(Data[[#Headers],[Average]]),COUNTA(Data[#Headers]))),\"\")","v":{"v":0.7133333333333334,"d":"0.71"}},{"$f":"LOOKUP(Data[[#This Row],[Average]],GradeAvg,GradeLetter)","v":"C-"},{"$f":"LOOKUP(Data[[#This Row],[Average]],GradeAvg,GradeGPA)","v":1.67},{"$f":"IF(COUNTA(Data[[#This Row],[Assignment 1]]:INDEX(Data[],ROW(Data[[#This Row],[Assignment 1]])-ROW(Data[[#Headers],[Average]]),COUNTA(Data[#Headers])))=0,\"\",COUNTA(Data[[#Headers],[Assignment 1]]:INDEX(Data[#Headers],1,COUNTA(Data[#Headers])))-COUNTA(Data[[#This Row],[Assignment 1]]:INDEX(Data[],ROW(Data[[#This Row],[Assignment 1]])-ROW(Data[[#Headers],[Average]]),COUNTA(Data[#Headers]))))","v":11},0.75,0.71,0.68]
[null,"Henry Ross",9876,{"$f":"IFERROR(AVERAGE(Data[[#This Row],[Assignment 1]]:INDEX(Data[],ROW(Data[[#This Row],[Assignment 1]])-ROW(Data[[#Headers],[Average]]),COUNTA(Data[#Headers]))),\"\")","v":{"v":0.7933333333333333,"d":"0.79"}},{"$f":"LOOKUP(Data[[#This Row],[Average]],GradeAvg,GradeLetter)","v":"C+"},{"$f":"LOOKUP(Data[[#This Row],[Average]],GradeAvg,GradeGPA)","v":2.33},{"$f":"IF(COUNTA(Data[[#This Row],[Assignment 1]]:INDEX(Data[],ROW(Data[[#This Row],[Assignment 1]])-ROW(Data[[#Headers],[Average]]),COUNTA(Data[#Headers])))=0,\"\",COUNTA(Data[[#Headers],[Assignment 1]]:INDEX(Data[#Headers],1,COUNTA(Data[#Headers])))-COUNTA(Data[[#This Row],[Assignment 1]]:INDEX(Data[],ROW(Data[[#This Row],[Assignment 1]])-ROW(Data[[#Headers],[Average]]),COUNTA(Data[#Headers]))))","v":11},0.72,0.81,0.85]