HMG Academy CBT | Teacher Dashboard

—

Total Exams

—

Submissions

—

Overall Pass Rate

—

Integrity Flags

Recent Activity

📭

No submissions yet.

Quick Actions

➕

New Exam

Create assessment

📊

View Results

Analyse performance

📋

Assessments

Manage exams

⚙️

Settings

Setup & SQL guide

Live Exams

No exams are currently live.

Configure New Assessment

Complete all sections then add your questions using any method below.

Academic Context

Subject

Class / Arm

Term

Exam Type

Topic / Chapter (optional)

Academic Session (optional)

Exam Configuration

Duration (Minutes)

Allowed Attempts

Questions to Pull

Pass Mark (%)

Auto-Close Date & Time (optional)

If set, the exam closes automatically at this date and time. Leave blank to close manually.

Open Exam Immediately?

Student Access

Choose who can sit this exam. Registered mode requires students to be in your class roster.

Exam Mode

Any student with the link can enter their name and sit the exam.

Restore / Reuse Exam Package

Import a previously exported HMG CBT exam package JSON. This restores the exam configuration and question bank into this form so you can edit and publish it as a new assessment.

Import Exam Package (.json)

Use this for backup, reuse, or moving an exam between deployments.

Question Bank

Choose how you want to add questions. You can switch between methods — questions are merged into one pool.

📄 CSV Column Order (Row 1 = header, data from Row 2)

              Col1: Question  |  Col2: A  |  Col3: B  |  Col4: C  |  Col5: D  |  Col6: CorrectAnswer  |  Col7: Explanation  |  Col8: Type  |  Col9: Tolerance  |  Col10: Unit  |  Col11: Accept  |  Col12: MRQ_AON  |  Col13: Pairs  |  Col14: Items
            

Columns 1–7 are the base format compatible with all older question banks. Columns 8–14 are optional — leave them blank for MCQ questions. Wrap all cells in double quotes if they contain commas.

Question Type Reference — Col8: Type

mcq Multiple Choice — one correct answer Default if Type column is empty

Col6 (CorrectAnswer): Write exactly A, B, C, or D — whichever option is correct.
Cols 2–5 (A B C D): All four option texts. Leave C and D blank only if your question genuinely has two options.
Cols 9–14: Leave all blank.
"What is the capital of Nigeria?","Lagos","Abuja","Kano","Ibadan","B","FCT moved to Abuja in 1991.","mcq",,,,

mrq Multiple Response — one or more correct answers (checkboxes)

Col6 (CorrectAnswer): List ALL correct option letters separated by commas — e.g. A,C or A,B,D. Order does not matter.
Col12 (MRQ_AON): Write true for all-or-nothing scoring (student must get every correct option to earn any mark). Write false or leave blank for partial credit (student earns a fraction for each correct option chosen).
Cols 9–11, 13–14: Leave blank.
"Which are products of photosynthesis?","Glucose","Water","Oxygen","Carbon dioxide","A,C","CO₂ is consumed, not produced.","mrq",,,,false,

tf True / False

Col2 (A): The label shown on the True button — usually just write True.
Col3 (B): The label shown on the False button — usually just write False.
Cols 4–5 (C, D): Leave blank — True/False only uses A and B.
Col6 (CorrectAnswer): Write A if the statement is True, or B if it is False.
Cols 9–14: Leave all blank.
"Lagos is the capital of Nigeria.","True","False","","","B","The capital is Abuja since 1991.","tf",,,,

short Short Answer / Fill-in-the-Gap — student types a word or phrase

Cols 2–5 (A B C D): Leave all blank — Short Answer has no options.
Col6 (CorrectAnswer): The primary correct answer. Grading is case-insensitive exact match.
Col11 (Accept): Optional. Additional accepted answers separated by the pipe symbol |. Use this for spelling variations, abbreviations, or alternate forms — e.g. H₂O|water|h2o.
Cols 9–10, 12–14: Leave blank.
"The chemical symbol for water is ___","","","","","H₂O","H₂O or water are both accepted.","short",,,,"H2O|water|h₂o",

