Course Schedule

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

Reading Reflections #2

Fri 5/15 UNC Salaries Questionnaire

Reading Reflections #2

 Data cleaning
Clean campaign finance reports

Audit trail/recipe

Reading Reflections #3

Mon 5/18 Cleaned campaign finance reports

Audit trail/recipe

Reading Reflections #3

Acquiring data – download, scrape. request
Public records request letter

Scrape website

Reading Reflections #4

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

Final Project proposal

Reading Reflections #6

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

Coffee survey

“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

Data visualization #2

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
 

 

Print Friendly, PDF & Email

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.