Review:
WordPress posting
Review four corners:
1. Make a copy
2. Four corners test
3. Check the math
4. Excel and the Black cross copy function
5. Sorting
>—<
Freeze Panes
Percentage Change
(New Number-Old Number)/Old Number *100
Question: Percentage Change on Citybudget.xls – Which Department Get The Biggest Raise?
Spreadsheet Formatting:
Cells – Dollar Signs
Grid Lines
Add / Delete Columns
Exercise 2:
Analyzing Change
National Center for Education Statistics
https://nces.ed.gov/collegenavigator/
Gather Data for Univ of Arkansas
Main points:
Data gathering / cleaning from website
Formatting in Excel
Relabel
Tricky Sum Function
Calculate Percentage Change Between 2015-16 and 2016-17.
The percentage change 2013-2014 & 2016-2017
If you finish early, then start on homework, comparing University of Arkansas to University of Missouri at Columbia
HOMEWORK:
Complete Exercise #2 with Univ of Arkansas and Univ of Missouri at Columbia. Compare the two schools with these questions.
1) How much would an in-state student expect to pay in total tuition, room and board for the 2016-2017 school year? How has that changed in the last year on a percentage change basis?
2)How much would an out-of-state student expect to pay in total tuition, room and board for the 2016-2017 school year? How has that changed in the last year on a percentage change basis? How does that differ from in-state students?
4) Which category increased the most from the 2016-2017 school years? Raw change? Percent change?
5) Write a lead for a story based on your analysis.
6) What other information and/or sources would help you finish this story?
Post Answers and spreadsheet in a Brief Memo to WordPress by 11:59 pm Sunday, Aug 27
Fayettevile Roots Festival is going on now
Free stuff at the Roots festival
http://kuaf.com/post/no-ticket-not-problem