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.

TCU-specific Documentation Tags

acceptable access accessibility accessible accommodations activate activate course activities ada additional additional time adjusted final grade android annotations announcements anonymous app apple apps assignment grader assignments athlete attachment attendance audio auditor banner best practice best practices 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 e-rater email email all classes email groups embed end date engagement english enroll enrollment enrollments event log event logs exam exams exclude exempt exempt grade exemptions 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 grade final grades force locale french GA gardes google drive gradebook grade item grade items grademark grades grade scheme grading grading system group chat groups guest hide 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 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 pass/fail password pedagogical points peoplesoft permissions personalize photo platform requirements points 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 release grades replace strings reply-to report request request bookmark reset reset quiz respondus restore restricted restrictions roles role switch rubrics scantron schedule scorm section change sections selectbox self-enroll self assessments set dates settings setup wizard shared shared shell shell shuffle snapshot solution spotlight sos spanish special access special class start date statistics student student grades students study abroad submission folder submission view submission views surveys TA table of contents teaching assistant technical requirements template test text text grade item 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 visibility web conferencing weighted widget widgets