7 minutesBefore you begin, for a reminder on the file structure notes and automating subsequent exports, check out Create student data files.
Build the course data files by following the format indicated below.
StudentCourses (.txt or .csv)
This file contains student credit history (with marks), courses in progress, and scheduled courses for the next semester (if applicable).
| Column Name | Type | Description |
|---|---|---|
| StudentID | char(20) | Student who took the course, must be listed in Student Table above. |
| CourseCode | char(50) | Code of course taken. |
| CourseName | char(100) | Name of course taken. |
| GradeLevel | Int |
Highly recommended. The grade that the student has taken the course. If this is not supplied, the grade level is calculated based on the DateCourseComplete column and may be incorrect for special cases such as summer school courses. Note: If the Grade Level column cannot be provided (highly recommended), then the optional DateCourseComplete column must be included. |
| GradeMark | char(5) |
The grade the student achieved in the course (0 if in progress or transferred course).
Note: Do not include interim or temporary grades here as they will be visible to the student. |
| CreditValue | Numeric | Credit value of the course (e.g. 0.5, 1, 2). Set to 0 if failed course. If the course is in progress or scheduled, input credit value as if the course were achieved (courses in progress can also be 0). |
| OPTIONAL COLUMNS | ||
| DateCourseComplete | Int |
Format yyyy-mm-dd. Date the course was completed or will be completed. Blank or null values will default to the end of the current school year (July 1st).
Note: If the GradeLevel column is provided (highly recommended), the DateCourseComplete column is not needed. |
| HSCourse | Int | 0 = no; 1 = yes. Is this course applicable to high school? Many districts allow students to take courses in middle school that meet high school graduation requirements. Default would be yes for all high school students - this is only applicable to middle school student courses. |
| CoursePart | char(5) | In some systems it may be necessary to identify the course part. A yearlong course might only receive partial credit. For example, a student might pass first semester but fail second semester. If the CourseCode is the same we might need CoursePart to determine which section needs to be taken again. |
Example:
1005252|ENG56|EnglishLit|2016-06-15|79|0.5
CourseCodes (.txt or .csv)
This file is a list of all courses offered for the upcoming year. If the upcoming year is not yet available, then it should reflect the current course offering. CourseCodes is only required from high schools.
| Column Name | Type | Description |
|---|---|---|
| SchoolCode | char(15) | The code of the school (see School table) where the course is offered. |
| CourseCode | char(50) | The course code from the course curriculum. The course code should be unique within a school and what is visible on a student's transcript. |
| CourseName | char(250) | Course name or title. |
| CreditValue | Numeric | The number of credits student receives upon successful completion of course. |
| GradeLower | Int |
If the course is offered to multiple grades, specify the lowest grade level the course is offered.
If only a single grade is offered, set both GradeLower and GradeUpper to the same value. |
| GradeUpper | Int |
If the course is offered to multiple grades, specify the highest grade level the course is offered.
If only a single grade is offered, set both GradeLower and GradeUpper to the same value. |
Example:
SchoolCode|CourseCode|CourseName|CreditValue|GradeLower|GradeUpper
123|ENG56|EnglishLit|0.5|9|12
Back to top
