Data Validation and Error Reports¶

This page deals with questions related to the data quality reports currently made available on the EFT

Where can I find the Data Validation and Error Reports?¶

These are released per SU on the EFT server. Please reach out the AOE SLDS Support Group if you need help gaining access.

Once logged in, head to the folder:

/SLDS VR/SUXXX/From AOE/Ed-Fi/20XX/checks

Which will have your files from the various checks. If there are rows in the check file, you have an issue, if the check file is no longer there, you don't have any errors for that check. The check file should have a description column, and sometimes an issue/notes column, that will help you determine the actions you need to take to resolve the issue.

Your goal should be to have as little of these errors as possible, and have an explination for the error if the data is actually correct. For example if we say your "gender is outside expected norms", and it's because the school has 20 students and an abundance of girls in one class, make note of that in case we ask about it. We're just looking for explinations as to why the data is outside of what we expect. The Feds ask us these questions when we submit your data to them, so we need your help here in responses to them.

There is also a reports folder that has html based reports based on your submitted data. Please review these for accuracy, they are there to help you review your data and look at it in a different way, so you can spot errors. They are located here:

/SLDS VR/SUXXX/From AOE/Ed-Fi/20XX/reports

Can you explain to me the Outlier report?¶

Initially we called this the 15 percent change check, but we've augmented it to check against state norms.

Additionally, we've changed from 15 to 10 percent to match what our federal partners check for when we submit data.

If the data for a particular field/columns aggregate fails both the 10 percent change and the state norms check, we flag it as an outlier, and this is the high priority error you're seeing.

It's a likely indicator that something is wrong, or that there's been a drastic change in your school. It helps to find this problem or confirm this change with you now so we don't have to down the road.