In-class Activities

# 0 In-class Activities Policy 

• You should submit your own solutions to the in-class exercises, even though you work as groups in class;
• Submit your answers in a single Word document and you are encouraged to use a similar format as we show in class;
• The due date is the starting time of the next class. For instance, we had the in-class exercises on Wednesday , the due date for this exercise solutions is 9:00am Friday.
• The system will shutdown on 9:00am sharp. No late in-class exercises are accepted.
• You are allowed to miss two in-class activities without penalty.
• The grade is “success or fail”. You will get score of 1 if you succeed and 0 if you fail.
• Answers to the exercises will be posted on the course website right after you submit yours.

# 1 In-class Activities: Identifying Entities

• In-Class Exercise #1 – Identifying Entities
• In-Class Exercise #1 – Identifying Entities [KEY]

# 2 In-class Activities: ER Modeling 

• In-Class Exercise #2 – ER Modeling
• In-Class Exercise #2 – ER Modeling [KEY]

# 3 In-class Activities: Creating Schemas  

• In-Class Exercise #3 – Creating Schemas
• In-Class Exercise #3 – Supporting Document: Schemas Templates
• In-Class Exercise #3 – Creating Schemas [KEY]

# 4 In-class Activities: SQL Pen and Paper 

• In-Class Exercise #4 – Pen and Paper Query Exercise
• In-Class Exercise #4 – Pen and Paper Query Exercise [KEY]

# 5 In-class Activities: SQL Out with Workbench

• In-Class Exercise #5 – SQL Out  with Workbench
• In-Class Exercise #5 – SQL Out with Workbench  [KEY]

# 6 In-class Activities: SQL In with Workbench

• In-Class Exercise #6 – Putting data into Database with SQL
• In-Class Exercise #6 – Putting data into Database with SQL [KEY]

# 7 In-class Activities: Data Visualization 

• In-Class Exercise #7 – Data Visualization Principles
• In-Class Exercise #7 – Food-Emporium_Dashboard
• In-Class Exercise #7 – Data Visualization Principles [KEY]

# 8 In-class Activities: Pivot Tables

• In-Class Exercise #8 – Pivot Tables.pdf
• In-Class Exercise #8 – Salesperson Cube – for class.xlsx
• In-Class Exercise #8 – Pivot Tables [Key] 

# 9 In-class Activities: Descriptive Statistics

• In-Class Exercise #9 – Descriptive Statistics Review
• In-Class Exercise #9 – Descriptive Statistics Review [Key]

# 10 In-class Activities: Getting Started with R & R-studio

• In-Class Exercise #10.1- Getting Started with R&RStudio (no need to submit)
• TestScript.r
• USBalanceOfTrade.csv
• In-Class Exercise #10.2 –  Descriptive Statistics Using R&RStudio
• In-Class Exercise #10.2 –  Descriptive Statistics Using R&RStudio [key]
• Descriptives.r
• NBA14Salaries.csv

# 11 In-class Activities:  Decision Trees in R

• In-Class Exercise #11 – Decision Trees in R.docx
• OrganicsPurchase.csv
• dTree.r
• In-Class Exercise #11 – Decision Trees in R [key]

# 12 In-class Activities:  Clustering in R

• In-Class Exercise #12 – Clustering Using R.doxc
• Census2000.csv
• Clustering.r
• In-Class Exercise #12 – Clustering Using R [Key]

# 13 In-class Activities:  Association Rule Miling in R

• In-Class Exercise #13.1 – Computing Confidence, Support, and Lift
• In-Class Exercise #13.2- Association Rules Using R
• Bank.csv
• aRules.r
• In-Class Exercise #13.1 – Computing Confidence, Support, and Lift [Key]
• In-Class Exercise #13.2- Association Rules Using R [Key]