{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":31,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":54,"n_cols":24,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"Please enable the macros in order for the worksheet to display the correct result."]
[null,null,"   Please Select ALL Items Collected"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The lowest quiz score is dropped",null,null,null,"Quiz",null,null,"Quiz Score"]
[null,null,"            Quizzes & Homeworks:",null,null,null,null,null,null,"Q 1","Q 2","Q 3","Q 4","Q 5","Q 6","Q 7",null,null,null,"TOTALS"]
[null,null,null,null,null,null,null,"Your Scores",null,0,0,0,0,0,0,0,null,null,null,{"$f":"SUM(J6:P6) - MIN(J6:P6)","v":0},null,null,{"$f":"IF(T8=0,0,100*(T6/T8)*N46)","v":0}]
[]
[null,null,null,null,null,null,null,"Max Scores",null,0,0,0,0,0,0,0,null,null,null,{"$f":"SUM(J8:P8) - MIN(J8:P8)","v":0},null,null,{"$f":"IF(T8=0,0,100*(T8/T8)*N46)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Homework",null,null,"Homework Score"]
[null,null,null,null,null,null,null,null,null,"HW 1","HW 2","HW 3","HW 4","HW 5",null,null,null,null,null,"TOTALS"]
[null,null,null,null,null,null,null,"Your Scores",null,0,0,0,0,0,null,null,null,null,null,{"$f":"SUM(J11:N11)","v":0},null,null,{"$f":"IF(T13=0,0,100*((T11/T13)*N45))","v":0}]
[]
[null,null,null,null,null,null,null,"Max Scores",null,0,0,0,0,0,null,null,null,null,null,{"$f":"SUM(J13:N13)","v":0},null,null,{"$f":"IF(T13=0,0,100*((T13/T13)*N45))","v":0}]
[]
[]
[null,null,"Module # Posts & Assignments:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Module #",null,null,"Lesson Score"]
[null,null,null,null,null,null,null,null,null,"Intro","M2_P","M3_UC","M3_US","M4_A","M5_P","M6_A","M10_P",null,null,"TOTALS"]
[null,null,null,null,null,null,null,"Your Scores",null,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(J18:Q18)","v":0},null,null,{"$f":"IF(T20=0,0,100*((T18/T20) * N47))","v":0}]
[]
[null,null,null,null,null,null,null,"Max Scores",null,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(J20:Q20)","v":0},null,null,{"$f":"IF(T20=0,0,100*((T20/T20) * N47))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivery"]
[null,null,"             Project Deliverables:",null,null,null,null,null,null,"Del #2","Del #3*","Del #4",null,null,null,null,null,null,null,"TOTALS"]
[null,null,null,null,null,null,null,"Your Scores",null,0,0,0,null,null,null,null,null,null,null,{"$f":"SUM(J26:L26)","v":0}]
[]
[null,null,null,null,null,null,null,"Max Scores",null,0,0,0,null,null,null,null,null,null,null,{"$f":"SUM(J28:L28)","v":0},null,"Project","Prj_Score"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(IF(T28=0,0,(T26/T28)*0.4)+(IF(T35=0,0,T33/T35)*0.6))","v":0},{"$f":"IF(V30=0,0,100*((V29/V30)*N50))","v":0},"==>Student"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(IF(T28=0,0,(T28/T28))*0.4+(IF(T35=0,0,T35/T35))*0.6)","v":0},{"$f":"IF(V30=0,0,100*((V30/V30)*N50))","v":0}]
[null,null,"                  Semester Project:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project"]
[null,null,null,null,null,null,null,null,null,".mov",".pptx",".docx","Prb Comp",null,null,null,null,null,null,"TOTALS"]
[null,null,null,null,null,null,null,"Your Scores",null,0,0,0,0,null,null,null,null,null,null,{"$f":"SUM(J33:N33)","v":0}]
[]
[null,null,null,null,null,null,null,"Max Scores",null,0,0,0,0,null,null,null,null,null,null,{"$f":"SUM(J35:N35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total %","Grade"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q38=0,0,100*((W6+W11+W18+W29+N48*J39+N49*K39+N51*L39)/Q38))","v":0},{"$f":"VLOOKUP(Q37,Cutoffs,2)","v":"F"}]
[null,null,"                  Tests & Final:",null,null,null,null,null,null,"Test 1","Test 2","Final",null,null,null,"Perfect",{"$f":"W8+W13+W20+W30+N48*J41+N49*K41+N51*L41","v":0}]
[null,null,null,null,null,null,null,"Your Scores",null,0,0,0]
[]
[null,null,null,null,null,null,null,"Max Scores",null,0,0,0,null,null,null,null,"Grade","Cutoffs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,"D-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hmwk",0.2,null,null,65,"D+"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Quizzes",0.2,null,null,70,"C-"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Posts/Assgn",0.05,null,null,73,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Test 1",0.15,null,null,77,"C+"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Test 2",0.15,null,null,80,"B-"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sems Prj",0.15,null,null,83,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Final",0.1,null,null,87,"B+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,"A-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,"A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"A"]