SEP: Participant Evaluation System
A platform for ProExcelencia operations, replacing scattered Excel files with real-time scholar, activity, volunteer-hour, and performance tracking.
Overview
SEP, the Participant Evaluation System, is the platform I built to help AVAA manage ProExcelencia with live data instead of scattered spreadsheets. It centralizes scholar records, activities, chat clubs, volunteer hours, attendance, and reports across three national chapters.
The cover summarizes the product direction: an education platform built around tracking, reporting, and program visibility.
Context
Before SEP, program tracking depended on Excel files, manual updates, and fragmented historical records. Simple questions took extra time to answer: which scholars were active, how many activities had been completed, which hours were logged, and what still needed attendance review.
The team needed one operational record for activity planning, scholar follow-up, attendance control, and reporting.
My role
I worked on the product structure, data organization, interface design, backend workflows, and implementation. My focus was to move the team from manual spreadsheet management to a digital workflow that matched how ProExcelencia actually operates.
Product scope
SEP became the main platform for managing the scholar lifecycle, from activity registration to performance reporting.
The platform supports:
- scholar database management
- activity and calendar tracking
- chat club participation records
- volunteer-hour logs
- attendance review
- performance reports
- chapter-level monitoring
This view shows the main operations panel: KPI cards, a monthly activity calendar, and lists for upcoming or pending activities.
Reporting and analytics
The reporting views let staff review activity totals, monthly trends, attendance status, distribution charts, and exportable tables without manually filtering spreadsheets.
This screen focuses on program reporting. It turns activity records into charts and tables the team can use for follow-up and internal reports.
Scholar visibility
SEP also includes scholar-facing views for personal progress. Participants can review their activity history, chat club progress, modality patterns, and goal completion.
This view shows the participant side of the platform, where scholars can track their own progress and pending goals.
Operational impact
SEP reduced repetitive tracking work by centralizing activity, attendance, volunteer-hour, and reporting workflows. The team gained more time for scholar mentoring, activity planning, chapter coordination, and impact reporting.
The practical result was a cleaner operating model. Data entered during daily work could later support reports and decisions without rebuilding the same information by hand.
What I learned
This project reinforced that internal tools work when they follow the real workflow. SEP had to reflect how scholars move through activities, how attendance becomes evidence, how volunteer hours are validated, and how historical records become usable data.