Data and Analytics

Department of Management Information Systems, Temple University

Data and Analytics

MIS 2502.003 ■ Fall 2025 ■ Shuhua Wu

Schedule

 

WEEK DATES TOPIC TASKS DUE MATERIALS
1 8/25

Course Introduction and Syllabus

The Things You Can Do with Data

  
  8/27

The Information Architecture of an Organization

Understanding Database Schemas: Normalization, primary/foreign keys, joins

  

 
  8/29 Understanding Database Schemas: Normalization, primary/foreign keys, joins  
2 9/01 Labor Day – No Class

 

 
  9/03 In-class exercise #01: Creating database schema
  9/05 Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE  
3 9/08 Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE

Assignment 1: Database schema
  9/10 In-class exercise #02: Pen and Paper exercise

 
  9/12

Getting data out of RDMS: Joining tables

In-class exercise #03: Working with SQL, part 1

 

  
4 9/15 In-class exercise #03: Working with SQL, part 1

 
  9/17

In-class exercise #04: Working with SQL, part 2

Assignment 2: SQL #1

 

 

  • ICA #4: Task
  9/19 In-class exercise #04: Working with SQL, part 2  
5 9/22 Review for Exam 1

Assignment 3: SQL #2

  • Slides
  9/24 Review for Exam 1  
  • Study Guide
  9/26 Exam 1  

 
6 9/29

Introduction to Python

In-class exercise #05: Getting familiar with Jupyter, Python Basic, Data types
  • Install Jupyter and Anaconda
  • ICA #5: Notebook
  10/01

Python Data Structures

In-class exercise #06: Python Lists and Dictionaries

  

 
  10/03

Python Data Structures

In-class exercise #06: Python Lists and Dictionaries

  

 
7 10/06

Semi-structured data

In-class exercise #07: Working with semi-structured data

Assignment 4:  Python Basics
  10/08

Python and JSON

In-class exercise #08: Working with JSON in Python

  
  • ICA #8: Task
  • Data: airbnb
  10/10

Python Pandas

In-class exercise #09: Working with Python Pandas

  
  • ICA #8: Submit on Canvas
  • ICA #9: Task
  • Data
8 10/13

Python Pandas

In-class exercise #09: Working with Python Pandas

Assignment 5: Python and JSON

 
  10/15

In-class exercise #10: More practice with Pandas

 

  10/17

Fall Wellness Day (no classes held)

  

 

 
9 10/20

Reconciling Data: The extract, transform, load process (ETL)

Principles of Data Visualization

Assignment 6: Pandas
  • PowerPoint: ETL
  • PowerPoint: Data Visualization
  10/22

Principles of Data Visualization

In-class exercise #11: Data Visualization

 
  10/24

Hypothesis Testing

In-class exercise #12: Hypothesis Testing and Visualization in Python

  
  • PowerPoint: Hypothesis Testing
  • ICA #12: Notebook, NBA, Sales
  • ICA #12: Submit on Canvas
10 10/27 Review for Exam 2  
  • Slides
  10/29 Review for Exam 2  
  • Study Guide
  • Exam review
  • Practice for exam
  • Data
  • Practice for exam-Key
  10/31 Exam 2  

 
11 11/03

Introduction to Advanced Analytics and Python

PRO points project

 

  
  • PowerPoint: Advanced Analytics – Introduction

  • PRO points project
  11/05

 

Classification using Decision Trees

 

  
  • PowerPoint: Classification using Decision Trees
  11/07 In-class exercise #13: Decision Trees in Python  
12 11/10 Analysis Scenario: Identifying similar customers (clustering and segmentation)

Assignment 7: Decision Trees
  • PowerPoint: Clustering and Segmentation
  11/12 In-class exercise #14: Clustering and Segmentation in Python  
  • ICA #14: Task, Notebook, Data
  11/14 In-class exercise #14: Clustering and Segmentation in Python  
13 11/17

Analysis Scenario: What products are purchased together? (Association Rules)

 

Assignment 8: Clustering

  • Task
  • Data
  • Answer Sheet to fill
  • Submit on Canvas
  • PowerPoint: Association Rule Mining
  11/19 In-class exercise #15: Computing Confidence, Support, and Lift  
  • ICA #15: Task
  • Submit on Canvas
  11/21 In-class exercise #16: Computing Confidence, Support, and Lift  
  • ICA #16: Task, Notebook, Data
  • Output [in case Python did not work]
  • ICA #16: Submit on Canvas
14 11/24

Thanksgiving holiday – no class

 

  
  11/26 Thanksgiving holiday – no class  

 
  11/28 Thanksgiving holiday – no class  

 
15 12/01 Review for Exam 3

Assignment 9: Association Rules

  • Task
  • RulesFile
  • Submit on Canvas
  • Exam Review Slides
  • Student Feedback Forms
  12/03 Review for Exam 3

 
  • Study Guide
  12/05 Final Exam

PRO points project (optional): Due on 12/08

  • Task
  • Submit on Canvas
  • Follow the instructions in the Task document to request points