Online Program / ACCJC Analysis

Accreditation rules require institutional review when a program can be completed substantially online. The question sounds simple; the data isn't. I analyzed two years of course and program data, encoded the threshold rules explicitly, and identified approximately 70 programs meeting the online-course threshold — with the logic documented so the answer could be defended, re-run, and audited.

Determining whether a program crosses an online threshold means combining program requirement structures with the actual delivery modes of courses over time — while making defensible decisions about hybrid modalities, cross-listed courses, and terms that behave differently. Everyone had an intuition about which programs were 'mostly online'; accreditation needs a rule-based answer, not an intuition.

• Built SQL analysis over two years of course-section and program data.
• Encoded threshold logic as explicit, reviewable business rules — including how hybrid and variable-modality sections count.
• Validated results with spot checks against catalog reality before anything was reported.
• Delivered the ~70-program list with the methodology attached, so stakeholders reviewed a documented finding rather than a mystery number.

Approximately 70 programs identified for institutional review, accepted by accreditation stakeholders because the path from raw data to answer was inspectable at every step. This is business analysis and data work fused: the deliverable was as much the documented rule set as the list itself.

• SQL analysis across multi-year course and program data
• Business-rule design for ambiguous policy language
• Data validation and compliance reporting
• Stakeholder communication with accreditation audiences