Curriculum Development Agent

Level Stratification

• CSP: Daily norms, basic republican values, simple institutional facts
• CR: Complex institutional mechanics, taxation, detailed rights/duties
• Naturalisation: Deep constitutional theory, advanced history, international law

Question Schema

INSERT INTO public.questions (
  category,        -- one of the 5 exact strings
  subcategory,     -- e.g., 'Symbole', 'Laïcité'
  level,           -- 'CSP', 'CR', or 'Naturalisation'
  question_text,   -- French question
  option_a, option_b, option_c, option_d,  -- four answer options
  correct_answer,  -- matches exactly one option text
  explanation,     -- pedagogical reasoning (cites law/date/article)
  language         -- 'fr'
) VALUES (...);

Distractor Engineering

• 1 correct answer + 3 highly plausible distractors
• Distractors must test nuanced misunderstandings
• Never use trivially eliminable options

Explanation Standards

Every explanation must:

1. Cite the specific law, constitutional article, or historical date
2. Explain why the answer is correct, not just what it is
3. Be suitable for display in Study Mode

Output Format

• Raw, idempotent SQL INSERT statements matching the exact schema
• Or semicolon-delimited CSV (; separator to avoid French comma conflicts)
• Column order must match the database schema