Discussion for Oct 20: Pivot Tables
Part 1: Pivot tables
Pivot tables are a powerful tool in Excel to analyze and tabulate complex spreadsheets.
Follow the instructions on this NICAR tipsheet called pivot tables.. You will be using a practice dataset called worldbank.
Assignment Due 11:59 pm Wednesday Oct. 12:
Create a pivot table using WorldBank.
#1 Following the NICAR handout instructions, create a list of the top countries on this disbarment list. Sum up the violations and then sort the list, highest to lowest.
Save these on separate tabs on a single spreadsheet and upload it to a blog post on WordPress.
Homework Due 11:59 pm Wednesday, Oct. 19
Read: Data Journalism Handbook, “Understanding Data”
Post two questions about this reading on a blog post.