| Purpose | Loads courses that have been previously taken by students and courses students are currently enrolled in so that these courses will appear in students’ course plans. |
|---|---|
| Filename | student_courses.csv |
| What to Include | All courses previously taken or currently being taken for students that will be using Course Planner, and for all current 12th-grade students. Include all taken courses, even if the student did not pass the course. |
| What to Exclude | 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
student_sis_id
| 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. ****
64 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 (or started in for courses lasting more than one term), 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. ****
For historical courses, should indicate the amount of actual credit awarded, and should be 0 if no credit was awarded. ****
For currently enrolled courses, this field should be blank. Courses passed in the current school year in the most recent term will be automatically detected as a currently enrolled course and the credits ignored.
If a course was taken and completed in a previous semester for the current school year, this course is considered historical and you must pass the credit awarded or the course will appear as failed. |
| credit_remaining_possible | OPTIONAL | FLOAT | For courses a student is currently enrolled in, can indicate the possible credit the student could earn on completion of the course. |
| grade_achieved | OPTIONAL | STRING | The numeric grade or letter grade achieved for this course. May be left blank for currently enrolled courses. |
| 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). |