Student Loan Program Trends in the United States (2007–2025)



Written Report

    This project examines how federal student loan programs in the United States have changed over time, with a focus on borrowing amounts, the number of student recipients, and the growing cost burden on individual borrowers. Although student debt is often discussed as a single issue, most people are not aware that federal loans come from different programs, each with its own history and trends. The goal of this analysis is to understand which programs are expanding, which are disappearing, and whether students today are receiving more borrowed dollars per person than they did in the past.

    The idea for this project was influenced by several existing visual resources, including the Federal Student Aid dashboard, DataUSA’s educational finance reports, and journalist-designed college affordability graphics. These examples revealed how powerful visual storytelling can be in making complex financial data easier to understand. However, many of these dashboards focus on overall totals or tuition pricing without comparing how individual loan programs contribute to borrowing patterns. This gap motivated a closer look at program-level differences, especially the cost per borrower.

    The data used in this study came from the Federal Student Aid Portfolio Summary of the National Student Loan Data System (NSLDS). The data was cleaned in Excel by removing quarter-specific values, unmerging multi-row column labels, and restructuring the spreadsheet into a simple four-column format containing year, total dollars, number of recipients, and loan program name. A new calculated measurement, “dollars per recipient,” was created by dividing total dollars by total borrowers for each program. All visualizations were produced in Tableau Public, using a combination of time-series line charts, a dual-axis comparison chart, a scatter plot, and a bar graph. These different visualization methods made it possible to analyze both long-term change and program differences.

    The results reveal clear changes in how students borrow. Direct Loans have rapidly grown since 2010 and now dominate federal lending, both in total dollars and in number of borrowers. FFEL (Federal Family Education Loans) steadily declined until the program was phased out and replaced by Direct Loans, while Perkins Loans remained small and have nearly disappeared. Another important finding is that the average amount borrowed per student has increased almost every year. Even in years when the number of recipients dropped, total dollars continued to rise, meaning that the typical student is taking on more debt than before.

    These trends suggest that relying on a single dominant loan program may simplify borrowing, but it also concentrates risk and does little to lower the cost burden for students. Rising loan dollars per borrower reflect the broader issue of increasing tuition and higher education costs in the United States. Future research could compare these loan trends with college tuition data, loan interest rates, or default and repayment outcomes to better understand the long-term impact on students.

    Overall, this project shows how federal loan programs have shifted dramatically over the past two decades and highlights how the cost of borrowing per student has continued to grow. Understanding these patterns is essential for students, policymakers, and educators who are working toward a more affordable and equitable higher education system.


Comments

Post a Comment

Popular posts from this blog

My Geographic Map of Florida COVID-19 Cases by ZIP Code

Image
     For this week’s assignment, I was instructed to find a dataset and create a visual using Tableau. I selected the Florida COVID-19 Cases by ZIP Code (April 28, 2021) dataset from the University of South Florida Libraries’ Digital Heritage and Humanities Collection, originally downloaded from the Florida Department of Health ArcGIS Data Portal. Using this data, I wanted to examine how COVID-19 cases were distributed across Florida ZIP codes during the s pring of 2021. After importing the dataset into Tableau, I generated this geographical map using a blue color scale , since it provided the clearest contrast.      On the map, ZIP codes shaded in darker blue represent higher case counts, while lighter areas represent lower counts. Unsurprisingly, South Florida ZIP codes (especially in Miami-Dade and Broward counties) had the highest reported numbers. Central Florida areas around Orlando also showed clusters of elevated case counts. What stood out most w...
Read more

Spotting Differences in R: Comparing Fuel Efficiency by Cylinder Count

Image
  For this assignment, I used RStudio and the built-in mtcars dataset to explore differences in average miles per gallon (MPG) across cars with different numbers of cylinders. Using ggplot2 , I created a simple bar chart that displays the mean MPG for 4-, 6-, and 8-cylinder cars. The chart clearly shows that 4-cylinder cars achieve the highest average fuel efficiency , followed by 6-cylinder, and then 8-cylinder vehicles with the lowest MPG. This visualization directly supports a spotting differences task, it makes the contrasts between groups immediately visible through bar height comparisons along a shared baseline. From a design perspective, I applied a minimal theme and used a clear title and axis labels to keep attention on the comparison itself. This aligns with Stephen Few’s  principle of simplifying visuals so that viewers can detect differences quickly and accurately. Likewise, Yau  emphasizes using straightforward encodings, like length along a common scale...
Read more