Case Study: Philadelphia Literacy Initiative

1. Introduction

Overview:

The Philadelphia Literacy Initiative, part of the Urban Affairs Coalition (https://uac.org/), operates a network of volunteer tutors who work with students from pre-kindergarten through third grade. We built a web-based platform to modernize how the initiative tracks tutoring sessions, monitors student progress, and manages their volunteer tutor network.

The platform replaces manual tracking methods with a centralized system featuring session logging, student progress tracking, and an AI-powered reporting chatbot that allows administrators to query data using plain language.

Challenge:

Creating an intuitive session tracking and reporting platform for a user base that trends older, while ensuring compliance with student privacy requirements and providing administrators with powerful yet accessible data querying capabilities.

2. The Problem

Background:

The Philadelphia Literacy Initiative coordinates volunteer tutors who work with young students on literacy skills. Before this platform, the organization relied on manual processes, spreadsheets and paper records, to track which tutors worked with which students, what skills were covered, and how students progressed over time.

Pain Points:

• Manual tracking methods made it difficult to maintain consistent records across all tutoring sessions
• No centralized system for monitoring tutor activity and student progress over time
• Reporting was cumbersome—pulling insights from scattered records required significant manual effort
• Older user base needed a solution that wouldn't create technical barriers to adoption

3. Our Solution

Discovery Process:

The client initially needed a way to modernize their session tracking. While the original vision was somewhat broad, the core requirement was clear: track sessions between tutors and students in a way that captures what was worked on and how it went. From there, the platform evolved into a comprehensive oversight tool with AI-powered reporting capabilities.

Proposed Solution:

• Session Reporting System:

  • One-on-one tutoring sessions (single tutor, single student)
  • Small group sessions (one tutor, multiple students)
  • Classroom support (teacher working with an entire class)
  • Captures date/time, duration, session type, curriculum, skills worked on, reading materials, and progress metrics

  • Student Management:

  • Secure student records with privacy-compliant storage (no real names stored)

  • Individual student profiles tracking their journey from PreK through 3rd grade

  • Progress Tracking:

  • Historical view of each student's development over time

  • Ability to see skill progression across sessions and grades

  • AI-Powered Reporting:

  • Natural language chatbot for querying session data

  • Export reports as PDFs for sharing and record-keeping
  • Designed for accessibility—no technical knowledge required

  • Admin Dashboard:

  • Tutor and student management tools

  • Activity monitoring and session logs
  • Centralized access to all platform data

Technology Stack:

• Backend: Django (Python)
• Frontend: Django HTML Templates with Tailwind CSS
• Database: PostgreSQL
• AI Integration: OpenAI API (chatbot functionality)
• Platform: Web (responsive design for mobile and desktop)

4. Implementation

Platform Development:

• Built a lightweight Django application using HTML templates for fast, accessible page rendering
• Implemented Tailwind CSS for consistent styling and mobile responsiveness
• Designed UI specifically for accessibility, accounting for the older primary user base

Session Tracking System:

• Created flexible session logging supporting one-on-one, group, and classroom formats
• Built structured data capture for curriculum, skills, reading materials, and progress metrics
• Implemented privacy-compliant student records without storing personally identifiable information

AI Reporting Integration:

• Integrated OpenAI to power a natural language query interface
• Users can ask questions in plain text (e.g., "Show me all sessions for tutor X" or "What skills did student Y work on this month")
• Built PDF export functionality for generating shareable reports

Accessibility Focus:

• Prioritized intuitive navigation for users less comfortable with technology
• Minimized complexity in UI design while maintaining full functionality
• Ensured the platform works seamlessly across screen sizes

5. Results

Product Outcomes:

• Launched a fully functional web platform for session tracking and reporting
• Migrated the initiative from manual record-keeping to a dedicated digital system
• Established a single source of truth for all tutoring activity and student progress

Technical Achievements:

• AI-Powered Plain Language Queries: Administrators can retrieve any data without technical knowledge
• Privacy-Compliant Architecture: Student data stored without real names to meet compliance requirements
• Accessible Design: Platform successfully adopted by older user base with minimal friction
• Flexible Session Logging: Supports multiple session formats (1:1, group, classroom) in one unified system

Business Impact:

• Eliminated manual tracking overhead: No more spreadsheets or paper records to maintain
• Improved visibility: Admins now have complete oversight of tutor activity and student progress
• Streamlined reporting: AI chatbot dramatically reduces time needed to pull insights and generate reports
• Scalable foundation: Platform can grow with the initiative as they onboard more tutors and students

6. Lessons Learned

Key Takeaways:

• Accessibility Must Be Intentional: Designing for an older user base requires actively reconsidering assumptions about how people navigate applications. What feels intuitive to developers may create barriers for less tech-savvy users.

• AI Can Democratize Data Access: A natural language query interface removes technical barriers, allowing non-technical administrators to extract insights without learning query languages or complex reporting tools.

• Privacy Compliance Shapes Architecture: Building student privacy into the data model from the start (no real names stored) avoided potential compliance issues and simplified the security posture.

• Iterative Feedback Improves Adoption: Rolling out to real users and patching based on their feedback ensured the platform actually worked for the people using it daily.

7. Conclusion

Summary:

The Philadelphia Literacy Initiative now has a dedicated digital platform that transforms how they track tutoring sessions and monitor student progress. By replacing manual processes with an accessible, AI-enhanced system, administrators can focus on their mission—improving literacy outcomes for young students—rather than wrestling with spreadsheets and paperwork.

The platform's emphasis on accessibility ensures that the older volunteer base can fully utilize the system, while the AI reporting chatbot provides powerful data querying capabilities without requiring technical expertise.