Snapshot Preparation: Graduation for Choice Schools
Overview
This page includes an overview of WISEdata snapshot preparation tasks for Choice schools to ensure data quality for graduation data.
Optionally, you can use this document to create a printable checklist for graduation snapshot data as you complete these tasks.
Tools
Reviewing Validation Messages in WISEdata
On the Validation Messages screen, you can use the options under the Filters section to filter for "High School Completion," "Year End Exit," and "High School Graduation" validation messages.
- Use the High School Completion filter to review validation errors related to high school completion data.
- Use the High School Graduation filter to review validation errors related to high school graduation plan data.
- Use the Year End Exit filter to review validation errors related student exit data.
WISEdash Extracts
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. WISEdata users at Choice schools can access WISEdash extracts in WISEdata Portal. To do so:
- Log in to WISEdata Portal through WISEhome.
- Under the Agency header, go to Exports.
- Download the “Graduation & HS Completion Rate” and “Graduate Future Cohorts” extracts under the WISEdash Extracts section.
To learn more about WISEdash extracts for Choice schools, refer to this guide.
Key Data Properties
Graduation Cohorts
A student is assigned to a graduation rate cohort based on two factors:
- School year of the student’s first high school enrollment period in Wisconsin.
- Student’s grade level placement at the time of first high school enrollment period.
To be counted as a graduate under the four-year adjusted cohort rate, a student must earn a regular diploma on or before the summer following their fourth year of high school. This includes early graduates.
To be counted as a completer under the four-year adjusted cohort rate, a student must earn a regular diploma, high school equivalency diploma, or other high school completion credential on or before the summer following their fourth year of high school. This includes early completers.
Data Elements
Required graduation data elements include:
- Credential Type (Diploma Type): The kind of completion certificate earned by students completing high school.
Check Data Quality
Correct Errors and Warnings
In your student information system (SIS), correct the data containing validation errors and warnings.
- Visualize the numbers of errors & warnings on the Data Quality page and utilize the metrics to look for odd or unusual patterns.
- Prioritize critical errors. Data with critical validation errors may not be loaded to WISEdash or otherwise will have a large impact on your resulting data.
- In the WISEdata Portal > Validation Messages page, use the Validation Category filter to focus on validations relating to topics the snapshot is capturing for the selected School Year.
For more information on correcting errors and warnings, refer to the WISEdata Mini Tutorial and Validations Mini Tutorial.
Common Validation Issues
-
Critical - Missing Diploma (Validation Rule 6493):
Student identified as a High School Completer, but either the credential is missing from the student Academic Record resource or the student Academic Record itself is missing. To fix the error, verify if the student has completed high school. If so, submit the credential/diploma on the student Academic Record. If not, change the Exit Type to something other than High School Completer (HSC). In WISEdata diploma type is submitted on /studentAcademicRecord resource for current school year SAR records.
-
Missing Exit Withdraw Date (Validation Rule 6606):
Exit Withdraw Date for the student's enrollment is required at the end of each school year, even for students continuing in the same school in the next school year. This rule runs once a school year has ended.
-
Required field is missing: 'Exit Type'. (Validation Rule 7062):
Exit Type must be submitted for Primary Enrollment types if Exit Date is provided.
-
Term Completion Indicator is Yes In District (Validation Rule 6569):
Term Completion Indicator (a.k.a Completed School Term) is 'Yes' in multiple enrollment records in your school or agency.
-
Term Completion Indicator is Missing (Validation Rule 6571):
Identification of whether a student completed the school term is required for every enrollment period with an exit date.
Review Data in WISEdash Extracts
Please visit the WISEdash Extracts for Choice Schools webpage to learn more about this valuable tool set.
Data Flow and Troubleshooting
If your data is flowing incorrectly, work backward to find where things went wrong. The following topics explain the flow of data: if you have an issue with one tool, look to the previous step in the data flow to make changes.
Data Flow for Snapshot
Data is:
- entered into your vendor tool (SIS, for example)
- pushed to WISEdata and run through data quality checks (validations)
- validated in the system on the day and time of the snapshot, will be loaded to WISEdash, and snapped for reporting purposes
Users can use WISEdata Portal validation results to go back to their vendor tool to make corrections and push the corrected data to WISEdata.
For WISEid data flow:
- LEA user enters info to WISEid (weekly) and into local SIS
- The data from the SIS and from WISEid flows into WISEdata via a nightly sync job.
- WISEdata runs a validation to check for sound and accurate data, then rejects or reports errors and warnings accordingly back to LEA user.
- LEA corrects and modifies data in SIS and WISEid until accurate and current.
- Info in WISEdata is collected (via snapshots and otherwise) into data warehouse and into WISEdash.
Refer to the diagrams below for a visual representation of WISE data flow:
Data Privacy
For resources on data privacy, refer to the Student Data Privacy page.
Getting Help
Resources
- Detailed snapshot preparation guide: instructions for snapshot and walkthrough for all data components
- WISE overview: WISE intro video, basics about WISE
- WISEdata Help: links to WISE help pages and useful resources
- Info for Schools: basics of getting started with WISEdata
- Data Elements: list of links to all WISEdata data elements and their descriptions, uses, and codes
- Knowledge Base articles: useful articles on validations and other related topics
-
WISExplore: home page for WISExplore
- WISELearn: homepage for WISELearn, educator resources
- WISEdata Events Calendar: View deadlines, trainings, webinars, and other events
- Google Currents: WISEdata community to view and post questions and comments to fellow users
Getting Help Directly
Have a question or an issue you need help solving? Please submit a help ticket.
Giving Feedback
Just click the big, purple button below!