Using Secure Data Portal Workbooks for Data Validation

OSPI publishes workbooks routinely before data is made public.  This is to give schools/districts a chance to validate that the data being sent to OSPI is accurate, and to give leadership time to create communications for the public about the data before it is released.  In this module, we will discuss data validation, or making sure that the data shown reflects what you (and your team) know about your school(s)/district.

Alright, back into the Enrollment District Preview workbook.


It's always a good idea to start with the "About" view so you know what data are included, any data definitions you need to know, what you should be looking at for data validation, and in most cases where the data were pulled from. *Note, this workbook was updated since the September 5th deadline listed on this page.

Once in a view, you will see the views listed at tabs at the top of the page.  This will allow you to switch between views without having to navigate back to the landing page.  Let's click in to the first view, "October 1 Enrollment" to get started with validating data.


You will see that the page is blank and has a couple drop down options.  This is because all workbook on the Secure Portal, with exception of the "DataToolsForAll" subproject, are filtered to only see the schools or schools in your district that you have been granted access to (more on the DataToolsForAll folder in the next module).  This filter is in place to protect student privacy, since the data displayed is built off of student level data. 


We are using the enrollment workbook as an example since we do not suppress enrollment numbers - our example school district is Hockinson SD.  Let's start with selecting your district from the "District Name" drop down menu and walk through some features of Tableau workbooks:
Now select a school:
On to data validation!
The views get more and more detailed the farther you dive into the workbook:


Finally, follow to learn how to download a custom data set:

Now it's your turn to explore and validate your data!