Assignments for April 22

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?

Readings: What is SQL?, SQL Fundamentals


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s