{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["SBG"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"SBG","index":0,"n_rows":36,"n_cols":12,"rows_kept":36,"merged":[[0,1,0,9],[1,1,1,9],[2,1,2,9],[4,1,4,2],[15,1,15,2],[24,1,24,2]]}
[null,"Standards Based Grading (SBG)"]
[null,"This worksheet comes with no warranties, it is given to you as a courtesy.  Go to CANVAS grades to check your minimum current grade. Email kaw@usf.edu if you need clarifications or have a suggestion to improve this worksheet.  Use it only after Unit Test 1 grades are given to you."]
[null,"Editable cells are the ones in grey"]
[]
[null,"UNIT TEST GRADES"]
[null,"Chapter","Maximum Chapter Score","Maximum Chapter Score for Tests Gotten Grade So Far For ","Regular Test","First Retake","Second Retake (not taking place)","Third Retake (not taking place)","Final Exam","Chapter Grade","Standard Level Met","Chapter"]
[null,"Chap1 (Unit test 1)",40,40,30,30,0,0,0,{"$f":"masterygrade(D7,E7:I7)","v":{"v":30,"d":"30.0"}},{"$f":"masterylevel(J7,D7)","v":"Progressing (C)"},"Chap1"]
[null,"Chap2 (Unit test 1)",20,20,15,15,0,0,0,{"$f":"masterygrade(D8,E8:I8)","v":{"v":15,"d":"15.0"}},{"$f":"masterylevel(J8,D8)","v":"Progressing (C)"},"Chap2"]
[null,"Chap3 (Unit test 1)",20,20,15,20,0,0,0,{"$f":"masterygrade(D9,E9:I9)","v":17.5},{"$f":"masterylevel(J9,D9)","v":"Proficient (B)"},"Chap3"]
[null,"Chap4 (Unit test 2)",40,0,0,0,0,0,0,{"$f":"masterygrade(D10,E10:I10)","v":{"v":0,"d":"0.0"}},{"$f":"masterylevel(J10,D10)","v":"Not Checked Yet"},"Chap4"]
[null,"Chap5 (Unit test 2)",40,0,0,0,0,0,0,{"$f":"masterygrade(D11,E11:I11)","v":{"v":0,"d":"0.0"}},{"$f":"masterylevel(J11,D11)","v":"Not Checked Yet"},"Chap5"]
[null,"Chap6 (unit test 3)",40,0,0,0,0,0,0,{"$f":"masterygrade(D12,E12:I12)","v":{"v":0,"d":"0.0"}},{"$f":"masterylevel(J12,D12)","v":"Not Checked Yet"},"Chap6"]
[null,"Chap7 (unit test 3)",40,0,0,0,0,0,0,{"$f":"masterygrade(D13,E13:I13)","v":{"v":0,"d":"0.0"}},{"$f":"masterylevel(J13,D13)","v":"Not Checked Yet"},"Chap7"]
[null,"Chap8 (unit test 3)",40,0,0,0,0,0,0,{"$f":"masterygrade(D14,E14:I14)","v":{"v":0,"d":"0.0"}},{"$f":"masterylevel(J14,D14)","v":"Not Checked Yet"},"Chap8"]
[]
[null,"OVERALL GRADES"]
[null,null,"Weights","Weight Done","Percentage  Score With SBG","Percentage  Score Without SBG"]
[null,"Test Grade",45,45,{"$f":"SUM(J7:J14)/SUM(D7:D14)*100","v":{"v":78.125,"d":"78.1"}},{"$f":"SUM(E7:E14)/SUM(D7:D14)*100","v":{"v":75,"d":"75.0"}}]
[null,"Online HW grade from CANVAS",15,15,{"$f":"F19","v":{"v":90,"d":"90.0"}},{"v":90,"d":"90.0"}]
[null,"Fundamental Test grade from CANVAS",5,0,{"$f":"F20","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[null,"Final Exam Grade from CANVAS",25,0,{"$f":"F21","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[null,"Programming Projects Grade from CANVAS",10,0,{"$f":"F22","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"}]
[null,"Survey Grade",0,0,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[]
[null,"CURRENT/PROJECTED GRADES"]
[null,"Current Percentage  CANVAS Grade"]
[null,{"$f":"ROUND(CanvasGrade(C18:C22,D18:D22,F18:F22)+E23*0.025,0)","v":79}]
[null,{"$f":"fungrade(B27)","v":"B-"}]
[]
[null,"Projected Percentage CANVAS Grade"]
[null,{"$f":"INT(WithProperWeightGrade(C18:C22,D18:D22,F18:F22)+E23*0.025+0.999999)","v":79}]
[null,{"$f":"fungrade(B31)","v":"B-"}]
[]
[null,"Projected Percentage SBG Grade"]
[null,{"$f":"INT(WithProperWeightGrade(C18:C22,D18:D22,E18:E22)+E23*0.025+0.999999)","v":82}]
[null,{"$f":"fungrade(B35)","v":"B"}]