|
USCOTS Workshop
Teaching Data Science
May 27-28, 2015
State College, PA
|
|
The Teaching Data
Science workshop is intended for instructors in statistics, mathematics, or
computer science who have an interest in incorporating data science type
curriculum into their existing courses. Participants who complete this
one-day workshop will
·
Learn
basic data science methods to complete common tasks conducted by
practitioners
·
Work
through several classroom ready handouts that have been used in teaching
data science at Winona State University, and critique and discuss the
incorporation of the workshop handouts into your existing course.
|
|
|
Handouts
|
Content
|
#1
|
Download
[PDF]
|
Method:
Association Rules
Data Technologies: Filters, Tables, and Functions in Excel
Data: Excel | CSV | Source
|
#2
|
Download
[PDF]
|
Method:
String Management in Excel
Data Technologies: String Functions and PivotTables in Excel
Source: Excel | CSV | Source
|
#3
|
Download
[PDF]
|
Method:
Summaries and Visualization in Excel
Data Technologies: Merge Basics, Advanced Functions, and Slicing
Source: Data | Dictionary | FIPS | Excel | Web
|
#4
|
Download
[PDF]
|
Method: Append and Merge Tables
Data Technologies: Offset, VLookup, Match, and
Index functions in Excel
Source: Excel Subset | TXT Data | TXT Stations | Excel Version | Web Data | Web Stations | Source
|
#5
|
Download
[PDF]
|
Method: R
Basics
Data Technologies: Reading in Data,
Summaries, and Visualizations in R
Source: CSV
|
#6
|
Download
[PDF]
|
Method:
Some Advanced Methods in R
Data Technologies: Loops, Wrapping Functions, and the by() function in R
Source: CSV
|
#7
|
Download
[PDF]
|
Method:
Scraping Data from Website in R
Data Technologies: XML Package, String
Functions, and Writing Functions in R
Source: Data
Wiki Link | Data Local Copy
|
|
Putting these Concepts
into Practice
|
Task
Choices
·
AUDIO
Task Descriptions: Link | PDF
Data: CSV | Excel
·
King County Food Inspection
Tasks: 1) Which Violation Descriptions are most common? 2) Do locations whose name contains “Bar”
have higher inspection scores that other locations? 3) How often are food inspections done on a
Sunday?
Data: Website
| Inspection Form
|
Workshop Evaluation: Link
|
Authors: Christopher J.
Malone, Silas Bergen
Winona State University
© 2015
|
|