1 / 9

Presenters: Ken Meehan, Director of Institutional Research, Fullerton College

Aligning College and MIS Data. Presenters: Ken Meehan, Director of Institutional Research, Fullerton College Craig Hayward, Dean of IT, Planning, and Research, Cabrillo College Terrence Willett, Director of Analytic Applications, Cal-PASS. Ken Meehan. Comments on MIS data flow

helena
Download Presentation

Presenters: Ken Meehan, Director of Institutional Research, Fullerton College

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Aligning College and MIS Data Presenters: Ken Meehan, Director of Institutional Research, Fullerton College Craig Hayward, Dean of IT, Planning, and Research, Cabrillo College Terrence Willett, Director of Analytic Applications, Cal-PASS

  2. Ken Meehan • Comments on MIS data flow • Discussion of key MIS data elements • Importance of building a datamart

  3. Craig Hayward (Cabrillo)MIS data issues • Timing for local data warehouse • SB11 (Ed status) & SB15 (Enroll status) • Unreliable high school of origin and first time/continuing status • Matriculation/Orientation on the Data Mart • Faculty use Cal-PASS SMART tool • FTES

  4. Orientation data – Fall 2008

  5. Early Childcare WORKING DRAFT NOT EXHAUSTIVE Source: http://www.senatorsimitian.com/legislation/entry/sb_1298_education_information_system/ In development Direct data sharing* High level cross-agency systems map of key collections Existing Data sharing through local agencies Planned/ potential CDE Data Systems Non CDE Data Systems National Student Clearinghouse AYP/API CASEMIS CASAS TOPS Pro CSU ERS CCC COMIS CALTIDES** Assessments CPEC CALPADS** CALPASS Prisons, Census Migrant CCTC CASE UC CSS ConApps SACS CDPH EDD Other CDE systems/ units including CDS, Charter schools Other CDE units including Homeless, CALSAFE, Title 3, Private Schools etc. From Franchise tax, benefits system etc. * Does not imply direct data linkages. Only state system linkages shown ** CALPADS is envisioned to replace much of the CBEDS, Language Census, Student National Origin Report and select Consolidated Application data *** CALTIDES is envisioned to collect data primarily from CALPADS and Commission on Teacher Credentialing’s CCTC’s Credential Automation System Enterprise CASE system Source: Interviews with respective agencies, RAND, team analysis

  6. Dimensional Model Cal-PASS Data Flow ETL Object Repository 0607,01612590000001,0000179441,U,,12,ABARCA,CARLOS,09091988,M,500,,,,,,,,,,,,,,,,,,,01,15,1,,,,,,N,010,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,01,10032006,N,275,0,0,4,24,0,0,0,0,0,0,,10032006,X,,,,,,,,,,,,,,,,,,,,,,,N,Y,,,8,,,,,,,,,, 0607,01612590000001,0000154281,9107510861,,11,BLACK,BRITNI,11291990,F,600,,,,,,,,,,,,,,,,,,,00,13,1,,,,,,N,000,N,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,01,10032006,N,302,1,8,6,35,3,15,5,28,4,33,01,10032006,N,340,5,71,12,67,18,90,0,0,7,47,2.5,,,,,,,,,,,N,N,U,72,80,,,,,,,,,, 0607,01612590000001,0000159553,U,,11,BOWIE,EARLISHA,10231988,F,999,,,,,,,,,,,,,,,,,,,00,14,1,,,,,,Y,060,Y,,Y,,,,,,,,,,,,,,,,,,,,,,,Y,,,,,,,,,,,,,,,,,,,01,10032006,N,278,3,23,4,24,4,20,0,0,0,0,,10032006,A,,,,,,,,,,,,,,,,,,,,,,,N,N,,,40,,,,,,,,,, 0607,01612590000001,0000161233,U,, 0607,01612590000001,0000179441,U,,12,ABARCA,CARLOS,09091988,M,500,,,,,,,,,,,,,,,,,,,01,15,1,,,,,,N,010,Y,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 9107510861,,11,BLACK,BRITNI,11291990,F,600,,,,,,,,,,,,,,,,,,,00,13,1,,,,,,N,000,N,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,01,10032006,N,302,1,8,6,35,3,15,5,28,4,33,01,10032006,N,340,5,71,12,67,18,90,0,0,7,47,2.5,,,,,,,,,,,N,N,U,72,80,,,,,,,,,, 0607,01612590000001,0000159553,U,,11,BOWIE,EARLISHA,10231988,F,999,,,,,,,,,,,,,,,,,,,00,14,1,,,,,,Y,060,Y,,Y,,,,,,,,,,,,,,,,,,,,,,,Y,,,,,,,,,,,,,,,,,,,01,10032006,N,278,3,23,4,24,4,20,0,0,0,0,,10032006,A,,,,,,,,,,,,,,,,,,,,,,,N,N,,,40,,,,,,,,,, 0607,01612590000001,0000161233,U,, ETL CUSTOM FILES Cal-PASS Submission Universities K-12 CSU UC UC UC CCCCOMIS LA CSU Private

  7. Comparison of Datamart and SMART Tool * American Indian/Alaskan Native in Datamart

  8. Sources of Differences in Reports • Data from separate submission dates • Differences in filters or parameters • Datamart does not report enrollments under the Program Retention/Success reports for courses that have an Accounting Method of “Other”. • Differences in category boundaries and sort orders

  9. Contact Information Ken Meehan, Fullerton College kmeehan@fullcoll.edu Craig Hayward, Cabrillo College craig@cabrillo.edu Terrence Willett, Cal-PASS/IEBC twillett@calpass.org

More Related