Create Course Data Files

FYI: 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(10) 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(10) 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:

123|ENG56|EnglishLit|0.5|9|12

Still need help? Contact Us Contact Us