Looking for table for SBAC Interim assessment blocks.
Does anyone know where this data is saved?
-
Official comment
Roger that. In that case, the interim assessment blocks are in the exact same table as your summative casspp data. To hone in on those interim assessment blocks, you’ll need to filter by assessment type. Here’s an example:
SELECT * FROM state_data_ca.caaspp_2018_ela WHERE "caaspp_2018_assessType" = 'INTERIM ASSESSMENT BLOCKS'
Does that help?
Comment actions -
That's totally normal. All that means is your ODBC credentials/permissions were created before the 2019 tables were created. When your ODBC credentials are created, we give you access to all existing tables, but when new tables are created (as they are every year for new years of state data), if you want to access these new tables, you'll have to submit a help ticket requesting that we refresh your credentials.
I know this is inconvenient, but it ensures the highest level of security for the sensitive data in your Illuminate database.
Please send an email to help@illuminateed.com asking us to refresh your ODBC credentials/permissions. Feel free to CC me on the email. We will refresh your ODBC access and then you'll have access to these tables as well!
Please sign in to leave a comment.
Comments
8 comments