KIERA Service Tracker

A web-based platform designed to help students log and manage their volunteer service hours which allows students to find volunteering opportunities and quickly get their hours approved.

Comment

Inspiration

The inspiration for Service Tracker came from recognizing that, while volunteering plays a crucial role in civic responsibility, with 75.7 million Americans contributing 4.99 billion hours annually, the tracking systems in secondary education remain highly flawed. Many schools require service for graduation, yet students consistently face challenges with inconsistent record-keeping, such as forgetting to log dates, locations, and durations, leading to delayed and time-consuming verification processes. Furthermore, we noticed that existing tracking platforms often lack clear analytics, are expensive, rely on ads, or collect unnecessary user data. We set out to build KIERA Service Tracker to eliminate these frustrations and transform volunteer reporting into an organized, meaningful, and motivating experience that strengthens coordination between students, schools, and community organizations.

What it does

Service Tracker is a comprehensive digital platform operating through three interconnected systems designed for students, organizations, and administrators. For students, the platform acts as a centralized hub where they can submit volunteer hours, track progress through an analytics dashboard, download certificates, earn milestone achievements, participate in optional rankings, and use the Explore page’s map and list views to discover and sign up for local events. For organizations, it provides a streamlined interface to post volunteer opportunities, manage participant sign-ups, and directly verify student service hours. Administrators serve as the system’s oversight layer, utilizing a central command center to approve or reject pending hours, verify new organization accounts, and monitor system-wide analytics to ensure accurate data across the entire volunteer ecosystem.

How we built it

We developed the platform using a decoupled frontend-backend architecture, transitioning from an initial Squarespace and Airtable prototype to a robust, custom-built application using Lovable’s AI and prompt features. The frontend is a single-page application built with React, TypeScript, and Vite, utilizing Tailwind CSS, shadcn/ui, and Radix UI to create a responsive, component-driven design system. This client layer connects securely to a Supabase PostgreSQL backend, which handles data storage, authentication, and automated database triggers that process hour submissions in real-time. To deliver enterprise-grade functionality, we integrated several specialized third-party tools, including Leaflet and the Nominatim API for interactive mapping, Recharts for dynamic analytics visualizations, React Hook Form and Zod for input validation, and jsPDF for automated certificate generation.

Challenges we ran into

Building a secure, multi-role platform introduced several significant technical and operational challenges, particularly regarding data privacy and platform limitations. Early in development, we realized our initial platform, Squarespace, could not support our complex functional requirements, forcing us to completely transition our progress to Lovable to achieve greater flexibility. Architecturally, preventing unauthorized data access and false volunteer submissions was a major hurdle; we had to meticulously configure Row Level Security (RLS) policies within Supabase to ensure students could only access their own records while preventing unauthorized users from modifying sensitive data. Additionally, keeping our development organized required strict reliance on Jira to track sprint timelines and systematically manage the resolution of bugs and edge cases during comprehensive testing phases.

Accomplishments that we're proud of

We are incredibly proud of successfully engineering three distinct, fully integrated user systems for students, organizations, and administrators that seamlessly communicate to form a unified verification workflow. We successfully implemented a dynamic hour submission process that intelligently routes data: verified organizations can approve hours directly, while submissions for unregistered organizations automatically fall back to an administrator review queue, ensuring no volunteer effort goes unrecognized. Furthermore, we are proud of our visually intuitive Analytics and Explore pages, which successfully translate complex database records into accessible charts, graphs, and interactive map markers, ultimately transforming a traditionally stressful graduation requirement into an engaging and highly organized digital experience.

What we learned

Throughout this project, we learned that creating effective software requires a meticulous balance between robust backend engineering and clear project management. Technically, we mastered how to construct complex relational databases in Supabase, implement secure role-based authentication, and manage automated data workflows using database triggers. Operationally, utilizing Jira taught us the critical importance of defining specific team roles, tracking sprint timelines, and conducting rigorous edge case and functional testing to identify vulnerabilities. Ultimately, we discovered how to bridge the gap between abstract user needs and tangible digital solutions, learning that a well-designed user interface must be supported by strict data validation and security protocols to maintain system integrity.

What's next for KIERA Service Tracker

Moving forward, our primary focus is to further refine the platform’s verification workflow to make it even easier for newly invited organizations to join the system and validate student hours. We plan to expand the organization's tools by enhancing their ability to promote upcoming community events and manage large-scale volunteer sign-ups directly through the platform. Additionally, we aim to continue conducting research with actual organizations and school administrators to gather practical feedback, iteratively refining our user interface and security measures to potentially scale KIERA Service Tracker for broader deployment.

Built With

Share this project:

Updates