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/)