Analytics & Insights

Schedule

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 Detailed Schedule

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


Department

The long name for the department.  Mathematics Education, English Education, Trade and Industrial Education, etc.


Dimension


Sec

(METADATA) - The section designation for the Course being offered (to distinguish this course from the same course being offered during the same semester/term).


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


Staff Name

Staff member's full name formatted last name, first name (e.g., Sinatra, Nancy).


Dimension


Year

The school year for the related school. 1999-2000, 2000-2001, 2001-2002, etc. Note that dates outside the defined school year are set to School Year of 0.