Agenda for Sept. 23, 2018
- Continue on Private vs. Public Colleges:
How Does The Debt Load Differ?
2. Post interactive graphics on Tableau Public, Embed in WordPress.
3. Demographics and Default
The Private vs. Public Colleges Assignment, Continued
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 college debt, median public college debt.
Create a chart median debt for graduates for public and private colleges
Create a chart median debt for discontinued students from public and private colleges
Revel in your nerd powers
Post Interactive Graphics to Tableau Public.
–Post on Tableau Public the chart for median debt for graduates for public and private colleges
–Copy embed code from Tableau Public from the Share icon in the lower right corner of your data visualization. Embed code looks something like this:
–Post on WordPress.
- Create a new post
- Use Divi Builder, the Purple box above the formatting bar
- Insert columns, pick a full row
- Insert module, pick </> Code
- Paste your Tableau Public embed code in the Content box
- Scroll down, change the Admin Label to My Mind-Blowing Tableau Graphic (or something more humble). Save and Exit
- Change Page Layout (upper right corner) to Fullwidth. Publish
Revel in your nerd powers
Demographics and Default
- In addition to the fields we are already using (name, city, enrollment, median debt, student debt, graduate debt, private/public, etc) list the new fields you would use to build a new table that includes:
–Default
–Demographics
–SAT scores
–Special college designator (HBCU, Native American)
–First generation students
All 1,826 columns explained here.
https://collegescorecard.ed.gov/assets/FullDataDocumentation.pdf
https://collegescorecard.ed.gov/assets/CollegeScorecardDataDictionary.xlsx
Group Assignment:
Group 1: Demographics
Group 2: Default
Use this spreadsheet: ARDebt_Sept26-1dfz8ea
Compose your thoughts at the bottom of this Google Doc:
Homework, due 11:59 p.m. Saturday, Sept. 29.
Explore the demographic and default data. Two teams look at a new expanded spreadsheet: ARDebt_Sept26-1dfz8ea
that has Demographic and Default data.
You will generate a graphic that explores some aspect of this demographic data. What are the default rates by women? What are the debt loads for men? How do white, African-American and other students compare on debt loads? On Defaults?
Generate one chart to explore these questions. I want to have 10 different charts examining these questions.
Demographic Data:
Kris, Samantha, Katie Beth, Elizabeth, Grant
Default Data:
Caitlin, Haley, Hailey, Skylar, Megan
Post one chart on Blackboard by 11:59 pm Saturday and two paragraphs about what you found and what story you think should be explored with the data.