Multi-School Educational Tracker Development

Educational Attainment & School Performance Platform Development

I am seeking an experienced full-stack developer to provide technical guidance and potentially help design and build a web-based educational attainment and performance management platform for secondary schools in Scotland.

The platform is currently supported by a mature Excel/VBA prototype and is intended to evolve into a secure, scalable web application capable of serving multiple schools, departments, and user groups.

Project Overview

The system will provide a centralised environment for tracking, analysing and reporting on student attainment, progress and performance.

The platform will support multiple user levels, each with tailored dashboards, permissions and reporting capabilities, including:

- Parents
- Teachers
- Principal Teachers / Faculty Heads
- Senior Leadership Teams (DHT/HT)
- Local Authority / Central Team Staff

Core Functional Requirements include...

- Student Tracking & Attainment
- Record and monitor attainment data across multiple tracking windows.
- Compare current performance against targets and predictions.
- Analyse attainment trends over time.
- Identify students requiring intervention.
- Support qualification tracking and reporting.
- Dashboards & Analytics
- Individual student profiles.
- Teacher dashboards for classes and subjects.
- Department and faculty performance dashboards.
- Whole-school attainment and progress dashboards.
- Senior leadership reporting.
- Interactive charts, visualisations and benchmarking tools.
- Multi-School Structure
- Multi-tenant architecture with multiple schools operating on a single platform.
- Schools only access their own data.
- Central authority users can access data across range of schools.
- Robust role-based permissions and security.

Data Management ideas...

- Import data from school management systems (e.g. SEEMIS exports).
- Automated processing and calculation of attainment measures.
- Historical data storage for trend analysis.
- Export functionality for Excel, PDF and reporting purposes.
- Parent Engagement
- Secure parent portal.
- Access to student progress and attainment information.
- Communication tools and notifications.
- Reporting and progress updates.

Desired Technical Skills

Ideally applicants will have experience in...

- Full-stack web development.
- Secure multi-user platforms.
- Database design and management.
- Educational or management information systems.
- User authentication and role-based permissions.
- Data analytics and visualisation.
- Cloud-hosted applications (Azure preferred).
- API integration and data imports.

What Already Exists

The project is not starting from scratch. A substantial Excel/VBA-based prototype already exists, including...

- Data processing workflows.
- Attainment calculations.
- Reporting logic.
- Dashboards.
- Business rules and educational workflows.

The current Excel/VBA platform is actively used across multiple schools and supports the management of large volumes of attainment and tracking data. The system contains extensive business logic, automated calculations, reporting functionality and user-facing dashboards that have evolved through real-world educational use.

Ideal Applicant

I am looking for a developer who enjoys building data-driven business systems rather than simple websites. Experience with educational software, management information systems, CRM-style platforms, reporting systems or analytics dashboards would be particularly valuable.

Please include:

- Relevant examples of previous projects.
- Technologies you would recommend for the platform.
- High-level thoughts on architecture and approach.
- Estimated availability and rates.

I am an education professional rather than an IT professional. Over a number of years I have developed an attainment and performance management system using Excel, formulas, Power Query and VBA. The platform is now used across multiple schools and demand continues to grow.

Whilst the existing solution remains highly effective, I am increasingly conscious of the limitations of a spreadsheet-based architecture in terms of scalability, security, maintenance and future development. I am therefore seeking professional advice and potentially a long-term development partner to help evaluate the next stage of the project's evolution into a modern web-based platform.

This project may develop into a longer-term partnership for the right developer.