In-Class Activities

In-class Activities Policy 

• You should submit your own solutions to the in-class exercises, even though you work as groups in class;
• You are allowed to miss two in-class activities without penalty.
• The grade will be evaluated based on completeness and correctness and as “success or fail”. You will get a score of 1 if you succeed and 0 if you fail.

# 11 In-class Activities: Data Visualization [Due by 11:59 pm on 3/18]

• In-Class Exercise #11 – Data Visualization Principles
• In-Class Exercise #11 – Food-Emporium Dashboard.xlsx

# 10 In-class Activities: Working with Pandas in Python [Due by 11:59 pm on 3/13]

• In-Class Exercise #10 – Pandas in Python
• In-Class Exercise #10 – NYC_Restaurant_Inspection.csv
• In-Class Exercise #10 – NBA14Salaries.csv

# 8/9 In-class Activities: Working with JSON in Python [Due by 11:59 pm on 2/27]

• In-Class Exercise #8 – JSON in Python
• In-Class Exercise #8 – airbnb.json

# 7 In-class Activities: Python Data Structures [Due by 11:59 pm on 2/25]

• In-Class Exercise #7 – Python Data Structures

# 6 In-class Activities: Python Basics Data Types [Due by 11:59 pm on 2/20]

• In-Class Exercise #6 – Python Basics and Data Types

# 5 In-class Activities: Semi-structured Data [Due by 11:59 pm on 2/18]

• In-Class Exercise #5 – Working with Semi-Structured Data

# 4 In-class Activities: SQL Part 2 [Due by 11:59 pm on 2/6]

• In-Class Exercise #4 – SQL Part 2

# 3 In-class Activities: SQL Part 1 [Due by 11:59 pm on 1/30]

• In-Class Exercise #3 – SQL Part 1

# 2 In-class Activities: SQL Pen and Paper [Due by 11:59 pm on 1/28]

• In-Class Exercise #2 – Pen and Paper Query Exercise

# 1 In-class Activities: Creating Schemas [Due by 11:59 pm on 1/21]

• In-Class Exercise #1 – Creating Schemas
• Schema template