Field Submission Checks and Reporting
- 🚸 Student data is submitted to EdFusion
- 🖳 EdFusion doesn't do everything we need
- ⛵ Created a standard process for validation
- 👍 Automated report distribution
- 🛫 Assembled scripted actionable summary report
Current State
EdFusion
🛄 not all that and a bag of chips.
Rules were missed
Let's not go talk about why. 🤬 🙊 🙉 🙈
Examples
Table Cross referencing
- Teachers ⇆ Students ⇆ Courses
- Graduation & Enrollments
Missing Pieces
- No principal submitted
- Missing students
- Attendance
How does a data Collection work?
- 📆 Collection opens
- 📬 Field Submits Data
- ❌ Collection closes
- 🔎 Validation checks are made
- 📨 Report and repeat as necessary?
📞 Where I come in
Called to support staff member while on vacation 🌴
⌨ I like to code
What else do we need?
Created Framework for Checks
Showed it to others...
Of to the races 🏇
🤷♂️ We have a Problem
🎯 Distribute all these files?
😞 That's DMAT's problem
⌨ Remember, I like to code
⏱ Let's save time, forever. 🚀
📊 Summary Reports?
✍ Team offered why this is important to get right
🏄 I created custom reports for each SU
Summary
- Created a standard for others to use
- Solved hard problems for the organization
- Used automated process to:
- Reduce manual labor
- Document how process is done
- Allow reproducible results
🎉 🥳 🧁 🇺🇸 😁 📈 🤑 💸 🌞
🥊 Bonus Round
More to do?
- Pull in more verifications
- Create a report high lighting only errors
- Automate messaging to field about reports
- Review and Audit each year
Luigi
