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.

Screenshot of the Grade Earned report editor. 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 when:

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.

Screenshot of an example of the Grade Earned report in CSV format. Grade Earned Report - CSV Format

Screenshot of an example of the Grade Earned report in HTML format. Grade Earned Report - HTML Format

SQL Query

EXEC [get_RI_GradeEarnedReport] @calendarXML = '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. When the Grading Task Name contains a value of Summer, a value of Sum reports. When the Grading Task Name contains a value of Final, a value of Final reports. 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. The Quarter Grade needs to be selected as State Reported and have "Quarter" in the name in order to report. Numeric, 3 digits	Grading and Standards > Score Groups and Rubrics > Score Group > Score GradingTask.score Grading and Standards > Grading Tasks > Grading Task Details
Letter Grade Earned	Letter Grade (A-F) the student earned for the term. The reported value can be plus, minus or blank. The Quarter Grade needs to be selected as State Reported and have "Quarter" in the name in order to report. 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

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.

When the Grading Task Name contains a value of Summer, a value of Sum reports. When the Grading Task Name contains a value of Final, a value of Final reports.

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.

The Quarter Grade needs to be selected as State Reported and have "Quarter" in the name in order to report.

Numeric, 3 digits

Grading and Standards > Score Groups and Rubrics > Score Group > Score

GradingTask.score

Grading and Standards > Grading Tasks > Grading Task Details

Letter Grade Earned

Letter Grade (A-F) the student earned for the term. The reported value can be plus, minus or blank.

The Quarter Grade needs to be selected as State Reported and have "Quarter" in the name in order to report.

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

Previous Versions

Grade Earned Report (Rhode Island) [.2219 - .2319]

Grade Earned Report (Rhode Island)