Here are some resources you may find helpful for converting and importing data for your projects.
- Instructions for running a JAR file.
- xml2csv-con.jar: Convert CSV files that you can import into spreadsheets.
- GrabSenateVotes.jar: Gathers all the votes from a specified congress number and puts them into an XML file. Works for Congress sessions from 101-113. It will report votes that could not be added due to formatting issues.
- GrabHouseVotes.jar: Gathers all the votes from a specified year from the House and puts them into an XML file. There are many votes in each year (for example, there are about 600 votes for 2010).
- Instructions for converting SPSS files to Excel.
- Tutorial on how to install LXML and Pip/Requests onto your computer (Windows only)
Web Bundle mentioned found here
Here are some resources you may find helpful for displaying and presenting your projects. All tutorials are designed for Windows lab machines.
- Tutorial for creating a Google website.
- Instructions to publish an Excel table as a webpage.
- Make sure you click the Share button in the upper right of your Google site so it can be viewed by anyone. If you want to keep it private, you can grant the course staff access.
- Sometimes hand-annotating interesting trends is better than describing them using text. Look at this website that visualizes the number of vehicles involved in fatal crashes using conditional formatting.
- Windows and Mac instructions for creating a ZIP file.