Creating Excel Spreadsheets for Grading
This workshop explores different methods of using Excel to calculate student grades. In addition to calculating weighted averages, we discuss methods of dropping the lowest grade, and assigning letter grades based on numeric average grades via a lookup table. Finally, we cover various dynamic means of assessing the performance of entire class by using charts and summation functions.
The workshop will be hosted on Zoom or WebEx.