Data and Analytics

Department of Management Information Systems, Temple University

Data and Analytics

MIS 2502.004 ■ Spring 2026 ■ Austin Culmer-Smith

Schedule

Wk Dates Topics | ICA’s Course Materials Assignments
1 01/13
  • Course Introduction and Syllabus
  • The Things You Can Do with Data
  • The Information Architecture of an Organization

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

 
2 01/20

In-class exercise #01: Creating database schema 
   ♦ ICA#1: Task
 

 
  01/22 Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE

 
3 01/27

In-class exercise #01: Creating database schema 
  ♦ Submit ICA #1 on Canvas

 

Assignment 1 Due: Database schema

 
  01/29

Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE

In-class exercise #02: Pen and Paper exercise
  ♦ ICA #2: Task
  ♦ Submit ICA #2 on Canvas

 
4 02/03

Getting data out of RDMS: Joining tables
  ♦ ICA #3: Task

In-class exercise #03: Working with SQL, part 1
 ♦ Submit ICA #3 on Canvas

 

Assignment 2 Due: SQL #1
  02/05

In-class exercise #04: Working with SQL, part 2
 ♦ ICA #4: Task
 ♦ Submit ICA #4 on Canvas

 

 
5 02/10

 
  • Review for Exam #1

Assignment 3 Due: SQL #2
  02/12

 
  • Exam #1
  
6 02/17

Introduction to Python

In-class exercise #05: Getting familiar with Jupyter, Python Basic, Data types

  
  02/19

Python Data Structures

In-class exercise #06: Python Lists and Dictionaries

    
7 02/24

Semi-structured data

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

 

Assignment 4:  Python Basics
  02/26

Python and JSON

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

    
8

3/1 – 3/7

Spring Break – No Class

 

  
9

03/10

Python Pandas

In-class exercise #09: Working with Python Pandas

 

Assignment 5: Python and JSON
  03/12

In-class exercise #10: More practice with Pandas

    
10 03/17

Principles of Data Visualization

In-class exercise #11: Data Visualization

 

Assignment 6: Pandas
  03/19

Hypothesis Testing

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

    
11 03/24 Review for Exam 2    
  03/26 Exam 2    
12 03/31

Introduction to Advanced Analytics and Python

Classification using Decision Trees

    
  04/02 In-class exercise #13: Decision Trees in Python    
13 04/07 Analysis Scenario: Identifying similar customers (clustering and segmentation)

 

Assignment 7: Decision Trees
  04/09 In-class exercise #14: Clustering and Segmentation in Python    
14 04/14

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

In-class exercise #15: Computing Confidence, Support, and Lift

 

Assignment 8: Clustering
  04/16 In-class exercise #16: Computing Confidence, Support, and Lift    
15 04/21 Review for Exam 3

 

Assignment 9: Association Rules

 

 

 04/23 Final Exam

PRO points project (optional): Due