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. On the nav bar, click the Assessment menu, then select Grades.
    Grades on Nav Bar
  2. Click the Enter Grades tab.
    Enter Grades
  3. Select the Export button to prepare and export a TCU Online compatible and properly formatted .CSV file.
    Export Grades
  4. Choose the Key Field (we recommend Org Defined ID), Grade Value (we recommend Points Grade), User Details (we recommend Last Name and First Name), and Grade Item Type to include in the spreadsheet. All grade items should be checked, but you can uncheck grade items you don’t want to import.

    Export Grades Options

  5. Click Export to CSV.
    Export to CSV
  6. A pop-up window will appear indicating that your .CSV file is being processed. Once you receive the complete status, your file is ready to download. Click the Download button to download the prepared file.
    Export Download File
  7. Locate the TCU Online .CSV file on your computer (likely in your Downloads file) and open it in Excel.
  8. Sort this TCU Online .CSV file to prepare for copying and pasting your grades into it. The following is recommended:
    1. Select Row 1 and then select Wrap Text so your column headers (assignment titles) are easy to read.
    2. Select the last names of the students, 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.
  9. Do one of the following: Copy Grades from Another Source or Enter Grades Manually. See the sections below for the steps.

Copy Grades from Another Source:

  1. 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.
  2. Select and copy the grades for your file. Then paste them into the appropriate grade item column of the downloaded TCU Online .CSV file.
  3. 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.

Enter Grades Manually

  1. Enter the grades in the desired grade item column
  2. 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.

Import Grade File

  1. Return to the Enter Grades area of your TCU Online gradebook.
    Enter Grades
  2. Click on the Import button.
    Import Grades
  3. Click on the Choose File/Browse button, and then select the .CSV file from your computer.
    Import Grade file
  4. Check the box to Create new grade item when an unrecognized item is referenced if you added columns to the CSV file. Click on the Continue button.
    Create New Grade Item with Import
  5. On the page that follows, any errors will appear. If errors appear, reference to row numbers that caused the error are included.  Click Continue.
    Import Errors and Warnings
  6. On the next page, a preview will display showing which grades you are importing. If everything looks as expected, click Import.
    Import Preview Imported Grades
  7. The Grades tool will return to the Enter Grades page displaying the updated gradebook and including the newly imported grades.

 

Learn about other Options for Entering Grades within TCU Online.