How a University Department Saved 4+ Hours a Week by Replacing Spreadsheets with a Purpose-Built LMS
A university department was managing lecture delivery and student attendance through email, shared drives, and manual spreadsheets. We built a purpose-built LMS in six weeks — automating attendance tracking and saving staff 4+ hours every week.
The Problem
A university department needed to modernise how it delivered course content and tracked student progress. The existing approach relied on a patchwork of email, shared drives, and manual attendance registers — fragmented, time-consuming, and difficult to audit.
The cost was real and weekly:
- No centralised place for students to access lecture recordings
- Attendance tracking was done manually, consuming 4+ staff hours every week
- Lecturers had no reliable visibility into whether content was actually being watched
- Students had no structured path through course material
The goal was a purpose-built system that would centralise delivery, automate tracking, and give staff back meaningful time every week.
Before and After
| Before | After | |
|---|---|---|
| Lecture access | Email attachments, shared drives | Structured lesson portal |
| Attendance tracking | Manual spreadsheet registers | Automatic on lesson completion |
| Staff time on admin | 4+ hours per week | Zero — fully automated |
| Student progress visibility | None | Real-time dashboard for lecturers |
| Content storage | Fragmented across 4 spreadsheets | Single access-controlled platform |
What We Built
- Full-Stack Development
- Video Hosting Integration
- User Authentication
- Attendance Tracking
- Saved per week for staff
- 4+ hrs
- Students and staff on platform
- 200
- Spreadsheets replaced by platform
- 4 → 1
- Spec to live
- 6 weeks
Approach
I built a full-stack LMS designed around two core user types: lecturers who upload and organise content, and students who work through it.
Lecturers can create structured courses and lessons, embed video content, and see exactly which students have completed which modules. Attendance is recorded automatically as students progress through lessons — no manual registers, no spreadsheets, no chasing.
On the student side, the experience is clean and structured: a clear course outline, easy access to recorded lectures, and a visible progress indicator so students always know where they are in the material.
The system was built to fit around existing university workflows rather than replace them wholesale — straightforward enough that no training was needed.
Results
The platform eliminated the manual processes that were costing the department 4+ hours every week:
- Automatic attendance tracking — student progress is logged as they complete lessons, with no staff input required
- 4+ hours saved per week — no more manual registers, no more distributing content via email
- Single centralised platform — all course content, lecture recordings, and student records in one place
- 200 users on day one — staff and students onboarded without a support burden
The learning management system Oliver built has transformed how we deliver lectures. Students can access content easily, and the automatic attendance tracking saves our staff hours every week. Exactly what we needed.
Free 20-minute discovery call — fixed price and timeline before anything is signed.