numeric Numeric Input — student enters a number

Cols 2–5 (A B C D): Leave all blank.
Col6 (CorrectAnswer): The exact correct number — e.g. 9.81 or 42.
Col9 (Tolerance): Acceptable margin of error. Write 0 for exact match, or a number like 0.5 to accept answers within ±0.5 of the correct value. Leave blank for exact match.
Col10 (Unit): Optional display unit shown to the student — e.g. m/s², kg, °C.
Cols 11–14: Leave blank.
"Calculate the acceleration due to gravity (standard value)","","","","","9.81","g = 9.81 m/s²","numeric","0.05","m/s²",,

matching Matching — student pairs each left item to the correct right item

Col1 (Question): The question instruction — e.g. "Match each country to its capital city."
Cols 2–5 (A B C D): Leave all blank.
Col6 (CorrectAnswer): Leave blank — correctness is determined by the pairs in Col13.
Col13 (Pairs): The matching pairs written in JSON format. Each pair is {"left":"...","right":"..."} and all pairs are wrapped in a JSON array. Distractors (extra right-side options that do not match any left item) are appended as {"left":"DISTRACTOR","right":"Extra wrong option"} — the system recognises the keyword DISTRACTOR and uses only the right value as a decoy.
Cols 9–12, 14: Leave blank.

                  "Match each element to its symbol","","","","","","","matching","","","","","[{""left"":""Sodium"",""right"":""Na""},{""left"":""Potassium"",""right"":""K""},{""left"":""Iron"",""right"":""Fe""},{""left"":""DISTRACTOR"",""right"":""Au""}]",""
                

⚠️ In CSV, every double-quote inside a cell must be escaped as two double-quotes (""). The cell itself must be wrapped in double-quotes.

ordering Ordering / Sequencing — student drags items into the correct order

Col1 (Question): The instruction — e.g. "Arrange the following steps of mitosis in the correct order."
Cols 2–5 (A B C D): Leave all blank.
Col6 (CorrectAnswer): Leave blank — the correct order is defined by Col14.
Col14 (Items): All items written as a JSON array in their CORRECT order. The system automatically scrambles them for the student. Write each item as a string — e.g. ["Prophase","Metaphase","Anaphase","Telophase"]
Cols 9–13: Leave blank.

                  "Arrange the stages of mitosis in the correct order","","","","","","","ordering","","","","","","[""Prophase"",""Metaphase"",""Anaphase"",""Telophase""]"
                

⚠️ Same JSON escaping rule: double-quotes inside a CSV cell must be written as "".

Advanced Question Types — Free, Rule-Based, No AI API

cloze — multi-blank fill-in-the-gap. Col14 = JSON array of accepted answers per blank, e.g. ["mass|m","acceleration|a"].
essay — long response scored by keywords/minimum word count. Col11 = keyword list; Col14 = JSON rubric. Teacher review is recommended because no AI API is used.
categorization — student assigns each item to a category. Col14 = JSON array of {"item":"...","category":"..."}.
multi_numeric — several numeric answers in one question. Col14 = JSON array of {"label":"x","answer":3,"tolerance":0}.

✏️ Manual Entry — Type each question directly in the browser. Choose the question type first — the form fields change automatically to match the type. Required fields are marked. Explanation is always optional.

📊 Excel Column Order (Row 1 = header, data from Row 2)

              A: Question  |  B: Option A  |  C: Option B  |  D: Option C  |  E: Option D  |  F: CorrectAnswer  |  G: Explanation  |  H: Type  |  I: Tolerance  |  J: Unit  |  K: Accept  |  L: MRQ_AON  |  M: Pairs  |  N: Items
            

Columns A–G are the base format. Columns H–N are optional — leave the cells empty for standard MCQ questions.

