lost and found: tracking down former louisiana students to bring them back to campus jim purcell,...

Lost and Found: Tracking Down Former Louisiana Students to Bring Them Back to Campus

Jim Purcell, Jennifer Morgan and Luke Dowden

Slate.com

3

Addressing the need for an educated Workforce

• Educating those closest to degree • Fine tuning our curricular delivery mechanisms• Sharing of information and students • Greater transferability• Graduating students

• BoR and CALL staff conducted a study to identify where your “stop-out” students are currently located and to obtain current contact information on students that have relocated.

• This project only utilizes directory information. With this information you will be able to contact these students in hopes of getting them back in college to finish their degree.

Scope of the data• For 4-year universities:

– Stopouts since 2000 – Student have 60 hours – Must have acceptable GPA, at least 2.00 or higher

• For 2-year colleges:– Student must be a sophomore in their last term at your institution– Student has 30 hours– Must have acceptable GPA, at least 2.00 or higher

The institutions provided a list of students containing this data:

• Last Name• First Name• Middle Name or Middle Initial• Maiden Name (if applicable)• Most Current Street Address• Most Current City of Residence• Most Current Zip Code• Year last attended

Board of Regents

• Removed students who had earned a credential somewhere else in the state

• 6,056 of 78, 631 ( < 1% had earned a degree)

78,631 Stopouts

Reenrolled ; 19326; 25%

Stopouts; 59305; 75%

First question:• Where are our dropouts?

LegendStudent

1 - 150

151 - 350

351 - 700

701 - 1000

1001 - 1752

Louisiana Statewide StopoutsTotal: 78,631

LegendStudents

1 - 50

51 - 150

151 - 300

301 - 500

501 - 735

4 year Institution StopoutsTotal: 36,466

4 and 2 year Institution Stopouts

4 Year Legend

Students

1 - 50

51 - 150

151 - 300

301 - 500

501 - 735

2 Year Legend

Students

1 - 50

51 - 150

151 - 300

301 - 500

501 - 1561

01 - 1415 - 2930 - 5859 - 206207 - 3874

Legend

Louisiana State UniversityStopouts: 4,553

Legend

LSU Students1 - 1113 - 2729 - 7193 - 152169 - 222

LouisianaState UniversityStopoutsTotal: 3,874

01 - 56 - 1011 - 2627 - 9293 - 4133

Legend

Southeastern Louisiana UniversityStopouts: 4,355

Southeastern Louisiana UniversityStopoutsTotal: 4,133

LegendSELU Students

1 - 1921 - 3439 - 5761 - 133171 - 256

Southern University StopoutsTotal: 2,249

LegendSUBR Students

1 - 67 - 1822 - 3554 - 92110 - 140

Baton RougeCommunityCollege StopoutsTotal: 4,429

LegendBRCC Students

1 - 1619 - 3538 - 6881 - 136

160 - 286

All RegionsTotal 72.8%

Students in Louisiana attend their local community college or university

Legend

Region

1

2

3

4

5

6

7

8

Second question:• What can you tell me about the life and times

of our dropouts/stopouts?

Becky Smith 2003 in Baton Rouge Enrolls at BRCC

Marries and moves in 2006 Becky S. Wilson in Phoenix - enrolls in Community College

Divorces in 2007 Becky Wilson in Phoenix - Education on hold

Adapts full first name in 2008

Rebecca Wilson

Remarries in 2009 Rebecca

Jones

Moves in 2010

Rebecca Jones to Shreveport

Rebecca Jones

Wants to finish degree

What is the challenge?

Overview

23

Hundreds of Data Sources

Clean, Recognize,

Consolidate

InfoBase180 M

US Consumers

Customer Uses:

• Correct names, addresses, phone, email• OLD: 12 Main St, anytown, IL, 60203• NEW: 123 Main Street, Any Towne, IL 60230

• Enhance internal data for more complete picture• Add: Age, income, home value, etc.

