In-Class Exercises

In-Class Exercise 14—Due by 16:50, December 3

ICA #10.2- Association Rules Using R

Bank

To download the aRules.r code (https://www.dropbox.com/s/tj6htc4cexlaav2/aRules.r?dl=0)

 

In-Class Exercise 13—Due by 16:50, November 30

ICA #10.1 – Computing Confidence, Support, and Lift

 

In-Class Exercise 12—Due by 16:50, November 16

ICA #9 – Clustering Using R

Census2000

Download the Clustering.r (https://www.dropbox.com/s/mkwhxhtxqqzj05a/Clustering.R?dl=0)

 

In-Class Exercise 11—Due by Midnight, November 9

ICA #8 – Decision Trees in R

OrganicsPurchase

dTree.r file (https://www.dropbox.com/s/qu8xmulkiotxrud/dTree.r?dl=0)

 

In-Class Exercise 10—Due by 16:50, October 29

ICA #7 – Descriptive Statistics Using R&RStudio

NBA14Salaries

Download Descriptive.r (https://www.dropbox.com/s/u0aa6qc563sg1qg/Descriptives.r?dl=0)

 

In-Class Exercise 9—Due by 16:50, October 17

ICA #5 – Pivot Tables

Salesperson Cube

 

In-Class Exercise 8—Due by 16:50, October 12

ICA #4 – ETL – excel basics

 

In-Class Exercise 7—Due by 16:50, October 3

ICA #6.1 – Data Visualization Principles

Food-Emporium_Dashboard

 

In-Class Exercise 6—Due by 16:50, September 28

ICA #3 – SQL Part 2

 

In-Class Exercise 5—Due by 16:50, September 24

ICA #2.2 – SQL Part 1

 

In-Class Exercise 4—Due by 16:50, September 19

ICA #2.1 – Pen and Paper Query Exercise

 

In-Class Exercise 3—Due by 16:50, September 14

ICA #1.3 – Converting ERDs to schemas

 

In-Class Exercise 2—Due by 16:50, September 10

ICA #1.2 – ER Modeling

 

In-Class Exercise 1—Due by 16:50, September 5

ICA #1.1 – Identifying Entities