Student Management

The student management page is the primary view for tracking every child on the platform, from initial intake through active tutoring. Coordinators use it to monitor funnel health, assign tutors, and ensure no student falls through the cracks.

Student List

The student list at /admin/students is a paginated, filterable table showing all children on the platform. It supports funnel-based filtering to help coordinators focus on specific stages.

// Query parameters
?page=1&limit=25&funnel=active&search=ethan

// Response
{ "students": [...], "total": 142, "page": 1, "limit": 25 }

Funnel Tabs

The student list has tabbed filters that segment the funnel. Badge counts are loaded separately for performance.

// Returns badge numbers for each funnel tab
{ "active": 42, "awaiting": 8, "has_options": 5, "needs_attention": 3 }

Student Detail Page

Clicking a student opens the detail view at /admin/students/view/[id]/ with four sub-routes accessible via tabs.

Name Display Convention

Supporting Endpoints

Recent Sessions

// Returns the last N sessions for a specific student
[{ "id": 301, "date": "2026-03-20", "status": "Approved",
   "tutor_name": "Alex Tan (9)", "subject": "Math",
   "checked_in_at": "...", "checked_out_at": "..." }]

Pool Status

// Shows which tutor pool the student is in and match candidates
{ "child_id": 12, "pool": "matching",
  "candidates": [{ "tutor_id": 9, "score": 78, "status": "Pushed" }] }

Parent Detail

// Full parent profile with all children and package info
{ "parent_id": 5, "name": "Sarah Lim", "email": "...",
  "phone": "...", "children": [...], "packages": [...] }

Parent Account Maintenance

// Coordinator-only account maintenance for linked parent users
{ "email": "[email protected]", "password": "demo" }

// Response
{ "parent_user_id": 1789, "updated_fields": ["email", "password"], "password_updated": true,
  "parent": { "id": 1789, "email": "[email protected]", "display_name": "...", "phone": "..." } }

This route is intended for coordinator/operator fixes through the existing worker, not for parent self-service. It supports temporary-password resets for account recovery and email correction after resolving the linked family from the student detail.

Child Insights

The insights system aggregates tutor observations and AI-generated summaries for each child over time.

Readiness Reports

Tutoring Readiness profiles are parent-filled questionnaires scoring children across developmental and learning domains. Alerts trigger when a child has a match (even before first session). Multiple snapshots over time track progress.

// Returns all readiness reports across all children
[{ "child_id": 12, "child_name": "Ethan", "status": "Completed",
   "total_b": 8, "total_c": 10, "total_d": 9, "total_e": 7, "total_g": 18, "total_h": 6, "overall_af": 40 }]

Readiness Domains

Each item is scored 0-3: 0 = Not Yet, 1 = With Full Support, 2 = With Some Support, 3 = Independently. Each domain also has a free-text notes field for qualitative observations. Overall score = B+C+D+E+H (G scored separately).

Subject-Specific Proficiency

In addition to developmental domains, the readiness report includes subject-specific proficiency questions based on the child's level and subject. 459 curriculum topics across 3 subjects are stored in proficiency-topics.json:

Each topic uses a 4-point scale: Not Yet Started, Beginning, Getting There, Proficient. Scores are stored in proficiency_scores_json on the readiness report.

Soft Delete

// Sets deactivated_at = NOW() -- does not delete the record
// Response: 200 OK
{ "success": true, "deactivated_at": "2026-03-27T10:30:00Z" }