Embedded Files
OBJECTIVE
While working as a Teaching Assistant for a statistics course at Oregon State University, I was tasked with aggregating student evaluations. Specifically, each student was required to submit peer reviews of their group members, which were formatted as tables in Word documents. My role involved consolidating these individual scores into a single spreadsheet and computing the average ratings for each student. This manual data extraction and entry process was not only time-consuming but also prone to human error. To streamline the workflow, I developed a Python program that automates the data retrieval and processing tasks. The program captures student evaluations submitted through a Google Form and auto-calculates the average scores.
Initial evaluation method
Revised evaluation method
How does it work?
The program takes in two CSV files: one downloaded from Canvas with student info, and another from raw data exported from Google Forms. Student scores are assigned by matching the names within each group. It outputs consolidated grades and comments for easy import into Canvas. Additional features include input error handling and customizable scoring parameters. Comprehensive documentation detailing these functionalities is provided below. The source code is also available on GitHub.
Program UI
Program Output
Tools used: Python, Google Forms, Excel
Google Sites
Report abuse