The Ohio Board of Regents

Extending the HEI Database

To Other DatabasesMay 25, 2001

Presented to SHEEO/IPEDSConference

Robert Sheehan

Why Extend Higher Education Databases?

To identify predictors of college successTo put campus performance into context of campus missionTo examine relationship between financial aid and college outcomesTo examine concurrent college employmentTo examine post college employment outcomes

3

Legitimate usage for research purposes by state agency of SSN’s under FERPA - not for retransmittal

Reviewed by State Attorney General Office & consistent with U.S. Dept. Education Policy memo

Most common unique identifier

Students with no SSN, have institution provided ID’s

SSN’s can be added after the fact or as a separate id

What’s the linkage? We are “joining” HEI college data to other datasets using unique record identifiers (SSN’s).

4

Student• Disability?• Parent’s education

High School• GPA• Academic core?• Grades• # years English• # years math• # years science• Extra-curricular?

Current Data Extensions

Graduate

•Loan indebtedness

•In-State Employ

•Salary

•Employer Type

•Further College

Family

•Financial Aid & Family Income

•Loan indebtedness

•Parent’s education

College

•Enrollment,

•Retention,

•Transfers, Mobility

•Courses, Grades

Student

•Employment

Pre-Collegiate Data

Collegiate Data Post Collegiate Data

5

Joining to High School Data

Students in Ohio (or wanting to study in Ohio) typically complete ACT Assessment in High School Junior or Senior Year

ACT Assessment self report from high school student

How get the data? • Unit Record (SSN) ACT data provided through

research agreement with ACT Inc.

6

Joining to High School Data: Full-Time, First-Time College Students

77% take the ACT Assessment

38% come from families making $50K or less• almost 50% at two year campuses

Only 66% have taken high school academic core: • 4 years English; 3 years Math & Science

Average High school GPA’s range from 2.8-3.2

7

Joining to family/student characteristics data

Most Students in Ohio (or wanting to study in Ohio) completed Federal Aid Application Forms (FAFSA)

FAFSA provide “auditable” information, better than self report

How get the data?• FAFSA data provided to state agency = ISIR

Records also available to campuses

8

Joining to family/student characteristics data: Full-Time Undergrads Applying for Aid

70% apply for federal and state aid• Less than 60% at community colleges

81% are dependent students• majority in all sectors but lower rates two year campuses

50% have actual family incomes under $50K• 70% two year campuses

60% four year campuses parent has college degree• Less than 45% on two year campuses

9

Joining to family/student characteristics data: Part-Time Undergrads Applying for Aid

41% apply for federal and state aid

39% are dependent students

77% have actual family incomes under $50K

43% four year campuses parent has college degree

10

Joining to employment data

All employers in Ohio (except federal employers) submit quarterly wage records (ES202)

How get the data?• Matched Wage Records come from state

employment office under terms of Federal Workforce Investment ACT (WIA)

11

Joining to employment data

The more you learn the more you earn The major and discipline you choose

influences your earnings

Starting Salary Estimates by Discipline Area and Subject Fielddata as of 5/11/2001Discipline Area Subject Field Grads

Avg Salary Grads Avg Salary

Accounting 451 $27,865 697 $38,685Administrative and Secretarial 345 $23,309 <5 NABusiness Information and Data Processing Services 214 $32,870 460 $42,289Finance 27 $33,890 490 $31,996Human Resources Management 6 $25,513 242 $32,472Management 436 $33,056 330 $35,015Marketing 116 $29,001 711 $32,473Other Business 301 $31,447 199 $36,911

Business

Associate Baccalaureate

Employment Estimated Starting Salaries for Spring 1998 and Spring 1999 Graduates

12

Where are the data?

See the following sector and state statistics

Campus data are also available

13

High School Data Charts

data as of 5/2/2001

Sector StudentsCompleted ACT?

Income 50K or less

Students Who Enter College With "Core Curriculum"

Average GPA

Average ACT Composite Score

Community Colleges 3,782 49% 49% 53% 2.8 20State Community Colleges 3,789 45% 46% 47% 2.8 20Technical Colleges 2,394 44% 58% 37% 2.8 19University Branches 5,751 73% 47% 54% 2.9 21University Main Campuses 28,393 84% 34% 71% 3.2 23Independent Campuses 14,477 84% 40% 69% 3.2 24State 58,586 77% 38% 66% 3.2 23

Full Time, First Year Enrollees in Ohio Public in Autumn, 2000 at Ohio's Public and Independent Colleges and Universities

14

Financial Aid Data Charts: Full Time Students

Tax StatusFamily Income

Parents' Highest

Education

Sector undergrads

Applied for Federal/State Aid

Dependent Tax Status

Under 50K College

Unmarried no Children

Unmarried with Children

Married with Children

Community Colleges 11,303 56% 63% 70% 43% 75% 17% 6%State Community Colleges 13,219 59% 58% 71% 44% 72% 17% 8%Technical Colleges 8,262 73% 59% 72% 37% 69% 14% 13%

University Branches 15,258 70% 73% 62% 41% 81% 8% 8%University Main Campuses 107,864 64% 85% 48% 60% 93% 3% 2%Independent Colleges 48,434 84% 87% 44% 61% 92% 3% 3%State 204,340 69% 81% 51% 57% 89% 5% 4%

