Utilizing the Data Produced By Student Tracker How

Utilizing the Data Produced By Student. Tracker How to turn a Long File into a Wide File 1

National Student Clearinghouse Research Center (NSCRC) Mission: NSCRC is an independent organization that conducts and supports objective research related to educational enrollment, progression and completion for the benefit of students, institutions, and the broader public. NSC Research Center created in 2010 • 501(c)(3) non-profit organization • Provide research and information for the benefit of the education community

About Clearinghouse Data Our Relationship with Participating Institutions: • • • Clearinghouse holds the data as agent of the institutions Clearinghouse provides valuable services, saving the institutions money Agreements with institutions govern allowable uses of data Data elements include: • • • Enrollment status and term begin and end dates Graduation indicator flag Identifiers for tracking students across institutions Most institutions also provide detailed degree data Some institutions also provide class level, major, gender and race 3

Student. Tracker A cost effective way to replace survey and anecdotal information with timely, documented enrollment and degree data

How Student. Tracker Works Submit cohort Run file against our database Email you when your report is ready Matches compiled in a Student. Tracker report *Instant queries for individual students can be performed via the Web 5

Student. Tracker Query Types Institutional Research • • • Identify important enrollment trends and patterns Track concurrent enrollment of your students Determine cohort graduation rates Fulfill federal reporting requirements Verify and correct cohort default rates

Student. Tracker Query Types Admissions • • • Improve your ability to target, select and retain students Verify prior enrollments for transfer applicants Validate your graduate school placement rate

Student. Tracker Query Types Financial Aid • • • Track graduated/transferred Perkins borrowers Verify parent/sibling enrollments Evaluate ED cohort default data Support mid year transfer monitoring process Determine who holds students’ loans (web)

Response Files The Clearinghouse returns. . . Control Report POverview of Results Aggregate Summary Report PContains totals of students enrolled by institution Unit Record File (also called the Detail Report) PContains individual student records (except FERPA blocked records)

Sample Control Report NATIONAL STUDENT CLEARINGHOUSE STUDENTTRACKER CONTROL REPORT #17907 FOR HOMETOWN UNIVERSITY (001234 -00) DOES THE SCHOOL PARTICIPATE IN DEGREEVERIFY? (YES ) DOES THE SCHOOL SEND “ADDITIONAL” DATA ELEMENTS? (NO) YOUR FILE CREATION DATE: 5/23/2006 RANGE OF SEARCH DATES PROVIDED IN REQUEST FILE: 07/03/2000 - 01/16/2006 TOTAL STUDENTS IN YOUR REQUEST FILE: TOTAL STUDENTS WITH NO RESPONSE DATA AVAILABLE: 11 1 TOTAL STUDENTS FOUND AND INCLUDED IN AGGREGATE REPORT: 10 LESS: STUDENT LEVELREPORTING BLOCKED BY SCHOOL: 0 LESS: STUDENT LEVEL REPORTING BLOCKED BY STUDENT: 0 TOTAL STUDENTS REPORTED AT DETAIL LEVEL: 10

Sample Summary Report

Sample Unit Record File (Detail File) see your handout for more information • • Student identifiers Information for other institution attended: name, OPE code, type (4 yr+, 2 yr, <2 yr), public/private • • • Term begin/end date Ability to see if a student attended multiple other schools School sequence number

Sample Unit Record File (detail file) Class Level (fresh, soph, associates, grad, etc. ) Enrollment Major 1, 2 Enrollment CIP 1, 2 For Additional Data Element Schools Only Degree CIP 1, 2, 3, 4 Degree Major 1, 2, 3, 4 Graduation status and date Degree title (i. e. BS, Bachelor of Art) Degree major (i. e. History, Engg. ) For Degree. Verify Schools Only

Student Tracker queries Those that can be run by Colleges and Universities: • Subsequent Enrollment (SE) of previously enrolled students – see who transferred elsewhere, see if a student re-enrolled in college somewhere after earning a credential from your institution, track concurrent enrollment * the example file that we’ll be working with was from an SE query • Declined or Denied Admissions (DA) – find enrollments for students who were accepted to your institution but didn’t attend; find enrollments for students to whom you denied admission • Prior Attendance for Pending Admissions (PA) – for students applying to your institution, see what other institutions they’ve previously attended (this is the only query that looks backwards) • Longitudinal Cohort (CO) – view enrollments and credentials over a specified period of time for a cohort of students; all students in this file must have the same search date • Sibling Enrollment (SB) – view enrollments of siblings/parents of current students for Financial Aid purposes 14

The detail file gives student level data (I emailed you a sample which should be similar) 15

The Detail file…in more detail! 16

Answering Your Questions. . . • What is my institution’s completion rate? • What is my institution’s persistence rate? CO (Longitudinal Cohort) query: - for incoming freshmen - for transfer students Yields: graduation information enrollment rates transfer behavior (aggregate form is different from other query types) 17

A table from a cohort (aggregate) report for a CO query: * this is helpful is you participate with the ‘Voluntary System of Accountability’ (VSA) or ‘Student Achievement Measures’ (SAM) 18

Other Available Resources from NSC’s Research Center (these are listed on your handout) Detailed statistics on NSC coverage: state sector_desc Fall_2003 Fall_2012 Fall_2013 Fall_2014** West Private, for-profit, 4 -year 81. 00% 85. 80% 89. 50% West Public, 2 -year 86. 30% 99. 70% West Private, not-for-profit, 2 -year 80. 00% 48. 20% 48. 60% West Private, for-profit, 2 -year 0. 00% 46. 90% 45. 80% Alabama Overall 75. 90% 90. 10% 90. 90% 97. 90% Alabama All 4 -year Institutions 92. 30% 89. 10% 89. 00% 98. 20% Alabama All 2 -year Institutions 41. 70% 92. 50% 95. 40% 97. 20% Alabama All Public Institutions 76. 50% 98. 10% 99. 80% Alabama All Private, not-for-profit Institutions 86. 90% 88. 60% 89. 30% Alabama All Private, for-profit Institutions 0. 00% 39. 50% 43. 00% 91. 90% Alabama Public, 4 -year 96. 10% 100. 00% Alabama Private, not-for-profit, 4 -year 87. 50% 90. 40% 91. 00% Alabama Private, for-profit, 4 -year 0. 00% 25. 40% 25. 30% 94. 40% Alabama Public, 2 -year 41. 90% 94. 50% 97. 30% 99. 40% Alabama Private, not-for-profit, 2 -year 0. 00% http: //nscresearchcenter. org/workingwithourdata/ 19

Other Available Resources from NSC’s Research Center Credential Level Lookup Table http: //nscresearchcenter. org/workingwithourdata/ 20