Merced College

Merced Schedule Assessment

Upload a term schedule and check it against Title 5 seat-time rules, cross-department time conflicts, faculty load-unit math, and instructor recognition — entirely in your browser. Nothing you upload is sent to a server.

What this tool checks, and against which rulesShow
Title 5 minute requirement
California Code of Regulations, Title 5 (seat-time)

Compares each section's actual scheduled minutes per class meeting against the state's required minimum for its credit units and meeting pattern — including the holiday-adjusted table for a class meeting only once a week, on a Monday or a Friday.

Cross-schedule conflicts
Overlapping meeting times

Flags any two sections that share a meeting day and an overlapping time window, whether they belong to the same department or two different ones. A same-faculty, same-course, identical-time pair is treated as one cross-listed lecture, not a conflict.

Faculty load-unit math
Faculty Association CBA, Article X

Applies the contract's lecture / lab / activity unit-load ratios and its large-class compensation multiplier to each section's scheduled contact hours. Reports "not computed" rather than guessing when a row's instructional category isn't known.

Faculty roster recognition
Optional roster upload

Flags a section whose instructor isn't found on an uploaded faculty roster. Skipped entirely — not silently passed — when no roster is provided.

Unreadable meeting times
Data-quality check

Flags any row whose meeting days or times genuinely couldn't be parsed, so a gap in your spreadsheet is never mistaken for a clean result.

Cancelled-section exclusion
Optional status column

Excludes a row from every other check once you confirm which of its status column's values mean "cancelled" — shown separately as excluded, never silently dropped.

Faculty load summary
Faculty Association CBA, Article X (full load: 30 units/academic year)

Totals each faculty's computed load across the uploaded file(s) — informational only, no automatic flag, since the real contractual floor is annual (Fall + Spring), not per term. Counts a shared/concurrent lecture cross-listed across sections once, not once per section.

1

Upload your schedule file(s)

One department per file, in whatever column layout that department already uses. You can select or drag in several files at once.

2

Optional: faculty roster

Upload a roster to flag a schedule row whose instructor isn't on it.