• Log In
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Data and Analytics

Department of Management Information Systems, Temple University

Data and Analytics

MIS 2502.003 ■ Spring 2022 ■ Youngjin Kwon
  • Schedule
  • Announcement
  • Syllabus

Schedule

  • Assignment due dates are subject to change.
  • The deadlines of Assignment #6 and #7 have been put off. 
  • See the second table below in this page to check previous schedule and files uploaded
DATES TOPIC COURSE MATERIALS Assignment

Week 11

Mar 25

In-class exercise #09: Getting familiar with Python and Anaconda Part 1

ICA#9

How to load csv file.pptx

 

Week 12

Mar 28

In-class exercise #09: Getting familiar with Python and Anaconda Part 1

In-class exercise #10: Descriptive Statistics Using Python and Anaconda

ICA#10  

Week 12

Mar 30

In-class exercise #10: Descriptive Statistics Using Python and Anaconda

Classification using Decision Trees

13 Decision Trees

#Due (11:59 PM)

Download Optional Assignment – Short Essay

How to earn PRO points

Download Optional Assignment MongoDB

Week 12

Apr 1

In-class exercise #11: Decision Trees in Python ICA11  

Week 13

Apr 4

Analysis scenario: Identifying similar customers (clustering and segmentation)

14 Clustering

 

Week 13

Apr 6

In-class exercise #12: Clustering and Segmentation in Python

ICA12

 

Week 13

Apr 8

Analysis scenario: What products are purchased together (association rules)

 

15 Association Rule Mining

#6 Due (4/10 8PM): Download Assignment#6

Week 14

Apr 11

Analysis scenario: What products are purchased together (association rules)

   

Week 14

Apr 13

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

In-class exercise #14: Association Rule Mining in Python

ICA #13

ICA #14

 

Week 14

Apr 15

In-class exercise #14: Association Rule Mining in Python

 

#7 Due (11:59PM; no late submission): 

Download Assignment #7

Week 15

Apr 18

In-class exercise #10: Descriptive Statistics Using Python and Anaconda

Review for MySQL

   

Week 15

Apr 20

Review for MySQL

Review for Exam 3

Exam 3 Study Guide

Review-for-Exam-3

#8 Due (11:59PM; no late submission): 

Download Assignment #08

Week 15

Apr 22

Exam 3    

 

  • Previous schedule before Exam 2
DATES TOPIC COURSE MATERIALS Assignment

Week 1

Jan 10

Course Introduction and Syllabus

The Things You Can Do about Data

00 Course Introduction

01 Things You Can Do With Data

 

Week 1

Jan 12

The Information Architecture of An Organization

Understanding Database Schema: Normalization, Primary/Foreign Keys, Joins

02 Information Architecture

03 Relational Data Modeling

Please complete this survey (Link)

Week 1

Jan 14

Understanding Database Schema: Normalization, Primary/Foreign Keys, Joins

 

Set Up Vertabelo 

Week 1

Jan 17

No class (Dr. Martin Luther King, Jr. Day)

 

 

Week 2

Jan 19

In-class exercise #01: Creating database schema

ICA #1 Database Schema

Schema Template

 

Week 2

Jan 21

In-class exercise #01: Creating database schema

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.

04 SQL Out 1- Basic

Set up MySQL Workbench

Submit ICA#1 By the end of the class

Week 3

Jan 24

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

ICA #2 Pen and Paper Query Exercise

 

Week 3

Jan 26

In-class exercise #02: Pen and Paper Query  

#1 Due (8PM):

Database Schemas

Week 3

Jan 28

Getting data out of RDMS: joining tables

05 SQL Out 2 – Advanced

 

Week 4

Jan 31

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

ICA #3 – SQL Part 1

Practice – joining tables

 

Week 4

Feb 2

Getting data out of RDMS: Subselects “05 SQL Out 2 – Advanced ” downloadable above will be covered  

Week 4

Feb 4

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

ICA #4 – SQL Part 2

#2 Due (8PM):

Download Assignment # 2

Week 5

Feb 7

Review of ICA 4 and Assignment 2

 

 

Week 5

Feb 9

Semi-structured Data

Advanced_LEFTJOIN

06 Semi-Structured Data

 

Week 5

Feb 11

Review for Exam 1

Review for Exam 1

Install MongoDB – Mac

Install MongoDB – Windows

 

#3 Due (8PM):

Download Assignment #3

Optional_MySQL

Week 6

Feb 14

Discussion of Assignment 3

Review for Exam 1

Exam 1 Study Guide  

Week 6

Feb 16

Exam 1

 

 

Week 6

Feb 18

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

ICA #5 – Semi-Structured Data  

Week 7

Feb 21

Getting data out of NoSQL: PROJECT, MATCH, SORT, LIMIT and GROUP

07 NoSQL 1 – Basic   

Week 7

Feb 23

In-class exercise #06: Working with NoSQL, part 1

ICA #6 – NoSQL Part 1  

Week 7

Feb 25

In-class exercise #06: Working with NoSQL, part 1

Getting data out of NoSQL: How to query nested document and array, JOIN

08 NoSQL 2 – Advanced

ICA #7 – NoSQL Part 2

 

Week 8

(Feb 28, Mar 2, Mar 4)

No class (Spring Break)    

Week 9

Mar 7

Getting data out of NoSQL: How to query nested document and array, JOIN

In-class exercise #07: Working with NoSQL, part 2

 

#4 Due (8PM): 

Download #4 – NoSQL

Week 9

Mar 9

In-class exercise #07: Working with NoSQL, part 2

 

 

Week 9

Mar 11

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

09 ETL

 

Week 10

Mar 14

Principles of Data Visualization

In-class exercise #08: Data Visualization

10 Data Visualization

ICA #8 – Excel

ICA #8 – Description

ICA #8 – Answer Template

 

Week 10

Mar 16

In-class exercise #08: Data Visualization

Introduction to Advanced Analytics and Python

11 Advanced Analytics and Python

Install Python and Anaconda

Quick Guide to Jupyter Notebook Python and Anaconda

#5 Due (8PM):

Download Assignment #5 – NoSQL Part 2

Week 10

Mar 18

 

Introduction to Advanced Analytics and Python

2009BaseballTeamStats.csv

 

Week 11

Mar 21

Review for Exam 2

Exam 2 Study Guide

Review-for-Exam-2

 

Week 11

Mar 23

Exam 2    

 

Primary Sidebar

Class Location
~ Jan 21 : Online Class (Zoom Link)
Jan 22 ~ : Class at Alter Hall 035
Instructor
Name: Youngjin Kwon
Email: youngjin.kwon@temple.edu
Please use 2502 as the subject line
Office Hours: 4-5PM Mon/Wed or email me.
Online Location: Zoom Meeting
Campus Location: Speakman Hall 208F
ITA
Name: Rahman Mohammed
Email: rahman.mohammed@temple.edu
Office Hours: 11AM-12PM Mondays
Location: Zoom Meeting
Campus Location: TBD

Copyright © 2025 · Department of Management Information Systems · Fox School of Business · Temple University