Tips for Covering A Disaster
My friends in South Carolina and North Carolina are getting prepared to cover Hurricane Florence, which could be a major disaster (40 inches of rain expected in some places…). Read this checklist on how to prepare for covering such a disaster – lots of good tips in general for field reporting, ie, use pen and paper since you need to preserve your iPhone battery. Have a paper map because downed cell towers will render Google Maps useless. Etc. Bring a mobile power supply to plug into your car’s cigarette lighter to power your laptop. Basically, prepare to live in your car (pro tip, rent a car so you are destroying someone else’s ride, not your own, in the disaster zone).
https://www.poynter.org/news/heres-what-you-need-help-you-cover-hurricanes
This is a good mindset for field reporting in general – prepare for stuff to blow up and go wrong.
————————————————————————————————
Tableau Desktop Software
Thank you for your interest in the Tableau for Teaching program. Below is a website (landing page link) for your upcoming class. Each student should go to the landing page to download Tableau Desktop and enter the product key noted below. This key will allow your entire class to activate Tableau Desktop for the duration of the course.
Please forward these instructions to your students:
The download is for your personal computer. All lab computers have Tableau Desktop 2018. No other computers on campus have it.
You will need to free up hard drive space and have sufficient memory. In my experience, you need at least 15 gb free hard drive space and 4 gb ram – it will be slow but it will run with that. Download the latest version of Tableau Desktop here
- For Lab Computers, Open Tableau Desktop
- Click on the link above and select Get Started. On the form, enter your school email address for Business E-mail and enter the name of your school for Organization.
- Activate with your product key: TCN8-F401-A980-11F5-79E7
Resources:
New to Tableau? Data Analytics for University Students guide
Students can continue using Tableau after the class is over by individually requesting their own one-year license through the Tableau for Students program here
Continue with Tableau
Resume with Student Loan Data
Chart: Schools with Student Loan Debt
–Add and format headlines
–Add annotations
–Add a Filter to Control All Cities on Worksheet
–Drag Cities to Filter
–Format Data in Dollars. Axis and Pane. Format. Currency Custom.
–Interactive Filter. Format as a drop down
…
Tableau Calculations
Introduction to Calculations Transcript
Table Calculation: Add a new column divides graduate debt into enrollment
–In Measures Data Tab, Left Click on GRAD_DEBT_MDN, Create Calculated Field
–Put in this formula: sum[GRAD_DEBT_MDN]/[UGDS]
–Rename This as: Grad Debt Per Capita Enrollment
Drag INSTNM to Rows
#Grad Debt Per Capita Enrollment to Columns
Format with a Title, add appropriate annotations.
Color the graphic, include labels.
Dual Axis Chart
Institutions to Rows
Graduate Debt to Columns
Withdrawal Debt to Columns
Dual Axis Chart for the two debts
Display in Side by Side Bar Chart.
Edit Chart Title
Edit Labels – left click, edit alias
Rotate School Labels – left click, rotate label
Edit Y Axis Legend – left click, format. Scale. Numbers, Custom. No decimals
Homework Due Saturday, Sept. 15, 11:59 p.m.
- Build a chart with a new calculated field dividing graduate debt into enrollment
Visualize by school
Format the X and Y axes, Label the rows with specific debt to enrollment (UofA is $xxxx),
Provide a headline and source.
2. Build a chart with a new calculated field dividing dropout debt into enrollment
Visualize by school
Format the X and Y axes, Label the rows with specific debt to enrollment (UofA is $xxxx),
Provide a headline and source.
3. Build a Dual Axis Chart the Calculated Fields, Graduate Debt / Enrollment and Dropout Debt / Enrollment
Filter by Beauty Schools
Visualize by school
Format the X and Y axes, Label the rows with specific debt to enrollment (UofA is $xxxx),
Provide a headline and source.
Export and upload the three image files and load to Blackboard.
Write two story ideas to come from this data work in a Word file.