Agenda for Sept. 23, 2018
- Continue on Private vs. Public Colleges:
How Does The Debt Load Differ?
2. Group Exercise – Data Dictionary: Student Loan Dataset
3. Post interactive graphics on Tableau Public, Embed in WordPress.
Review Matching
Group Exercise – Data Dictionary: Student Loan Dataset
https://collegescorecard.ed.gov/data/
All 1,826 columns explained here.
https://collegescorecard.ed.gov/assets/FullDataDocumentation.pdf
https://collegescorecard.ed.gov/assets/CollegeScorecardDataDictionary.xlsx
Group Assignment: Examine The Data Dictionary. Sketch out the broad categories describing the data. Hint: There’s a section on demographics – race, ethnicity.
Consult this article for ideas about the types of data you can examine
Questions:
What are the broad groupings?
What questions do you want to answer with this data and which data fields should we look at next?
Compose your thoughts at the bottom of this Google Doc:
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:
<div class=’tableauPlaceholder’ id=’viz1537795242033′ style=’position: relative’><noscript><a href=’#’><img alt=’Median Debt of Graduated Students in Arkansas, 2016Source: CollegeScorecard ‘ src=’https://public.tableau.com/static/images/St/StudentLoans-ARK20168-19-18/Sheet1/1_rss.png’ style=’border: none’ /></a></noscript><object class=’tableauViz’ style=’display:none;’><param name=’host_url’ value=’https%3A%2F%2Fpublic.tableau.com%2F’ /> <param name=’embed_code_version’ value=’3′ /> <param name=’site_root’ value=” /><param name=’name’ value=’StudentLoans-ARK20168-19-18/Sheet1′ /><param name=’tabs’ value=’no’ /><param name=’toolbar’ value=’yes’ /><param name=’static_image’ value=’https://public.tableau.com/static/images/St/StudentLoans-ARK20168-19-18/Sheet1/1.png’ /> <param name=’animate_transition’ value=’yes’ /><param name=’display_static_image’ value=’yes’ /><param name=’display_spinner’ value=’yes’ /><param name=’display_overlay’ value=’yes’ /><param name=’display_count’ value=’yes’ /></object></div> <script type=’text/javascript’> var divElement = document.getElementById(‘viz1537795242033’); var vizElement = divElement.getElementsByTagName(‘object’)[0]; vizElement.style.width=’100%’;vizElement.style.height=(divElement.offsetWidth*0.75)+’px’; var scriptElement = document.createElement(‘script’); scriptElement.src = ‘https://public.tableau.com/javascripts/api/viz_v1.js’; vizElement.parentNode.insertBefore(scriptElement, vizElement); </script>
–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
Homework, due 11:59 p.m. Tuesday, Sept. 25.
New data table: Examine the 2016 data and the data dictionary.
- 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
2. Build a new spreadsheet with these fields. Upload to Blackboard.