{"id":1640,"date":"2023-07-26T16:24:24","date_gmt":"2023-07-26T20:24:24","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/pdp\/?post_type=ht_kb&#038;p=1640"},"modified":"2026-01-21T09:46:33","modified_gmt":"2026-01-21T14:46:33","slug":"using-the-dashboards-to-check-data-quality","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/using-the-dashboards-to-check-data-quality\/","title":{"rendered":"Using the Dashboards to Check Data Quality"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_90 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">CONTENTS<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/using-the-dashboards-to-check-data-quality\/#Tutorials\" >Tutorials<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/using-the-dashboards-to-check-data-quality\/#First_Year_Enrollment_Dashboard\" >First Year Enrollment Dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/using-the-dashboards-to-check-data-quality\/#First_Year_Gateway_Course_Completion_Dashboard\" >First Year Gateway Course Completion Dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/using-the-dashboards-to-check-data-quality\/#First_Year_Credit_Accumulation_Rate_Dashboard\" >First Year Credit Accumulation Rate Dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/using-the-dashboards-to-check-data-quality\/#First_Year_Credit_Completion_Ratio_Dashboard\" >First Year Credit Completion Ratio Dashboard<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/using-the-dashboards-to-check-data-quality\/#Next_Steps\" >Next Steps<\/a><\/li><\/ul><\/nav><\/div>\n<p>After your institution has certified your data submission and it passes all data quality checks, the Clearinghouse processes and aggregates the data and provides you with access to analysis-ready files and institution- and benchmarking-level dashboards. Even with data quality checks and audits we apply during the submission and aggregation process, it is possible that inaccurate, missing, unknown, or otherwise incomplete data or values may be included in the dashboards. Errors or delays in submitting data to other Clearinghouse services, such as enrollment reporting or degree verification, can also impact the quality of the PDP dashboards. For more detailed information on the impact of missing data, see <a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/key-performance-indicators-and-critical-data-elements\/\">Key Performance Indicators and Critical Data Elements<\/a>.<\/p>\n<p>This Data Quality Dashboard Check from <a href=\"https:\/\/achievingthedream.org\/\" target=\"_blank\" rel=\"noopener\">achievingthedream.org <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-995\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/2021\/07\/icon-externalsite.png\" alt=\"\" width=\"12\" height=\"12\" \/><\/a> can help you determine if all the data your institution submitted is visible and the dashboards and filters are functioning correctly. If the the numbers or calculations look incorrect (e.g., credit completion ratio is 100%), there is a high number of \u201cunknowns\u201d for a variable, or a filter or dashboard is not populated, contact Clearinghouse representative at <a href=\"mailto:pdpservice@studentclearinghouse.org\" target=\"_blank\" rel=\"noopener\">pdpservice@studentclearinghouse.org<\/a> to discuss and resolve the issue(s) before rolling out the dashboards at your institution.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tutorials\"><\/span>Tutorials<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To familiarize yourself with the dashboards, watch the following tutorial videos:<\/p>\n<h3>Basic Institution-Level Dashboard Functionality<\/h3>\n<p><iframe loading=\"lazy\" title=\"Basic Institution-Level PDP Dashboard Functionality\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/fp_ahsw0EpU?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>Dimensions and Filters<\/h3>\n<p><iframe loading=\"lazy\" title=\"PDP Dimensions and Filters\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/-Zmqvct4yog?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>When checking data consistency in the PDP dashboards, you should start with the dashboards where you have submitted data on all semesters for a cohort year. For this check, we will review the <a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/first-year-enrollment-dashboard\/\">First Year Enrollment<\/a>, <a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/first-year-gateway-course-completion-dashboard\/\">First Year Gateway Course Completion<\/a>, <a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/first-year-credit-accumulation-rate-dashboard\/\">First Year Credit Accumulation Rate<\/a>, and <a href=\"https:\/\/help.studentclearinghouse.org\/pdp\/knowledge-base\/first-year-credit-completion-ratio-dashboard\/\">First Year Credit Completion Ratio<\/a> dashboards.<\/p>\n<p>As you work through each step, document any discrepancies with your data and note the cohort year(s) and filter(s) you selected to inform your discussion with the Clearinghouse representative.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"First_Year_Enrollment_Dashboard\"><\/span>First Year Enrollment Dashboard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Check 1: Cohort Enrollment<\/h3>\n<p>Review Cohort Enrollment section at the top of the dashboard, focusing on the most recent cohort year for which you have submitted a full year of data. If any of the three boxes are blank, this is an indication that your data needs further review.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"capturedimg\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/blanknumbers.jpg\" alt=\"\" width=\"600\" height=\"70\" \/><\/p>\n<div class=\"info\">\n<p>If you have not yet submitted data for <span style=\"text-decoration: underline;\">ANY<\/span> semester in the most recent cohort year, select the next most recent cohort year from the <strong>Cohort <\/strong>filter in the top left.<\/p>\n<\/div>\n<p>Determine if the cohort size is what you expected. If the number looks significantly different from your average undergraduate cohort size for a year, you might have incomplete or missing cohort or course data.<\/p>\n<h3>Check 2: Filters<\/h3>\n<p>Review each of the filters at the top of the dashboard to ensure that all submitted data is populated. This is crucial for your institution to be able to disaggregate the data in the future.<\/p>\n<div class=\"info\">\n<p>Each time you select or deselect a filter, you must click <strong>Apply<\/strong> for the filter to take effect.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"capturedimg\" style=\"margin-top: 20px; margin-bottom: 15px;\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/dashboardcheck2-1.png\" alt=\"\" width=\"150\" height=\"143\" \/><\/p>\n<\/div>\n<ul>\n<li><strong>Cohort:<\/strong> Click each year and check the Cohort Enrollment section at the top of the dashboard. The numbers should change with each year you select. If the numbers seem incorrect, this is another indication that your data requires further review. If the most recent year&#8217;s data is not complete, choose the next most recent year for the following steps.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"capturedimg\" style=\"margin-top: 20px; margin-bottom: 15px;\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/dashboardcheck3-1.png\" alt=\"\" width=\"100\" height=\"193\" \/><\/li>\n<li><strong>Cohort Term:<\/strong> Select each option and make sure numbers are showing for every term. Make sure the semesters and sessions are correct for your institution. Examples of incorrect semesters\/sessions would be if winter is showing but your institution does not offer a winter session or if your institution offers a summer semester but summer isn&#8217;t showing.<\/li>\n<li><strong>Credential Type Sought:<\/strong> Ensure that all types of credentials are showing. Often only one degree type appears. In the example below, only <strong>Associate<\/strong> and <strong>Unknown<\/strong> are showing. Select <strong>Unknown. <\/strong>Does this number seem too high for all cohort years? If so, look at the individual cohort year to assess further (select <strong>All<\/strong> to uncheck all options, then select the year and click <strong>Apply<\/strong>). It&#8217;s possible that for some years you did not correctly identify the students\u2019 degree type sought in your course file(s), or a course file is missing. Select <strong>All<\/strong> again ensure all students are populated before continuing to the next filter.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"capturedimg\" style=\"margin-top: 20px; margin-bottom: 15px;\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/dashboardcheck4-1.png\" alt=\"\" width=\"150\" height=\"102\" \/><\/li>\n<li><strong>Attendance:<\/strong> The options for this filter are <strong>Full-time, Part time, <\/strong>and <strong>Unknown<\/strong>. Select <strong>Unknown<\/strong>. Does the number look correct? Select both<strong> Full-time<\/strong> and <strong>Part-time<\/strong>. Does this number look correct? If many students are <em>Unknown<\/em> for attendance, a course file might be missing or incomplete for that cohort.<\/li>\n<li style=\"margin-bottom: 0;\"><strong>Dual\/Summer Enrollment:<\/strong> This is an optional field, so <strong>Unknown<\/strong> may be the only option available. Make sure the numbers are populated, then check the numbers by a specific cohort year for which you have submitted all the data.\n<div class=\"box\" style=\"margin-top: 10px; margin-bottom: -20px;\">\n<div class=\"info\">\n<p>These students are only the ones with dual enrollment who matriculated, so if you do not know this number, skip this section for now.<\/p>\n<\/div>\n<\/div>\n<\/li>\n<li><strong>Age Group:<\/strong> Since the age group is calculated, you do not need to select any options for this filter.<\/li>\n<li><strong>Race\/Ethnicity:<\/strong> Select either your institution&#8217;s highest or lowest race\/ethnicity populations and look at them individually. The Clearinghouse uses small cell suppression, so this method might not work depending on your institution&#8217;s numbers. Each student can only be counted in one category on the dashboard, so you might see slight variations from your internal numbers if you do not de-duplicate.<\/li>\n<li><strong>Pell Grant, First Generation, Math Prep, and English Prep:<\/strong> You should see each category as an option as well as <strong>All<\/strong> and <strong>Unknown<\/strong>. Select each option and make sure numbers appear. For example, <strong>Math Prep<\/strong> should show <strong>Ready in Math <\/strong>and <strong>Not Ready in Math<\/strong>. <em>First Generation, Math Prep, <\/em>and <em>English Prep<\/em> are optional fields, so you will only see <strong>Unknown<\/strong> if you did not provide this information.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"First_Year_Gateway_Course_Completion_Dashboard\"><\/span>First Year Gateway Course Completion Dashboard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Submitting gateway course data is option, but we highly recommend it. If this dashboard is not populated, it is likely because your institution did not submit this data.<\/p>\n<h3>Check 1: Required vs. Cohort<\/h3>\n<p>Compare the number for required gateway math and English to the overall new student cohort. If the numbers are roughly equal, your institution might have coded all new students as requiring gateway math and English instead of considering the requirement at the program-level.<\/p>\n<h3>Check 2: Unknown Statuses<\/h3>\n<p>Select <strong>Math Prep<\/strong> and <strong>English Prep<\/strong> from the <em>Select Dimension<\/em> drop-down.\u00a0In the top-right quadrant, you should see two to three line graphs, depending on whether you have <em>Unknown<\/em> showing in the legend.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"capturedimg\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/dashboardcheck5.png\" alt=\"\" width=\"125\" height=\"92\" \/><\/p>\n<p>Select <strong>GPA Range <\/strong>from the <em>Select Dimension<\/em> drop-down. If there is a substantial number of students with <em>UK<\/em> GPAs in the bottom-left quadrant, or data is missing for multiple years, your data requires further review.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"capturedimg\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/dashboardcheck6.png\" alt=\"\" width=\"275\" height=\"381\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"First_Year_Credit_Accumulation_Rate_Dashboard\"><\/span>First Year Credit Accumulation Rate Dashboard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Check 1: CAR Drops<\/h3>\n<p>Determine if you there are any drops in the credit accumulation rate (CAR) percentage for older cohorts. The most recent cohort might show a small drop as compared to previous cohorts if you have not submitted all course data for that cohort\u2019s first academic year.<\/p>\n<p>In the example below, there is a drop to nearly 0% in the 2016-17 cohort. This could indicate that course data is missing for the 2016-17 cohort for their first academic year (possibly one or more terms).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"capturedimg\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/dashboardcheck7.png\" alt=\"\" width=\"600\" height=\"332\" \/><\/p>\n<p>Select <strong>2<\/strong> from the <em>Academic Year<\/em> filter. Again, the most recent cohort might show a small drop as compared to previous cohorts if you have not submitted all course data for that cohort\u2019s second academic year.<\/p>\n<p>In the example below, there is a drop to nearly 0% in the 2016-17 cohort. This could indicate that course data is missing for the 2016-17 cohort for their second academic year (possibly one or more terms).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"capturedimg\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/dashboardcheck8.png\" alt=\"\" width=\"600\" height=\"343\" \/><\/p>\n<h3>Check 2: CAR Spikes<\/h3>\n<p>Select both <strong>1<\/strong> and <strong>2<\/strong> from the <em>Academic Year<\/em> filter. Look for any spikes in CAR. Most institutions see CAR at somewhere between 30-50%. If you see numbers closer to 90-100% for a cohort, there might be issues with your course data.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"First_Year_Credit_Completion_Ratio_Dashboard\"><\/span>First Year Credit Completion Ratio Dashboard<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Check 1: Credit Completion Ratios<\/h3>\n<p>Review the credit completion ratio numbers on the dashboard. If they seem very low or very high, there might be issues with your course data and\/or how you coded credits earned\/attempted for courses.<\/p>\n<h3>Check 2: Average Credits Earned<\/h3>\n<p>Look at the Credit Completion Ratio by Cohort section of the dashboard. If you see purple lines that are very low (close to 0) or very high (over 30), there might be issues with your course data and\/or how you coded credits earned\/attempted for courses.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"capturedimg\" src=\"https:\/\/help.studentclearinghouse.org\/pdp\/wp-content\/uploads\/dashboardcheck9.png\" alt=\"\" width=\"605\" height=\"360\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Next_Steps\"><\/span>Next Steps<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you identify data quality issues based on this check, contact us at <a href=\"mailto:pdpservice@studeniclearinghouse.org\" target=\"_blank\" rel=\"noopener\">pdpservice@studeniclearinghouse.org<\/a>, share your documentation, and schedule a time to discuss the discrepancies and how to resolve them.<\/p>\n<p>If you did not identify any discrepancies, congratulations! You are now ready to share and use your dashboards.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to use the Data Quality Dashboard Check to help you determine if all the data your institution submitted is visible and the dashboards and filters are functioning correctly.<\/p>\n","protected":false},"author":6,"menu_order":88,"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":[89,78],"ht-kb-tag":[],"class_list":["post-1640","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-data-submission-tools","ht_kb_category-institutional-researchers"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/1640","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=1640"}],"version-history":[{"count":39,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/1640\/revisions"}],"predecessor-version":[{"id":16609,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb\/1640\/revisions\/16609"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/media?parent=1640"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-category?post=1640"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/pdp\/wp-json\/wp\/v2\/ht-kb-tag?post=1640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}