Track 1: Data Organization With Spreadsheets / Using OpenRefine
Fri 04/16 from 10:00 a.m. – 12:00 noon: Data Organization in Spreadsheets for Social Scientists
Description:
Participants will learn: Good data entry practices – formatting data tables in spreadsheets, How to avoid common formatting mistakes, Approaches for handling dates in spreadsheets, Basic quality control and data manipulation in spreadsheets, and Exporting data from spreadsheets.
Facilitators:
Dr. Nannette Napier – Associate Dean for School of Business, Professor of Management Information Systems and Decision Sciences
Dr. Luis Torres – Associate Professor of Marketing
…
Fri 04/23 from 10:00 a.m. – 12:00 noon: OpenRefine for Social Science Data
Description:
Participants will learn: OpenRefine (formerly Google Refine) is a powerful free and open source tool for working with messy data: cleaning it and transforming it from one format into another. This lesson will teach you to use OpenRefine to effectively clean and format data and automatically track any changes that you make. Many people comment that this tool saves them literally months of work trying to make these edits by hand.
Facilitators:
Dr. Kyle Huff – Associate Professor of Management
Dr. Luis Torres – Associate Professor of Marketing
…
Track 2: Data Management With SQL
Fri 04/16 from 10:00 a.m. – 12:00 noon: Data Management with SQL for Social Scientists Part 1
Description:
Participants will Learn: This is part one of a two part series. In this session, cover the following topics: What is a relational databases?, Using DB Browser for SQLite, The Select Statement, Missing data, Creating New Columns, and Aggregations.
Facilitators:
Dr. Anupam Nath – Assistant Professor of Management Information Systems and Decision Sciences
Dr. Kyle Huff – Associate Professor of Management
…
Fri 04/23 from 10:00 a.m. – 12:00 noon: Data Management with SQL for Social Scientists Part 2
Description:
Participants will Learn: This continues where Part 1 left off. Participation in this session does not require completion of part 1, but participants will need to be familiar with the topics covered in part 1 to get the most out of this session. Topics in this session include: Creating tables and views, The SQLite command line, Joins, and Using database tables in other environments.
Facilitators:
Dr. Anupam Nath – Assistant Professor of Management Information Systems and Decision Sciences
Dr. Nannette Napier – Associate Dean for School of Business, Professor of Management Information Systems and Decision Sciences