How to fill each column per question type

mcq (or blank) — Fill A–G normally. Column F = A, B, C, or D. Leave H–N empty.
mrq — Fill A–G. Column F = comma list of correct letters e.g. A,C. Column H = mrq. Column L = true or false for all-or-nothing. Leave I,J,K,M,N empty.
tf — Column B = True, Column C = False, leave D and E empty. Column F = A (if true) or B (if false). Column H = tf. Leave I–N empty.
short — Leave B,C,D,E empty. Column F = the correct answer text. Column H = short. Column K = pipe-separated alternates e.g. H₂O|water. Leave I,J,L,M,N empty.
numeric — Leave B,C,D,E empty. Column F = the correct number. Column H = numeric. Column I = tolerance (e.g. 0.5). Column J = unit (e.g. m/s²). Leave K,L,M,N empty.
matching — Leave B–F empty. Column H = matching. Column M = pairs as JSON array: [{"left":"Sodium","right":"Na"},{"left":"DISTRACTOR","right":"Au"}]. Leave I,J,K,L,N empty.
ordering — Leave B–F empty. Column H = ordering. Column N = items as JSON array in CORRECT order: ["Prophase","Metaphase","Anaphase","Telophase"]. Leave I,J,K,L,M empty.

⚠️ Excel Tips: For Matching and Ordering, type the JSON directly into the cell — do NOT wrap it in quotes in Excel (Excel handles the cell boundary automatically). Use regular double-quotes inside the JSON. Save as .xlsx, not .xls where possible.

📄 PDF Question Format Guide

The PDF parser reads text extracted from your PDF and recognises questions by their structure. Each question type has a specific format the parser looks for. Use a text-based PDF (not a scanned image). If your PDF was exported from Word or Google Docs, it will work perfectly.

Format per question type

⊙ MCQ — Multiple Choice

                1. What is 2 + 2?

                A) 3

                B) 4

                C) 5

                D) 6

                Answer: B

                Explanation: 2 + 2 = 4.

Rules: Number each question (1. or 1)). Options must start with A) B) C) D). Answer line must start with Answer: followed by A, B, C, or D. Explanation line is optional.

☑ MRQ — Multiple Response

                2. Which are products of photosynthesis? [MRQ]

                A) Glucose

                B) Water

                C) Oxygen

                D) Carbon dioxide

                Answer: A,C

                Explanation: Glucose and Oxygen are produced.

Add [MRQ] anywhere in the question text. Answer line lists all correct letters separated by commas: Answer: A,C

⟺ True / False

                3. Lagos is the capital of Nigeria. [TF]

                A) True

                B) False

                Answer: B

                Explanation: The capital is Abuja since 1991.

Add [TF] anywhere in the question text. Option A must be the True label, B the False label. Answer is A (True) or B (False).

✏ Short Answer / Fill-in-the-Gap

                4. The chemical symbol for water is ___. [SHORT]

                Answer: H₂O

                Accept: H2O|water|h₂o

                Explanation: Water is H₂O.

Add [SHORT] in the question text. No A/B/C/D options needed. Answer line gives the primary correct answer. Optional Accept: line lists alternate answers separated by |.

# Numeric Input

                5. Calculate the standard acceleration due to gravity. [NUMERIC]

                Answer: 9.81

                Tolerance: 0.05

                Unit: m/s²

                Explanation: g = 9.81 m/s² at sea level.

Add [NUMERIC] in the question text. No A/B/C/D options. Answer = correct number. Optional Tolerance: line gives the ± margin. Optional Unit: line gives the display unit.

⇌ Matching

                6. Match each element to its chemical symbol. [MATCHING]

                Left: Sodium | Right: Na

                Left: Potassium | Right: K

                Left: Iron | Right: Fe

                Distractor: Au

                Explanation: Na=Sodium, K=Potassium, Fe=Iron.

