Curriculum Audit & Repair

Detect and fix misaligned assignments — weekend dates, week mismatches, missing dates, and sequence breaks.

Overview

The Curriculum Audit tool scans all active (non-graded, non-cancelled) assignments for a student and flags issues that could cause assignments to appear on the wrong day or in the wrong order.

To access: From any teacher page, click Homeschool > Audit in the navigation bar, or go to curriculum-audit.html directly.

What it detects

Issue Type Description Example
Weekend Dates Assignments with a due date on Saturday or Sunday Due Feb 16 (Presidents' Day gap)
Week Mismatch Assignment's due date falls outside its assigned week's date range Assigned to Week 5, but due date is in Week 8
Missing Dates Active assignments with no due date set Status is "new" but due_date is NULL
Sequence Breaks Assignments from the same resource appear out of order by date Lesson 7 scheduled before Lesson 6

Running an Audit

  1. Open the Curriculum Audit page
  2. The audit runs automatically on page load
  3. Summary cards show counts for each issue type
  4. Detailed tables appear below for each issue category

To re-scan after making changes, click the Re-scan button in the top-right corner.

Screenshot: Audit summary cards
Summary cards give a quick overview of all detected issues

Fixing Issues

Weekend Date Fixes

  1. The audit suggests the next available weekday for each weekend assignment
  2. Review the suggested dates in the "Fix To" column
  3. Adjust any dates manually using the date picker if needed
  4. Select assignments to fix using checkboxes (or click "Accept All Suggested")
  5. Click Apply Selected Fixes
  6. Confirm the action in the popup dialog

Week Mismatch Fixes

For assignments where the due date doesn't match the assigned week, you can set a corrected date. The system will automatically recalculate the week assignment and day of week.

Missing Date Fixes

For assignments with no due date, pick an appropriate date using the date picker. The system validates that you choose a weekday within a school week.

⚠️

Validation: The repair system rejects dates that fall on weekends or outside any school week. If a date is invalid, the date picker border turns red.

What Repair Does

When you apply a fix, the system updates three things for each assignment:

  1. due_date on student_assignments — the source of truth for scheduling
  2. week_id on assignments — recalculated from the new date's school week
  3. day_of_week on assignments — recalculated (1=Mon through 5=Fri)

All changes happen in a single database transaction. If any fix fails, all changes are rolled back.

Understanding Sequence Breaks

Sequence breaks are informational — they show where assignments from the same curriculum resource are scheduled out of their intended order. For example, if "Math Mammoth Ch.5 L.2" is dated before "Ch.5 L.1", that's a sequence break.

These are shown in a read-only table for review. To fix them, adjust the relevant due dates using the weekend or mismatch fix tools above.

Tips

  • Run the audit after any bulk curriculum changes or imports
  • Check the audit after holiday breaks to catch gap assignments
  • The "Select All" checkbox makes bulk fixing quick
  • After applying fixes, the page automatically re-scans to verify
  • A green "All Clear" message appears when no issues remain