These scripts have been validated for Python 3.8, though any Python 3.x version should work. They have been tested on Windows and Linux (Ubuntu).
- openpyxl - This library is not included in a standard python installation, and can be added via pip with the command 'pip install openpyxl' or by running 'python setup.py install'
- tkinter - This should be included in Windows python installs. If running on linux, you may need to run 'apt-get install python3-tk'
- Create a json grading rubric. There is a provided example ExampleRubric.json from an assignment a previous year
- Download the .zip of student assignments from MyCourses and place into an empty folder
- Run UnpackSubmissions.py and select the downloaded .zip. Then select the json rubric you would like to grade against
- Grade the assignments by marking how many points are deducted in each requirement and add comments. No value in the deduction column is counted as no point loss, comments are optional
- Run CombineGrades.py and select the main folder. It will combine all grading sheets into one Excel file named AllStudents.xlsx
- Copy the grade and comments into the MyCourses grading page. NOTE: You may need to double-click each comment in the master xlsx in order to properly copy the formatting (such as line breaks). This is a limitation of Excel.