Add [MATCHING] in the question text. Each pair on its own line: Left: [item] | Right: [match]. Optional distractor lines add extra right-side options that do not match any left item: Distractor: [wrong option]. No A/B/C/D or Answer line needed.

⇅ Ordering / Sequencing

                7. Arrange the stages of mitosis in the correct order. [ORDERING]

                Item: Prophase

                Item: Metaphase

                Item: Anaphase

                Item: Telophase

                Explanation: The correct sequence is P-M-A-T.

Add [ORDERING] in the question text. List each item on its own line starting with Item:. The items must be listed in the CORRECT order — the platform scrambles them for the student automatically. No A/B/C/D or Answer line needed.

⚠️ PDF Tips: Use a text-based PDF, not a scanned image (scanned PDFs cannot be parsed). Export from Word, Google Docs, or LibreOffice for best results. Do not mix question types on the same line. Each question must start on a new line with its number.

Questions loaded: 0

Diagnostic Overview

Filter by any dimension then Generate Insights.

Exam

Subject

Class

Term

Type

Integrity

Search Student

Submissions

—

Average Score

—

Pass Rate

—

Highest Score

	Student	Class	Subject	Term	Type	Topic	Score	%	✓/✗/–	Mode	Integrity	Time	Date	Actions

Total Students

Classes

Registered-Mode Exams

Add Students

Add students individually or import a class list via CSV.

Full Name

Student ID

Class

Class Roster

All registered students. Students use their Student ID to access registered-mode exams.

#	Full Name	Student ID	Class	Added	Action

Account

Your HMG Academy CBT account details.

👤 Signed In As

Teacher account · HMG Academy CBT

📊 Platform Summary

—

Exams Created

—

Total Submissions

—

Integrity Flags

HMG Brand & Support

This dashboard is part of HMG Technologies under HMG Concepts — a Nigerian education and technology brand founded in 2015.

👤 Founder / Visioner

Adewale Samson Adeagbo
Data Scientist · STEM Educator · AI-Augmented Solutions Developer · 15+ years classroom teaching across Lagos and Ogun State.

📞 Contact Channels

WhatsApp/Hotline: +234 810 086 6322
Phone: +234 907 790 7677
Brand Email: hismarvellousgrace@gmail.com
Tech/Partnerships: buildingmyictcareer@gmail.com

🏢 Enterprise Operations

Free institution-ready workflows for HMG Academy, schools, tutorial centres, and partner academies. These features use browser downloads and Supabase data already available to your teacher account — no paid API required.

Institution Data Portability & Compliance Tools

📦 Full Teacher BackupExport exams, results summary, student roster, and metadata as JSON for audit or migration.

🖨 Access SheetsPrint exam code/link instruction sheets for invigilators, WhatsApp groups, or CBT lab notice boards.

📋 Deployment ChecklistDownload a ready checklist covering Supabase, hosting, RLS, and post-deployment test steps.

🔐 Security ChecklistDownload a short school/admin checklist for safe handling of links, codes, backups, and result data.

⬆ Import Student Backup JSON

⚙️ Supabase Setup Guide

Run all these SQL statements once in Supabase Dashboard → SQL Editor. This sets up data isolation, security, and all required columns. Run them in order.

🔐 Step 1 — Enable Row Level Security (RLS) on Both Tables

This is the master switch. Without this, all teachers see each other's data.

-- Enable RLS on both tables ALTER TABLE exams ENABLE ROW LEVEL SECURITY; ALTER TABLE results ENABLE ROW LEVEL SECURITY;

🔒 Step 2 — Exams: Teachers Only See & Edit Their Own

Each teacher is completely isolated. They can only read, create, update, and delete their own exams.

