Creating Excel Spreadsheets for Grading
Teaching with Technology Workshop
Event Description
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.