Easy Class Participation Tracking, Grading, Rubric Generation, and More with Excel
2 years ago 2 min read
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!