So, how do we get these grades to transfer without having to enter them by hand in Google Classroom?
The answer can be found in this short tutorial video and guide I created. Enjoy!
And how do we get these grades to transfer in Schoology? Watch and Read HERE
Instructions from the video (if you like to read instead)
- Create an assignment in TAC
- Store the Class Student Names and Student ID numbers in a spreadsheet (Sheets or Excel).
- Open the Assignment in Google Classroom
- Select the gear button in the top right corner and select "Download these grades as CSV"
- Open the downloaded CSV file. Select "File", then "Save as Google Sheets" to edit and include missing student ID #'s
- Make sure Google Sheet file is alphabetical by LAST NAME, then paste Student ID #'s from your class record created in Step 2. Paste the ID #s in front of column A by hovering your cursor over column A, clicking the button, then selecting "Insert 1 left". This means your ID #'s will be in Column A and your scores will be in Column E.
- With your Google Sheet complete with Student ID#'s, names, and scores from the Classroom assignment all loaded properly, select "File", then "Download as...", then "Comma-separated values". A new CSV file will download to your computer.
- Go back to your TAC gradebook. Select the Mass Edit button () below the assignment title. Then, select "Import Scores From File" in the pop up window.
- Select , then select your CSV file created in step 7 and click OPEN. Your CSV filename will then be listed next to the "Choose File" button. Click the bubble next to "CSV" FIRST, then enter "1" in the "Student ID Column Number" box and "5" for the "Score Column Number" box. Lastly, check the box next to "File has Header Row" and click Import. (A pop-up window will tell you something like "35 of 35 scores imported" (These numbers correspond with Column A (1) and Column E (5) in your CSV file.)
- Hit the save button on TAC to finalize the transfer.