Uploading Grades from Schoology to TAC

Two of the most common ways to distribute class information to students is either Google Classroom or Schoology (sorry Moodle peeps). And one of the biggest headaches involved with these systems is the transferring of grades into our school's Student Information System (SIS) called Teacher Access Center (TAC), powered by eSchools and SunGard. In fact, many of you may not even use the grade book features on other platforms because they don't sync with your grade book. Now I know, I know. Many of you educators out there may have a fully integrated system where your grade book magically syncs up. But for those of us in this world of piecemeal technology, we need to be able to take advantage of the grade book features available to us in Schoology or Classroom (although Classroom grade book is arguably not a grade book really, but you get my point.)
So, how do we get these grades to transfer without having to enter them by hand in Schoology?
The answer can be found in this short tutorial video and set of directions I created. Enjoy!
And how do we get these grades to transfer in Google Classroom? Watch and Read HERE

Transferring Grades from Schoology to TAC

Instructions from the video (if you like to read instead)

  1. Create an assignment in TAC
  2. Store the Class Student Names and Student ID numbers in a spreadsheet (Sheets or Excel)
  3. Open the Gradebook for your Schoology Course.
  4. Select the 3 Dots or Menu button in the top right corner and select "Export" 
  5. Choose "Gradebook as CSV" as your export type and then click "Next" 
  6. Open the downloaded CSV file. Select "File", then "Save as Google Sheets" to edit and include missing student ID #'s      
  7. 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 the column labeled "Unique User ID". This means your ID #'s will be in Column C and all of your score columns will be from Columns F to the end.
  8. 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.
  9. Go back to your TAC gradebook. Select the Mass Edit Button () , then select your CSV file created in step 8 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 "3" (numeric equivalent to Column C) in the "Student ID Column Number" box and the number that corresponds with the score column you want(Column G equals 7 and so on) 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.)                                                                      
  10. Lastly, save your scores before exiting.

Popular Posts