This lesson provides a high-level view of the data in the Analysis Ready report, aka “wide file”. Each of the four sections (student information, retention & persistence, up to eight academic years and cumulative outcomes) is covered.
Resources
- StudentTracker® Premium Service User Guide
- StudentTracker® Premium Service Analysis-Ready File Data Dictionary
Transcript
Welcome. The purpose of this tutorial is to explain what the analysis ready report is and its basic parts. The analysis ready report, also known as the wide file format, transforms the basic service's detail report into a version with one row per student. Please note this report is only available to premium subscribers. The analysis ready report is a comma separated values or CSV file that transforms the detail report into an analysis ready format by displaying one row per student versus multiple rows per student. The analysis ready report makes it much easier to analyze the data and identify trends. It's important to understand that the analysis ready report will only be returned for subsequent enrollment or SE, denied or declined admission or da and longitudinal cohort or Co queries submitted by premium subscribers. It is limited to these queries because they are forward-looking and this report is designed for longitudinal research purposes. The analysis ready report has 216 columns of data that can be categorized into four general sections: student information, persistence and retention flags, up to eight academic years worth of enrollment outcomes and where applicable and available industry credentials information, and cumulative enrollment and outcomes information. Student information consists of student information and search date as provided for each student in your StudentTracker request file. Persistence and retention flags identify whether the student has at least one enrollment or degree record in Academic Year 2. These flags are calculated only when a student has reported enrollment in Academic Year 1. Persistence will indicate a y value when the student has an academic record in year two at a different institution based on OPEID code. Retention will indicate a why when the student has an academic record in year two at the same institution. Enrollment and outcome information is available for up to eight academic years from the search date provided for each student in the request file. For each Academic Year, we will report whether the student has an enrollment and/or credential data from the requesting school, a different 2-year school or a different four-year school. We will also report whether the student has any industry credentials when available and applicable. For more detailed information, please consult the user guide or the data dictionary. Cumulative enrollment and outcome information are provided from search date to present. This section provides the following information: time elapsed from search date to start date at a different two or four institution, time elapsed from search date to the award dates of the highest credentials at the requesting school, a different 2-year school and a different four-year school, total number of Industry credentials earned between search date and present and pattern of first enrollments to give insights on student mobility. To find out more about StudentTracker for Colleges and University's Premium service or any of our StudentTracker services, please visit us online.