- Assignment due dates are subject to change.
- The deadlines of Assignment #6 and #7 have been put off.
- See the second table below in this page to check previous schedule and files uploaded
| DATES | TOPIC | COURSE MATERIALS | Assignment |
|---|---|---|---|
|
Week 11 Mar 25 |
In-class exercise #09: Getting familiar with Python and Anaconda Part 1 | ||
|
Week 12 Mar 28 |
In-class exercise #09: Getting familiar with Python and Anaconda Part 1 In-class exercise #10: Descriptive Statistics Using Python and Anaconda |
ICA#10 | |
|
Week 12 Mar 30 |
In-class exercise #10: Descriptive Statistics Using Python and Anaconda Classification using Decision Trees |
13 Decision Trees |
#Due (11:59 PM) |
|
Week 12 Apr 1 |
In-class exercise #11: Decision Trees in Python | ICA11 | |
|
Week 13 Apr 4 |
Analysis scenario: Identifying similar customers (clustering and segmentation) |
||
|
Week 13 Apr 6 |
In-class exercise #12: Clustering and Segmentation in Python |
||
|
Week 13 Apr 8 |
Analysis scenario: What products are purchased together (association rules) |
|
#6 Due (4/10 8PM): Download Assignment#6 |
|
Week 14 Apr 11 |
Analysis scenario: What products are purchased together (association rules) |
||
|
Week 14 Apr 13 |
In-class exercise #13: Computing Confidence, Support, and Lift In-class exercise #14: Association Rule Mining in Python |
||
|
Week 14 Apr 15 |
In-class exercise #14: Association Rule Mining in Python |
#7 Due (11:59PM; no late submission): |
|
|
Week 15 Apr 18 |
In-class exercise #10: Descriptive Statistics Using Python and Anaconda Review for MySQL |
||
|
Week 15 Apr 20 |
Review for MySQL Review for Exam 3 |
#8 Due (11:59PM; no late submission): |
|
|
Week 15 Apr 22 |
Exam 3 |
- Previous schedule before Exam 2
| DATES | TOPIC | COURSE MATERIALS | Assignment |
|---|---|---|---|
|
Week 1 Jan 10 |
Course Introduction and Syllabus The Things You Can Do about Data |
||
|
Week 1 Jan 12 |
The Information Architecture of An Organization Understanding Database Schema: Normalization, Primary/Foreign Keys, Joins |
Please complete this survey (Link) | |
|
Week 1 Jan 14 |
Understanding Database Schema: Normalization, Primary/Foreign Keys, Joins |
|
Set Up Vertabelo |
|
Week 1 Jan 17 |
No class (Dr. Martin Luther King, Jr. Day) |
|
|
|
Week 2 Jan 19 |
In-class exercise #01: Creating database schema | ||
|
Week 2 Jan 21 |
In-class exercise #01: Creating database schema Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE Make sure you’ve reviewed the guide for setting up a connection in MySQL Workbench. |
Submit ICA#1 By the end of the class |
|
|
Week 3 Jan 24 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE | ||
|
Week 3 Jan 26 |
In-class exercise #02: Pen and Paper Query |
#1 Due (8PM): |
|
|
Week 3 Jan 28 |
Getting data out of RDMS: joining tables | ||
|
Week 4 Jan 31 |
In-class exercise #03 Working with SQL, part 1 | ||
|
Week 4 Feb 2 |
Getting data out of RDMS: Subselects | “05 SQL Out 2 – Advanced ” downloadable above will be covered | |
|
Week 4 Feb 4 |
In-class exercise #04: Working with SQL, part 2 |
#2 Due (8PM): |
|
|
Week 5 Feb 7 |
Review of ICA 4 and Assignment 2 |
|
|
|
Week 5 Feb 9 |
Semi-structured Data |
||
|
Week 5 Feb 11 |
Review for Exam 1 |
|
#3 Due (8PM): |
|
Week 6 Feb 14 |
Discussion of Assignment 3 Review for Exam 1 |
Exam 1 Study Guide | |
|
Week 6 Feb 16 |
Exam 1 |
|
|
|
Week 6 Feb 18 |
In-class exercise #05: Working with semi-structured data |
ICA #5 – Semi-Structured Data | |
|
Week 7 Feb 21 |
Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
07 NoSQL 1 – Basic | |
|
Week 7 Feb 23 |
In-class exercise #06: Working with NoSQL, part 1 |
ICA #6 – NoSQL Part 1 | |
|
Week 7 Feb 25 |
In-class exercise #06: Working with NoSQL, part 1 Getting data out of NoSQL: How to query nested document and array, JOIN |
||
|
Week 8 (Feb 28, Mar 2, Mar 4) |
No class (Spring Break) | ||
|
Week 9 Mar 7 |
Getting data out of NoSQL: How to query nested document and array, JOIN In-class exercise #07: Working with NoSQL, part 2 |
#4 Due (8PM): |
|
|
Week 9 Mar 9 |
In-class exercise #07: Working with NoSQL, part 2 |
|
|
|
Week 9 Mar 11 |
Reconciling Data: The extract, transform, load process (ETL) |
||
|
Week 10 Mar 14 |
Principles of Data Visualization In-class exercise #08: Data Visualization |
||
|
Week 10 Mar 16 |
In-class exercise #08: Data Visualization Introduction to Advanced Analytics and Python |
11 Advanced Analytics and Python Install Python and Anaconda |
#5 Due (8PM): |
|
Week 10 Mar 18 |
Introduction to Advanced Analytics and Python |
||
|
Week 11 Mar 21 |
Review for Exam 2 |
||
|
Week 11 Mar 23 |
Exam 2 |