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.
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.
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 |