Transcript Using Metadata Files to Navigate an Interactive Data Warehouse

Tracking Our Students with
National Student Clearinghouse
StudentTracker Data
Presented by:
Sandy Naumann
Jennifer Li
Kent McShan
TAIR 30th Annual Conference
February 2008
What is the National Student
Clearinghouse?
The National Student Clearinghouse is a nonprofit organization providing post-secondary
and secondary student degree, diploma and
enrollment verification.
http://www.studentclearinghouse.org/
Facts about National Student
Clearinghouse
o
o
o
Established in 1993 by higher Ed
Central repository for collection & exchange of
enrollment records
Provides online enrollment/degree verification to
employers, student service providers, insurance
companies, credit issuers, US Dept of Education, and
others
What is StudentTracker?
o
o
o
StudentTracker provides access for members
to the enrollment database of over 80 million
student records to identiify where your
students transferred to or where they
transferred in from.
All participating institutions sign agreements
to ensure full compliance with FERPA
requirements
Funding for StudentTracker through
Achieving the Dream
What Is Achieving the
Dream?
Achieving the Dream is a multi-year national initiative
to help more community college students succeed. The
initiative is particularly concerned with student groups
that traditionally have faced the most significant barriers
to success, including low-income students and students
of color. Lone Star College System (LSCS) is one of 83
participating colleges and universities.
http://www.achievingthedream.org/default.tp
Format of Request File Sent
Three types of reports received
Back from Clearinghouse
o
Control Report
o
Aggregate Report
o
Student-level Detail Report
Control Report
Aggregate Report
Student-Level Detail

For Whom to Request Data?
o
AtD Cohorts – Subsequent & Previous
o
All Students for 5 Years-Subsequent & Previous
Schedule for Future Data
Requests
Once a term after official day for:
o
All AtD Cohorts
o
All credit students in that term
o
Credit students for past 5 years
StudentTracker Data Storage
o
o
Import data to data warehouse (SQL Server
Database)
Create primary key to ensure data consistency
among various data tables
Populate AtD Transfer
Variables
o
o
Use WebFocus Reporting tool to generate AtD
transfer variables.
Match Clearinghouse data to students tables.
Usage of Transfer Field in AtD
Datasets
To track the following records:
o
Number of AtD Cohort students transferred
o
Semester of transfer
o
Percentage of non-returners in an AtD Cohort are
transfers?
Sample AtD Transfer Report
Sample AtD Transfer Report
When use StudentTracker data for
AtD data submission, be aware:
o
Not all colleges participate in Clearinghouse
o
Latest term data not available yet
o
Need to resubmit data later
Using StudentTracker Data
For Other Reports
o Fall 2006 Transfers in by College
o Transfers Out After Fall 2006 by College
o Transfers Out After Fall 2006 by College Type
Fall 2006 Transfers in by College
Transfers Out After Fall 2006 by
College
Transfers Out After Fall 2006 by
College Type
Questions?