A platform supporting longitudinal mathematical education research by managing survey data collected from cohort of pupils, parents and teachers across UK schools.

Solution

The platform organises data into structured, research-ready datasets enabling tracking of participant development over time.

It provides cohort management, with schools, classes, teachers and students populated via class-list uploads. A processing pipeline validates each entity, updates changed records and logs errors. Survey data are imported through a two-phase workflow: first validated and previewed, then persisted on confirmation, ensuring data integrity before committing changes.

Cohorts progress through school years, maintaining links between participants, classes and schools to enable longitudinal tracking. Researchers access data through a secure API with granular, field-level controls to protect sensitive data.

Tech Stack

.NET Core, Next.js and PostgreSQL

Key Features

• Track students, teachers and parents across multiple school years
• Create and collect surveys with customisable question types
• Bulk import class lists and survey data with validation
• Manage schools, classes and participant assignments
• Withdrawal management
• API access with field-level permissions for researchers
• Audit logging for compliance