Just copy in your students names and the spreadsheet will calculate class and student averages automatically.
It takes into account students with missing marks (e.g. absent..) that they don't impact on the calculations.