Importing transcript records to Gradelink can be done in just a few clicks. The key to success is ensuring your data is extremely clean and normalized. Like tidying up a room or garage by sorting everything into properly labelled bins, cleaning up data ensures records are easy to retrieve and reporting is accurate.
- Ensure any student accounts associated to the transcript records you import have been added or imported to the Students page.
- Download the import template, a .csv (comma separated value) formatted file.
- Paste your date into the template. Below are the columns and what should go in them.
- Save the template file, and drag it to the Upload area.
- If Student IDs you pasted came from Gradelink rather than another system, check the box "Student IDs are from Gradelink"
- Click Submit
If any errors are detected in your upload, the import gets completely aborted (no records imported) and we'll present a returned .csv file that includes specific error notations.
Field | Examples | Required? | Explanation |
| TermTitle | Quarter 1 2023-2024 Trimester 1 2023-2024 Semester 1 2023-2024 | Yes | Comprehensive title of an individual term the student earned a grade in. Ensure the school year is included. |
| TermStart | 08/01/2023 | Yes | Start date of the term. Approximate dates are acceptable, but ensure the terms are in the correct chronological order. |
| TermEnd | 10/15/2023 | Yes | End date of the term. Approximate dates are acceptable, but ensure the terms are in the correct chronological order. |
| ClassTitle | Biology 101 Mathematics 7 Honors English | Yes | Comprehensive class (subject) title. |
| ClassType | Standard Credit | No | Standard class type will be assumed for most classes earning a letter grade. Enter "credit" for classes that only give Credit (CR) or No Credit (NC) for passing or failing. CR/NC gets removed from GPA calculation. |
| ClassUnits | 1 0.5 | No | Weight that this class has in GPA calculation. If unspecified, default value of 1 will be used. |
| EarnedUnits | 1 0.5 | No | Units earned by the student for this term's grade. Typically matches value of ClassUnits, or 0 if student received "F" |
| SISStudentID | 123456 | Yes | Student's unique ID number from originating system. If no prior ID available, enter student's Gradelink ID. |
| GradeLevel | 10 PK TK | Yes | Student's grade level when the grade was earned. |
| LetterGrade | B+ S X | Yes, unless PercentageGrade entered | Letter grade symbol must exist in at least one of your school's grade scales. Not required if PercentageGrade entered. |
| PercentageGrade | 88.3% | Yes, unless LetterGrade entered | Only required if LetterGrade is not entered |
| AlternativeGrade | Inc W D | No | Used for overridden grade such as Incomplete (Inc), Withdrawn (W) or Dropped (D) |
| GPABoost | 1 | No | Used for Honors or AP courses, typically 0.5 or 1.0. Not required if GradeScaleName is "Honors" |
| GradeScaleName | Standard Honors Kinder | No | If unspecified, A-F grades will be assigned "Standard" gradescale; "Honors" will apply configured GPA boost value even if one isn't specified in GPABoost. |