National Title IV-E Data Warehouse - PowerPoint Presentation

Slide1

National Title IV-E Data Warehouse SurveyTraci L. LaLiberteUniversity of MNon behalf of the IV-E National Data Taskforce

Slide2

History of TaskforceMulti-state outcome study proposal (2007)Meetings and Conversations (2010-2012)Small group discussions at CSWE, SSWR, other conferences/meetings and phone calls Representatives from 31 universities have participatedCSWE October 2011…a task force is born!2012-2015 Survey, data sharing agreements, pilot development, database development

Slide3

Task Force MembersCalSWEC at BerkeleyUniversity of PittsburghUniversity of Albany & the National Child Welfare Workforce InstituteUniversity of HoustonUniversity of Minnesota

Texas State

University of Georgia

University of

Maryland

Portland State University

Slide4

PurposeDevelop a national picture of the IV-E funded social work workforce: Who are they?Where are they?How long are they staying?

Slide5

Benefits to ParticipationSee how your program fits into national pictureContribute to the national data setBuild an infrastructure for eventually looking at outcomes

Slide6

Current Status and Future DirectionsInitial study:Survey all programs and invite to participate (Fall/Winter 2012)Analyze results of survey (Spring 2013)

Identify source for funding of data collection and analysis (??)

Begin data collection and analysis (Fall 2015)

Future study:

Tie to outcomes (TBD)

Slide7

States Included in the Sample (n=31)ArizonaArkansasCaliforniaColoradoConnecticutIdaho

Indiana

Kentucky

Louisiana

Maryland

Minnesota

Missouri

Montana

Nevada

New Hampshire

New Jersey

New Mexico

New York

North Carolina

North Dakota

Ohio

Oklahoma

Oregon

Pennsylvania

Tennessee

Texas

Utah

Vermont

Washington

Wisconsin

West

Virginia

*

Surveys were submitted by 72 respondents on behalf of 31 states

Slide8

States not included in the SampleNo Program (n=17)Delaware

District of Columbia

Florida *

Hawaii

Illinois

Iowa

Kansas

Maine*

Massachusetts

Michigan

Mississippi

Georgia*

Nebraska

South Carolina

South Dakota

Virginia

Wyoming

* No current program, however did complete survey

No Response/Unknown (n=3)

Alabama

(appears to have a program. Possibly state operated)

Alaska

Rhode Island

Slide9

Title IV-E Program ModelsBSWMSW

Consortium Model

(n=11)

AR, CA, IN, KY

,

LA, MD, NC, NJ,

OH, OK, PA

11

10

State

Operated Model (n=4)

CO, CT, MO, TN

3

4

Individual School Site

Model (n=14)

AZ, ID, MT, ND, NH, NM, NV, OR, TX, UT, VT, WA, WI, WV

13

14

*1 PhD

Consortium

&

Individual School Site

Models (n=2)

MN, NY

2

2

Slide10

How often would your institution/agency be willing to contribute [unidentified] data to a national database?Frequency of Contribution of Data

State Response

N=31

Indiv

.

Response

Count n=72

1 time only

0

0 (0%)

Annually

23 (74%)

48 (67%)

Periodically but not every year

1 (3%)

5 (7%)

Not

at all

0

0 (0%)

Unsure, but we are interested by the idea

5 (16%)

14 (19%)

Missing

2 (7%)

5 (7%)

Slide11

STATEWho CollectsProgram Have Access to Data

Arkansas

Academic Institution

&

Consortium

Yes, some data

California

Consortium

Yes,

all data

Indiana

Missing

Missing

Kentucky

Other -

Yes, all data

Louisiana

Missing

Missing

Maryland

Missing

Missing

New

Jersey (2)

ConsortiumYes, all dataNorth CarolinaConsortiumYes, all dataOhioAcademic InstitutionYes, some dataOklahomaAcademic InstitutionYes, all dataPennsylvania ConsortiumYes, all data

Consortium Models:

Data

C

ollection & Access (n=11)

Slide12

STATEWho CollectsProgram

Have Access to Data

Colorado

Academic Institution/Consortium collects data, “the department is in partnership with institutions of higher learning”

