Review:
WordPress posting
Review four corners:
1. Make a copy
2. Freeze Panes
3. Four corners test
4. Check the math
Excel and the Black cross copy function
5. Sorting
>—<
New:
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
United Nations Population Dataset. Work With Nicar Coursepack:
Open sample dataset: UrbanPop.xls
Percentage Change
Questions:
–Which urban areas was the largest in 1950?
–Which is expected to be the largest in 2030?
Percentage Change
–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:
Complete Exercise #1 and Answer All Questions Below Using UrbanPop
–Which urban areas was the largest in 1950?
–Which is expected to be the largest in 2030?
Percentage Change
–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?
Include a formatted spreadsheet with U.S. cities answer
Post Answers in a Brief Memo to WordPress by 11:59 pm Sunday, Jan 22