• Segment• Understand characteristics of consumers• Monitor for changes

• Contact• Direct mail, email, web campaigns for customer

acquisition, retention

Possible Data Sources• Public information

– U.S. Telephone directories– Motor vehicle registrations*– Driver’s licenses*– Birth records & other public

records– County real estate property

records– Board of realtors records– *May 2000 regulated cutoff

• Specialty data compilers– Product registration

questionnaires / warranty cards– Catalogers– Specialty retailers– Packaged goods manufacturers– Publishers– Buying Activity

Household• Marital status• Credit card indicator• Presence of children• Children’s age ranges• Household size• Income

Household• Marital status• Credit card indicator• Presence of children• Children’s age ranges• Household size• Income

Buying Activity• Apparel• Automotive• Jewelry• Electronics• Telecommunications• Home Furnishings• >700 attributes

Buying Activity• Apparel• Automotive• Jewelry• Electronics• Telecommunications• Home Furnishings• >700 attributes

Interests• NASCAR• Boating• Golf• Health & Beauty• Investments• Auto Enthusiast• Social Causes• > 100 attributes

Interests• NASCAR• Boating• Golf• Health & Beauty• Investments• Auto Enthusiast• Social Causes• > 100 attributes

Wealth Indicators• Highly likely investor• Net worth indicator• Real estate investor• Income producing assets• Discretionary Spending index

Wealth Indicators• Highly likely investor• Net worth indicator• Real estate investor• Income producing assets• Discretionary Spending index

PersonicX• Household-level segments• 100% U.S. coverage• 70 unique clusters • Product purchase propensity • Monthly updates

PersonicX• Household-level segments• 100% U.S. coverage• 70 unique clusters • Product purchase propensity • Monthly updates

Individual• Age• Education• Occupation• Gender • Ethnicity variables (rollup and country codes, country

of origin, language, religion, etc.)

Individual• Age• Education• Occupation• Gender • Ethnicity variables (rollup and country codes, country

of origin, language, religion, etc.)

Real Property• Dwelling size• Purchase date• Home market value• Available home equity• Loan detail, type and date -Interest rate type

-Lender name -Up to 3 lien positions

Real Property• Dwelling size• Purchase date• Home market value• Available home equity• Loan detail, type and date -Interest rate type

-Lender name -Up to 3 lien positions

Life Events• New Parent• Recent Divorce• Newlywed• Entering Adulthood• Empty Nester• Intend to Purchase Vehicle

Life Events• New Parent• Recent Divorce• Newlywed• Entering Adulthood• Empty Nester• Intend to Purchase Vehicle

Auto• Vehicle purchase, ownership, warranty data from after-

market and self-reported data • File grows thru monthly feeds• Specific vehicle details:

make, model, year, etc.

Auto• Vehicle purchase, ownership, warranty data from after-

market and self-reported data • File grows thru monthly feeds• Specific vehicle details:

make, model, year, etc.

Other sources

Mosaic Codes

Data for Mosaic survey was only available for 18% (6,577 out of 36,466) of the students.

Power EliteFlourishing Fami...

Booming with Co...Suburban Style

Thriving BoomersPromising Families

Young, City SolosMiddle-Class Mel...

Family UnionAutumn Years

Significant SinglesBlue Sky Boomers

Families in MotionPastoral Pride

Singles and StartersCultural Connect...

Golden Year Guar...Aspirational FusionStruggling Societies

AB

CD

EF

GH

IJ

KL

MN

OP

QR

S407426413

935529

48557

119313

14333

162467

1,170408

4952

97312

Students

Four Year Mosaic Code Students

Data for Mosaic survey was only available for 18% (6,577 out of 36,466) of the students










AB

CD

EF

GH

IJ

KL

MN

OP

QR

S407426413

935529

48557

119313

14333

162467

1,170408

4952

97312

Students


