PATH: OH State Reporting > Ohio Extracts > Student Course Grade (FR)
The Student Course Grade (FR) Extract reports Pathway-to-Learning data and tracks course progression, identifying students who may be at risk of not graduating based on current course performance.
Student Course Grade (FR) Extract Editor
Report Logic
A record reports for each course Grade, for each student. A student must have a Grading Score marked as State Reported to report. Grades are reported based on the State Grade mapped to the score. Records only report if credit is assigned to a Grading Task on the Course. If a student has multiple grades in the same term, the grade for the Grading Task marked as Final is reported. If there is not Grading Task marked as Final, the most recent grade from a Grading Task marked as State Reported is reported.
Generating the Extract
- Select Student Course Grade (FR) as the Extract Type.
- Select the Reporting Period.
- Select a specific Grade Level to filter results to students enrolled in grades mapped to the selected state grades. By default, grades 9-12 are selected.
- Enter a reporting Date Range in mmddyyyy format or by clicking the calendar icon and selecting a date.
- Select the Format in which the report should generate. Use State Format (Fixed Width) for submission to the state or HTML or CSV for data review and verification.
- Select an Ad Hoc Filter to limit reported students based on an existing filter.
- Select which Calendar(s) should be included in the extract.
- Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate. If generating multiple extracts at a time, requests can only be submitted to the Batch Queue.
Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
Extract Layout
| Element | Description | Campus Location |
| Filler | Reports as blank space (8 characters). | N/A |
| Sort Type | Always reports as FR. | N/A |
| Filler | Reports as blank space (1 character). | N/A |
| Fiscal Year | The Fiscal Year determined by the end year of the reported school year. For example, 2020 reports for the 2019-2020 school year. Date field, YYYY | N/A |
| Reporting Period | Always reports L-Staff/Course. | N/A |
| District IRN | The state-assigned information retrieval number (IRN) of the district. Numeric, 6 digits | System Administration > Resources > District Information > State District Number District.number |
| EMIS Student ID Number | The local student identification number. Numeric, 6 digits | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
| Local Classroom Code | The code used by the local school district to identify a specific classroom. Reports the State School Number-Course Number-Section Number. Alphanumeric, 20 characters | System Administration > Resources > School > State School Number; Scheduling > Courses > Course > Number; Scheduling > Courses > Section > Section Number School.number; Course.number; Section.number |
| Term | The length of time the course is taught. This field looks first at the Code entered on the Grading Task being reported. If a Code is entered (Y, S, T, Q, or X), this field reports that code followed by the number of the term that the Grading Task is assigned. If a Code has not been entered, this field considers the number of terms the section and the term that the grade/grading task is being reported.
If the student does not have a grade, the same logic as above is used, except that the sequence for the last term the section is scheduled into is used to determine the numerical value. Alphanumeric, 2 digits | Calculated, not dynamically stored. |
| Course Grade | The final grade the student earned in a particular term. This field does not include honors or grade quality points (+/-). Reports for all courses in grades 9-12 or those marked as High School Credit courses. If the record is reported for a grade received on a Grading Task marked as State Reported, this field reports the State Score value selected on the Score Group mapped to the grade the student received. If no State Score exists, reports the grade. Additional Information: If the Grading Task is not marked as State Reported and the student has a Roster End Date prior to the end of the section, reports as W. If the section has ended with no grade reported, reports as U. To report a final grade, the grading task must be marked as Final. If any reported grading task has Course Credit associated with it, all grades marked as State Reported are reported. A grade of I: Incomplete only reports if the term is over and no grade has been given for the reported grading task. A record does not report if the student does not have a grade, unless the term has ended and the student has withdrawn. | Scheduling > Courses > Grading Tasks; Grading & Standards > Grading Tasks > State Reported; Grading & Standards > Score Groups & Rubrics > State Score |
| Grade Status | The in-progress grade for the student. Options are as follows: Reports as F if the grading task is marked as State Reported and Final and the grade is either posted to the transcript or the Grade is W. Reports as P if the grading task is marked as State Reported and is not posted to the transcript (and Grade is not W), regardless of whether the task is marked as Final. Reports as I if the grading task is marked as State Reported, not marked as Final, and the grade is posted to the transcript. | Calculated, not dynamically stored Grading & Standards > Grading Tasks > Final |
