Texas State University Logo
Banner Image
ETC Support
Phone: 512.245.5566
M-F 8 a.m. - Midnight
S&S Noon - Midnight


Join the Conversation

adjust type sizemake font smallermake font largerreset font size

Import Scores from TREC

version 2.9.3 1/06/14

The Gradebook 2 tool is able to import .CSV files containing scores and comments from the Testing, Research Support and Evaluation Center (TREC)

When importing grades from TREC into Gradebook 2

  • Column headers in the TREC file must not be changed. Grades, comments and other data in the file itself can be changed, but column headers must not be modified. If column headers are changed, you will receive an error during the import process.
  • If a student does not provide their correct Texas State ID (A#) on their Scantron form, their scores will not be imported into Gradebook 2. Students who cannot be imported will be identified during the import process.
  • The file type must remain .CSV. Other file types cannot be imported into Gradebook 2.
Expand or Collapse all.

Import Grades from TREC

Play button

Step 1: In the Gradebook Overview screen, click [Tools] and select [Import].
Step 2: Select "University Testing Center" from the Import Format drop-down menu.

Step 3: Click [Browse] and locate the TREC file you wish to import. Click [Open].

NOTE: If you received your scores .CSV file in an email from the Testing Center, you must download the file to your computer before attempting an import.

Step 4: Click [Next].
Step 5: An alert box will appear if any entries do not match students enrolled in the course. Click the [X] at the top-right corner to close the alert box.
Step 6: Enter a name for the item you are importing. This is the name that will be assigned to the item in Gradebook 2.
Step 7: Click [Next].
Step 8: Enter the maximum point value you wish to assign to the item. The default value is 100.
NOTE: Grades imported from the TREC file will always be imported as a percent. In a points-based Gradebook 2, points are calculated by multiplying the score earned by the total points possible. For example, if a student’s score was 77% (as imported in the TREC file) and the item is worth 150 points (as designated in step 7) the calculated score would be 115.5 [.77 * 150 = 115.5].
Step 8: Click [Finish].
Step 9: If your Gradebook 2 has been setup to use Categories, you may choose the category you wish to assign the grade to in the Category column. Click on the category in the column and assign it appropriately.
Step 10: Click [Next].
Step 11: Click [Done].

The grades that are imported are automatically not released to students. You must change this setting if you wish to make the score be visible to students. Any comments that were included in the import file will be available to students in the Comments tab. If you wish to view the comments, click a student’s name and click the Comments tab.