Syllabus Management System

Associated Board of the Royal Schools of Music (ABRSM)

Key Details

The Challenge

A much talked and dreamt about project: find a way to convert a paper syllabus into a digital format, online, and to give the syllabus team oversight and control over that process. And to do it, initially, with a limited budget.

The Solution

Explore what’s doable and adds real value. Complete that and use it to secure further funds. Plan a staged approach to deliver functionality when needed. Be flexible, agile, and persevere.

Listing syllabuses
Maintaining static data
Transforming relational data to hierarchical data using Altova MapForce
Entity modelling
Entity modelling

Key Tasks

Z

Gather

Gather and review business requirements, interview staff, and incorporate feedback.

Z

Research

Research technologies and solutions. Make recommendations.

Z

Model

Create a data model, validate it, and transform the data as necessary.

Z

Test

Build a solution, test and deploy it.

Z

Workshop

Run workshops and deliver presentations.

Z

Prototype

Build and test prototypes, review feedback, and adjust the solution.

Z

Create

Create PDF, Excel and web-based reports.

Key Features

ASP.NET MVC

Textbook ASP.NET MVC solution with a SQL Server backend database, mapped using Entity Framework.

Altova MapForce

Altova MapForce used to transform relational data transformed to hierarchical XML.

Data Modelling

Data Model prototyped in Access before migrating to SQL Server.

Bootstrap

Boostrap front-end, with functionality extended by JavaScript add-ons and JQuery.

Altova StyleVision

Altova StyleVision used to create reports from the XML.

Key Skills

Coding

Data Analysis

Business Analysis

Communication

Key Technologies

(Microsoft) Access

AJAX

ASP.NET MVC

Bootstrap

C#.NET

CMS

CSS3

Entity Framework

HTML5

JavaScript

JQuery

(Altova) MapForce

SQL Server

(Altova) StyleVision

Visual Studio

XML

(Altova) XMLSpy

XSL

Takeaway

Project Sponsor

The important of having a project sponsor if a project is to succeed, especially if it extends many years and many phases.

Perseverance

The importance of perseverance – solutions aren’t always immediate, but often require some thought and effort.

Staged Approach

The importance of breaking a project down into manageable stages, especially if funding is tight and needs to be continually justified.