| Purpose | Loads courses that have been previously taken by students so that these courses will appear in students’ course plans. |
|---|---|
| Filename | historical_student_courses.csv |
| What to Include | All courses previously taken for students using Course Planner and all current 12th-grade students. Include all courses taken, even if the student did not pass the course. |
| What to Exclude | Exclude all records for students who are not “currently enrolled”. Elementary courses do not need to be included. Courses taken in grades 6-8 can be excluded if you are not using Course Planner for middle school students, and the middle school courses do not get used for high school placement or credit. |
| Minimum Upload Frequency | During initial Course Planner configuration, and again immediately before students begin using Course Planner. |
| Recommended Upload Frequency | Nightly to ensure that any changes to student courses in your SIS are updated in SchooLinks. |
| Partial Data | Partial data is not supported. You must send the entire set of data each time the file is sent. Any previously included courses that are not included in a later upload will be removed. |
Choose the template that matches how you intend to pass student identifiers. If you are unsure which identifiers to use, check the Example Identifiers tab in the Data Upload tool on SchooLinks to see which identifiers have data loaded that match what you’ll be exporting.
student_number
historical_student_courses.csv
student_sis_id
historical_student_courses.csv
| Column Name | Required | Data Type | Description |
|---|---|---|---|
student_number OR student_sis_id |
REQUIRED | STRING | The type of identifier must match the column name being used (an SIS ID, or student number). |
Indicates the student this course is for. ****
20 characters maximum length. |
| course_id | REQUIRED | STRING | The course ID for the course taken by the student. For courses your district offers, should match the course_id specified in the course master data. ****
For transfer courses, may be an identifier that does not exist in your course master.
64 characters maximum length. |
| course_name | REQUIRED | STRING | The name or title of the course.
100 characters maximum length. Quoted if it contains commas. |
| course_subject | OPTIONAL | STRING | The subject area of the course, which can be used for courses that do not appear in your course master.
100 characters maximum length. Quoted if it contains commas. |
| school_year | REQUIRED | INTEGER | The school year the course was taken in, using the ending year. Always passed as a 4-digit year.
For example, for a course taken during the 2022-2023 school year, pass 2023 in this column. |
| grade_year | REQUIRED | INTEGER | The grade year in which the student took the course. ****
Examples include 9, 10, 11, etc. |
| academic_term | REQUIRED | INTEGER | The academic terms this course was taken in, based on the number of academic terms configured in your Course Planner configuration.
Examples: 1 for a full-year course (starts in the first semester), 1 for a course taken in the Fall, 2 for a course taken in the spring. |
| credit_awarded | REQUIRED | FLOAT | The amount of credit actually earned by the student for this course. ****
Should indicate the amount of actual credit awarded, and should be 0 if no credit was awarded.
If a course was taken and completed in a previous semester for the current school year, you must pass the credit awarded or the course will appear as failed. |
| grade_achieved | OPTIONAL | STRING | The numeric grade or letter grade achieved for this course. |
| numerical_grade_achieved | OPTIONAL | FLOAT | If the grade_achieved is a letter grade, this value can provide the numeric version of the earned grade. |
| outside_credit_type | OPTIONAL | STRING | One of: middle school, external, or blank. ****
When blank, this course will appear as taken or planned in an actual academic year. ****
When specified, this will prevent a course from taking up credit in an academic year (credit will still count for graduation). |