Import Scores from a File

On this page:

Use this procedure to import scores from either a text or CSV file. For details on input file formats, refer to Supported File Formats below.

Import scores from a file

1. From

   

   Gradebook, select Entry to display the Gradebook Entry page.
2. If you are in SBGB Summary Mode, click

   

    for GB Entry mode or

   

    for SBGB Detail mode on the mode selector

   

   .
3. If you need to update the class or marking period, click Change to display the Class List, and make your selections.
4. If the assignment is not displayed on the assignment header, select the appropriate category or mark type in the Competencies and Marks filters or the Categories and Marks filter.
   
   • If the assignment header displays 

     

     , the assignment is graded by rubric, and scores cannot be imported using the steps below. Refer to Rubric Score Entry for information on importing rubric scores from a file.
     Note: If 

     

      displays in a cell or group of cells, scores cannot be entered in these cells because the assignment is associated with a rubric, the student was not enrolled in the class on the assignment's due date, or multiple classes are being displayed and the assignment did not apply to this student.
5. Click  

   

    in the assignment's header to display mass update options.
6. Click Import Scores From File to expand the import menu.
7. Select the input file.
8. Select the File Format.
9. Enter the input Column Numbers or Positions.
10. To override existing scores, check Override Existing Scores.
11. If the input file has a header row, check File has Header Row.
12. Click Import.
13. When the import is complete, the Import Summary dialog displays indicating the number of students for whom scores were loaded and the number of active students. If the number of imported scores is not equal to the number of active students in the class, then some students may not have scores in the input file.
    If you selected to override existing scores, a note also displays in the Import Summary dialog.
14. Click Close on the Import Summary dialog.
15. When finished:
    • If you've enabled Auto Saving, you're done. For more information about Auto Saving, refer to the Settings topic in the online help system.
    • Otherwise, click Save.

Supported File Formats

On the Gradebook Entry page, you can enter student assignment scores from an external CSV (Comma Separated Values) or text file. This topic describes the input file requirements.

Input files must contain fields for both the Student ID and the score to be entered. For CSV files, you are prompted for the student ID and score column numbers. For a Text file, you are prompted for the field positions.

CSV Files

Since CSV files are not formally-specified, a variety of implementations exist. For the Gradebook Import Scores From File option, CSV input files must meet the following criteria:

• The file can include a header row. If the CSV file has a header row, check File has Header Row when importing.
• The file can include multiple fields, but it must include fields for Student ID and the score to be imported.
• The file must use commas as a delimiters.
• Quotes are not permitted in fields.
• If spaces are present in a field, they are read during import.

How CSV files are read by the Import Scores from File option

• Since quotes are not permitted, fields cannot include commas (each comma delimits a new field).
• Scores are not checked when read from a CSV file. Any invalid scores are flagged after entry to the Gradebook Entry page.

Example file:

The example below has a header row, five columns, and six student records. The Student ID is in column 2, and the student's score is in column 4.

Grade,Student ID,Student Age,Score,Homeroom
10,107769,15,92,4C-117
10,106732,16,C,4C-117
11,102531,16,88,3B-222
9,109441,14,77,2A-247
10,105321,15,A,4C-119
10,107621,15,69,4C-117

For this input file, the Import Scores From File selections would be:

Text Files

Text files can include a header row. If the file has a header row, check File has Header Row when importing. All data is referenced by a record's horizontal position, so each field must contain the same number of characters.

How text files are read by the Import Scores from File option

• If a text file record has no data in any of the specified Student ID Positions or Score Positions, an error is generated.
• Scores are not checked when read from a text file. Invalid scores are flagged after entry to the Gradebook Entry page.

Example file:

The example file below holds the same student and score information as the above example and likewise includes a header row. Since data is stored by position in text files, each field selected for input must have the appropriate number of characters to be read properly. In this example, the header row lists each field's position.

Grade (1-2) Student ID (3-8) Student Age (9-10) Score (11-12) Homeroom (13-18)
1010776915924C-117
1010673216 C4C-117
1110253116883B-222
0910944114772A-247
1010532115 A4C-119
1010762115694C-117

For this input file, the Import Scores from File selections would be: