Management information system for a school media programme
TVPSS — School Resource Centre TV
01 / Problem
TVPSS empowers students to run school media programmes including journalism, broadcasting, and hosting, but schools had no shared system for tracking branding assets, crew profiles, equipment inventory, or channel links. Data lived in scattered spreadsheets.
02 / Approach
Built a Spring Boot MVC application with Spring Security for role-based access (registrar, teacher, admin equivalents), server-rendered with Thymeleaf and styled with Tailwind. Designed the PostgreSQL schema around the four resource types schools needed to track, with search and filtering so staff could find what they needed without scrolling spreadsheets.
03 / Architecture
Classic three-tier Spring Boot application: Thymeleaf views, a service layer enforcing access rules via Spring Security, and PostgreSQL as the system of record. Content library management (branding, crew, equipment, channel links) sits behind a unified search/filter layer.
04 / Outcome
A centralized platform that replaced scattered spreadsheets with searchable, role-gated resource management, improving decision-making and communication between individual schools and the central programme team.