Pivot Table Class Exercise
Univ of Arkansas, Fayetteville financials
Video On Gathering Financials, Pivot Table and Making A Chart
- Get the “UAF Various Facility Pledged Revenues” from Pg. 3 and import into Excel. Use Adobe Acrobat Pro
University of Arkansas financial report June 2016
(Data Note: Data in this exercise represents revenues pledged for repayment of various bond issues. They do not represent the full budget. If you are curious about that, see: http://financial-affairs.uark.edu/PDFs/1415annualrept.pdf)
2. Check and verify your data was imported correctly. Check the totals against the original Create a tab with a data biography
3. Format into dollars, no decimals
4. Pivot table with the Source as rows, 2012 and 2016 as columns
4. Create a Percentage Change Calculation, 2016-2012
5. Copy Data and Paste as Values into a new tab
6. Delete 2012-2016 columns. Highlight Source and % change, Click chart, create bar chart
Part 2
Repeat with data from Pg. 6: UAF Athletic Pledged Revenues.
Follow the same steps
Update, 5:45 pm: Homework assignment based on this data has been cancelled. See below for new homework assignment.
Backup material:
http://spreadsheets.about.com/od/datamanagementinexcel/ss/8912pivot_table.htm#step1
Update: New Homework Assignment
Read: Data Journalism Handbook, the group of case studies “In The Newsroom.” Review all of the case studies, post two questions or observations by 11:59 pm Sunday.
http://datajournalismhandbook.org/1.0/en/in_the_newsroom.html
It’s pretty interesting reading about how data reporting is being applied in newsrooms both in the U.S. and Europe.