For my internship and bachelor project at AP Hogeschool , I developed LOVAP, a web-based activity management system for Sint-Maarten Bovenschool in Beveren. It replaces an older system used to manage school activities, offering a modern interface, improved security, and full integration with Smartschool .


What is LOVAP?

LOVAP is a web system I developed for Sint-Maarten Bovenschool to manage activity requests in a more structured and reliable way. Teachers can create requests for things like museum visits or workshops, including details such as classes, times, locations, and costs. Admins can then review, approve, or reject these requests, all communication happens through Smartschool messages. The system also includes a Power BI dashboard to help staff get a clear overview of all activities, relevant data and interesting insights throughout the school year.


Why LOVAP?

Before LOVAP, teachers submitted activity requests through a basic and unsecured form, with communication still going through email, while the entire communication goes through Smartschool. This caused delays, errors, and frustration.

LOVAP solves these issues by:

  • Enforcing authentication via Smartschool
  • Validating inputs before submission
  • Automating notifications and approvals
  • Offering useful overviews and filters for staff
  • Providing insights through a statistics dashboard powered by Power BI

Key Features

1. Request Activities

Teachers can create detailed requests, including:

  • Title, date, and time
  • Classes involved
  • Costs and location
  • Responsible teachers and supervisors
  • Extra notes and context

A multi-step form guides the user through this process.

2. Role-Based Access

Access and features are based on user roles:

  • Teachers: can request and view activities
  • Admins: can approve, reject, and edit any activity
  • Bookkeeping: has access to financial overviews and statistics

3. Smartschool Integration

All communication (approvals, rejections, reminders) happens through Smartschool messages. No more lost emails.

4. Statistics and Insights

Admins can filter by class, year, or status, and view trends in activity volume, cost breakdowns, and many more information using Power BI visualizations.


Tech Stack

  • Frontend: Angular 19 + TailwindCSS + DaisyUI
  • Backend: ASP.NET Core with CQRS (via MediatR)
  • Database: SQL Server (EF Core)
  • Authentication: Smartschool OAuth 2.0
  • Deployment: Windows Server 2025 with IIS
  • Reporting: Power BI Gateway

Development Highlights

Smartschool API Integration

One of the most challenging but rewarding parts was integrating with Smartschool’s SOAP API. This includes secure login, user data syncing, and message sending.
We obtain all the teachers from Smartschool. But because the API is extremely slow (ex. retrieving all teachers (192 people) can take up to 3 seconds), we cache the data in our database and update it every 24 hours. This way, we can quickly access teacher data without hitting the API every time.

Dynamic Class Upload

Admins can upload an Excel file at the start of the school year to set up classes. The system validates structure, prevents duplicates, and logs uploads.

Flexible PDF Generator

When an activity is approved, the system automatically generates a styled PDF with all details. It can be downloaded at any time by the teacher.


Challenges

  • Handling Smartschool’s less-than-modern API
  • Managing role-based access both in frontend (guards) and backend (policy-based)
  • Ensuring good performance with growing activity data
  • Building a clear UI that works for all staff, even those less comfortable with digital tools
  • Ensuring the application works reliable for many years to come, since there won’t be any updates or bugfixes after the project is done.

Outcome

LOVAP has been in production at Sint-Maarten Bovenschool since April 2025 and is actively used by over 150 teachers and staff members. Feedback has been positive, especially around the clarity of the form, ease of approval, and the reliability of the notifications.


Screenshots

(Obviously, for privacy reasons, I cannot just share all the data, so i have blurred some sensitive information in the screenshots below)

Activity Overview Page

  • LOVAP activity overview page showing list of school activities with filters and status indicators

Activity Request Form (multi-step)

  • LOVAP activity request form step 1: entering basic activity details
  • LOVAP activity request form step 2: selecting classes and participants
  • LOVAP activity request form step 3: setting date, time and location
  • LOVAP activity request form step 4: adding costs and financial details
  • LOVAP activity request form step 5: review and submit activity request

Activity Details Page (including editing)

  • LOVAP activity details page showing complete activity information and approval status
  • LOVAP activity details page in edit mode with editable fields for administrators

Admin Overview

  • LOVAP administrator dashboard with activity statistics and management controls

Admin settings page

  • LOVAP admin settings page for configuring system parameters
  • LOVAP settings page showing class setup and Excel upload interface

Smartschool Messages

  • Smartschool message notification about activity approval
  • Smartschool message showing activity details sent to teachers
  • Smartschool integration message displaying activity status update

Possible Future Improvements

  • Add notifications/reminders for upcoming activities
  • Implement a calendar view for activities/integrate with existing smartschool calendar
  • Implement a way to resubmit rejected requests with changes
  • Make class setup fully automated via Smartschool API (removing Excel step)

Code & Docs

This project is not public, if you’re interested in technical details or implementation decisions, feel free to connect with me on LinkedIn and send me a message there!