Agenda for Sept. 19, 2018
Private vs. Public Colleges: How Does The Debt Load Differ?
Return of the Data Dictionary: Student Loan Dataset
https://collegescorecard.ed.gov/data/
All 1,826 columns explained here.
1) Find the field that distinguishes between public and private colleges:
https://collegescorecard.ed.gov/assets/FullDataDocumentation.pdf
https://collegescorecard.ed.gov/assets/CollegeScorecardDataDictionary.xlsx
2) Build a new spreadsheet from this raw data: AR2016ALL-1jwseiw
Name your new sheet ARDebt9_19
It will have these fields:
A) The private / public colleges field
B) Latitude and Longitude
C) The 8 data fields we have used so far in ARDebt.
D) A data dictionary
The ARDebt data has these fields:
| NAME OF DATA ELEMENT | VARIABLE NAME |
| Institution name | INSTNM |
| City | CITY |
| State postcode | STABBR |
| ZIP code | ZIP |
| Enrollment of undergraduate certificate/degree-seeking students | UGDS |
| The median original amount of the loan principal upon entering repayment | DEBT_MDN |
| The median debt for students who have completed | GRAD_DEBT_MDN |
| The median debt for students who have not completed | WDRAW_DEBT_MDN |
Let’s Clean Up These Stupid Names in ARDebt9_19
| NAME OF DATA ELEMENT | VARIABLE NAME | English Name |
| Institution name | INSTNM | COLLEGE |
| City | CITY | CITY |
| State postcode | STABBR | STATE |
| ZIP code | ZIP | ZIP |
| Control of institution | CONTROL | PRIVATE_PUBLIC |
| Latitude | LATITUDE | LATITUDE |
| Longitude | LONGITUDE | LONGITUDE |
| Enrollment of undergraduate certificate/degree-seeking students | UDGS | ENROLL_UNDERGRAD |
| The median original amount of the loan principal upon entering repayment | DEBT_MDN | DEBT_MDN |
| The median debt for students who have completed | GRAD_DEBT_MDN | GRAD_DEBT_MDN |
| The median debt for students who have not completed | WDRAW_DEBT_MDN | WDRAW_DEBT_MDN |
3) Make Charts in Tableau
Import ARDebt9_19 into Tableau.
Create a chart of the overall median debt, median private, median public college debt.
Create another one, public, private for graduates and discontinued students.
Revel in your nerd powers