Skip to Content
Student Grades Template 2019-06-13T14:24:17-06:00

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:

  1. COURSE
  2. STAFF
  3. 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 NumberField NameData Type, Required, CodeValid Values
1DISTRICT CODECharacter, Required, Key
2LOCATION CODECharacter, Required, Key
3SCHOOL YEAR DATEDate, Required, Key
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
6REQUEST SEQUENCECharacter, Required, Key​
  • 0
8STUDENT IDCharacter, Required, Key​Enter 9 digit student ID
9MARKING PERIOD NUMNumber (0 decimals), Required, Key​
  • 501 – 40 Day
  • 502 – 80 Day
  • 503 – 120 Day
  • 901 – End of Year (EOY)
  • 903  – Summer (optional)
10NUMERIC GRADENumber, conditionally Required, UpdateableFinal numeric grade a
student received in a course.
11ALPHA GRADECharacter, Conditionally Required, Updateable
  • A
  • B
  • C
  • D
  • F
  • I = Incomplete
  • W = Withdrawn
12PASS/ FAILCharacter, Conditionally Required, Updateable
  • P = Pass
  • F = Fail
22SEMESTERCharacter, Required, Key
  • 1 = 40 Day
  • 2 = 80 Day
  • 3 = 120 Day
  • 4 = End of Year
  • 6 = Summer (Optional)
24CREDITS EARNEDNumber (4 decimals), Required, Updateable
  • 0 = Grade F (failed) OR incomplete class OR non-High School credit class.  Use 0 for Middle School or failed classes.
  • .25 = Traditional High School ½ semester class
  • .33 = 1 College Credit Hour OR 1/3 Credit for Trimester reporting
  • .34 = 1/3 Credit for Trimester reporting
  • .66 = 2 College Credit Hours
  • .67 = 2 College Credit Hours
  • .5 = Traditional High School 1 semester class OR its equivalent in block scheduling systems
  • 1 = 3 College Credit Hours OR traditional year-long High School class OR its equivalent in block scheduling systems
  • 1.33 = 4 College Credit Hours
  • 1.5 = Special case for block classes.
  • 1.66 = 5 College Credit Hours
  • 1.67 = 5 College Credit Hours
  • 2 = 6 College Credit Hours
26COURSE CODE LONGCharacter, Required, Key8 digit course code

SY19 Course Codes

27SECTION CODE LONGCharacter, Required, Key
28CONDUCT GRADECharacter, Conditionally Required, Updateable
29COURSE INSTRUCTOR SNAPSHOT DATEDate, Required, Updateable

  • 2018-10-01 = 40D
  • 2018-12-15 = 80D
  • 2019-03-01 = 120D
  • 2019-06-01 = EOY
  • 2019-06-29 = Summer (Optional)

  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2020-06-01 = EOY
  • 2020-06-29 = Summer (Optional)

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

 

Page last updated June 13, 2019