{"id":1578,"date":"2023-03-06T16:30:44","date_gmt":"2023-03-06T21:30:44","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/pdp\/?post_type=ht_kb&#038;p=1578"},"modified":"2025-06-03T11:53:25","modified_gmt":"2025-06-03T15:53:25","slug":"using-the-analysis-ready-files","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/using-the-analysis-ready-files\/","title":{"rendered":"Using the Analysis-Ready Files"},"content":{"rendered":"<p>The analysis-ready files are Excel files of student-level data displayed in one row per student with 50+ columns of data elements and calculated outcomes. The data is derived from your PDP course and cohort files as well as Clearinghouse enrollment and degree data for a deeper dive into key student outcomes across a range of variables.<\/p>\n<p>Take our tutorial course, <a href=\"https:\/\/www.studentclearinghouse.org\/academy\/courses\/postsecondary-data-partnership-analysis-ready-files\/\">Orienting and Using the Analysis-Ready Files<\/a>, to learn more about how to use the analysis-ready files.<\/p>\n<p>Watch the video below for a high-level overview of the three analysis-ready files, differences between the files, and potential questions the files can answer.<\/p>\n<p><iframe loading=\"lazy\" title=\"Using PDP Analysis-Ready Files to Understand First Year Student Success\" width=\"420\" height=\"236\" src=\"https:\/\/www.youtube.com\/embed\/-C-KLsMxADE?feature=oembed\"  allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2>Use Cases<\/h2>\n<h3>Using the Course-Level Analysis-Ready File<\/h3>\n<p>Watch the video below to learn how to use the course-level analysis-ready file to understand which gateway English and Math courses students have taken and determine if retention rates differ based on which gateway course a student takes.<\/p>\n<p><iframe loading=\"lazy\" title=\"Using the PDP Course-Level Analysis-Ready File\" width=\"420\" height=\"236\" src=\"https:\/\/www.youtube.com\/embed\/Pri5l2H73VM?feature=oembed\"  allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3>Using the Cohort-Level Analysis-Ready File<\/h3>\n<p>Watch the video below to learn how to use the cohort-level analysis ready file to find the percentage of students required to take math and\/or English gateway courses and determine if there\u2019s a benefit to student retention when student\u2019s complete required gateway courses in their first year.<\/p>\n<p><iframe loading=\"lazy\" title=\"Using the PDP Cohort-Level Analysis-Ready File\" width=\"420\" height=\"236\" src=\"https:\/\/www.youtube.com\/embed\/jpHbNX13tIs?feature=oembed\"  allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h3>Using the Financial Aid Analysis-Ready File<\/h3>\n<p>Watch the video below to learn how to use the financial aid analysis-ready file to identify students with unmet needs.<\/p>\n<p><iframe loading=\"lazy\" title=\"Use the Financial Aid Analysis-Ready File to Identify Students with Unmet Financial Need\" width=\"420\" height=\"236\" src=\"https:\/\/www.youtube.com\/embed\/OLGMF8KYmVY?feature=oembed\"  allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn what Analysis-Ready (AR) files are, how to use them, and explore use cases.<\/p>\n","protected":false},"author":6,"menu_order":44,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[58,78],"ht-kb-tag":[],"class_list":["post-1578","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-ar-file-usage","ht_kb_category-institutional-researchers"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/1578","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/comments?post=1578"}],"version-history":[{"count":8,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/1578\/revisions"}],"predecessor-version":[{"id":16306,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/1578\/revisions\/16306"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/media?parent=1578"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-category?post=1578"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-tag?post=1578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}