Easy Class Participation Tracking, Grading, Rubric Generation, and More with Excel
One of my classes this semester requires me to track how often students speak in class, and evaluate each comment. I also have students leading discussion, and I need to be able to generate completed rubrics easily for them so they get my feedback.
I’ve found that I can keep track of all of this in an Excel Spreadsheet on my iPad Pro, and that I can also use Excel to generate individual rubrics and a class wide participation report.
Here’s an example workbook that you can download and modify, and some screenshots that explain how it works.
Hopefully you find the spreadsheet useful – I know I have in just the 2 weeks I’ve been using it. It’s saved me a lot of administrative work, enabling me to do more “fun” pedagogical stuff in class!