version 2.7.1 6/01/2012
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:
- Colum 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.
Step 1: Choose [Import] from the Gradebook 2 Tools menu.
Step 2: Locate the TREC file you wish to import and click [Browse].
Step 3: Click [Next].
Step 4: 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 5: Enter a name for the item you are importing. This is the name that will be assigned to the item in the Gradebook.
Step 6: Click [Next].
Step 7: 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 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 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 will automatically be set to not be released to the student. 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 on the student’s name you wish to view and click the Comments tab.
Questions: Contact ETC Support at 245.5566 M-Th 8am - 10pm, F 8am-5pm.
If your login fails and you need help with your Net ID or password, contact ITAC at 245.4822.