🚨 Data Integrity Control Center

Critical system-wide data repair and schema enforcement

🚨 REVENUE-IMPACTING SYSTEM FAILURE

37,000 questions are broken and cannot be used for revision

What's broken:

❌ Students see wrong topics when revising (Business Law shows Criminal content)

❌ Mock exams can't be built properly (missing questions)

❌ Progress dashboards show incorrect data (wrong subject counts)

❌ Questions stuck as "unapproved" and invisible to students

❌ Pass predictions broken (Angoff scores missing)

What clicking "RUN FULL REPAIR" will fix:

✅ Correctly categorize all 37,000 questions into FLK1/FLK2

✅ Calculate missing Angoff scores for pass predictions

✅ Approve questions for live use (students can see them)

✅ Assign proper subjects and topics

✅ Fix SQE2 skills display (510 tasks)

⚠️ NO DATA DELETED - Only fixes metadata

⏱️ Takes ~2-5 minutes to run

Click "RUN FULL REPAIR NOW" button below to start

🚨 CRITICAL: Full System Repair

This fixes the broken question database so students can revise properly

What happens when you click:

1️⃣ Processes 100 questions per run (prevents timeout)

2️⃣ Assigns correct FLK1/FLK2 categories based on subject

3️⃣ Calculates Angoff scores for pass predictions

4️⃣ Approves questions for live student access

5️⃣ Fixes SQE2 task display

⚠️ Click multiple times until all items processed

✅ SAFE OPERATION

• No data deleted

• Only adds missing metadata

• Can be run multiple times safely

Targeted Repairs

📊 What happens during repair:

1. Loads ALL questions from database (not limited to 2026)

2. Enforces schema requirements (difficulty, Angoff, FLK type, subtopic)

3. Auto-approves questions that meet quality standards

4. Calculates Angoff scores based on difficulty (easy=0.75, medium=0.60, hard=0.45)

5. Assigns FLK1/FLK2 based on subject mapping

6. Returns detailed statistics of all changes