Notes on using Excel for Grade Sheets
The cells are labeled as A1 - A999, B1 - B999, etc.
To get the average of 3 cells, D5, E5, F5, you can use =SUM(D5:F5)/3
To get a weighted sum of two cells D5, E5 where D5 is the homework grade for 20% and E5 is the exam grade for 80%, you can use =D5*0.2+E5*0.8
To count the number of entries automatically, you can use
=COUNT(D5:F5) |