Teacher Dashboard
Enter a class code to fetch your students' progress from Supabase. Optionally filter by student number. Each record shows when it was last updated and a summary of progress across subjects.
Setup notes (for teachers)
This prototype uses Supabase to persist student progress. To set it up in your own project:
create table if not exists public.student_progress(
class_code text not null,
student_no int not null check (student_no between 1 and 30),
progress jsonb not null default '{}'::jsonb,
updated_at timestamptz not null default now(),
primary key (class_code, student_no)
);
alter table public.student_progress enable row level security;
-- Development policies (open). Tighten policies before production.
create policy "read_all" on public.student_progress for select using (true);
create policy "write_all" on public.student_progress for insert with check (true);
create policy "update_all" on public.student_progress for update using (true) with check (true);
Replace the SUPABASE_URL and SUPABASE_ANON_KEY below with your actual project values.
Row level security policies should restrict access to your own class code.