A) Power Elite The wealthiest households in the US, living in the most exclusive neighborhoods, and enjoying all that life has to offer











AB

CD

EF

GH

IJ

KL

MN

OP

QR

S407426413

935529

48557

119313

14333

162467

1,170408

4952

97312

Students


S) Struggling Societies - Economically challenged mix of singles, divorced and widowed individuals in smaller cities and urban areas looking to make ends meet











AB

CD

EF

GH

IJ

KL

MN

OP

QR

S407426413

935529

48557

119313

14333

162467

1,170408

4952

97312

Students


N) Pastoral Pride - Eclectic mix of lower middle-class widowed and divorced individuals and couples who have settled in country and small town areas.


Struggling SocietiesAspirational FusionGolden Year Gua...Cultural Connect...Singles and Star...

Pastoral PrideFamilies in MotionBlue Sky BoomersSignificant Singles

Autumn YearsFamily Union

Middle-Class Mel...Young, City Solos

Promising FamiliesThriving Boomers

Suburban StyleBooming with Co...Flourishing Fami...

Power Elite

SR

QP

ON

ML

KJ

IH

GF

ED

CB

A

0 200 400 600 800 1000 1200 1400 1600 1800

312362

97112

523849

88408432

11701642

467932

162331

3326

143209

313561

119190

5743

485572

465529

989935

383413

396426

263407

Four and Two Year Institution StudentsFour year Institutions Two year Institutions

Couples with Clout 2-Year

Couples with Clout 4 -Year

Picture Perfect Family 2-Year

Picture Perfect Family 4 -Year

Kids and Cabernet 2-Year

Kids and Cabernet 4 -Year

Platinum Prosperity 2-Year

Platinum Prosperity 4 -Year

American Royalty 2-Year

American Royalty 4 -Year

A05

A04

A03

A02

A01

5274

123167

2038

62118

610

"A" Power EliteThe wealthiest households in the US, living in the most exclusive

neighborhoods, enjoying all that life has to offer

•Student•Institution Code•Last Enrolled Year Term•Last Name•First Name•Maiden Name (if applicable)•Most Current Street Address•Most Current City of Residence•Most Current Zip Code•Most Current Phone Number•Last Enrolled Year•Re-enrolled?•Email Address•Deceased•Mosaic USA Codes•Count Names•Estimated Income•Occupation

Campuses are getting the following:

Percentage of people 25 years and older who have completed high school or more education.

Percentage of people 25 years and older who have completed a bachelor’s degree or more education.

Project Win-Win• Involves 35 community colleges and colleges in six

states—Louisiana, Missouri, New York, Ohio, Virginia, and Wisconsin—in finding former students, no longer enrolled anywhere and never awarded any degree, whose records qualify them for associate’s degrees, and get those degrees awarded retroactively.

• Simultaneously, this effort will identify former students who are “academically short” of an associate’s degree by no more than nine credits, find them, and seek to bring them back to complete their degree.

Pulaski Tech

Tracking Stop Outs

"This place is what's best in America. We saw it in this competition."

The GE deal also includes a requirement that the state dedicate $5 million over 10 years, or $500,000 per year, to developing technology-centered curriculum at institutions of higher education around Louisiana.The education aspect was a major sticking point for GE, which during negotiations expressed concern about Louisiana's ability to supply workers now and into the future. About 80 percent of the local GE workforce is expected to have five years of experience or more in their field, Secretary of Economic Development Stephen Moret said."I perceived that to be the most significant issue they dwelled on a bit," Moret said. "It was not a question of quality, but of density."

What about other state’s dropouts that move to Louisiana?

Other State’s StopoutsTotal: 42,650

LegendStopouts

1 - 6364 - 128129 - 212213 - 363364 - 741

Slate.com

46

civic involvementcivic involvementvolunteer activity by

education levels

Bureau of Labor Statistics. (2003). Volunteering in the United States, 2003. USDL03-888. U.S. Department of Labor.

50%

