Data: Assignment #1 (due Tuesday 11/22)

Part 1 of your data assignment for this class will be to convert unsearchable PDFs of certified election results into .csv spreadsheet files. This is for the crowdsourced Open Elections project.

Here are detailed instructions on creating a usable .csv file for Open Elections. (Scroll down to “The Process.”) Please follow these detailed instructions. If we turn in something that varies from this format, it will be not usable for the project (and your grade will reflect this). If you have any questions, email me before 3 p.m. on Monday.

We are focusing on 2015 general election results in Mississippi. You can find your county assignment(s) here. (Here’s a list of all the the MS counties with 2015 results.)

You will need to email me your .csv files (one for each county) by 12:30 p.m. on Tuesday 11/22. You can create your .csv files by using Excel/Numbers or you can make your county spreadsheets in Google Sheets. Here’s a guide to using Google Sheets.