The Subject Learning Coaches programme, ultimately ran by what was the Department for Education and Skills, is a programme of professional development to raise the standards of education in ‘none higher’ adult education programmes in the UK. Prior to the onset of this project, the programme was managed by independent regional bodies using a combination of a legacy access-driven database application and a collection of spreadsheets and paper based documents.
Working as one half of a small team, I worked to develop a bespoke implementation of SugarCRM provide a single integrated solution. Based on version 3 of SugarCRM, the solution involved the replacement of all the data models within Sugar with custom models and objects, as well as significant alterations to the underlying MVC architecture.
Key points of the project include:
- ~30 data entities with associated Models, Views and Controllers.
- Powerful cross entity searching with upto 30 input fields.
- >50K lines of PHP code managed via CVS.
- Built-in Email sending client, allowing distribution of newsletters with multiple attachments to highly targetted lists.
- Built in document management system.
- Role based permission system with full audit trails and data integrity tools.
- Bespoke data Reporting including instantaneous and historical ’snap shot’ reports.
As the system evolved over the course of almost three years, it became one of the key drivers for the business processes for the management of the SLC programme.
Organisations list
Contacts advanced search
