The Power $ Efficiency of a Data Warehouse

Does this happen in your school district?
 
The Scenario
A director of curriculum and instruction asked each school lead teacher to create a Google spreadsheet of student scores. The file needed to contain each student enrolled in the school Grade 3-8 and list last year’s reading, math, and science score information, the EVAAS Projected score, the Check-in percent correct with the subscores for CI #1 and #2, and I-Ready scores and subscores.
 
This information would be used to help identify students at-risk and to create remediation groups.
The lead teachers started the task and found that it was a very time-consuming task.
 
The Solution
One lead teacher reached out to me and asked if any of this information was in the district’s new data mart system. Yes, all of the data had been uploaded to the system and was easily put into a spreadsheet report by writing SQL code to pull the data from the tables.
Consequently, WITHIN a few hours each school had reports of all of their students with all of the required data.
Exporting the information from the database saved the lead teachers about 15 hours of work EACH!
 
Critical Question
Can you collect all of that information on your hundreds /thousands of students as efficiently as a school district with a data warehouse?
 
A hosted database is the answer. Upload spreadsheets, link the data with student number, wirte simple SQL code using a query tool and run the code and download your spreadsheet with the merged data that your administrators and teachers need.
 
A databses and attached reporting solution does not need to cost tens of thousands of dollars. It can be done for most school districts for less than $10,000. And Data Smart LLC can provide the training so that the data warehouse can be managed in-house by your school district data stewards.