midwest-college-scorecard.csv

The U.S. Department of Education (DOE) collects and publishes data on institutions of higher education in their College Scorecard. The data provided in the College Scorecard facilitate transparency and provide information for interested stakeholders (e.g., parents, students, educators). The data in midwest-college-scorecard.csv include information on 92 institutions from Minnesota and its adjacent states (Iowa, North Dakota, South Dakota, and Wisconsin) drawn from the 2020–21 data.

---

The attributes included inthe data are:

• institution: Name of institution of higher education
• control: Institutional control (Private nonprofit, Private for-profit, or Public)
• state: Two-letter U.S. state abbreviation indicating the location of the institution
• admission_rate: Admission rate indicating proportion of students who applied that are admitted to the institution
• act: The 75th percentile ACT composite score at the institution. The composite score is composed of items from the English, mathematics, reading, science sections.
• debt_all: Median amount of debt (loan principle when entering repayment) for all undergraduate borrowers
• debt_grads: Median amount of debt after graduation for undergraduate borrowers who complete their degree
• earnings: Median earnings of students working and not enrolled 10 years after entry
• completion_rate: The 6-year completion rate for first-time, full-time students at the institution

Preview

# Load library
library(tidyverse)

# Import data
colleges = read_csv(file = "https://raw.githubusercontent.com/zief0002/epsy-5261/main/data/midwest-college-scorecard.csv")

# View data
colleges

# A tibble: 92 × 9
   institution                                          control             
   <chr>                                                <chr>               
 1 Buena Vista University                               Private (Non-Profit)
 2 Central College                                      Private (Non-Profit)
 3 Clarke University                                    Private (Non-Profit)
 4 Cornell College                                      Private (Non-Profit)
 5 Dordt University                                     Private (Non-Profit)
 6 Drake University                                     Private (Non-Profit)
 7 Emmaus Bible College                                 Private (Non-Profit)
 8 Faith Baptist Bible College and Theological Seminary Private (Non-Profit)
 9 Graceland University-Lamoni                          Private (Non-Profit)
10 Grand View University                                Private (Non-Profit)
   state admission_rate   act debt_all debt_graduates earnings completion_rate
   <chr>          <dbl> <dbl>    <dbl>          <dbl>    <dbl>           <dbl>
 1 IA             0.660    25    17500          25000    47076           0.628
 2 IA             0.745    25    20815          26984    53417           0.661
 3 IA             0.888    23    19500          26717    50541           0.545
 4 IA             0.811    30    21500          27000    51898           0.638
 5 IA             0.732    28    17500          21500    52342           0.741
 6 IA             0.691    31    19500          23000    73451           0.782
 7 IA             0.991    26     9350          15750    39334           0.746
 8 IA             0.561    27     8750          12971    42315           0.56 
 9 IA             0.666    24    14209          21212    45600           0.474
10 IA             0.996    22    15097          22500    53256           0.507
# ℹ 82 more rows

References

U.S. Department of Education. (2023). College Scorecard data.