-- Teachers can only SELECT their own exams (authenticated) CREATE POLICY "Teachers select own exams" ON exams FOR SELECT TO authenticated USING (auth.uid() = teacher_id); -- Students (anonymous) can read any exam to load it by code CREATE POLICY "Students can read exams by code" ON exams FOR SELECT TO anon USING (true); -- Teachers can only INSERT exams they own CREATE POLICY "Teachers insert own exams" ON exams FOR INSERT WITH CHECK (auth.uid() = teacher_id); -- Teachers can only UPDATE their own exams CREATE POLICY "Teachers update own exams" ON exams FOR UPDATE USING (auth.uid() = teacher_id); -- Teachers can only DELETE their own exams CREATE POLICY "Teachers delete own exams" ON exams FOR DELETE USING (auth.uid() = teacher_id);

🔒 Step 3 — Results: Full RLS Policies (FIXED — Run This Version)

⚠️ The standard subquery approach (SELECT teacher_id FROM exams WHERE id = exam_id) causes a recursive RLS deadlock because the exams table also has RLS enabled. This version uses a SECURITY DEFINER helper function that bypasses RLS safely for the lookup only.

-- Step 3a: Drop old broken policies if they exist DROP POLICY IF EXISTS "Teachers select own results" ON results; DROP POLICY IF EXISTS "Teachers update own results" ON results; DROP POLICY IF EXISTS "Teachers delete own results" ON results; DROP POLICY IF EXISTS "Students can submit results" ON results; -- Step 3b: Create a SECURITY DEFINER helper function. -- This function runs as the DB owner and can read exams without RLS blocking it. CREATE OR REPLACE FUNCTION get_exam_teacher_id(p_exam_id uuid) RETURNS uuid LANGUAGE sql SECURITY DEFINER STABLE AS $$ SELECT teacher_id FROM exams WHERE id = p_exam_id LIMIT 1; $$; -- Step 3c: Recreate policies using the helper function (no recursive RLS) CREATE POLICY "Teachers select own results" ON results FOR SELECT TO authenticated USING (auth.uid() = get_exam_teacher_id(exam_id)); CREATE POLICY "Students can submit results" ON results FOR INSERT TO anon, authenticated WITH CHECK (true); CREATE POLICY "Teachers update own results" ON results FOR UPDATE TO authenticated USING (auth.uid() = get_exam_teacher_id(exam_id)); CREATE POLICY "Teachers delete own results" ON results FOR DELETE TO authenticated USING (auth.uid() = get_exam_teacher_id(exam_id));

📦 Step 4 — Add Anti-Cheat & Answer Columns

Adds columns for per-question answer data, violation counts, and integrity logs.

ALTER TABLE results ADD COLUMN IF NOT EXISTS answers_data JSONB; ALTER TABLE results ADD COLUMN IF NOT EXISTS violations integer DEFAULT 0; ALTER TABLE results ADD COLUMN IF NOT EXISTS violation_log JSONB;

🔗 Step 5 — Your Student Portal Link

Share this with your students. Each exam appends ?code=XXXXXX automatically. The URL below reflects whichever deployment you are currently using (Vercel or GitHub Pages).

🌐 Vercel: https://hmgacademy-cbtsystem.vercel.app/student.html
📄 GitHub Pages: https://cssadewale.github.io/cbt-system/student.html

📦 Step 5 — Add Student Mode Columns to Existing Tables

These columns enable registered-student exams and track how each student sat the exam.

-- Add exam_mode column to exams table ALTER TABLE exams ADD COLUMN IF NOT EXISTS exam_mode text DEFAULT 'open'; -- Add student identity columns to results table ALTER TABLE results ADD COLUMN IF NOT EXISTS student_id_ref text; ALTER TABLE results ADD COLUMN IF NOT EXISTS student_type text DEFAULT 'open'; ALTER TABLE results ADD COLUMN IF NOT EXISTS answers_data JSONB; ALTER TABLE results ADD COLUMN IF NOT EXISTS violations integer DEFAULT 0; ALTER TABLE results ADD COLUMN IF NOT EXISTS violation_log JSONB;