Yes, all data

Connecticut

State Employer

Possibly –need to address sharing issues

Missouri (2)

State

Employer and

Individual School Site

Yes, all data

TN

State Employer

Yes, all data

State Operated Model:

Data

Collection &

Access (n=4)

Slide13

STATEWho CollectsProgram Have Access to Data

Arizona

Academic Institution

Yes, some data

Idaho (2)

State

Employer

Yes,

all data/Missing

Montana

State

Employer

& Academic

Institution

Yes, all data

North Dakota

Missing

Missing

New

Hampshire (2)

State Employer

& Academic Institution

Yes, some data/Yes, all dataNew Mexico (4)State Employer& Academic InstitutionYes, all dataNevadaAcademic InstitutionYes, all dataOregonMissingMissingIndividual School Site:

Data

Collection &

Access (n=14)

Slide14

STATEWho CollectsProgram

Have Access to Data

Texas (14)

State

Employer

Yes, some data/Yes, all data/Possibly

need to address data sharing issues

Utah (2)

State Employer

& Academic Institution

Yes,

some data

Vermont

Missing

Missing

Washington (3)

Missing

Missing

Wisconsin (4)

Academic Institution

Yes, all data

West

Virginia (3)

State Employer& Academic InstitutionYes, some data/Yes, all dataIndividual School Site: Data Collection & Access (cont.)

Slide15

STATEWho CollectsProgram Have Access to Data

Minnesota

Academic

Institution &

Consortium

Possibly –need to address sharing issues/Yes, some

data

New

York

Academic Institution & Consortium

Possibly –need to address sharing issues/Yes, some data

Mixed Model:

Data Collection &

Access (n=2)

Slide16

Specific Categories of Data: Title IV-E Recipient Demographic Data & Post Graduation Data

Slide17

Currently Collect

Do not currently collect but could collect without difficulty

Do not currently collect but

could

with

additional supports

We cannot collect this type of data

We do not foresee collecting this data

Missing Data

If student is currently employed as a CW professional

10

1

0

0

0

Prior to Title IV-E, # of years of paid CW

experience

6

4

1

0

0

Degree funded by Title IV-E dollars (BASW/ BSW/ MSW/Ph.D.)

11

0

0

0

0

Degree earned prior to becoming a Title IV-E scholar

5

5

1

0

0

Student enrollment status (PT/FT/other)

83000Graduation Year110000Name of educational institute 110000Race & Ethnicity101000Languages student speaks fluently46001Age at graduation55100

Title IV-E Recipient Demographic Data: Consortium Models (n=11)

Slide18

Currently Collect

Do not currently collect but could collect without difficulty

Do not currently collect but

could

with

additional supports

We cannot collect this type of data

We do not foresee collecting this data

Missing

Data

If student is currently employed as a CW professional

3

1

Prior to Title IV-E, # of years of paid CW

experience

1

2

1

Degree funded by Title IV-E dollars (BASW/ BSW/ MSW/Ph.D.)

3

1

Degree earned prior to becoming a Title IV-E scholar

1

2

1

Student enrollment status (PT/FT/other)

3

1

Graduation

Year

3

1

Name of educational institute

3

1

Race & Ethnicity121Languages student speaks fluently211Age at graduation121Title IV-E Recipient Demographic Data: State Operated Models (n=4)

Slide19

Currently

Collect

/ without difficulty **

Do not currently collect but

could

with

additional supports

We cannot collect this type of data

We do not foresee collecting this data

Missing Data

If student is currently employed as a CW professional

14

Prior to Title IV-E, # of years of paid CW

experience

10

3

1

Degree funded by Title IV-E dollars (BASW/ BSW/ MSW/Ph.D.)

13

1

Degree earned prior to becoming a Title IV-E scholar

13

1

Student enrollment status (PT/FT/other)

13

1

Graduation

Year

13

1

Name of educational

institute

5

9

Race & Ethnicity

1121Languages student speaks fluently1031Age at graduation1031Title IV-E Recipient Demographic Data: Individual School Site Models(n=14)**Collapsed first two responses into one

Slide20

Currently Collect/ With Support

