Thursday, Aug 25:
1) Review reading questions on Dedman, Color of Money
2) Windows vs Mac: Excel, Access and data
3) Resume Exercise #2 – NICAR Coursepack
–Review Exercise1 & Basics and Sorting in Excel
—Open sample dataset: UrbanPop.xls
1. Make a copy
2. Freeze panes, Four corners test
Shift + Command + Arrows
Answer to Freeze Panes problems
3. Sorting
–Which urban areas was the largest in 1950?
–Which is expected to be the largest in 2030?
4. Percentage Change
(New Number-Old Number)/Old Number *100
–Which had greatest rate of change between 1950-2015?
–Are any urban areas expected to lose population from 2010 to 2030?
–If so, how many and which one is expected to lose the most?
–Which United States urban area is expected to have the largest percent increase from 2015 to 2030?
Homework:
Read: Cohen, Numbers in the Newsroom, to pg. 30 (through the percent change section)
Read: Basics and Sorting in Excel & Exercise1
Read Dedman, Color of Money, Day 2-4 May 1, 1988.
–Blog reading questions on Dedman by 5 p.m. 8/29.
Focus on method, handling of data