1. Figure out the final grades for this class.
NOTE: Use < =ABS+(NB1+2)/10+PROJ/2 > and copy
down (ctrl d).
2. Figure out the averages for each assignment and for the final
grades.
NOTE: You will need to make the totals first.
Write < =sum(first square:last square) > and copy right (ctrl r) for
totals columns.
Then write < = total square/number of students > and copy right
(ctrl r) to find averages.
3. Print out the completed table.
| NAME | ABSENCES | NOTEBOOK 1 | NOTEBOOK 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 |