When Californians approved Prop 49 funding for after school programming, the Los Angeles Unified School District (LAUSD) became its largest recipient. In 2004, when the District received its first round of After School Education and Safety (ASES) funds to support programs among more than 500 schools and 30 nonprofit partner agencies, it met the data challenge through manual processes: data critical to field operations and evaluation was exchanged manually by spreadsheets; information submitted by the nonprofits in Excel files had to be copied and pasted in the District’s own files. Validations of crucial data—including student ID numbers and names—were often made visually, delaying report processing by a matter of months.
To maintain funding, attendance allocations (participants to programs) had to be exact, but on-site reporting by busy staffers led to errors that frustrated both auditors and evaluators. In order to manage after school programs effectively, the District needed a data solution that would shift the collection burden from people to the platform.
Solution: Cityspan automates processes to reduce errors, accelerate reportingTo allow schools and providers to concentrate on program delivery, Cityspan incorporated data expertise into the platform, automating critical processes:
Ensuring timely and high quality data entry
Support accuracy critical for compliance
Results: Compliance ensures renewed funding, encourages further efficiency
Alternative data entry methods and automated validation reduced the data submission and correction cycle from months to minutes, eliminating report delays. Precise allocation gave both the providers and auditors confidence in the attendance and program data, supporting the LAUSD’s requests for renewed funding—a small investment in data technology saved millions of dollars in funding. In fact, the platform’s success has inspired new features that will make program management easier and more rewarding, including site observation reporting and digitized site equipment inventories.
Benefits at a glance:
- Management of more than 1,500 individual grants issued to more than 500 schools and ~30 nonprofit partners
- Increased and sustained funding due to improved compliance
- Validation of files reduced from 3 months to 5 minutes
- More accurate attendance allocation to meet funder scrutiny
- Real-time visibility into program attendance and performance
- Expanded analysis of program retention and student outcomes
- Closer collaboration between school district and nonprofit providers