Assignments for Feb. 21

Excel: Using data files available from the Florida Division of Elections for the 2008 and 2004 presidential preference primaries, determine which counties saw the biggest increase in Democratic and Republican turnout from 2004 to 2008. You may want to use a pivot table to help with this, but you don’t have to.

Data: Imagine you’re going to create a dataset with information on SMPA’s faculty members (one that you would use for reporting purposes, of course). What information would it contain? How would you structure it? Please provide sample rows in a spreadsheet, plus a brief introduction to your reasoning for including the information you picked. When you’re designing your spreadsheet, think about the kinds of questions you’d want to answer, and what information could help answer them.

Intro to SQL: Read SQLZoo 1 and SQLZoo 2.
Intro to MS Access: Read this overview.

Story for Class Discussion: St. Pete Times story on migration.


About this entry