Schedule and Syllabus
Updated: November 16, 2015
Here is the updated syllabus (as of 11/3): MIS2502 Syllabus [Gong] – Fall 2015 v1103
Syllabus and schedule are subject to change.
Day | Topics | Course Materials | Assignments |
Week 1 |
|||
Aug 24 | Course Introduction and Syllabus
The Things You Can Do with Data |
PowerPoint: The Things You Can Do With Data | |
Aug 26 | The Information Architecture of an Organization | PowerPoint: Information Architecture | |
Aug 28 | Data Modeling
Gathering requirements |
PowerPoint: Relational Data Modeling | |
Week 2 |
|||
Aug 31 | In-class exercise: Identifying entities | ||
Sep 2 | More on ERDs: Relationships, cardinality |
PowerPoint: Relational Data Modeling | |
Sep 4 | In-class exercise: Creating an entity relationship diagram
(Last day to add or drop a full-term course) |
||
Week 3 |
|||
Sep 7 | Labor Day – No Class | ||
Sep 9 | From ERDs to Schemas: Normalization, primary/foreign keys, joins |
PowerPoint: Relational Data Modeling | |
Sep 11 | In-class exercise: Converting ERDs to schemas |
Week 4 |
|||
Sep 14 | Getting data out of the database: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE
Make sure you’ve reviewed the guide for setting up a connection in MySQL Workbench and reviewed the MySQL PowerPoint deck. |
PowerPoint: SQL 1 | Assignment 1 Due: ER Modeling |
Sep 16 | In-class exercise: Pen-and-paper SQL exercise | ||
Sep 18 | Getting data out of the database: Joining tables, SQL subselects, LIMIT | PowerPoint: SQL 1 | |
Week 5 |
|||
Sep 21 | In-class exercise: Working with SQL, part 1 | ||
Sep 23 | Creating and updating the database: SQL CREATE, DROP, and ALTER; SQL INSERT, UPDATE, and DELETE | PowerPoint: SQL 2 | |
Sep 25 | Papal Visit – No Class | ||
Week 6 |
|||
Sep 28 | In-class exercise: Working with SQL, part 2 | ||
Sep 30 | Principles of Data Visualization |
PowerPoint: Data Visualization | Assignment 2 Due: SQL #1 |
Oct 2 | Review for Exam 1 |
||
Week 7 |
|||
Oct 5 | In-class exercise: Data Visualization (We will not meet in class. Video recorded) | ||
Oct 7 | Exam 1 | Assignment 3 Due: SQL #2 | |
Oct 9 | Principles of Data Visualization | PowerPoint: Data Visualization | |
Week 8 |
|||
Oct 12 | Getting data into the analytical database: The Extract, Transform, Load process | PowerPoint: ETL | |
Oct 14 | Turning transaction data into analytical data: Overview of the Dimensional Model | PowerPoint: Dimensional Data Modeling | |
Oct 16 | The structure of the Dimensional Model: The Star Schema | PowerPoint: Dimensional Data Modeling | |
Week 9 |
|||
Oct 19 | Working with Dimensional Data: Pivot Tables in Excel In-class exercise: Pivot Tables in Excel(Oct. 20 is the Last day to withdraw from a full-term course) |
Assignment 4 Due: ETL in Excel | |
Oct 21 | Introduction to Advanced Analytics and R | PowerPoint: Advanced Analytics – Introduction | |
Oct 23 | In-class exercise: Descriptive Statistics Review | ||
Week 10 |
|||
Oct 26 | In-class exercise: Getting familiar with R and RStudio | Assignment 5 Due: Pivot Tables in Excel | |
Oct 28 | Review for Exam 2 | Assignment 6 (Group Project) Due: Data Visualization | |
Oct 30 | Exam 2 |
Week 11 |
|||
Nov 2 | In-class exercise: Getting familiar with R and RStudio (continued) | ||
Nov 4 | Analysis Scenario: Determining customer behavior based on a profile (decision trees) | PowerPoint: Classification using Decision Trees | |
Nov 6 | In-class exercise: Interpreting Decision Tree Output
In-class exercise: Decision trees in R |
||
Week 12 |
|||
Nov 9 | In-class exercise: Decision trees in R | PowerPoint: Clustering and Segmentation | Assignment 7 Due: Analytics #1 – Introduction to working with R |
Nov 11 | Analysis Scenario: Identifying similar customers (clustering and segmentation) | ||
Nov 13 | In-class exercise: Clustering and Segmentation in R | ||
Week 13 |
|||
Nov 16 | In-class exercise: Clustering and Segmentation in R (Continued) Analysis Scenario: What products are purchased together? (Association Rules) |
PowerPoint: Association Rule Mining | |
Nov 18 | Analysis Scenario: What products are purchased together? (Association Rules) (Continued)
In-class exercise: Computing Confidence, Support, and Lift |
PowerPoint: Association Rule Mining | Assignment 8 Due: Analytics #2 – Decision Trees in R |
Nov 20 | In-class exercise: Association Rule Mining in R | ||
Week 14 |
|||
Nov 23, 25, 27 | Fall Break &Thanksgiving Recess – No Class | ||
Week 15 |
|||
Nov 30 | In-class exercise: Association Rule Mining in R (Continued) | Assignment 9 Due: Analytics #3 – Clustering in R | |
Dec 2 | Advanced Analytics: Wrap up | ||
Dec 4 | Review for Final Exam | ||
Week 16 |
|||
Dec 8 | Assignment 10 Due: Analytics #4 – Association Rules in R | ||
Final Exam Wednesday, Dec 16 from 1:00 to 3:00 pm |