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

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+AA-
B+BB-
C+CC-
D+DD-
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

  1. Select the Format of the Report - either CSV or HTML.
  2. Select which Calendars to include in the report.
  3. 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.

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