ADR 0003: Learner hours vs scheduled hours

Context

Adding up event durations double-counts time. - Main campus (AMC) and Fort Collins (FCB) run parallel copies of most sessions. - Some events overlap for the same students, such as individual coaching slots during a small-group block. - Exams and take-home “checkpoints” are scheduled as availability windows of several hours or several days, not seat time. - Times are entered inconsistently: 08:00:00, 1PM, 11:00am, and ends before starts (13:00–04:00).

Decision

The hours table is computed per course × academic year × campus. - scheduled_hours: the sum of event durations. - learner_hours: the union of scheduled time per campus-day, so overlapping sessions count once. - Exams and any event longer than 6 h are excluded. We call them assessment windows and don’t guess whether they are take-home. - Events with no campus count toward both campuses. - When an end time is before the start, an afternoon start (12:00–16:59) is read as a missing PM (13:00–04:00 → 16:00). Anything else is read as an overnight window (17:00–07:30), which the 6 h rule then excludes.

Consequences

Hours are an upper bound on what a student at one campus is scheduled to attend. Hours by teaching method use scheduled time, not learner time. The exclusions and the time repair are documented where the numbers are shown.