Student Grades Extract
Contents
Introduction
The Student Grades extract is a summary report of the grades for students in grade levels KG through 12 for courses completed during the school year. Grades are only required for high school courses for students in grade levels 9 through 12. For grade levels KG through 8, course enrollments are reported, but the course grade is not applicable. The extract is generated in a comma-delimited format.
Selection Criteria
Selection criteria determine which database records are used in the report.
Student Selection
The Student Grades extract includes records from the [Students] and [ReEnrollments] tables that meet the following criteria:
- Students who are not excluded from state reporting.
- Students who are enrolled in a school that is not excluded from state reporting.
- Students who are enrolled in the current school year based on the Term at the top of the page at report runtime.
Stored Grade Selection
The Student Grades extract includes grade records from the [StoredGrades] table based on the following criteria:
- The student must be enrolled in grade level 9, 10, 11, or 12.
Note: Historical grades are not reported for students in grade levels PK – 8.
- The historical grade must not be excluded from state reporting.
- The historical grade must not be associated with a course or section that is excluded from state reporting.
- The historical grade must be assigned one of the store codes entered at report runtime.
Course Enrollment Selection
The Student Grades extract includes course enrollment records from the [CC] table based on the following criteria:
- The student must be enrolled in grade level PK, KG, 1, 2, 3, 4, 5, 6, 7, or 8.
Note: Current course enrollments are not reported for students in grade levels 9-12. Course information for those students is derived from the historical grade record.
- The course enrollment must not be associated with a course or section that is excluded from state reporting.
- The course enrollment must be active during the report date range (not dropped).
Report Input
For help with navigation and report generation, see How to Find and Generate a Report.
Field | Description |
Data to be Filled | Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Set All from the pop-up menu. To clear all checkboxes, choose Reset All. |
Schools to Include | Select the schools to be included in the report. If you are running the report from a school, the selection defaults to your school. |
Current Selection Students | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Session Type | Indicate the type of session for which you want to report grades. Options are:
|
Select Grade Scale | If applicable, select a Grade Scale from the pop-up menu |
Select Report Type | Select the type of report to run. Options are:
|
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Element # | Data Element | Description | [Table]FieldName |
1 | District Code | The NDE Number for the district. | [Prefs]Name=districtnumber [Prefs]Value |
2 | Location Code | The report extracts the value from the Alternate School Number field if it is populated on the Edit School page from where the course was taken. Otherwise, the report extracts the value from the School Number field from where the course was taken. | [Schools]Alternate_School_Number [Schools]School_Number |
3 | School Year | This value is automatically extracted as June 30th. The report determines the year by referencing the last day in the current year term, as defined in the Years & Terms. Extracted in the format YYYY-MM-DD. | [Terms]LastDay |
4 | Not Collected | Not collected. | N/A |
5 | Not Collected | Not collected. | N/A |
6 | Not Collected | Not collected. | N/A |
7 | Staff ID NDE Staff ID Override | The identifier assigned to the staff member by the NDE. Note: The extract reports the value in Historical > Stored Grades > NDE Staff ID. If that field is blank, the extract reports the value in Sections > NDE Staff ID Override. If that field is blank, the extract reports the teacher’s staff ID. | [S_NE_SGR_X]NDE_Staff_Override [S_NE_SEC_X]NDE_Staff_Override [S_NE_USR_X]Staff_ID [CC]TeacherID
|
8 | Student ID | The student’s state assigned identifier. | [Students]State_StudentNumber |
9 | Marking Period Number | The Marking Period is a key field. A value must be supplied for each record or the data loading process will reject the record. Provide the literal “0”. Always extracts as zero. | N/A |
10 | Not Collected | Not collected. | N/A |
11 | Alpha Grade | The final letter grade earned by the student. If the student is in grade level KG, 1, 2, 3, 4, 5, 6, 7, or 8, then a value of “0” is reported. If the student is in grade level 9, 10, 11, or 12, then the appropriate historical grade is reported, as follows:
| [StoredGrades]Grade [S_NE_ReportingStoreCodes_S]StoreCodes |
12 | Not Collected | Not collected. | N/A |
13 | Not Collected | Not collected. | N/A |
14 | Not Collected | Not collected. | N/A |
15 | Not Collected | Not collected. | N/A |
16 | Not Collected | Not collected. | N/A |
17 | Not Collected | Not collected. | N/A |
18 | Not Collected | Not collected. | N/A |
19 | Not Collected | Not collected. | N/A |
20 | Not Collected | Not collected. | N/A |
21 | Not Collected | Not collected. | N/A |
22 | Semester | Indicates when the course was offered and the length of the course. Note: This value is currently always extracted as “0”. Valid values:
| N/A |
23 | Not Collected | Not collected. | N/A |
24 | Not Collected | Not collected. | N/A |
25 | Not Collected | Not collected. | N/A |
26 | Course Code Long | The district assigned code that uniquely identifies the course. | [Courses]Course_Number |
27 | Section Code Long Section Number Override | The district assigned code that uniquely identifies the section. The value is reported as the course number concatenated with the section number and store code: Course#Section#StoreCode | [Courses]Course_Number [Sections]Section_Number [StoredGrades]StoreCode [S_NE_SGR_X]Section_Code_Override |
28 | Not Collected | Not Collected | N/A |
29 | Not Collected | Not Collected | N/A |
30 | Not Collected | Not Collected | N/A |
31 | Not Collected | Not Collected | N/A |
32 | Dual Credit Code
| Indicates if the student earned both high school and postsecondary credit for the course. | [S_NE_SEC_X]Dual_Credit_Code |
33 | Controlling District Code Controlling District Code Override | The County District Number associated with the NDE Staff ID. | [S_NE_SEC_X]Controlling_District_Code [S_NE_SGR_X]District_Code_Override
|
38 | Course Delivery Model | Indicates how the course was delivered. Valid values are:
Note: The extract pulls from the Historical > Stored Grades > Course Delivery Model field. If this field is blank, the value in the School Setup > Sections > Course Delivery Model is reported. | [S_NE_SGR_X]Course_Delivery_Model |