Target Table: STUD_GRADES
Data Submission Schedule: 40 Day, 80 Day, 120 Day, End of Year (EOY), SUMMER (optional)
Grain: One record per district / location / school year / student / course / section / semester / marking period num (reporting period)
Load Sequence/Dependencies:
- COURSE
- STAFF
- STUDENT
Template Description – This template defines the Student Grades fact table for Middle and High School course. Student Grades can be submitted during every reporting period (40 Day, 80 Day, 120 Day, EOY) for which a grade pertains. If a grade and/or credit has not yet been earned for the course, then do not include this record. ONE final “Student Grade” record should be submitted per course/section corresponding with the latest reporting period enrollment record. One STUDENT GRADE record should be submitted for each “class,” which is identified as a unique combination of COURSE CODE plus SECTION CODE.
File Name Format: DDD_STUD_GRADES_YYYYMMDDHHMM.fff
File Name Format Example: 001_STUD_GRADES_201907071201.csv
| Field Number | Field Name | Data Type, Required, Code | Valid Values |
|---|---|---|---|
| 1 | DISTRICT CODE | Character, Required, Key | |
| 2 | LOCATION CODE | Character, Required, Key | |
| 3 | SCHOOL YEAR DATE | Date, Required, Key |
|
| 6 | REQUEST SEQUENCE | Character, Required, Key |
|
| 8 | STUDENT ID | Character, Required, Key | Enter 9 digit student ID |
| 9 | MARKING PERIOD NUM | Number (0 decimals), Required, Key |
|
| 10 | NUMERIC GRADE | Number, conditionally Required, Updateable | Final numeric grade a student received in a course. |
| 11 | ALPHA GRADE | Character, Conditionally Required, Updateable |
|
| 12 | PASS/ FAIL | Character, Conditionally Required, Updateable |
|
| 22 | SEMESTER | Character, Required, Key |
|
| 24 | CREDITS EARNED | Number (4 decimals), Required, Updateable |
|
| 26 | COURSE CODE LONG | Character, Required, Key | 8 digit course code |
| 27 | SECTION CODE LONG | Character, Required, Key | |
| 28 | CONDUCT GRADE | Character, Conditionally Required, Updateable | |
| 29 | COURSE INSTRUCTOR SNAPSHOT DATE | Date, Required, Updateable |
|
TEMPLATE GUIDANCE
- Student Grades can be submitted during every reporting period (40 Day, 80 Day, 120 Day, EOY) for which a grade pertains. If a grade and/or credit has not yet been earned for the course, then do not include this record. ONE final “Student Grade” record should be submitted per course/section corresponding with the latest reporting period enrollment record. One STUDENT GRADE record should be submitted for each “class,” which is identified as a unique combination of COURSE CODE plus SECTION CODE.
- The following students should not be submitted in this template:
- Hospitalized students (Location Code = 993)
- Homebound students (Location Code = 998)
- Home schooled students (Location Code = 999)
- Students enrolled in private school but receiving public special education services (Location Code = 997).
- Course Instructor Snapshot Date, Semester, Course Code Long, Section and Student ID MUST match the corresponding fields in the STUDENT COURSE ENROLLMENT template and the COURSE template. Student ID, Section and Course Instructor Snapshot Date are not in the COURSE template so the matching fields in the COURSE template must be Semester and Course Code Long. The same School Year, District Code, Location Code, Course Code Long, Section, Semester &Course Instructor Snapshot Date must also be found in the COURSE INSTRUCTOR template to determine the teacher who assigned the grade.
- Withdrawal (W) and Incomplete (I) STUDENT GRADE records are highly recommended because College and Career Readiness Bureau (CCRB) reviews final grades to calculate Perkins and dual credit funding. Omitting grades may adversely affect funding, so you are strongly encouraged to submit any withdrawal or incomplete grades. Failing to submit W or I grades will result in students being listed on “Missing Grade” exception reports.
Student Grades FAQs