| Date | Due Today (9 a.m.) |
In Class | Homework |
| Wed 5/13 | Introductions, tech set-up | Reading Reflections #1 | |
| Thur 5/14 | Reading Reflections #1 |
Spreadsheets |
UNC Salaries Questionnaire |
| Fri 5/15 | UNC Salaries Questionnaire
Reading Reflections #2 |
Data cleaning |
Clean campaign finance reports |
| Mon 5/18 | Cleaned campaign finance reports
Audit trail/recipe Reading Reflections #3 |
Acquiring data – download, scrape. request |
Public records request letter |
| Tue 5/19 | Draft of public records request letter
Reading Reflections #4 |
Scraping data from web pages |
Reading Reflections #5 |
| Wed 5/20 | Initial scrape of website
Reading Reflections #5 |
Intro to databases and SQL |
Police data questionnaire |
| Thur 5/21 | Interviewing data with SQL |
||
| Fri 5/22 | Police data questionnaire
Reading Reflections #6 Final Project proposal (5 p.m.) |
Rolling your own databases
“Midterm” |
Reading Reflections #7
“Midterm” |
| Mon 5/25 | Memorial Day. No Class. | ||
| Tue 5/26 | Reading Reflections #7
“Midterm” Coffee survey |
Maps and charts with Excel and Google Fusion Tables |
Data visualization #1 |
| Wed 5/27 | Data visualization #1 | Visual data analysis with QGIS and Tableau |
Union County crimes/schools map |
| Thur 5/28 | Union County crimes/schools map
Data visualization #2 Final public records request letter Data from scraped website |
Work on final project |
Work on final project |
| Fri 5/29 | Final Project (5 p.m.) |
FINAL EXAM DAY: Complete final project |
|