Overview - Student Profile

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).

Dimension

Chronic Level

Measure

% Attendance

Total number of days attended divided by the total possible days of attendance.

Measure

% Attendance

Total number of days attended divided by the total possible days of attendance.

Measure

% Attendance

Total number of days attended divided by the total possible days of attendance.

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.

Measure

% Attendance

Total number of days attended divided by the total possible days of attendance.

Dimension

School Year

(METADATA) - The contemporaneous school year for this student annual attributes record. Formatted 1999-2000, 2002-2003, etc.

Measure

GPA

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.

Measure

# Offenses

The number of discipline incidences entered into the system.

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.

Dimension

Test Subject

Writing, Reading, Mathematics, Citizenship, Science, ESL, Other.

Measure

Score

The primary test score for a given assessment. This value may be either a raw or scaled score dependent upon the type of test. Not applicable to cases where the test result is a waiver or similar result code.

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.

Dimension

Absence Reason

The primary reason for the absence.  The primary reason is the one assigned if both morning & afternoon absence reasons matched, or if only a single reason was assigned for the morning or afternoon, or the morning reason if morning & afternoon reasons differ.  If a class spans 2 or 3 periods it will typically have 2 or 3 absence entries (one for each period) and the reason could potentially vary and the primary reason would be the most cited one.  Typical values include Unexcused, Medical, Athletic, NA (Not Applicable), etc.  Reasons can (and often do) vary by 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

Code to indicate the type of attendance day for this student on this date:  FD = Full Day Absence, AM = AM Only Absence, PM = PM Absence Only, LF = Late AM & PM, LA = Late AM Only, LP = Late PM Only and PR = Present   Note:  If ABSENT_CODE and ABSENT_CODE are both Null then the student will not be considered absent (even though their is an elem_attendances record) and the attendance_type will be set to PR.

Measure

# Days

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.

Dimension

Begin

The date value MM/DD/YYYY corresponding to the day in the calendar for this record.  Only exists in table to provide production keys to the build process.

Dimension

Exit

Dimension

School

The full name of the school.

Dimension

Withdraw Reason

Description of why/how the student was withdrawn from the school.  For example, District School (meaning admitted to another school within the district), Moved, etc.

Dimension

Begin Date

The date value MM/DD/YYYY corresponding to the day in the calendar for this record.  Only exists in table to provide production keys to the build process.

Dimension

End Date

The date value MM/DD/YYYY corresponding to the day in the calendar for this record. Only exists in the table to provide production keys to the build process.

Dimension

Membership Days

The number of school days in which the student was a member of this program based loosely upon the start and end dates defined in the student system.  The number is calculated using the school calendar for either the program school or the Administrative school if no school was assigned.  Weekends and holidays are excluded as are dates outside the school year ()summer).

Dimension

Program Name

The descriptive names for the programs as defined in the student information system. Title I Reading, Alternative Lottery, ESL Pullout, etc.

Dimension

Status

Indicates if the status of the student's program membership:  Pending if the start date is later than today; Expired is the end date is prior to today and Active if today is between the start and end date of the program assignment.  The status will be set to Deleted if that record is removed from the Student Information System.

Dimension

Period

Dimension

Skill

Dimension

Curriculum Code

Dimension

Item

Measure

Student

Dimension

Date

The date of the record.

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.

Measure

Average Measure Value

High, Moderate, and Low are the levels of risk calculated. Cut scores for high, moderate, and low risk can be found on the Cut Scores - Risk Analysis dashboard.

Dimension

Risk Type

The prediction factor category.

Dimension

Risk Level

High, Moderate, and Low are the levels of risk calculated. Cut scores for high, moderate, and low risk can be found on the Cut Scores - Risk Analysis dashboard.

Measure

Count

The number of individual data elements included.

Dimension

Importance Variable

The name of the data element utilized in the prediction for the probability of on-time graduation.

Dimension

Importance Variable

The name of the data element utilized in the prediction for the probability of on-time graduation.