About the Data - Snapshot Dashboards
The Snapshot dashboards provided under the Advanced Analysis tab on the top menu are a type of data grid called Dynamic Crosstabs. This type of chart has a list of “Available Data” items such as Race, ELL Status and School Name that you can drag-and-drop to either the “Columns” or the “Rows” position, and arrange as desired for the data combinations that you would like to view. Data can be filtered by clicking the three bars symbol to the right of the data item and selecting the desired values. Some charts offer a choice of “Measures” such as Snapshot Student Count and Current Student Count to use on your chart. To select a different measure, click the white space next to the currently displayed measure, select an alternate measure, then remove the previous measure by clicking “x” in front of the measure name. Your preferred combination of rows, columns and measure can be saved for future use by clicking the Save icon next to Current Session and naming the configuration.
Caution! While there are other options available in the Function box, only "Sum" produces usable results. Only use "Sum".
What are snapshots?
In general terms, snapshots are pieces of data that are copied from active, dynamic tables in the DPI Data Warehouse (DW) at a specific point of time to a “permanent” location to support current and future reporting. This facilitates reporting from an unchanging set of attributes, providing consistent, repeatable query results unaffected by the dynamics of real-world changes and corrections.
The Snapshot dashboards in WISEdash for Districts provide users with tools to query data captured in a snapshot and compare that data to their district’s current data from the main DW tables. These comparisons can help the district identify and correct data reporting deficiencies in preparation for a future snapshot event.
What data is captured in a snapshot?
All current student attributes recorded in the DW such as race, gender, ELL status, etc. - with the exception of disability information - is captured as of the date the snapshot is taken. This means that the snapshot will reflect the current data values from your SIS regardless of the intended use of that particular snapshot. For example, if a student was not known to be homeless on the Third Friday of September but became homeless just recently, a TFS snapshot taken today would record that student as homeless.
Disability information is handled somewhat differently. Disability status, disability codes, education environment, and parentally placed private have associated begin and end dates that are also recorded in the snapshot. This allows the appropriate effective values to be selected for the intended use of that snapshot - i.e. disability attributes effective during the third Friday of September to be used in the TFS snapshot and those effective on October 1 for the Oct. 1 Child Count snapshot.
All enrollment changes and attendance values for the school year-to-date are captured with every snapshot.
How will snapshots be used?
The snapshots will serve as the permanent data source for certified reporting by DPI. This includes TFS Count Date enrollment, Oct. 1 Child Count, certified attendance, high school completion, dropouts, statewide assessment demographics, and others.
How data in the snapshot may be different than the WISEdata portal
Data shown on these dashboards and all other WISEdash dashboards may differ somewhat from data shown on the WISEdata Portal for a number of reasons. Most often, this is due to data reporting errors that cause data values to be nulled or rejected from loading into the DW. In addition, data is loaded nightly into the DW instead of being updated in real time as with WISEdata. Please continue to examine unresolved errors in the WISEdata Portal and rectify these whenever possible. WISEdata is a continuous process that requires regular attention to maintain accurate and current data.
When viewing snapshot data in WISEdash, it is normal and expected that current WISEdata values would begin to change over time as updates are made to the student data in your SIS. Changes made in your SIS will flow through WISEdata to the DW nightly and be reflected in the next snapshot taken.
Oct 1 Child Count data is district level
Special education data is reported at the district level, not school level. School-level reporting is not available for some combinations of filter selections on the Oct 1. Child Count Snapshot dashboard.
Date of Enrollment Filter
The Third Friday of September Snapshot dashboard uses this filter. Enrollment counts are tallied as of the date selected from this filter. Note that student demographic attributes are not necessarily available as of that date. When the “Snapshot” Data View is selected, then the Date of Enrollment filter is automatically set to the third Friday of September. Again, snapshot data shows only disability information as of the Date of Enrollment, but all other attributes are as of the date the snapshot was taken. See “What data is captured in a snapshot” above.
Date of Child Count Filter
The Oct 1. Child Count Snapshot dashboard uses this filter. Enrollment counts for students with disabilities are tallied as of the date selected from this filter. Note that student demographic attributes are not necessarily available as of that date. When the “Snapshot” Data View is selected, then the Date of Child Count filter is automatically set to October 1. Again, snapshot data shows only disability information as of the Date of Child Count, but all other attributes are as of the date the snapshot was taken. See “What data is captured in a snapshot” above.
Student-School Association Filter
This filter allows you to select the set of students that are/were attending your selected district/school or that are/were accountable by, but not necessarily attending, your district/school.
The snapshot dashboards handle security roles in a similar manner as all other dashboards, with a few exceptions.
- Using the Student-School Association set to Accountable enables users to include students that are (or were at the effective date of the snapshot) accountable to their district or school but attending a different school.
- The October 1 Child Count Snapshot dashboard requires district-wide (all schools) authorization.
The charts below are taken from the Spring Assessments Demographics Snapshot dashboard. The user is comparing the current student counts by grade and economic status (green header) to the Spring Assessments Demographics snapshot taken in the prior year (purple header). The comparison shows that while there is a slight drop in the number of students enrolled during the current year assessment periods, the number of economically disadvantaged students is higher. This change may prompt an examination of the reporting of the free and reduced lunch attributes in the district's SIS and WISEdata submissions.