Harvard - Examination & Question Banking Platform
Education & Healthcare · 2024

Harvard - Examination & Question Banking Platform

Enterprise examination platform with 55+ granular permissions, multi-level question banking, and bulk import pipeline for medical training institutions

PlatformWeb (.NET 9, Angular)
Stack.NET 9, Angular 20, SQL Server
Visit Live App

A medical training institution with multiple faculties had 15+ instructors writing the same questions independently in every exam cycle.

There were no shared question banks, so a pharmacology question written by one instructor in one department would be written again by another instructor in a different department.

Senior faculty were spending their time on data entry instead of teaching.

The curriculum structure from councils down to individual lectures existed only in disconnected spreadsheets that nobody trusted.

When the institution tried to expand to a second campus, they discovered that nothing was transferable.

Every exam required manual creation of every question, manual formatting, manual printing, and manual grading.

The cost was not just time.

It was the inability to scale.

We built a platform that models the complete academic hierarchy: councils, universities, faculties, academic years, semesters, modules with five format types, subjects, chapters, and lectures.

All navigable through an interactive tree view.

The examination engine supports four question types: MCQ, true/false, fill-in-the-blank, and matching, with a rich text editor for formatting.

Question banks have five visibility levels (private, shared, faculty-wide, public, and subscription) with three permission tiers (read-only, read-write, admin) and optional time-based expiration on shares.

The bulk import pipeline handles Excel, CSV, and JSON files with automatic batch detection, real-time validation, error correction directly in the UI, and retry on failed questions.

55+ granular permissions control access across the entire system.

The analytics dashboard includes an activity heatmap showing three months of question response data.

Full audit trail on every entity.

OTP-based password security.

Everything runs in Arabic and English with server-side rendering.

Results

01

Complete 10-level academic hierarchy digitized: councils, universities, faculties, years, semesters, modules, formats, subjects, chapters, lectures

02

Question bank sharing with 5 visibility levels and 3 permission tiers with time-based expiration

03

Bulk import pipeline supporting Excel, CSV, and JSON with batch detection, validation, and in-UI error correction

04

55+ granular permissions across entity CRUD, admin operations, content moderation, and reporting

05

4 question types: MCQ, true/false, fill-in-the-blank, and matching with rich text formatting

06

Interactive tree view for navigating and managing the full institutional hierarchy

07

Analytics dashboard with 3-month activity heatmap and question response statistics

08

Full audit trail with user attribution and timestamps on every entity change

09

OTP-based password security with email verification and token refresh

10

Server-side rendered Angular app running fully in Arabic and English

Technology Stack

.NET 9Angular 20SQL ServerEntity FrameworkMediatRFluentValidationJWTDockerEPPlusQuill EditorChart.js

Have a similar project in mind?

Let's talk about how we can build it for you.

Start a Project

أركيديا (Arkedia) — استوديو هندسة برمجيات مخصصة مقره القاهرة، مصر. نبني منصات مؤسسية متعددة المستأجرين وتطبيقات جوال Flutter وأنظمة ERP وبنية سحابية وحلول SaaS بالعربية والإنجليزية. تواصل معنا على [email protected].

Arkedia (أركيديا) is a custom software engineering studio based in Cairo, Egypt. We build multi-tenant enterprise platforms, Flutter mobile apps, ERP systems, cloud infrastructure, and SaaS products in Arabic and English. Contact [email protected].