Schedule Class Time & Room: Tuesdays and Thursdays, 9:30 AM – 10:50 AM, Alter 033 Class ID: MIS 2502, Section 004, CRN 27940 WEEK DATES TOPIC IN-CLASS ACTIVITY DUE 1 1/15 Introduction and information architecture Complete a required short pre-class survey by Jan. 14th. 1 1/17 Relational data modeling (1/3) – ERD: Requirements gathering, entity, and attribute ICA 1: Identifying entities and attributes 2 1/22 Relational data modeling (2/3) – ERD: Relationships and cardinality ICA 2: Creating an ERD 2 1/24 Relational data modeling (3/3) -Implementing the ERD: ERD to Database schema ICA 3: Converting ERDs to schemas 3 1/29 Getting data out of the database (1/2) – DML: SQL SELECT, DISTINCT, MIN, MAX, COUNT, and WHERE ICA 4: Pen-and-paper SQL exercise 3 1/31 Getting data out of the database (2/2) – DML: Joins, SQL subselects, and LIMIT Assignment 1: ER Modeling 4 2/5 MySQL and MySQL Workbench ICA 5: Working with SQL, part 1 4 2/7 Putting data into a database – DDL: CREATE, DROP, and ALTER INSERT, UPDATE, and DELETE 5 2/12 (IN-CLASS ACTIVITY) ICA 6: Working with SQL, part 2 5 2/14 Review for Exam 1: Study Guide and SQL Problem Set Assignment 2: SQL #1 6 2/19 EXAM 1 6 2/21 Reconciling Data: The Extract, Transform, Load(ETL) process 7 2/26 (IN-CLASS ACTIVITY) ICA 7: ETL using Tableau Prep Assignment 3: SQL #2 7 2/28 Semi-structured data analytics 8 3/5 3/7 SPRING BREAK 9 3/12 (IN-CLASS ACTIVITY) ICA 8: Working with semi-structured data Assignment 4: ETL using Tableau Prep 9 3/14 Advanced analytics using R (Statistics Review) (Demo codes) ICA 9: Descriptive statistics review 10 3/19 (IN-CLASS ACTIVITY) ICA 10: Getting familiar with R and RStudio 10 3/21 Review for Exam 2: Study Guide and SQL Problem Set 11 3/26 EXAM 2 11 3/28 Data mining (1/3) – Classification using decision trees ICA 11: ICA 9 & 10 Review (No submission) 12 4/2 (IN-CLASS ACTIVITY) ICA 12: Decision trees in R Assignment 5: Introduction to R 12 4/4 Data mining (2/3) – Cluster Analysis 13 4/9 (IN-CLASS ACTIVITY) ICA 13: Clustering in R Assignment 6: Decision Trees in R 13 4/11 Data mining (3/3) – Association rule learning ICA 14: Computing confidence, support, and lift (No submission) 14 4/16 (IN-CLASS ACTIVITY) ICA 15: Association rule mining in R Assignment 7: Clustering in R 14 4/18 Principles of Data Visualization 15 4/23 (IN-CLASS ACTIVITY) ICA 16: Data Visualization Assignment 8: Association Rules in R 15 4/25 Review for Exam 3: Study Guide Extra Credit Assignment and PRO Achievement Points! (Due by 11:59 PM) 16 5/2 EXAM 3 (8:00 to 10:00 am According to Temple Exam Schedule)