In-class Activity Policy
- You should submit your own solutions to the in-class exercises on Canvas under assignments section, even though you work as groups in class;
- Submit your answers in a single Word or PDF document (work as professional people) and you are encouraged to use a similar format as we show in class;
- You are allowed to miss two in-class activities without penalty.
- The grade is “Success or Fail”. You will get a score of 1 if you succeed and 0 if you fail.
In-Class Activity #1: Identifying entities and attributes
(Instruction | Solution | Feedback)
In-Class Activity #2: ER modeling
(Instruction | Solution | Feedback)
ICA #3: Converting ERDs to schemas
(Instruction | Submission Template | Solution | Feedback)
In-Class Activity #4: Pen and paper query exercise
(Instruction | Solution | Feedback)
In-Class Activity #5: Working with SQL, part 1 (SQL Out)
(Instruction | Solution | Feedback)
In-Class Activity #6: Working with SQL, part 2 (SQL In)
(Instruction | Solution | Feedback)
In-Class Activity #7: ETL using Tableau Prep
(Instruction | Solution)
In-Class Activity #8: Working with semi-structured data
(Instruction | Solution)
In-Class Activity #9: Descriptive statistics review
(Instruction | Dataset | Solution | Feedback)
In-Class Activity #10: Getting familiar with R/RStudio
(Instruction | R Script | Dataset | Solution)
In-Class Activity #11: ICA 9 & 10 Review
(No Submission Required)
In-Class Activity #12: Decision trees in R
(Instruction | R Script | Dataset | Solution | Feedback)
In-Class Activity #13: Clustering in R
(Instruction | R Script | Dataset | Solution | Feedback)
In-Class Activity #14: Computing confidence, support, and lift
(Instruction | Solution | No Submission Required)
In-Class Activity #15: Association rule mining in R
(Instruction | R Script | Dataset | Solution)
In-Class Activity #16: Data Visualization
(Instruction | Dataset)