First Critique: USA Today story on federal funding for smaller airports (and accompanying map). In reviewing this material, pay particular attention to how data drives the story and how the reporters used *and* explained it. Would you have done the same? Did they pay too much attention to some aspects and not enough to others? Was it clear to you what they did to arrive at their conclusions? Please critique both the story and map in at least 400 words. When in doubt about what to say, be specific. Don’t say, “I liked it.” Tell me why.
Excel: Download the first quarter 2010 filing for Earl Pomeroy of North Dakota from the FEC’s electronic filings search. Be sure to download the “Format documentation for downloads” file to get the headers for contributions (Schedule A) and expenditures (Schedule B) from the efiling headers for version 6.4 excel file. Then, answer the following questions using either filters or pivot tables:
1. How much money has come from donors listing a North Dakota address vs. from all other states combined?
2. How much money has Pomeroy’s campaign spent on salaries?
3. How much money have attorneys given to Pomeroy’s campaign?