WISEdash Extracts for Choice Schools
WISEdash Extracts are intended to help Choice schools access graduation rate, dropout rate, and absenteeism information normally available only in WISEdash for Districts.
WISEdash Extracts work similarly to normal WISEdata Portal exports, and allow Choice schools to download reports that they can use to track graduation cohorts and calculate graduation rates, high school completion rates, dropout rates, and chronic absenteeism.
The available WISEdash Extracts include:
| Extract Name | Description |
|---|---|
| Graduation & HS Completion Rate | This report shows students included in the numerator and denominator of the Graduation Rate (Regular Diploma) and High School Completion Rate. |
| Graduate Future Cohorts | This report shows the cohort for high school completion in which a student is placed based on grade level and school year of their first entry into high school. |
| Dropout Rate | This report shows students included in the numerator and denominator of the annual dropout rate. |
| Absenteeism | This report shows students' status regarding chronic absenteeism under the Wisconsin state definition. |
| Enrollment Certified Economic Data Change | This report lists students included in the certified Third Friday of September enrollment who were affected by the Statewide 2020-21 TFS Enrollment Economic Status Data Disclaimer. For more information, refer to the Choice Schools: How-to: Economic demographic data during the Pandemic guide. |
Accessing WISEdash Extracts
WISEdata users at Choice schools can access WISEdash Extracts in WISEdata Portal. To do so:
- Log in to WISEdata Portal through the WISEhome.
- Under the Agency header, go to Exports.
- Download the extract you want to see under the WISEdash Extracts section.
Data Definitions
See below for definitions of each column included in the WISEdash Extracts.
Graduation & HS Completion Rate and Graduate Future Cohorts
The following columns are included in the Graduation & HS Completion Rate and Graduate Future Cohorts extracts. For more information about calculating graduation rates, refer to the Understanding Wisconsin's High School Graduation Rate Calculations page. For more information about high school completion, refer to the About the Data - High School Completion page.
| Column Name | Description |
|---|---|
| Graduation Cohort | The year the student would have customarily graduated in four years. This value identifies the cohort set to which the student has been assigned based on their first high school enrollment. |
| Years or Less | The number of years or less (4, 5, 6, or 7) in which the student has completed high school. |
| Rate Inclusion Indicator | A Yes/No indicator for whether the student is to be included in the denominator of any rate calculations based on this row. |
| Graduation Indicator | A Yes/No indicator for whether the student has received a regular diploma in any year on or before the selected school year. |
| Graduation Numerator | Shows 1 if the student is included in the numerator. Shows 0 if the student is not included. Sum this column to determine the numerator of the graduation rate. |
| Credential | The kind of completion certificate the student attained after completing high school. Refer to the Credential Type data element page for more information. |
| High School Completion Indicator | A Yes/No indicator for whether the student received any completion credential in any year on or before the selected school year. |
| High School Completion Numerator | Shows 1 if the student is included in the numerator. Shows 0 if the student is not included. Sum this column to determine the numerator of the high school completion rate. |
| Denominator | Shows 1 if the student is included in the denominator. Shows 0 if the student is not included. Sum this column to determine the denominator of the graduation or high school completion rate. |
| First HS Enrollment Grade Level | The student's grade level (9-12) when they first entered high school. |
| First HS Enrollment Year | The school year in which the student first entered high school. |
| First HS Enrollment Date | The date the student first entered high school. |
| First HS Enrollment LEA ID | If a student first entered high school at a public school, this column show the public district's agency key. Otherwise, this column is blank. |
| First HS Enrollment LEA Name | If a student first entered high school at a public school, this column show the name of the public district. Otherwise, this column is blank. |
| First HS Enrollment School ID | The agency key of the school (public or Choice) in which the student first entered high school. |
| First HS Enrollment School Name | The name of the school (public or Choice) in which the student first entered high school. |
| WISEdata Update Availability | Indicates whether this record may be modified via submission to the WISEdata API. This is based on the school years currently available within the API. |
Dropout Rate
The following columns are included in the Graduation & HS Completion Rate and Graduate Future Cohorts extracts. For more information about calculating dropout rates, refer to the About the Data - Dropouts page.
| Column Name | Description |
|---|---|
| Dropout Rate School Year | The school year for which the student is counted as a dropout. Dropouts are calculated annually. A student may be a dropout in multiple and consecutive school years. |
| Grade Level |
The grade level in which the student will be reported as a dropout. For midterm dropouts, this grade level is equivalent to the grade level of the enrollment record that resulted in the dropout. For full term dropouts, this grade level is calculated as follows:
|
| Midterm Dropout Indicator | Indicates that the student did not complete the school year in which they are identified as a dropout. |
| Full Term Dropout Indicator | Indicates that the student completed the school term and did not re-enroll for the subsequent school year. |
| Term Completion Indicator | Indicates whether the student completed the selected dropout rate school year. |
Absenteeism
The following columns are included in the Absenteeism extracts. For more information about calculating chronic absenteeism, refer to the About the Data - Chronic Absenteeism page.
| Column Name | Description |
|---|---|
| School Year | The school year for which data is submitted to WISEdata. |
| LEA ID | The agency key of the agency submitting the WISEdata record. |
| LEA Name | The name of the agency submitting the WISEdata record. |
| School ID | The ID code for the school submitting the WISEdata record. |
| School Name | The name of the school submitting the WISEdata record. |
| WISEid | The student's unique identification number in WISEid. |
| Last Name | The student's last name. |
| First Name | The student's first name. |
| Choice Student Indicator | A Yes/No indicator showing whether a student participates in the School Choice Program. |
| Actual Days Attended | The sum of the reported days of attendance for the student at the submitting school. |
| Possible Days Attended | The sum of the possible total days of attendance the student could have had at the submitting school. |
| Attendance Rate | The actual days attended divided by possible days attended, shown as a percentage. |
| Absentee State | An indicator of whether a student is considered chronically absent under the Wisconsin state definition, shown as Yes, No, or Not Applicable. Not Applicable indicates a student who does not have sufficient continuous enrollment for absenteeism to be determined. |
Enrollment Certified Economic Data Change
The following columns are included in the Enrollment Certified Economic Data Change extract. For more information on why students are included in this extract, refer to the Choice Schools: How-to: Economic demographic data during the Pandemic guide.
| Column Name | Description |
|---|---|
| School Year | The school year for which data is submitted to WISEdata. |
| School ID | The ID code for the school submitting the WISEdata record. |
| School Name | The name of the school submitting the WISEdata record. |
| WISEid | The student's unique identification number in WISEid. |
| First Name | The student's first name. |
| Last Name | The student's last name. |
| Choice Student Indicator | A Yes/No indicator showing whether a student participates in the School Choice Program. |
| Certified Food Services Eligibility | The student's certified food services eligibility status as of the Third Friday of September enrollment count. |
| Certified Economic Disadvantage Status | The student's certified economic disadvantage status as of the Third Friday of September enrollment count. |