A custom training and booking management system for safeguarding training courses

Wakefield Safeguarding Children Partnership: Booking system

A custom training and booking management system for safeguarding training courses

A cost-effective, bespoke solution

The challenge

Wakefield Safeguarding Children Partnership (WSCP) is a partnership of statutory, voluntary and community agencies working to safeguard children and promote the welfare for children and young people in Wakefield. One of the primary services offered by the WSCP is multi-agency and educational training, which is offered to professional agencies and educational institutions across Wakefield to provide in-depth training on a wide range of safeguarding topics.

WSCP needed to update their outdated training and booking management system, which had met the organisation’s needs at the time of launch but no longer catered for evolving requirements. They needed a cost-effective solution that offered all the functionality of an established, off-the-shelf product, with a modern responsive website to match. Having researched various systems and accompanying web builds that all came up short, WSCP partnered with us, tasking us to deliver a new, custom training and booking management solution. As part of the project, we also redesigned the WSCP website for full integration with the system, which you can read about here.

The solution:

We developed a custom training and booking management system that integrated seamlessly with the new WSCP promotional website. Our solution allowed users (delegate managers) to register for an account and book multiple training courses for themselves and their colleagues. The system gave a suite of management tools for the WSCP team to manage all bookings from a central, secure location.

The system we designed used custom database tables and models for better storage. It also gave booking and delegate information access without overloading the primary WordPress table architecture. Because the bookings database is likely to grow in size over the coming years, this setup reduces stress on the WordPress primary database tables by storing all data in separate tables (whilst still in the same database) to improve performance. 

Through a comprehensive design and wireframing process, we allowed the WSCP team to fully understand the user experience before progressing to development, allowing for a well planned and approved system (meaning fewer amends post-development).

Delegate Manager

Front end features of the booking system

We created a system where front end users visiting the website can access:
  • Fully searchable and filterable training course listings (includes training courses and online resources)
  • Ability to create and manage a Delegate Manager account to make and access all bookings (includes ability to amend and cancel bookings).
  • Option to book training courses with available spaces for the Delegate Manager and colleagues.
  • Ability to register interest in courses and be notified when new dates or spaces become available (key for high-demand courses).
  • Automation of communication emails to Delegate managers and other booked delegates to confirm course and reminders 10-days before the course (also includes automated emails in case of course cancellations or amendments).
  • On confirmed attendance of a training course, all delegates are asked to complete a short course assessment, which then gives them the ability to download a digital course attendance certificate.
  • Manage a stored database of a Delegate Managers colleagues to allow for quicker course bookings in future (saves on repeatedly entering the same delegate’s information for multiple bookings).

WSCP team features

Team features of the booking system

For the WSCP team, we included the following features:
  • Comprehensive CMS for the creation of training courses and bookable dates, as well as online training resources, with categorisation for improved searchability.
  • Full access to all course bookings, broken down by course and course dates.
  • Ability to print attendance register sheets and dietary requirement sheets, as well as download all course delegates to a spreadsheet format for further data mining.
  • Ability to generate manual communications to all (or some) delegates for a specific course date (allowing for communicating updates to times and locations for example).
  • Ability to set a course for approval required – this means Delegate Managers can still book onto a course, but places must be approved by the WSCP team first (useful for in-demand courses and dates).
  • After a course, WSCP team can set an attendance register to mark if any delegates failed to attend a course. Submission of the attendance register triggers emails to each attended delegate to prompt for course feedback via an online assessment form.
course listings, logins and fully mobile responsive

The result

We’re pleased to say we met the project's original scope. Not only that, but additional discussions allowed us to extend the system to meet new requirements introduced later in the development process. The WSCP team has reported a positive response to the new training system, both internally from a management perspective and front end users.

After the initial development costs, it is projected that the system will deliver large yearly savings compared to original research into an off-the-shelf licenced solutions.

We continue to work with the WSCP on this project primarily in a hosting, maintenance and supporting role for the website. Initial discussions have already been had on possible future extensions to the system that may be introduced post-launch as the team’s requirements evolve

Let's start a project Let's start a project
Latest
Arrow left Arrow right
2023 Web Trends: 3 web trends perfect for enhancing the consumer experience in 2023
Blog Article 2023 Web Trends: 3 web trends perfect for enhancing the consumer experience in 2023
Read more: 2023 Web Trends: 3 web trends perfect for enhancing the consumer experience in 2023
What We Do Web design
Read more: Web design
A flexible digital content solution to inspire sixth-form college students
Project A flexible digital content solution to inspire sixth-form college students
Read more: A flexible digital content solution to inspire sixth-form college students
Latest News Wakefield-based agency invests in local digital talent
Wakefield-based agency invests in local digital talent
Read more: Wakefield-based agency invests in local digital talent
Feel Created Shortlisted for Dev Team of the Year at the UK Dev Awards 2023
Latest News Feel Created Shortlisted for Dev Team of the Year at the UK Dev Awards 2023
Read more: Feel Created Shortlisted for Dev Team of the Year at the UK Dev Awards 2023
What We Do Website & System development
Read more: Website & System development
What We Do Custom WordPress design & development
Read more: Custom WordPress design & development
Blog Article Should I outsource my web development project?
Should I outsource my web development project?
Read more: Should I outsource my web development project?
Feel Created achieves software supplier status on G-Cloud-13 framework
Latest News Feel Created achieves software supplier status on G-Cloud-13 framework
Read more: Feel Created achieves software supplier status on G-Cloud-13 framework
Blog Article Optimising web imagery for quicker loading websites
Optimising web imagery for quicker loading websites
Read more: Optimising web imagery for quicker loading websites
WordPress specialist web build for an established UK estate agency
Project WordPress specialist web build for an established UK estate agency
Read more: WordPress specialist web build for an established UK estate agency
What We Do Hosting and Maintenance
Read more: Hosting and Maintenance
Make it easy for your customer to find you with an up-to-date online web presence
Blog Article Make it easy for your customer to find you with an up-to-date online web presence
Read more: Make it easy for your customer to find you with an up-to-date online web presence
Project A custom WordPress architects website
A custom WordPress architects website
Read more: A custom WordPress architects website
A dynamic WordPress website for a vibrant sixth-form college setting
Project A dynamic WordPress website for a vibrant sixth-form college setting
Read more: A dynamic WordPress website for a vibrant sixth-form college setting
Project Nicholas Associates
Nicholas Associates
Read more: Nicholas Associates
Feel Created appointed by the University of Liverpool to develop Prosper Portal
Latest News Feel Created appointed by the University of Liverpool to develop Prosper Portal
Read more: Feel Created appointed by the University of Liverpool to develop Prosper Portal
What We Do Digital Marketing
Read more: Digital Marketing
Useful tips for defining your brand tone of voice
Blog Article Useful tips for defining your brand tone of voice
Read more: Useful tips for defining your brand tone of voice
Latest News Web Specialist Feel Created Invests in Local Area and Talent To Support Growth
Web Specialist Feel Created Invests in Local Area and Talent To Support Growth
Read more: Web Specialist Feel Created Invests in Local Area and Talent To Support Growth