Developers
May 1, 2023The developers for this plugin are:
Upgraded by: (SPRING 2023)
Tier Comp
Documentation for Tier Comparison
The tool was implemented to make the life of professors easier. The tool is for reading the Google Sheets sheet with the grades, in other words, the grade book. The grade book will be analyzed and will sort all of the grades between tiers in the document. Then, the program is going to create issues for those who have green, yellow, and red tiers. The professor is going to edit the message that wants to be sent, and after that, the issue will be created.
Run the file for `ReadWriteGoogleSheet` by running the command `python ReadWriteGoogleSheet.py`. To make sure that the file is sorting the data correctly. The data that needs to be displayed are the Github usernames and the grades that they had for the assignment that is being analyzed. This is inside the Tier-comparison repository.
After making sure that it works correctly, you can start the Github actions in the Tier Tester main.yml. This will post the issues and show the Github usernames with their grades and tier.
Now in the ReadWriteGoogleSheets file you should be able to change the cells that need to be analyzed, in this case we have `C2:C5`. Then you can change the value of the letter that is inside the f-string, depending on the cells that are being analyzed.
grades = 'C2:C5'
sheet.format(f"C{cell.row}",{"backgroundColor": {"red": 0.0,"green": 1.0,"blue": 0.0}})
The features that this plugin provides: