Main.GradeAssignment History
Hide minor edits - Show changes to markup - Cancel
Kumi
Hanako
Airi
Kyoko
Yuya
chihirot
chihiroa
chihiroh
Kumi
Hanako
Airi
Kyoko
Yuya
chihirot
chihiroa
chihiroh
Kumi
Hanako
Airi
Kyoko
Yuya
chihirot
chihiroa
chihiroh
Kumi
Hanako
Airi
Kyoko
Yuya
chihirot
chihiroa
chihiroh
NAME ABSENCES NOTE 1 NOTE 2 TEST FINAL GRADE
NAME ATTENDANCE NOTE 1 NOTE 2 TEST FINAL GRADE
Use formula = ABSENCES + (NOTE 1+ NOTE 2) /10 + TEST /2
Use formula = ATTENDANCE + (NOTE 1+ NOTE 2) /10 + TEST /2
NAME ABSENCES NOTE 1 NOTE 2 TEST FINAL GRADE (PERFECT 30 60 140 100)
NAME ABSENCES NOTE 1 NOTE 2 TEST FINAL GRADE PERFECT 30 60 140 100
Copy down.
3. Print out the completed table.
3. Tell the average to me or an assistant to find out if you are right!
NAME ABSENCES NOTE 1 NOTE 2 TEST FINAL GRADE
NAME ABSENCES NOTE 1 NOTE 2 TEST FINAL GRADE
NAME ABSENCES NOTE 1 NOTE 2 TEST FINAL GRADE (PERFECT 30 60 140 100) tm 26 46 138 74 nr 22 49 134 74 nm 30 51 137 81 nn 0 44 60 74 nk 26 25 118 70 hk 30 53 126 77 bk 22 59 140 81 hk 18 47 95 62 totals averages
NAME ABSENCES NOTE 1 NOTE 2 TEST FINAL GRADE (PERFECT 30 60 140 100) tm 26 46 138 74 nr 22 49 134 74 nm 30 51 137 81 nn 0 44 60 74 nk 26 25 118 70 hk 30 53 126 77 bk 22 59 140 81 hk 18 47 95 62 totals averages
1. Figure out the final grades for this class.
1. Figure out the final grades for my speaking class!
NOTE: Use formula = ABSENCES + (NOTE 1+ NOTE 2) /10 + TEST /2 and copy down (ctrl d).
Use formula = ABSENCES + (NOTE 1+ NOTE 2) /10 + TEST /2 Copy down.
Use sigma and copy right (ctrl r) for totals. Use < = total square/number of students > and copy right (ctrl r) for averages.
Use sigma and copy right for totals. Use = total / number of students and copy right for averages.