Run the copygradesv2.exe file or the .ahk script if you have AutoHotkey. You only need to do this once and can verify that the script is running by checking your system tray area. It will appear as a green icon with a white ‘H’.
Go to the spreadsheet and copy the class’s grades for the assignment that you would like to enter to the clipboard. The grades that you are copying should match up one-to-one with and be in the same order and number as the students in TEAMS.
Note: Please format your grades in columns because the script reads the grades line by line. Just copy the numbers, not the students names.
Navigate to TEAMS in the browser. Place your cursor into the top student’s grade box in the column for the assignment you are copying.
Now, press ctrl + alt + g. This will launch a dialog box showing you the contents of your clipboard. If all the grades are displayed, one on each line, press OK to start the copying process. If not, cancel, go back, and try to copy them again. The entire process should only take a few seconds.
Don’t touch the computer while the grades are copying, or else the process will not finish and could cause issues.
Verify that the grades have been copied properly by checking the first and last student to see if their grades match the Excel spreadsheet or Google sheet the grades were copied from.