California Community Colleges SEAP, Vision 2030, and IPEDS Master Datasets (2015–2025

This repository contains the comprehensive master datasets, relational Star Schema architectures, and technical data dictionary reports compiled for doctoral research on predictive equity forecasting across California Community Colleges (CCCCO). The dataset package (3.01 MB zip) includes: 1. Student Equity & Achievement Program (SEAP) Master Table (2016–2025): 364,263 records covering 118 community colleges/centers across 5 core student equity metrics (Persistence, Gateway Completion, Transfer, AD-T Completion). 2. Comparative Data Architecture & Lineage Report: Comprehensive empirical analysis proving that the SEAP master table represents a 3-Year Cohort Tracking Horizon subset of the enterprise Vision 2030 reporting engine. 3. Vision 2030 Data Architecture & Relational Schema Guide (Word Document): Star Schema definitions, entity-relationship models, composite primary key specifications, and BigQuery SQL DDL transformation queries. 4. Federal NCES IPEDS Data Dictionary & Architecture Guide: Comprehensive 10-year (2015–2024) survey documentation mapping 500+ raw institutional variables, CIP program completions, and expenditure metrics. Data Sources: - CCCCO DataVista / LaunchBoard Bulk Export Portal (https://datavista.cccco.edu/exports/new) - U.S. Department of Education NCES IPEDS Data Center (https://nces.ed.gov/ipeds/datacenter/)