Planning and Institutional Effectiveness

Data Dashboard and Data Coaches

 

Data Coaches

 

CA Community College Systems

 

UC/CSU Systems (Transfer)

 

Data Dashboard--Tableau

 

Enrollment

 

Course Success

  • Course Success View

    Course Success View Without Student ID Tableau

    (click the above View to access Tableau)

    • Description

      This dashboard provides you longitudinal trends back to Fall 2014 on measures:

      • 15 units first term
      • average GPA
      • average term unit load
      • average total units earned
      • course completion rate
      • course success rate
      • course enrollment
      • persisted to next term
      • persisted to next year
      • unduplicated headcount

      Therefore, you will be able to drill down by variables (college, course, academic year):

      • college
      • campus
      • division
      • department
      • subject
      • course number
      • course section
      • academic year
      • term
      • online

      Additional variables (possibly related to student equity, but not limited):

      • age group
      • ethnicity
      • gender
      • CTE courses
      • day/evening course (day, evening, 100% online)
      • final grade
      • first generation (Y,N)
      • foster youth (Y,N)
      • homeless (Y,N)
      • Incarcerated (Y,N)
      • International student (Y,N)
      • lab (Y,N)
      • Low income (Y,N)
      • Major (degree/certificate program)
      • MESA (Y,N)
      • Online (Hyb1, Hyb2, 100% online, REG)
      • PUENTE (Y,N)
      • student type (continuing, new, returning)
      • term
      • total units earned
      • course transfer status (both UC and CSU, CSU only, not transferable)
      • UMOJA (Y,N)
      • Veteran (Y,N)
      • Zero Textbook Cost (Y,N)

      Additional variables (possibly related to 3SP, but not limited):

      • current educational goals (obtain an AA degree without transfer, obtain an AA degree and transfer, transfer to a 4-year university, earn a vocational certificate without transfer, etc.) 
      • orientation (Y,N)
      • student ed plan (Y,N)
      • student type (continuing, new, returning)
      • load status (part-time vs full-time)
      • load status breakdown (0.1-5.9, 6-11.9, 12-14.9, 15+)
      • high school graduate year
      • high school name

      If you are program coordinator and have student IDs, you can upload your student IDs to this dashboard and run various measures to study your program's effectiveness.

    • Videos

      Video 1: College

      Video 2: Subject

      Video 3: Persistent Rate

    • Reports

      Report 1:

      Report 2:

     

 

Degrees and Certificate

  • Degree and Certificate View

    Degree and Certificate View Without Student ID Tableau

    (click the above View to access Tableau)

    • Description

      This dashboard provides you longitudinal trends back to Fall 2013 on measures:

      • # of degree/certificate earners 
      • total units earned
      • average degree duration
      • 2 year grad rate
      • 4 year grad rate
      • 6 year grad rate
      • 8 year grad rate

      Therefore, you will be able to drill down by variables (college, course, academic year):

      • college
      • completed academic year
      • completed degree (AA, AAT, AS, AST, Certificate of Achievement, and Certificate of Completion)
      • completion term
      • degree program 

      Additional variables (possibly related to student equity, but not limited):

      • age group
      • ethnicity
      • gender
      • first generation (Y,N)
      • foster youth (Y,N)
      • International student (Y,N)
      • total units earned
      • Veteran (Y,N)

      Additional variables (possibly related to 3SP, but not limited):

      • current educational goals (obtain an AA degree without transfer, obtain an AA degree and transfer, transfer to a 4-year university, earn a vocational certificate without transfer, etc.) 
      • high school graduate year
      • high school name

      If you are program coordinator and have student IDs, you can upload your student IDs to this dashboard and run various measures to study your program's effectiveness.

    • Videos

      Video 1: Degree/Certificate

      Video 2: Degree/Certificacte Ethnicity

      Video 3: Navigation

    • Reports

      Report 1:

      Report 2:

  • Awards Dashboard (EMP Progress Measures 1 through 5)

    Awards Dashboard Tableau

    (click the above View to access Tableau)

    20% increase from 2016-2017 on AA & AS (1250) and Certificate; 25% increase on equity

    35% increase from 2016-2017 on ADT (444) ; 40% incased on equity

    Decrease units to 79 on AA & AS

     

 

Guided Pathway (LMC only)

  • Guided Pathway Tableau (LMC Only)

    Guided Pathways Tableau

    (click the above View to access Tableau) 

    • Description

      This dashboard provides you many guided pathway key performance indicators for longitudinal trends back to Fall 2014 on measures:

      • Unduplicated headcount
      • Average units earned
      • Course success
      • Persisted next term
      • 15 units first term
      • Degree/Certs Earned
      • Gateway English (ENGL 100). Successfully completed English 100.
      • Gateway Math (Math 34 (110), 120 (120), 37 (140), 40 (155), and 50 (210)). Successfully completed math. 

      Therefore, you will be able to drill down by demographic:

      • Meta Major (a place holder. No data) 
      • Student Ed Goals (Degree/Transfer, Adult Ed/ESL, Short-Term Career, and Undecided) 
      • Gender
      • Age Group
      • Ethnicity 

      Additional variables with filter function: 

      • Student Type (New, Continuing, Returning)
      • College and Campus
      • Terms and Academic Years
      • Age Group
      • Gender
      • Major (Degree program. The last letter indicated College.  L=LMC)
      • Ethnicity
      • Student Equity (DI groups: Low Income, African American, and Foster Youth)
    • Videos & Trainings

      Training 1: Flex Workshop-Data & Equity Recording

      Video 1: Navigation 

    • Reports

      Report 1: Data and Equity Flex (Guided Pathway Tableau) 8.20.2020

      Report 2: 

 

Employee Diversity Study

 

Zip Code Map

 

SQL Report