Classic View: RI State Reporting > Grade Earned
Search Terms: Grade Earned
The Grade Earned Report lists all grades earned by a student enrolled in grades 6-12 in a class for each term of the class. All students who have an active enrollment on or during the Prior and Effective Reporting Dates are included.
Grade Earned Report
Report Logic
State Score Options
The Score Group used needs to have the State Score column populated with corresponding values of the following letter grades:
| A+ | A | A- |
| B+ | B | B- |
| C+ | C | C- |
| D+ | D | D- |
| F |
Course Setup
A Course must have a SCED or State Code assigned in order to be included in the report.
Students marked as No Show or Summer Withdrawal are not included. Students are also not included if:
- The student's enrollment record is marked as State Exclude.
- The Grade Level of enrollment is marked as State Exclude.
- The Calendar of enrollment is marked as State Exclude.
The following is used to determine the Term Code.
Semesters
- S1 - Sequence 1 of 2 Semester Term
- S2 - Sequence 2 of 2 Semester Term
Trimesters
- T1 - Sequence 1 of 3 Trimester Term
- T2 - Sequence 2 of 3 Trimester Term
- T3 - Sequence 3 of 3 Trimester Term
Quarters
- Q1 - Sequence 1 of 4 Quarter Term
- Q2 - Sequence 2 of 4 Quarter Term
- Q3 - Sequence 3 of 4 Quarter Term
- Q4 - Sequence 4 of 4 Quarter Term
5 Term Schedule
- M1 - Sequence 1 of 5 Term Schedule
- M2 - Sequence 2 of 5 Term Schedule
- M3 - Sequence 3 of 5 Term Schedule
- M4 - Sequence 4 of 5 Term Schedule
- M5 - Sequence 5 of 5 Term Schedule
Year Long Schedule
- Y1 - Sequence 1 of 1 Term Schedule
Summer
- Sequence 1 of 1 Summer Schedule
- Name must be Summer
Generate the Grade Earned Report
- Select the Format of the Report - either CSV or HTML.
- Select which Calendars to include in the report.
- Click the Generate Extract button. The report displays in the selected format.
Grade Earned Report - CSV Format
Grade Earned Report - HTML Format
SQL Query
EXEC [get_get_RI_GradeEarnedReport] @calendarList = '11,13,1
Grade Earned Report Layout
Data Element | Description | Location |
|---|---|---|
District Code | State identifier assigned to the LEA by the SEA. Numeric, 2 digits | System Administration > Resources > District Information > State District Number District.state Number |
School Code | State-assigned school number. Numeric, 5 digits | System Administration > Resources > School > School Detail > State School Number School.state Number |
Local Section ID | Locally-assigned code that identifies each section in the selected calendar. This number combines the course number and the section number of the course. Alphanumeric, 20 characters | Scheduling > Courses > Course > Course Editor > Number Course.number Scheduling > Courses > Course > Section > Section Editor > Section Number Section.number |
Term Code | Code used to identify the term in which the grade was given. See the Report Logic section for options. Alphanumeric, 10 characters | System Administration > Calendar > Calendar > Term Calendar.term |
SASID | A unique identification number assigned to each student by the Department of Education. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
LASID | A unique identification number assigned to each student by the school district. Numeric, 16 digits | Census > People > Demographics > Person Identifiers > Local Student Number Person.student Number |
Numeric Grade Earned | Numeric grade the student earned for the term. Reported value is between 0 and 100. Numeric, 3 digits | Grading and Standards > Score Groups and Rubrics > Score Group > Score GradingTask.score
|
Letter Grade Earned | Letter Grade (A-F) the student earned for the term. The reported value can be plus, minus or blank. Alphanumeric, 2 characters | Grading and Standards > Score Groups and Rubrics > Score Group > State Score GradingTask.grade |
| Credits Received | Reports the total number of credits the student earned with the letter grade received for the course. Credits are reported from the grading task when the student earned the credit received. This requires the score to be marked as a Passing score on the score group. When no credits are earned for the grading task, a blank value reports. Numeric, 5 digits | Scheduling and Courses > Courses > Grading Task > Credit GradingTask.credit Grading and Standards > Score Groups and Rubrics > Score Group > Passing Score |
