If you are tasked with finding historical information in SIRAS, you are in luck, there is lot's of it.
But that's also the problem as older data adds up and stops making sense when exported later.
Reason being there may be several events that happened during the year, or none all while the student was enrolled.
So if we want any 'old' data from SIRAS to make sense today when reporting on it, we will need a list of who all was enrolled that same year.
We pivot on that larger list with the SIRAS data to identify which records in this 'too much' data from SIRAS we really need to look at.
Here is how you can get that 'too much' data from SIRAS:
You can study how SIRAS query works to find archives during the date ranges requested, or you can use the historical easy button below.
We suggest manually building the query for higher accuracy but review the historical estimates as well, see comparative screenshots.
Both methods have their pros/cons.
If you are doing several years in a row, then it is important that you use RESET SEARCH between each year you are reporting on.
For each year you find, export that data to Excel in separate files.
Here is how you would find students who may have attended during the academic year of 2018-2019
(This assumes your district has used SIRAS for at least 6 years.)
Prepare and save a SIRAS list of the data points you need for this report.
Save the list for using it in the export area.
You will do the past data query below, search to list
then export the data to report on from that year.
Click Search, then predefined queries
Open CALPADS Historical Estimates
Select 2018-2019 from Year for Census Queries (or whatever year you are reporting on)
Click the EOY Census to get all IEP transactions that occurred that academic year. see screenshot below
If you have found records you will be taken to a list.
Then go to /tools/data export/
Export this data to an excel spreadsheet.
Save the academic years into the name of the file so it is easy to identify later.
Then when you have several files for several years, those files can be compared to the SSID list of enrolled students to get final totals for each of the SIRAS files.
Contact support @sirassytems.com if you need further assistance with this.
This is an estimate of 2018-2019 with more open parameters on what records are found:
This also is an estimate from same AY 18-19that is more focused on unique records that have been sent to CALPADS: