instructor: Aaron Zhi Cheng, Section 003


Click the link to each assignment to view the instruction.

Submit your solutions as a Word or PDF file through Canvas> Assignments > To-Do Submissions.

# Assignment Due Date 
1 ER Modeling

A Checklist for Drawing ERD

September 17
2 SQL #1 – Getting Data out of the Database [Answer Sheet] September 28

(before class)

Bonus Creating Schemas [Optional] October 1
3 SQL #2 – Putting Data into the Database October 10
4 ETL and Pivot Tables in Excel

Data: ETL Workbook

October 17
5 Introduction to working with R

Data and R Code

November 7
6 Decision Trees

[Instructions / Data and R Code /Answer Sheet]

November 15
7 Clustering

[Instructions / Data and R Code /Answer Sheet]

November 27
8 Association Rules

[Instructions / Data and R Code /Answer Sheet]

Changed to

December 4