Norco College Counseling Chair Dashboard (2026-2029 RCCD Contract)

Flags two issues inside the selected office-hours window: zero-coverage gaps (no counselor scheduled in-person or remote) and in-person imbalance — weekdays where fewer than 40-50% of staffed counselor-hours are in person. Target: at least 40-50% in-person on every weekday during open hours.

Aggregates each counselor's OBL hours across Summer + Winter intersessions within the same academic year (AY = Jun-May, per RCCD calendar). Summer 2026 and Winter 2027 both belong to AY 2026-27. A counselor's 60-hour obligation is per academic year, fulfilled across any combination of intersessions in that year.

One weekly grid, 7 AM to 9 PM, Monday through Saturday. Each cell shows how many counselors are scheduled at that 30-minute slot (in-person / remote). Hover any cell to see exactly who is working and in what mode. Empty weekday cells are candidate gaps you can offer to adjuncts. Use the week selector to step through the intersession.

Where is the office uncovered? This view lists every weekday (Mon-Fri, non-holiday) within the intersession that has no counselor scheduled in person, plus a department-wide count of uncovered in-person time slots per week. Saturdays and holidays are excluded since coverage is not expected. Use this to spot days to fill before the session starts.

Total overload work (PAID intersession hours + any excess over 60-hr obligation) being requested across all uploaded schedules. Overload is paid hourly per Article X, Sec. H, at 0.00185 FTE/hr.

Which equity / categorical programs have counselor coverage scheduled during the intersession period. Yellow = no coverage.

The faculty workweek aligns with the general 40-hour framework: 30 student contact hours, 5 office hours, and 5 institutional service hours. Only the first two categories (35 hours total) are captured on the weekly schedule. The 5 institutional service hours are documented annually via the Institutional Service Plan and remain flexible at the faculty member's discretion.

Per Article X, counselor intersession hours must fall outside fall/spring semester dates. The 6-week summer session is followed by a "pre-fall" window (through approx. Aug 22) where counseling coverage may continue.

The schedule builder uses these activity codes. Institutional Service activities are tracked separately via the annual Institutional Service Plan, not on the weekly schedule.

Student Contact codes (count toward the 30-hour student contact target)

Office Hours codes (count toward the 5-hour office hours target: 2.5 prep + 2.5 undefined)

Overload and Non-Counted codes