👨‍🎓 Step 6 — Create Students Table

This table stores your class roster for registered-mode exams. Each teacher only sees their own students.

CREATE TABLE IF NOT EXISTS students ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), teacher_id uuid REFERENCES auth.users(id) ON DELETE CASCADE NOT NULL, full_name text NOT NULL, student_id text NOT NULL, class text NOT NULL, created_at timestamptz DEFAULT now(), UNIQUE (teacher_id, student_id) ); -- Enable RLS — teachers only see their own students ALTER TABLE students ENABLE ROW LEVEL SECURITY; CREATE POLICY "Teachers select own students" ON students FOR SELECT USING (auth.uid() = teacher_id); CREATE POLICY "Teachers insert own students" ON students FOR INSERT WITH CHECK (auth.uid() = teacher_id); CREATE POLICY "Teachers delete own students" ON students FOR DELETE USING (auth.uid() = teacher_id); -- Students (anonymous) can read roster to verify their ID during exam CREATE POLICY "Anyone can verify student ID" ON students FOR SELECT USING (true);

⚠️ Step 7 — Fix Existing Teachers Already on the Platform

If teachers registered BEFORE the profiles table was created, they have no profile row and will be blocked on login. Run this SQL to create active profiles for all existing auth users. Change 'buildingmyictcareer@gmail.com' to your actual admin email.

-- Insert active profiles for all existing auth users -- (Run this ONCE after creating the profiles table) -- It skips anyone who already has a profile row INSERT INTO profiles (id, email, full_name, role, status) SELECT u.id, u.email, COALESCE(u.raw_user_meta_data->>'display_name', split_part(u.email,'@',1)), CASE WHEN u.email = 'buildingmyictcareer@gmail.com' THEN 'admin' ELSE 'teacher' END, CASE WHEN u.email = 'buildingmyictcareer@gmail.com' THEN 'active' ELSE 'active' END FROM auth.users u WHERE NOT EXISTS (SELECT 1 FROM profiles p WHERE p.id = u.id) ON CONFLICT (id) DO NOTHING;

After running this, any new teacher who signs up will automatically get a 'pending' profile via the trigger (Step 4 in the admin SQL guide), and the admin must approve them before they can log in.

📋 CSV Question Format

Your CSV must follow this column order. The Explanation column is optional.

Question, A, B, C, D, CorrectAnswer, Explanation Example row: "What is 2²?","2","4","6","8","B","2 squared means 2×2 which equals 4."

👨‍🎓 Student CSV Import Format

When importing your class roster on the Students page, your CSV must follow this format. Row 1 is the header.

FullName, StudentID, Class Example rows: ADEWALE SAMSON, SS/2024/001, SSS2A FATIMA IBRAHIM, SS/2024/002, SSS2A CHUKWUEMEKA OBI, SS/2024/003, SSS2B

📷 Step 8 — Add Proctoring Data Column

Required for storing student identity photos and periodic exam snapshots from the anti-cheat system.

ALTER TABLE results ADD COLUMN IF NOT EXISTS proctor_data JSONB; ALTER TABLE results ADD COLUMN IF NOT EXISTS time_taken integer DEFAULT 0; ALTER TABLE results ADD COLUMN IF NOT EXISTS attempt_number integer DEFAULT 1;

✅ Step 8b — Add Scoring Count Columns (Fixes Student/Teacher Score Mismatch)

These three columns store the correct, wrong, and skipped counts computed by the student's browser at submission time. This is the ground truth — the teacher dashboard reads these directly instead of re-scoring from answers_data, which could produce different results if the question bank was edited after students submitted. Run this if your teacher dashboard shows different wrong counts than students see.

ALTER TABLE results ADD COLUMN IF NOT EXISTS correct_count integer DEFAULT NULL; ALTER TABLE results ADD COLUMN IF NOT EXISTS wrong_count integer DEFAULT NULL; ALTER TABLE results ADD COLUMN IF NOT EXISTS skipped_count integer DEFAULT NULL;

