Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Page Properties

Meeting Date:

Purpose:

Data Warehouse Advisory Group

Participants:

Mark Cohen, Steve Klein, Crystal Hernandez, Craig Hayward, Alex Jackl, Denise Inciong, Dulce Delgadillo, Dustin Tamashiro, Elaine Kuo, Jake Kevari, Jenni Allen, Valerie Lundy-Wagner, Virginia Moran, Z Reisz

Agenda

Item

Notes

1

Update of where the CCC Tech Center is with Data Center project

Image Added
2

Review of the prioritized of work for CCC Data for the current fiscal year

CCC Data: Data Source Prioritization - Draft

  • For Employment Development Department Unemployment Insurance Wage File, EDD is no longer accepting individual requests from colleges

3

The CO gets a direct match with EDD, but it is not part of MIS
Yes


The EDD data shows up in Salary Surfer
But colleges only see the aggregated data.
It's already a CO tool.
https://salarysurfer.cccco.edu/SalarySurfer.aspx

It contains EDD data but the issue is that the MOU does not allow the CCCCO to distribute that EDD data to colleges at a level that is more granular (i.e., appropriate to include in the DW).

Agreed--unitary level most helpful

If unitary records not available, some kind of vetted standard or threshold of acceptable performance would be more helpful than just some high-level aggregation...?

Decisions

Item

    Action Items

    Item

    •  Mark Cohen Send out Data Dictionary to Advisory Group

    Open Questions

    3

    Question

    Answer

    Date Answered

    1

    Dulce Delgadillo:

    Does the CCCApply application data include CCCApply Noncredit application data as well?
Can

    Yes, it does.

    2

    Dulce Delgadillo:

    Can you please send out that Data dictionary please? That would be great!

    2

    What is needed for colleges to access Canvas Data?

    Action Item noted above.

    3

    Do we know which data will be included for the Canvas Data?

    We do, Canvas has an API that we are leveraging. We will be leveraging API key provided by administrator from local college to pull data set out and into the data warehouse. It is a very robust data set, and we do have data dictionary for the Canvas data to have an idea of what is there.

    Canvas_Data_Domains 20170801.xls

    4

    In terms of Canvas Data, understanding is all that is needing is Canvas API key, is additional effort needed?

    All that is needed is Canvas API key, additional effort on the college side is not needed. How to obtain key is pretty straightforward.

    5

    Steve Klein:

    Is the Employment Development Department Unemployment Insurance Wage File data, what is currently being collected as part of the MIS data that CO does collect? The EDD data?

    Dulce Delgado:

    • It is being matched by social security numbers and is part of Adult Ed launch board and Strong Workforce and possibly student success metrics.

    Craig Howard:

    • The CO gets a direct match with EDD, but it is not part of MIS.

    • The EDD data shows up in Salary Surfer.

    • But colleges only see the aggregated data.

    • It's already a CO tool.

    • https://salarysurfer.cccco.edu/SalarySurfer.aspx

    • It contains EDD data but the issue is that the MOU does not allow the CCCCO to distribute that EDD data to colleges at a level that is more granular (i.e., appropriate to include in the DW).

    6

    Mark Cohen:

    Should we be tracking Salary Surfer as a potential data set for CCC Data?

    At this time there is no need for it, Advisory feedback.

    7

    Valerie: at student-enrollment level would need college code
districts share students across colleges, so enrollments are the only clear indicator of which college students "belongs"...?

    48

    Mark, will you summarize the questions, concerns, and share them with the CO?

    59

    Valerie: at student-enrollment level would need college code
districts share students across colleges, so enrollments are the only clear indicator of which college students "belongs"...?

    10

    Virginia Moran:

    If unitary records not available, some kind of vetted standard or threshold of acceptable performance would be more helpful than just some high-level aggregation...?

    11

    Valerie Lundy-Wagner:

    Mark, will you summarize the questions, concerns, and share them with the CO?

    We need some documentation of what's being raised.

    Google Docs perhaps to list those questions

    12

    Virginia Moran:

    Districts share students across colleges, so enrollments are the only clear indicator of which college students "belongs"...?

    13

    Virginia Moran:

    And will FCMAT be republishing the calculator.

    14

    Elaine Kuo:

    There are three foci here: (1) identifying data sets/sources and consider inclusion in the DW; and (2) what data elements are available (in each data set/source) and how they are organized when brought into the DW; (3) what calculations and how these data are applied at the larger system level (and how colleges can support and better understand their own data).