Grade Earned

Contents

Selection Criteria

Selection criteria determines which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

The report selects records based on the following criteria:

All Student class enrollment records whose date enrolled is greater than or equal to the Start Date specified by user and is less than or equal to the End Date specified by the user will be will be selected.
The Course cannot be set to be excluded from state reporting.
If electing to submit a final letter grade earned, the store code of the final grade to submit must be defined from Start Page > School >Grading > Final Grade/Reporting Term Setup > Edit Final Grade.
Associate all Grades used with the code set for Grade Earned from the District Office > District > Grade Scales > Select a Grade Scale > Edit > Select a Grade > Edit Grade: Default.
The Submit Final Grade Option if selected will pull only students with an Historical Grade - Start Page > Select a Student > Historical Grades.

Back to Top

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Data to be filled
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Select Students	The default option is All students. Use The xxx Selected Students to extract by a user-defined filtered student selection.
Start Date	Enter the Start Date for this report
End Date	Enter the End Date for this report
Submit Final Grade	Specify Yes to submit the final grade earned for students. Specify No if you will not submit the final grade earned for students.
Scheduling Options	Description
Scheduling – Run Now	Leave Run Now selected to run the report now.
Submit	Click Submit to run the report now.
Scheduling – Please Select When to run	Click the Schedule button to schedule this report to run.
Please Select Schedule Settings	Enter the Start Date and Start time. Click the Repeat button.
Please select repeat cycle options.	Choose the applicable option.
Please select end date range option	Enter the appropriate information.
Submit	Click Submit to schedule the report

Districts using the Automated Data Transfer (ADT) system may utilize the SQL script for state reporting purposes provided at the bottom of the report page.

Report Output

Column	Data Element	Description	[Table]FieldName	Field Type	Field Length
A	DISTCODE	This field contains the reporting district code.	[Prefs]District_Number	Text	2
B	SCHCODE	Local School Id.	[S_RI_SCH_X]Ride_ID	Text	5
C	LOCALCOURSEID	The identifier for the course assigned by the local education agency (LEA). If the Course RI Course Classification ID = 23002 is reported as a preschool course and so the local course id will be the Service Delivery Module + School Code + Section ID	[Courses]Course_Number OR [S_RI_CRS_X]Service_Delivery_Model + [S_RI_SCH_X]Ride_ID OR [S_RI_CRS_X]Private_SpecialEd_School + [S_RI_SEC_X]PreSchool_Section_ID	Text	20
D	TERMCODE	Code used to identify the term (School > Final Grade/Reporting Term Setup > New > Term Code for Grade Earned).	[S_RI_TRB_X]TCS_StoreCode if not Null [TERMBINS]storecode if not null (matches to TermBins first on [STOREDGRADES]storecode if null then [STOREDGRADES]termbinsname) [TERMS]isYearRec= then Y1 If none of the above is true then [TERMS]Abbreviation	Text	6
E	SASID	A 10-digit unique numeric ID assigned to each student in R.I. by the State.	[Students]State_StudentNumber	Text	10
F	LASID	This field contains the locally assigned student number.	[Students]Student_Number	Text	16
G	NUMERICGRADEEARNED	A final indicator of student performance in a class as submitted by the instructor.	Extracted as Null	Numeric	5
H	LETTERGRADEEARNED	The final letter Grade Earned for a student in the class. A final indicator of student performance in a class as submitted by the instructor. This field is required for grades 6-12 and will be blank in the extract for all other grade levels. The user must specify to submit the final grade at run time. If the user does submit the final grade it must exist as a Stored Grade (Start page > select a student > Historical Grades) see the selection criteria section for this report for the other setup components to submit a final letter grade earned.	Extracted as Null OR [StoredGrades]Grade AND [S_RI_GSI_X]TCS_Grade_Earned The Grade submitted is determined by the Store Code specified for the TCS Section Student Submission. Start Page > School > Grading > Final Grade/Reporting Term Setup > Edit Final Grade. The Grades in the Grade Scale for the course should be associated with their TCS Grade Equivalent from District Office > District > Grade Scales	Text	2
I	CREDITSRECEIVED	The number of credits a student earned for completing a given course. The student must be in grade 9 or above and the Term Code for Grade Earned must be set as 'Final' to report credits received.	[StoredGrades]EarnedCrHrs	Text	5