👑 Step 9 — Admin RPC Functions (Run in Supabase SQL Editor)

These functions let the admin panel see ALL teachers' data across RLS boundaries. The DROP … CASCADE lines remove any old version first — this fixes the "cannot change return type" error.

-- ══════════════════════════════════════════════ -- Drop old versions first (fixes "cannot change -- return type" error from previous runs) -- ══════════════════════════════════════════════ DROP FUNCTION IF EXISTS admin_get_all_profiles() CASCADE; DROP FUNCTION IF EXISTS admin_get_all_exams() CASCADE; DROP FUNCTION IF EXISTS admin_get_all_results() CASCADE; DROP FUNCTION IF EXISTS admin_set_profile_status(uuid,text) CASCADE; DROP FUNCTION IF EXISTS admin_delete_profile(uuid) CASCADE; -- ══════════════════════════════════════════════ -- admin sees all profiles -- ══════════════════════════════════════════════ CREATE FUNCTION admin_get_all_profiles() RETURNS SETOF profiles LANGUAGE sql SECURITY DEFINER STABLE AS $$ SELECT * FROM profiles ORDER BY created_at DESC; $$; -- ══════════════════════════════════════════════ -- admin sees all exams -- ══════════════════════════════════════════════ CREATE FUNCTION admin_get_all_exams() RETURNS SETOF exams LANGUAGE sql SECURITY DEFINER STABLE AS $$ SELECT * FROM exams ORDER BY created_at DESC; $$; -- ══════════════════════════════════════════════ -- admin sees all results (joined with exam info) -- Uses only columns guaranteed to exist. -- Adjust the column list if your table differs. -- ══════════════════════════════════════════════ CREATE FUNCTION admin_get_all_results() RETURNS TABLE ( id uuid, exam_id uuid, student_name text, student_class text, student_id_ref text, student_type text, score integer, total integer, attempt_number integer, time_taken integer, answers_data jsonb, violations integer, violation_log jsonb, proctor_data jsonb, created_at timestamptz, exams jsonb ) LANGUAGE sql SECURITY DEFINER STABLE AS $$ SELECT r.id, r.exam_id, r.student_name, r.student_class, r.student_id_ref, r.student_type, r.score, r.total, COALESCE(r.attempt_number, 1), COALESCE(r.time_taken, 0), r.answers_data, COALESCE(r.violations, 0), r.violation_log, r.proctor_data, r.created_at, jsonb_build_object( 'subject', e.subject, 'teacher_id', e.teacher_id, 'csv_data', e.csv_data ) AS exams FROM results r LEFT JOIN exams e ON e.id = r.exam_id ORDER BY r.created_at DESC; $$; -- ══════════════════════════════════════════════ -- admin can approve / reject teachers -- ══════════════════════════════════════════════ CREATE FUNCTION admin_set_profile_status(p_id uuid, p_status text) RETURNS void LANGUAGE sql SECURITY DEFINER AS $$ UPDATE profiles SET status = p_status WHERE id = p_id; $$; CREATE FUNCTION admin_delete_profile(p_id uuid) RETURNS void LANGUAGE sql SECURITY DEFINER AS $$ DELETE FROM profiles WHERE id = p_id; $$;

⚠️ If you still get a column error, run Step 8 first to add the proctor_data, time_taken, and attempt_number columns, then re-run Step 9.

🔬 Step 10 — Verify Your Setup (Run to Test)

Run this in the Supabase SQL Editor to confirm everything is working. You should see rows returned for exams and results if data exists.

