Assignments
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 |