Data Importer: Numeric Grades

Overview

The Veracross Data Importer allows schools to import numeric grades for students. Upon importing, if the student does not yet have a class enrollment or numeric grade record created, this process will create one for them. If a student already has a grade record for this assignment/exam, it will only be overwritten if:

  • the grades are not yet posted
  • the grade is not qualitative

Uploading Numeric Grades involves the following two steps:

  1. Preparing the data for upload using the Numeric Grades template, which is provided before data import on the Importer site.
  2. Uploading the data using the Veracross Data Importer.

Preparing the Data for Upload

The user must prepare a comma separated value (CSV) file containing all data to import. This file must contain all of the required columns in the order listed below, even if no content is populated in the columns. If there is no content in a column, that row must be left blank.

Fields in the Template

Required fields are marked with an asterisk (*). For this import template, there are a couple “either/or” scenerios for required fields that are as follows:

  • either person_id
    OR
    person_reference_type 
    and person_reference_value

and

  • either internal_class_id
    OR
    class_id and school_year
person_id Numeric. The person_id can be found in the Person ID field in a standard Find Person query.

Either the person_id field or both the person_reference_type and the person_reference_value field must be populated per row.

person_reference_type Must be an already existing person reference type. This information can be in a Person Reference Type query. Must be either of the following:

  • person reference type id (numeric)
  • person reference type description (text/numeric)

Either the person_id field or both the person_reference_type and the person_reference_value field must be populated per row.

person_reference_value

 

Text/numeric. This value is the person reference number ID in a Find Person Reference Number query.

Either the person_id field or both the person_reference_type and the person_reference_value field must be populated per row.

internal_class_id Numeric. The internal class ID for the class the grade record applies to. This number can be found as the Internal Class ID field in this Find Classes query.

Either the internal_class_id field or both the class_id and the school_year field must be populated per row.

class_id Numeric. The Class ID for the class the grade record applies to. This number can be found as the Class ID field in this Find Classes query.

Either the internal_class_id field or both the class_id and the school_year field must be populated per row.

school_year The school year in which the class takes place. May be in one of the following formats:

  • Year ID (numeric — located here as the “Year” field)
  • Year description (text/numeric — located here as the “School Year” field)

Either the internal_class_id field or both the class_id and the school_year field must be populated per row.

grading_period* The grading period that the grade record is set for. May be in one of the following formats:

  • Grading Period ID (numeric — located here as the “ID” field)
  • Abbreviation (text/numeric — located here as the “Abbreviation” field)
assignment_posted_grade Numeric. The numeric grade for the assignment.
exam_grade Numeric. The numeric grade for the exam.
posted_grade Numeric. The posted numeric grade, if the assignment has a numeric grade.

This cannot be populated if the “status” column is populated for this row.

status The grade status to be imported in case of non-numeric grades. May be in one of the following formats:

  • Grade Status ID (numeric — located here as the “ID” field)
  • Abbreviation (text/numeric — located here as the “Abbreviation” field)

This cannot be populated if the “posted_grade” column is populated for this row.

other_grade_1 The first (or only) other grade type, if your school has this functionality configured. May be in one of the following formats:

  • Other Grade ID (numeric — located here as the “Other Grade ID” field)
  • Abbreviation (text — located here as the “Abbreviation” field)
  • Description (text/numeric — located here as the “Description” field)
other_grade_2 The second other grade type, if your school has this functionality configured. May be in one of the following formats:

  • Other Grade ID (numeric — located here as the “Other Grade ID” field)
  • Abbreviation (text — located here as the “Abbreviation” field)
  • Description (text/numeric — located here as the “Description” field)
comments Text. The comment field on the grade record.

Performance Notes

There are additional things to consider when using this import type:

  • each combination of person_id/internal_class_id/grading_period can only have one row per import, or else the import will fail
print