Grade Book Import

• Click Download Sample File. The system generates a formatted file with the student information pre-populated.

• Select the Instructions tab. It displays instructions on how to complete the import process.

NOTE: The import template worksheet already contains the list of student names and the SIS IDs for your convenience. If you wish to import multiple assignments just copy and paste the student rows. The Instructions tab lists the available Measure Types and Subjects that can be used for your file import. Be sure the Import Template matches one of these values. To correlate to multiple report card rows, separate them with two bar characters (||). EX. MATH||GEOMETRY

• Complete the Import Template tab of the file.

NOTE: If importing more than one assignment, the students’ names and student IDs can be copied and repeated on the worksheet.

Scores can be entered either using percentages (ex: 90%) or using points earned/points possible (90/100). When using percentages, the ‘Points’ value of the assignment is set to 100. When using points earned/points possible, the ‘Points’ value of the assignments is set equal to the points possible entered on the worksheet. No other score types are supported at this time.

The assignment name, assignment description, measure_type, assignment_date, and subject fields must be completed for each line that is to be imported. If these fields are not complete, the corresponding lines) will not be imported.

• Save the Excel file.

• On the Grade Book Import screen, click Browse.

• Select the file and click OK.

• Select upload options in Upload Import File.

Add Assignments Not Found in Current Class - Only imports assignments that do not currently exist in Grade Book for the class in focus.

Ignore Unknown Columns in File - Ignores any columns not required by the import tool.

Overwrite Existing Score – Overwrites any existing scores found for the assignment.

• Click Upload Import File. When the system uploads the file, any errors with the file or format display.

NOTE: In the Review Import File box, the status displays the number of errors, if any. In the Import File Status box, each error displays, identifying the error and the row number where the error is located on the import file.

• Resolve any errors. Once all errors have been resolved, the Review Import File status changes to OK. Ready for Import and the Import Data button become available.

• Click Import Data. Once the import is complete, the Import File Status changes to OK: File Import Success!

The assignment and score display on Grade Book Main, tied to the appropriate grading periods, as defined in Grading Setup.