Review for Final Exam Final Exam Study GuideClass Meeting Link Zoom: https://temple.zoom.us/j/97791381885
Class link Canvas: https://templeu.instructure.com/courses/91657
| DATES | TOPIC | COURSE MATERIALS | DUE |
|---|---|---|---|
|
Week 1 Jan 20 |
Course Introduction and Syllabus The Things You Can Do about Data |
Powerpoint: |
|
|
Week 1 Jan 22 |
The Information Architecture of An Organization Understanding Database Schema: Normalization, Primary/Foreign Keys, Joins |
Powerpoint: 02 Information Architecture of an Organization
|
|
|
Week 2 Jan 25 |
Understanding Database Schema: Normalization, Primary/Foreign Keys, Joins |
PowerPoint: |
|
|
Week 2 Jan 27 |
In-class exercise #01: Creating database schema |
Supplements: |
|
|
Week 2 Jan 29 |
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. |
Powerpoint: Supplement: Quick Guide to MySQL Workbench (Mac Instructions start on page 3) |
|
|
Week 3 Feb 1 |
Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE |
|
|
|
Week 3 Feb 3 |
In-class exercise #02: Pen and Paper Query | ICA 2 Solution |
Assignment 1 Due Tuesday Feb 2 11:59 PM. The documents are in Canvas Assignment 1 Solution |
|
Week 3 Feb 5 |
Getting data out of RDMS: joining tables |
Powerpoint: |
|
|
Week 4 Feb 8 |
In-class exercise #03 Working with SQL, part 1 |
ICA 3 Solution |
|
|
Week 4 Feb 10 |
Getting data out of RDMS: Subselects | ||
|
Week 4 Feb 12 |
In-class exercise #04: Working with SQL, part 2 |
Assignment 2 Corrected Solution |
Assignment 2 Due Thursday Feb 11 11:59 PM: SQL 1 |
|
Week 5 Feb 15 |
Semi-structured Data |
Powerpoint: (By Hyeonsik Shin) |
|
|
Week 5 Feb 17 |
Discussion of ICA 4 Work on assignment 3
|
ICA 4 Solution |
|
|
Week 5 Feb 19 |
Review for Exam 1 In-class exercise #05: Working with semi-structured data |
Exam 1 Study Guide Powerpoint: Review for Exam 1 |
|
|
Week 6 Feb 22 |
In-class exercise #05: Working with semi-structured data |
Assignment 3 solution ICA 5 Solution |
Assignment 3 Due Sunday Feb 21 11:59 PM: SQL #2 |
|
Week 6 Feb 24 |
Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
Powerpoint: Quick Guide to MongoDB Compass Apple_s21 Quick Guide to MongoDB Compass Windows_s21
|
|
|
Week 6 Feb 26 |
You can take Exam 1 today or on March 1. Pick one date and attend the regular class on the other date. Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
TEST EXAM SOLUTION | Exam 1 |
|
Week 7 Mar 1 |
You can take Exam 1 today or on February 26. Pick one date and attend the regular class on the other date. Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP |
Exam 1 | |
|
Week 7 Mar 3 |
In-class exercise #06: Working with NoSQL, part 1 |
ICA 6 Solution | |
|
Week 7 Mar 5 |
|||
|
Week 8 Mar 8 |
Getting data out of NoSQL: How to query nested document and array, JOIN |
Powerpoint: |
|
|
Week 8 Mar 10 |
In-class exercise #07: Working with NoSQL, part 2 | ICA 7 Solution | |
|
Week 8 Mar 12 |
Reconciling Data: The extract, transform, load process (ETL) |
Assignment 4 solution PowerPoint: 09 ETL (By Hyeonsik Shin) |
Assignment 4 Due Thursday Mar 11 11:59 PM: NoSQL #1 |
|
Week 9 Mar 15 |
Work on ICA 7 and Assignment 5 |
|
|
|
Week 9 Mar 17 |
Work on Assignment 5 |
|
|
|
Week 9 Mar 19 |
Principles of Data Visualization In-class exercise #08: Data Visualization |
ICA #8 – Data Visualization Principles Assignment 5 Solution ICA 8 Solution |
Assignment 5 Due Thursday Mar 18 11:59 PM: NoSQL#2 |
|
Week 10 Mar 22 |
Introduction to Advanced Analytics and R
|
Please install R and RStudio before today’s class. See the installation guide Quick guide to using R and RStudio Powerpoint: |
|
|
Week 10 Mar 24 |
Welness Day, No Class Meeting |
Welness Day, No Class Meeting |
|
|
Week 10 Mar 26 |
Review for Exam 2 |
Powerpoint: Review for Exam 2 Study Guide: Exam 2 Study Guide Practice Exam 2 Questions Solution |
|
|
Week 11 Mar 29 |
|||
|
Week 11 Mar 31 |
Exam 2 |
|
Exam 2 |
|
Week 11 Apr 2 |
In-class exercise #10: Descriptive Statistics Using R and RStudio | ICA 10 solution | |
|
Week 12 Apr 5 |
Classification using Decision Trees |
Powerpoint: |
|
|
Week 12 Apr 7 |
In-class exercise #11: Decision Trees in R and RStudio | ICA 11 Solution | |
|
Week 12 Apr 9 |
|
|
|
|
Week 13 Apr 12 |
Clustering and Segmentation |
Powerpoint: Assignment 6 solution |
Assignment 6 Due Sunday Apr 11 11:59 PM: Decision Trees Optional Extra Credit Assignment Due Sunday Apr 11 11:59 PM |
|
Week 13 Apr 14 |
In-class exercise #12: Clustering and Segmentation in R |
ICA 12 solution |
|
|
Week 13 Apr 16 |
Association Rules |
Powerpoint: |
|
|
Week 14 Apr 19 |
In-class exercise #13: Computing Confidence, Support, and Lift |
Assignment 7 Answer Sheet solution Assignment 7 R file solution ICA 13 solution |
Assignment 7 Due Sunday Apr 18 11:59 PM: Clustering |
|
Week 14 Apr 21 |
In-class exercise #14: Association Rule Mining in R |
ICA 14 solution |
|
|
Week 14 Apr 23 |
Review for Final Exam | Assignment 8 solution
Practice Exam solution |
Assignment 8 Due Thursday Apr 22 11:59 PM: Association Rules |
|
Week 15 Apr 26 |
Review for Final Exam | ||
|
Monday May 3 |
Exam 3 at 1 PM | Exam 3 |