Do not currently collect but

could

with

additional supports

We cannot collect this type of data

We do not foresee collecting this data

Missing Data

If student is currently employed as a CW professional

2

Prior to Title IV-E, # of years of paid CW

experience

2

*

Degree funded by Title IV-E dollars (BASW/ BSW/ MSW/Ph.D.)

2

Degree earned prior to becoming a Title IV-E scholar

2

*

Student enrollment status (PT/FT/other)

2

Graduation

Year

2

Name of educational

institute

2

*

Race & Ethnicity

2

Languages student speaks fluently

2

*

Age at graduation

2

Title IV-E Recipient Demographic Data: Mixed Models(n=2)

Slide21

Currently Collect

Do not currently collect but could collect without difficulty

Do not currently collect but

could

with

additional supports

We cannot collect this type of data

We do not foresee collecting this data

Missing Data

Length

of work obligation

11

Graduate's fulfillment of her/his work commitment

11

Where the graduate fulfilled her/his commitment (public, private, tribal setting)

11

Is the graduate still employed by that agency

8

1

2

Did the graduate receive a promotion at that agency

6

1

4

Did the graduate make a lateral transfer to another position in child welfare in that agency

1

4

5

1

Job satisfaction

4

1

3

2

1

If the graduate left child welfare, why did they do so

31511Post Graduation Data:Consortium Models (n=11)

Slide22

Currently Collect

Do not currently collect but could collect without difficulty

Do not currently collect but

could

with

additional supports

We cannot collect this type of data

We do not foresee collecting this data

Missing Data

Length

of work obligation

3

1

Graduate's fulfillment of her/his work commitment

3

1

Where the graduate fulfilled her/his commitment (public, private, tribal setting)

3

1

Is the graduate still employed by that agency

3

1

Did the graduate receive a promotion at that agency

2

1

1

Did the graduate make a lateral transfer to another position in child welfare in that agency

2

1

1

Job satisfaction

1

2

1

If the graduate left child welfare, why did they do so

2

11Post Graduation Data:State Operated Models (n=4)

Slide23

Collect With Support

Not

Happening

Missing Data

Length

of work obligation

13

1

Graduate's fulfillment of her/his work commitment

13

1

Where the graduate fulfilled her/his commitment (public, private, tribal setting)

13

1

Is the graduate still employed by that agency

12

1

1

Did the graduate receive a promotion at that agency

12

1

1

Did the graduate make a lateral transfer to another position in child welfare in that agency

12

11

Job satisfaction

12

1

1

If the graduate left child welfare, why did they do so

12

1

1

Post

Graduation

Data:

Individual School Site Models (n=14)

Slide24

Collect

With

Support

Not

Happening

Missing Data

Length

of work obligation

2

Graduate's fulfillment of her/his work commitment

2

Where the graduate fulfilled her/his commitment (public, private, tribal setting)

2

Is the graduate still employed by that agency

2

Did the graduate receive a promotion at that agency

2

Did the graduate make a lateral transfer to another position in child welfare in that agency

2

Job satisfaction

2

If the graduate left child welfare, why did they do so

2

Post

Graduation

Data:

Mixed Models (n=2)

Slide25

In collecting and sharing data for a national database, what barriers might you encounter? (Respondents may select all that apply)Barriers to Collecting Data

n=72

Response

Percent

Response

Count

Time

65%

47

Data is “owned” by another entity (e.g.

state agency HR holds the data)

47%

34

Staffing

50%

36

Funding

31%

22

Other

21%

15

Slide26

IRB/would want state public CW cooperation“Lead” program does not collect data for all consortium programSome data is owned by others. Funding might be a barrierData is “owned” by another entityFERPA regulations(2) – specifically IRBLogistics – getting it all set up so that eventually it is quite automaticOther barriers

Slide27

Pilot – Fall 2015Region 1 – VermontRegion 2 - New YorkRegion 3 – Pennsylvania Region 4 – North CarolinaRegion 5 - Minnesota

Region 6 - Texas

Region 7 – Missouri

Region 8 - Utah

Region 9 - California

Region 10 - Oregon

Slide28

Discussion