40%

30%

20%

10%

0%

Less Than High School Diploma

High School Diploma

Some College

B.A. or Higher

9.9%(48 hours)

21.7%(48 hours)

34.1%(52 hours)

45.6% (60 hours)

Perc

enta

ge V

olun

teer

ing

blood donation by education level, 1994:

Source: DBD Worldwide. (2000). DBD Lifestyle Survey. Chicago. Available at www.bowlingalone.com

20%

15%

10%

5%

0%


High School Diploma

Some College

B.A. or Higher

6%

11%

13%

17%

Perc

enta

ge D

onati

ng B

lood

percentage who donate regularly

civic involvementcivic involvement

participation assistance programs

Source: Postsecondary Education Opportunity, May 28, 1997, pg 47.


High School Diploma

Some College& Bachelor’s

Degree or More

24.3%

10.2%

4.6%

Ever Participated in Assistance Programs

education level

governmentgovernment

governmentgovernmentincarceration rates by

education levels

2.5%

2.0%

1.5%

1.0%

0.5%

0.0%


High School Diploma

Some CollegeB.A. or Higher

1.9%

1.2%

0.3%0.1%

Perc

enta

ge In

carc

erat

ed

Source: Harlow, C.W. (2003). Education and Correctional Populations. Bureau of Justice Statistics, Department of Justice. NCJ195670.

economicPercent Below Poverty

Threshold, 2004

economicPercent Below Poverty

Threshold, 2004

Census Bureau

40%

30%

10%

0%


High School Diploma

Some College

B.A. or Higher

32%

15%

10%

4%

Perc

enta

ge H

ome

Ow

ners

hip

20%

economiceconomicunemployment rates and

education level, 2004

Source: Employment Policy Institute

10

8

6

4

2

0


High School Diploma

Some CollegeB.A. or Higher

9.7%

7.5%

5.1%4.6%

Quality of LifeQuality of LifeHome Ownership

Census Bureau, American Housing Survey for the United States:2005

80%

70%

60%

50%


High School Diploma Some College

B.A. or Higher

58%

69%66%

75%

Perc

enta

ge H

ome

Ow

ners

hip

Seatbelt Use while intoxicated, 1990

Source: American Journal of Public Health

80%

60%

40%

20%

0%


High School Diploma

Some College

B.A. or Higher

39%41%

52%

66%

Perc

enta

ge D

onati

ng B

lood

percentage who use seatbelt

SafetySafety

15%20%

31%

78%

economiceconomic

Average family income by educational attainment,

2003

Source: Postsecondary Education Opportunity, 2005

25

175

50

100

75

125

150

0LT-9 9-12 HSG Some ProfMA PhDBAAA

Inco

me

($00

0)

College

3,798,9405,254,193Professional degree

2,527,3243,982,577Doctorate

1,507,8232,963,076Master's degree

$1,111,921$2,567,174Bachelor's degree

346,1201,801,373Associate degree

270,5691,725,822Some college, no degree

01,455,253High school graduate

-304,5551,150,698High school dropout

-$478,903$976,350Less than 9th grade

DifferenceCompared to

High School Graduate

EstimatedLifetimeEarnings

Education Level

Source: Federal Reserve Bank of Dallas, 2005

The Impact of Education on Individuals:Lifetime Earnings

economiceconomic

http://www.time.com/time/magazine/0,9263,7601111114,00.html

BOARD OF REGENTS FOCUS

• To increase the education attainment of its citizens;

• To invest strategically in university research; and

• To become a more efficient and accountable enterprise.

Three Main Goals

58

Lost and Found: Tracking Down Former Louisiana Students to Bring Them Back to Campus

Jim Purcell, Jennifer Morgan and Luke Dowden

lost and found: tracking down former louisiana students to bring them back to campus jim purcell,...

Documents

legend slide

university slide

degree slide

activity slide

higher slide

retention slide

year legend students

louisiana students