Data Flow and Student Demographics in Educational Systems
Explore the process of data flow from Student Information Systems to WISEdash, the review of demographics snapshots, and the management of student data in educational portals. Learn about issues like mismatched names and birthdates, as well as the calculation of Economic Disadvantaged status in school settings.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
Student Demographics Student Demographics and Spring Snapshot: and Spring Snapshot: Ready, Set, Prep! Ready, Set, Prep! Britt Mueller Britt Mueller WISE Relationship Manager WISE Relationship Manager March 13, 2025 March 13, 2025
Agenda Agenda Data Flow from SIS to WISEdash WISEdata Review WISEdash for Districts Review Components of May Demographics Snapshot Dashboard
Data Flow from WISEdata to Report Card Data Flow from WISEdata to Report Card
Data Flow from WISEdata to WISEdash Data Flow from WISEdata to WISEdash Student Information System LEA / School / District WISEdata Portal WISEdash for Districts WISEdash Public Portal WISEdata Portal Submission Data Entry Validation Review Once the data is submitted correctly, it will flow into the data warehouse, also known as WISEdash. LEAs (school/district) collect student data and enter into their local SIS. LEAs push data from their SIS to the WISEdata Portal for validation. LEAs monitor and review the errors and warnings and make any necessary corrections in their SIS. Accountability Report Card is pulled from the WISEdash for Districts.
Mismatching Name / Birthdate WISEdata column is reported from your SIS. WISEid column is reported from the WISEid app.
Econ Econ Disadv Disadv Status, WISEdata Portal Status, WISEdata Portal (1 of 4) (1 of 4) DPI calculated Econ Disadvantaged Status is made up of two values: Econ Status in Demographics Food Service Eligibility
Econ Econ Disadv Disadv Status, WISEdata Portal Status, WISEdata Portal (2 of 4) (2 of 4) Demographics > Demographics School Level > Characteristics Exports > Student Characteristics > column Y and Z How-to: Audit for Econ Disadv Data
Econ Econ Disadv Disadv Status, WISEdata Portal Status, WISEdata Portal (3 of 4) (3 of 4) Exports > Programs > Student School Food Service Program Associations > Column L Exports > Enrollment 3rd Friday of September > Student School Food Service Program Associations > Column L
Econ Econ Disadv Disadv Status, WISEdata Portal Status, WISEdata Portal (4 of 4) (4 of 4) Result: Economically Disadvantaged Type (FRAN) Part 1: Food Services Eligibility Part 2: Economically Disadvantaged Status Free Lunch Yes F: Eligible for Free Lunch Reduced-Price Lunch Yes R: Eligible for Reduced-Price Lunch Full-Price Lunch Yes A: Economic Disadvantaged - Alt Mechanism Unknown Yes A: Economic Disadvantaged - Alt Mechanism Free Lunch No N: Not Economically Disadvantaged Reduced-Price Lunch No N: Not Economically Disadvantaged Full-Price Lunch No N: Not Economically Disadvantaged Unknown No N: Not Economically Disadvantaged
Econ Econ Disadv Disadv Status, WISEdash for Districts Status, WISEdash for Districts
Why WISEdash? Why WISEdash? What makes WISEdash the best place to review snapshot data??? Snapshots are MADE in WISEdash from WISEdash data giving you the most accurate preview of data before a snapshot. WISEdash data is post error correction showing you data at the end of the pipeline. Some snapshot data ONLY exists in WISEdash. SPED Assessment is only indicated in WISEdash Spring Snapshot Dashboard Graduation Cohorts are also exclusively determined in WISEdash so WISEdash is the best place to look at graduation rates before a snapshot
Whats a Snapshot What s a Snapshot Snapshot Definition: The set of current data that is frozen at a given time is referred to as a snapshot and forms the basis of this static or certified data used for reporting. Reliable -Static- Results: As we report a school year s enrollments, attendance, graduation rates, dropouts, discipline, demographics we need that data to remain Static so that we can reproduce results and rely on those results over time. Copied from Data Flow: To create a static or certified version of data we copy (or snapshot) data that flows into WISEdash on given snapshot dates.
WISEsecure User Roles Basic User Roles Vs Advanced User Roles, as described on the WISE Secure User Roles for WISEdash (DPI webpage)
Application Navigation Application Navigation Dashboards > Snapshots
Data Quality Indicators Data Quality Indicators Data Quality Indicator (DQI) at a glance of your data Points out potential issues 3 types of DQIs Informational count total or percentage Caution data may be questionable or in error Goal: 0 expected total is zero, may still be correct based on student scenario
Current vs Snapshot View Current vs Snapshot View
Dashboard Filters Dashboard Filters (1 of 2) (1 of 2)
Dashboard Filters Dashboard Filters (2 of 2) (2 of 2)
View Student List View Student List If you want to see the students listed within a filter topic, click the underlined topic total for a list of students within that filter selection
Download Student List Download Student List If you want to download the student list, click the Send button in the upper right corner of the graphic and download your preferred file type
Important to Note Important to Note Accountable vs Attending Accountable (default): the student may or may not attend your district but you are responsible for the accountability of the student. Attending: the student attends your district but you may or may not be accountable for them. Acctbl School vs Acctbl Sch Acctbl School: longer title of school name. Acctbl Sch: shorter title of school name.
Spring Snapshot Spring Snapshot These demographics are captured on the snapshot date and used in assessment data reporting for the State Accountability Report Cards, Indicator 3 for children with disabilities, federal consolidated state performance reports (CSPR), and ESSA federal Accountability Indicators. Migrant Status, English Language Learner, Homeless, and Parent in the Military are required for public LEAs only. Race/Ethnicity, Gender, Grade Level, Disability Status, Economically Disadvantaged Status, and Food Services Eligibility for all LEAs.
Spring Demographics Spring Demographics (1 of 2) (1 of 2) Use filters to disaggregate the data into more manageable size to review against SIS reports. Use filters to review totals for important demographics: Economic Status English Learners Students with Disabilities SPED Assessment Homeless If the totals are incorrect, view the student list to see the discrepancy. Once determined, Review the student(s) in WISEdata to see if a validation message is impacting data. Review the student(s) in your SIS to see if the demographics are reported and sending correctly.
Spring Demographics Spring Demographics (2 of 2) (2 of 2) SPED Assessment: student had an IEP at any point during the assessment window (Dec-Jun). SPED: student s current IEP status.
Resources Resources WISEdash for Districts About the Data: Snapshot Dashboards: Includes general information on how the dashboards work, definitions of filters, and details about the data of individual dashboards Snapshot Preparation Guidance: Includes what data is collected in which snapshot, who needs to submit it, why, snapshot preparation presentations and webinars, FAQs, and more WISEdash for Districts: Information, Help, and FAQ WISEdash for Districts Training and User Guides: Contains "how-to" guides, tutorial videos, and other resources
Q & A Q & A Scan the QR Code to go to the WISEdata 2025 Conference webpage. You can leave feedback, view the agenda, read about the sessions, and more! Thank you!
