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 may data in the snapshot 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.
At what time of year should the snapshot dashboards be used?
The Snapshot Dashboards are designed to assist with verification and review of student data prior to the date on which the Snapshot will be taken. In general, the Snapshot Dashboards are not intended for historic review. The October 1 Child Count Snapshot Dashboard is an exception as this count is only available as a snapshot dashboard at present. At the beginning of the school year Snapshot Dashboards for Attendance, Discipline, and Year End Completion are valuable to review the quality and accuracy of student data outcomes and demographics for the prior school year. Beginning October 1, review of the Third Friday of September and October 1 Child Count snapshot dashboards is critical to ensure timely and accurate data in the fall snapshot. In May, the Spring Assessment Demographics Snapshot is useful to review the current state of demographics, but not outcomes, during the Spring assessment window.
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 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) of students for which the school is accountable. The Student-School Association 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 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.