Grades: Import Grades from a .CSV File or Scantron Grades from a .XLS File

If you have grades saved in a .CSV file, or scantron grades in a .XLS file, and wish to import them into your TCU Online gradebook, you can use the Import function.

Scantron test results are emailed to the Instructor of Record as an .XLS file. Contact TCU IT for information about Scantron procedures and support.

The steps below assume that your TCU Online grade items have already been setup.

  1. Select Grades from the Navigation bar.
  2. Select Enter Grades.
  3. Select the Export button to prepare and export a TCU Online compatible and properly formatted CSV file.
    Select Export
  4. Choose the Key Field, Grade Value, User Details, and Grade Item Type to include in the spreadsheet. All grade items should be checked. Click Export to CSV.
    Export to CSV
  5. A pop up window will appear indicating that your .CSV file is ready. Click the Download button to download the prepared file.
    Export Download File
  6. Locate the TCU Online .CSV file on your computer (likely in your Downloads file) and open it in Excel.
  7. Sort this TCU Online .CSV file to prepare it for copy/pasting your grades into it. The following is recommend:
    1. Select Row 1 and then select Wrap Text so your column headers (assignment titles) are easy to read.
    2. Select the entire worksheet, then sort  by last name (column B) A to Z. Make sure you check the box for “my list has headers” so row 1 stays at the top. Your student data should now be alphabetized by last name A to Z.
  8. Now, open your .CSV or Scantron .XLS file that contains the grades you wish to import. containing your Scantron grades. Make sure that these grades are also sorted and listed in alphabetical order by last name A to Z.
  9. 9. Select and copy the grades for your file. Then paste them into the appropriate grade item column of the downloaded TCU Online .CSV file.
  10. Be sure to spot check the TCU Online .CSV file to make sure that the appropriate grades were added in the correct order. Once confirmed, save the file as a CSV.
  11. Return to the Enter Grades area of your TCU Online gradebook.
  12. Select Import.
  13. Select/choose the .CSV file from your computer then click Continue.
    Import Grade file
  14. On the page that follows, any errors will appear. Click Continue.
  15. On the next page, a preview will display showing which grades you are importing. If everything looks as expected, click Import.
  16. The Grades tool will return to the Enter Grades page displaying the updated gradebook including the newly imported grades.

 


Learn about other Options for Entering Grades within TCU Online.

TCU-specific Documentation Tags

acceptable access accessibility accessible accommodations activate activate course activities ada additional additional time android annotations announcements anonymous app apple apps assignment grader assignments athlete attachment attendance audio auditor banner best practice binder blind marking bonus bookmark bookmarks calendar cancelled course categories category chat class engagement classlist class progress combined combined shell completion tracking content content statistics content tool copy copy course course access course admin course home course offering course shell course snapshot course title crash course data dates design disability discussion discussions document storage draft dropbox dropped email email all classes email groups embed end date engagement english enroll enrollment enrollments exam exams exempt exempt grade export export grades extend access extension extra credit extra time Facebook faq far feedback file file extensions files file size file types final adjusted grades final calculated grades final grades force locale french GA google drive gradebook grade item grademark grades grading group chat groups guest history homepage homepages hours tracking html html editor html template html templates hyperlink import import grades inactive individual insert stuff instructor instructor presence instructors intelligent agents iOS item items journal journals kanopy known issue language library database limit link locale lockdown browser locker Log In login bookmark LOR manage dates master courses math missing class modules monitor mytcu name new faculty notifications offset offset dates originality overview password peoplesoft permissions personalize photo platform requirements post practice run preferences preview grades professor published pulse question library question pool questions quick link quicklinks quiz quiz import quizzes random sections record video release conditions replace strings reply-to report request request bookmark reset reset quiz respondus restricted roles role switch rubrics scantron schedule scorm section change sections self-enroll set dates settings setup wizard shared shared shell shell shuffle snapshot solution spotlight sos spanish special access special class start date student student grades students study abroad submission folder submission view submission views TA table of contents teaching assistant technical requirements template test text time tips tool access trademark turnitin twitter update profile updates upload content user profile user progress verify enrollments video video note view as student viewer virtual classroom visibility web conferencing widget widgets