College project · full-stack build
Sixth Form CRM
Relationship management for a sixth-form college's partner organisations
A staff-only CRM built as a college project for Notre Dame Catholic Sixth Form College. It keeps the organisations, contacts, visits and events behind the college's employer links in one secure place.
The challenge
Staff needed one place to see which organisations the college works with, who the contacts are, and what visits and events are coming up, instead of piecing it together from spreadsheets and inboxes.
The approach
A Blazor Server application on ASP.NET Core with Entity Framework Core and MySQL, behind JWT sign-in. Organisations are checked against the Companies House API, staff message each other in real time over SignalR, and any data can be exported to a spreadsheet for reporting.
Features
- Companies House lookups: Organisations are matched to the government's Companies House register, so records carry real registered company details.
- Live team chat: A SignalR message hub gives staff real-time conversations without leaving the CRM.
- Visits and events: Staff schedule visits and events, and the dashboard surfaces what's coming up next.
- Excel reports: Pick the data you need and export it straight to a spreadsheet, generated with ClosedXML.
- Verified accounts: Email and SMS verification, password resets and an activity log of who changed what.
- Employer reviews and compliance: Staff rate each placement employer, and every organisation carries its compliance and health and safety dates, so expiring checks don't slip.
Outcomes
- About 40 screens covering organisations, contacts, visits, events, news, reports and administration
- Staff-only by design: registration behind a rate-limited PIN, JWT sign-in, and an activity log of who did what
- Built and demonstrated as a college project; the screenshots here use fictional staff and employers
Built with
- Blazor Server
- ASP.NET Core
- EF Core
- MySQL
- SignalR
- MudBlazor