-- Test 1: Confirm RLS policies exist on results table SELECT policyname, cmd, roles FROM pg_policies WHERE tablename = 'results'; -- Test 2: Confirm the helper function exists SELECT proname FROM pg_proc WHERE proname = 'get_exam_teacher_id'; -- Test 3: Confirm admin RPC functions exist SELECT proname FROM pg_proc WHERE proname IN ( 'admin_get_all_results', 'admin_get_all_profiles', 'admin_get_all_exams' ); -- Test 4: Count all results (runs as superuser, bypasses RLS) SELECT COUNT(*) AS total_results FROM results; SELECT COUNT(*) AS total_exams FROM exams;

🚨 Step 11 — One-Shot Fix (Run This If Submissions Are Not Saving)

If students complete exams but results don't appear in your dashboard, run this single SQL block. It safely adds every required column (skipping any that already exist), recreates the INSERT policy that lets students submit, and verifies the setup. Run this in Supabase Dashboard → SQL Editor.

-- ══════════════════════════════════════════════════ -- STEP 11: ONE-SHOT FIX — Run if submissions aren't saving -- Safe to run multiple times (IF NOT EXISTS / OR REPLACE) -- ══════════════════════════════════════════════════ -- 1. Ensure RLS is enabled ALTER TABLE results ENABLE ROW LEVEL SECURITY; ALTER TABLE exams ENABLE ROW LEVEL SECURITY; -- 2. Add all optional columns (safe — skips if already present) ALTER TABLE results ADD COLUMN IF NOT EXISTS student_id_ref text; ALTER TABLE results ADD COLUMN IF NOT EXISTS student_type text DEFAULT 'open'; ALTER TABLE results ADD COLUMN IF NOT EXISTS answers_data jsonb; ALTER TABLE results ADD COLUMN IF NOT EXISTS violations integer DEFAULT 0; ALTER TABLE results ADD COLUMN IF NOT EXISTS violation_log jsonb; ALTER TABLE results ADD COLUMN IF NOT EXISTS proctor_data jsonb; ALTER TABLE results ADD COLUMN IF NOT EXISTS time_taken integer DEFAULT 0; ALTER TABLE results ADD COLUMN IF NOT EXISTS attempt_number integer DEFAULT 1; ALTER TABLE exams ADD COLUMN IF NOT EXISTS exam_mode text DEFAULT 'open'; ALTER TABLE exams ADD COLUMN IF NOT EXISTS close_at timestamptz; -- 3. Drop the old INSERT policy (if it exists) and recreate it -- This is the most common reason submissions silently fail. DROP POLICY IF EXISTS "Students can submit results" ON results; CREATE POLICY "Students can submit results" ON results FOR INSERT TO anon, authenticated WITH CHECK (true); -- 4. Recreate the SECURITY DEFINER helper (safe — OR REPLACE) CREATE OR REPLACE FUNCTION get_exam_teacher_id(p_exam_id uuid) RETURNS uuid LANGUAGE sql SECURITY DEFINER STABLE AS $$ SELECT teacher_id FROM exams WHERE id = p_exam_id LIMIT 1; $$; -- 5. Recreate teacher SELECT policy for results (safe — drop first) DROP POLICY IF EXISTS "Teachers select own results" ON results; CREATE POLICY "Teachers select own results" ON results FOR SELECT TO authenticated USING (auth.uid() = get_exam_teacher_id(exam_id)); -- 6. Verify — you should see the INSERT policy in the output SELECT policyname, cmd, roles FROM pg_policies WHERE tablename = 'results' ORDER BY cmd;

🔬 Live Connection Diagnostic

Click below to run a live test of your Supabase connection and RLS setup. Results appear instantly.

🔑 Change Password

Update your account password.

Teacher Login

Check Your Email

Account Under Review

Access Suspended

Recent Activity

Quick Actions

Live Exams

Configure New Assessment

Active Assessments

Diagnostic Overview

Add Students

Class Roster

📈 Performance Analytics

Score Distribution

Pass vs Fail Ratio

Submission Trend (Last 30 Days)

🏆 Top Students

Account

HMG Brand & Support

🏢 Enterprise Operations

⚙️ Supabase Setup Guide