I prepared a proof-of-concept centralized data set from several disjointed email communications and volunteered to develop a tool for administration based on the obvious use-case. As the year went on, they communicated other cumbersome or repetitive tasks that consumed their time. I extended the functionality as requested, and added a visual dashboard to track school-wide and sub-group trends.
Single point of entry for 5-10 editors
Single point of reference for 190 viewers
Extensive cross-referencing with outside data sources to aid in home contact
Task tracking to aide in dual entry with official attendance system
Duplicate records detection
Historical records maintained
Time-based sub-reports for current-day cases