Student Narrative
|
Type |
Column Label / Definition |
|---|---|
|
Dimension |
Student ID The student's code or ID number for the SIS system. This is padded with proceeding zeros to seven positions (e.g., 82901 becomes 0082901). |
|
Dimension |
Age The student's age in years - computed from Birthdate. This is the current age of an Active student, and the age at withdrawal date if Inactive. |
|
Dimension |
Status A high-level status grouping: Active, Pre-Enrolled, Expelled, Transferred-Out, Graduated, etc. |
|
Dimension |
Ethnicity The student's primary racial background: American Indian/Alaska Native, Asian/Pacific Islander, Black, Hispanic, Unknown/Unspecified, White. |
|
Dimension |
Current School School name where the student is currently enrolled - Beechcroft High School, Welcome Center at North, Prof. Inst. Walnut Ridge Hs, etc. Use in reports & analyses only as a student attribute - enrollment fact data should be used for student profiles. |
|
Dimension |
Grade The student's grade level. |
|
Dimension |
Current Cumulative GPA The student's cumulative GPA calculated and frozen from the previous school year. This is the unweighted GPA. |
|
Dimension |
Mobility
The number of times a student has changed schools during the past 365 days (past 12 months). |
|
Dimension |
ELL Indicates whether the student is currently active in an English as a Second Language program (Yes or No)? If the student is withdrawn and was participating in ESL at the time of withdrawing then they will be set to Yes.
|
|
Dimension |
Language The student's primary language: English, Spanish, Hmong, Urdu, etc. The default of null to English is in synch with most State Reporting. |
|
Dimension |
SE Indicates (Yes/No) whether the student is currently receiving special education services (either in regular classroom or special ed unit). |
Student Academic Trends for Final Marks
|
Type |
Column Label / Definition |
|---|---|
|
Dimension |
Year
The school year for the related school. 2021-2022, 2023-2024, 2025-2026, etc. Note that dates outside the defined school year are set to School Year 0. The attendance component in the student plan now sorts attendance data by default, showing the most recent year first.
|
|
Dimension |
Mark Short name for the performance group: A, B, C, NI, XL, P.. Full marks will be shortened - A, A+ or AH will all be represented here as A based upon Effort definitions in the Domains table. Student mark categories include A, B, C, D, F, 1, 2, 3, 4, Pass, Incomplete, and No Credit. |
|
Dimension |
Period (METADATA) - An assessment-specific (non-conformed) testing window. Some examples include Fall, Winter, Spring, Summer, Beginning, Middle, End, etc. Use -- when not applicable. |
|
Measure |
Marks Count Number of marks or assessments recorded.
|
Student Academic History
|
Type |
Column Label / Definition |
|---|---|
|
Dimension |
Course Name The full name for the course - this is the primary course name to be used in most reports, analyses, and filters. In state/multi-district deployments this is often conformed to the State or NCES Course Description. |
|
Dimension |
Course Subject (METADATA) - The subject area of the course - English, Math, Science, Social Studies, etc. This is either from the subject field in the course master or the description for the NCES 2 digit code associated with this course. |
|
Dimension |
Course Type The major classification of the course. This may be used for the high-level state or NCES classification of this course or for the associated Diploma type. |
|
Dimension |
Credits The weighted credit value for the mark received. This is the value considered when computing Total Credits for most purposes. A=1, B=1, D=1, F=0, etc. |
|
Dimension |
Grade Grade code from eSIS for the student's grade level for the current school year. 00, 01, 02, UG, PS, DC, etc. |
|
Dimension |
Grading Period A code that indicates a grading, marking, or report card period. Examples include FS or SS (Fall or Spring Semester Final Marks) and PR1 or RP6 (Progress Report Periods 1 or 6). This may differ from the Marking Period in the School Calendars as there may be several marking periods that end on the award date for a mark. In those cases, this is the most accurate data. |
|
Dimension |
Mark Short name for the performance group: A, B, C, NI, XL, P.. Full marks will be shortened - A, A+ or AH will all be represented here as A based upon Effort definitions in the Domains table. |
|
Dimension |
School The full name of the school. |
|
Dimension |
Term The term number for the related school (1, 2, 3, etc.). Note that dates outside the defined term are set to Term of 0. |
|
Dimension |
Type
|
|
Dimension |
Year
The school year for the related school. 2021-2022, 2023-2024, 2025-2026, etc. Note that dates outside the defined school year are set to School Year 0. The attendance component in the student plan now sorts attendance data by default, showing the most recent year first.
|
Student Academic Standards Progress
|
Type |
Column Label / Definition |
|---|---|
|
Dimension |
Course Name The full name for the course - this is the primary course name to be used in most reports, analyses, and filters. In state/multi-district deployments this is often conformed to the State or NCES Course Description. |
|
Dimension |
Course Subject (METADATA) - The subject area of the course - English, Math, Science, Social Studies, etc. This is either from the subject field in the course master or the description for the NCES 2 digit code associated with this course. |
|
Dimension |
Course Type The major classification of the course. This may be used for the high-level state or NCES classification of this course or for the associated Diploma type. |
|
Dimension |
Item |
|
Dimension |
Grade Grade code from eSIS for the student's grade level for the current school year. 00, 01, 02, UG, PS, DC, etc. |
|
Dimension |
Grading Period A code that indicates a grading, marking, or report card period. Examples include FS or SS (Fall or Spring Semester Final Marks) and PR1 or RP6 (Progress Report Periods 1 or 6). This may differ from the Marking Period in the School Calendars as there may be several marking periods that end on the award date for a mark. In those cases, this is the most accurate data. |
|
Dimension |
Mark Short name for the performance group: A, B, C, NI, XL, P.. Full marks will be shortened - A, A+ or AH will all be represented here as A based upon Effort definitions in the Domains table. |
|
Dimension |
School The full name of the school. |
|
Dimension |
Term The term number for the related school (1, 2, 3, etc.). Note that dates outside the defined term are set to Term of 0. |
|
Dimension |
Type
|
|
Dimension |
Year
The school year for the related school. 2021-2022, 2023-2024, 2025-2026, etc. Note that dates outside the defined school year are set to School Year 0. The attendance component in the student plan now sorts attendance data by default, showing the most recent year first.
|