Full-time Ohio Undergraduate Applicants for Financial Aid - Autumn, 2000 at Ohio's Public and Private Colleges and Universities

Marital Status - Dependents

15

More Financial Aid Data Charts: Part-Time Students

data as of 5/4/2001

Tax StatusFamily Income

Parents' Highest

Education

Sector undergrads

Applied for Federal/State Aid

Dependent Tax Status

Under 50K College

Unmarried no Children

Unmarried with Children

Married with Children

Community Colleges 50,374 32% 30% 85% 39% 50% 31% 15%State Community Colleges 43,155 36% 32% 80% 40% 51% 27% 17%Technical Colleges 13,191 43% 32% 81% 33% 47% 24% 22%University Branches 24,208 47% 40% 73% 39% 57% 17% 20%University Main Campuses 55,755 50% 49% 70% 50% 73% 13% 9%State 186,683 41% 39% 77% 43% 59% 21% 14%

Marital Status - Dependents

Part Time Undergraduate Applicants for Financial Aid - Autumn, 2000 at Ohio's Public and Private Colleges and Universities

16

Employment Data Charts

Starting Salary Estimates by Discipline Area and Subject Fielddata as of 5/11/2001Discipline Area Subject Field Grads

Avg Salary Grads Avg Salary

Art 8 $28,132 130 $24,411Communications 20 $26,013 749 $29,408

Communications Disorders 36 $24,088 57 $26,155Drama <5 NA 29 $23,332English 288 $25,877Foreign Languages 87 $29,731Journalism <5 NA 268 $26,392Liberal Arts 586 $32,525 122 $34,919Music 42 $30,594Other Visual and Performing Arts 87 $26,413 246 $31,078Philosophy and Religion 24 $32,925

Associate Baccalaureate

Employment Estimated Starting Salaries for Spring 1998 and Spring 1999 Graduates

Arts & Humanities

17

Employment Data Charts (Continued)

Starting Salary Estimates by Discipline Area and Subject Fielddata as of 5/11/2001Discipline Area Subject Field Grads

Avg Salary Grads Avg Salary

Accounting 451 $27,865 697 $38,685Administrative and Secretarial 345 $23,309 <5 NABusiness Information and Data Processing Services 214 $32,870 460 $42,289Finance 27 $33,890 490 $31,996Human Resources Management 6 $25,513 242 $32,472Management 436 $33,056 330 $35,015Marketing 116 $29,001 711 $32,473Other Business 301 $31,447 199 $36,911Counseling <5 NA <5 NAEducation Administration 6 $24,164Health and Phy. Ed. General <5 NA 132 $27,256Sports and Recreation 8 $37,121 92 $26,176Teaching 102 $21,310 1,966 $28,015

Associate Baccalaureate

Employment Estimated Starting Salaries for Spring 1998 and Spring 1999 Graduates

Business

Education

18

Employment Data Charts (Continued)

Starting Salary Estimates by Discipline Area and Subject Fielddata as of 5/11/2001

Architecture 10 $26,233 218 $30,951Civil Engineering <5 NA 207 $37,200Electrical Engineering 194 $46,933Engineering Technology 1,273 $36,576 228 $42,168Industrial/Manufacturing Engineering 10 $37,440 132 $40,572Mechanical Engineering 9 $32,872 375 $45,201Other Engineering 14 $33,005 314 $42,880Dental Health 273 $33,659 38 $33,279Medicine MD <5 NA <5 NAMental Health Services 72 $28,425 <5 NANursing 1,632 $34,147 1,293 $39,685OPTOMETRY (OD) <5 NA <5 NAOptometry 32 $25,375 <5 NAOsteopathic Medicine <5 NA <5 NAOther Medicine 1,292 $30,398 180 $30,670Pharmacy <5 NA 224 $62,873Physical and Occupational Therapy 31 $42,184 83 $35,752Veterinary Medicine 56 $25,256 <5 NA

Associate Baccalaureate

Employment Estimated Starting Salaries for Spring 1998 and Spring 1999 Graduates

Engineering

Health

19

Employment Data Charts (Continued)

Starting Salary Estimates by Discipline Area and Subject Fielddata as of 5/11/2001

Agriculture 99 $26,363 129 $32,639Biology 15 $28,135 430 $28,506Chemistry <5 NA 107 $31,865Computer Science 278 $35,741 295 $43,201Geology <5 NA 30 $24,981Math 9 $32,765 84 $30,772Natural Resources 48 $28,150 107 $28,935Other Physical Science 13 $28,032 17 $34,496Physics <5 NA 14 $24,687Anthropology <5 NA 45 $23,473Economics <5 NA 95 $31,411Ethnic Studies <5 NA 37 $22,986Family and Consumer Studies 125 $26,938 414 $26,853Geography <5 NA 26 $29,946History 129 $28,256Other Social Studies 11 $26,052 217 $28,790Political Science <5 NA 173 $29,348Psychology 545 $25,995Public Administration and Services 28 $31,325 18 $29,491Social Work 88 $24,902 318 $25,484Sociology 185 $24,993

Associate Baccalaureate

Employment Estimated Starting Salaries for Spring 1998 and Spring 1999 Graduates

Natural Science &

Mathematics

Social & Behavioral Sciences