{"id":22,"date":"2018-01-17T14:36:08","date_gmt":"2018-01-17T19:36:08","guid":{"rendered":"http:\/\/community.mis.temple.edu\/mis3580sec001s2018\/?page_id=22"},"modified":"2026-03-31T12:24:21","modified_gmt":"2026-03-31T16:24:21","slug":"schedule","status":"publish","type":"page","link":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/schedule\/","title":{"rendered":"Schedule"},"content":{"rendered":"

 <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Day<\/strong><\/td>\nTopics<\/strong><\/td>\nCourse Materials<\/strong><\/td>\nAssignments<\/strong><\/td>\n<\/tr>\n
\n

1\/13<\/p>\n<\/td>\n

\n

Course Introduction and Syllabus<\/p>\n

The Things You Can Do with Data.<\/p>\n

The Information Architecture of an Organization<\/p>\n<\/td>\n

\n

PowerPoint:\u00a0Course Introduction<\/a><\/p>\n

The Things You Can Do with Data<\/a><\/p>\n

Information Architecture<\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n<\/tr>\n

\n

1\/15<\/p>\n<\/td>\n

\n

Understanding Database Schemas: Normalization, primary\/foreign keys, joins<\/p>\n<\/td>\n

\n

PowerPoint: Relational Data Modeling<\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n<\/tr>\n

\n

1\/20<\/p>\n<\/td>\n

\n

In-class exercise: Creating database schema in MySQL Workbench<\/strong><\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

1\/22<\/p>\n<\/td>\n

\n

Getting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE<\/p>\n

Make sure you\u2019ve reviewed the guide for setting up a connection in MySQL Workbench <\/em><\/p>\n<\/td>\n

\n

PowerPoint: SQL 1<\/a><\/p>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

1\/27<\/p>\n<\/td>\n

\n

In-class exercise: Pen and Paper exercise<\/strong><\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\n

Assignment 1 Due: Database schema<\/p>\n<\/td>\n<\/tr>\n

\n

1\/29<\/p>\n<\/td>\n

\n

In-class exercise: Working with SQL, part 1<\/strong><\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n<\/tr>\n

\n

2\/3<\/p>\n<\/td>\n

\n

Getting data out of RDMS: Joining tables<\/p>\n

In-class exercise: Working with SQL, part 2<\/strong><\/a><\/p>\n<\/td>\n

\n

PowerPoint:\u00a0SQL 2<\/a><\/p>\n<\/td>\n

\n

Assignment 2 Due: SQL #1<\/p>\n<\/td>\n<\/tr>\n

\n

2\/5<\/p>\n<\/td>\n

\n

In-class exercise: Working with SQL, part 2<\/strong><\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n<\/tr>\n

\n

2\/10<\/p>\n<\/td>\n

\n

Review for Exam 1<\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\n

Assignment 3 Due: SQL #2<\/p>\n<\/td>\n<\/tr>\n

\n

2\/12<\/p>\n<\/td>\n

\n

Exam 1<\/strong><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n<\/tr>\n

\n

2\/17<\/p>\n<\/td>\n

\n

Semi-structured data<\/p>\n

In-class exercise: Working with semi-structured data<\/strong><\/a><\/p>\n<\/td>\n

\n

PowerPoint: Semi-structured data & NoSQL<\/a><\/p>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

2\/19<\/p>\n<\/td>\n

\n

Introduction to Python<\/p>\n

In-class exercise: Getting familiar with Jupyter, Python Basic, Data types<\/strong><\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

2\/24<\/p>\n<\/td>\n

\n

Python Data Structures<\/p>\n

In-class exercise: Python Lists and Dictionaries<\/strong><\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n<\/tr>\n

\n

2\/26<\/p>\n<\/td>\n

\n

Python and JSON<\/p>\n

In-class exercise: Working with JSON in Python<\/strong><\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\n

Assignment 4 Due: Python Basics<\/p>\n<\/td>\n<\/tr>\n

\n

3\/2-6<\/p>\n<\/td>\n

\n

Spring Break \u2013 No class<\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

3\/10<\/p>\n<\/td>\n

\n

In-class exercise: Working with JSON in Python<\/strong> (continued)<\/a><\/p>\n

Reconciling Data: The extract, transform, load process (ETL)<\/p>\n<\/td>\n

\n

PowerPoint:\u00a0ETL<\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n<\/tr>\n

\n

3\/12<\/p>\n<\/td>\n

\n

Python Pandas<\/p>\n

In-class exercise: Working with Python Pandas<\/strong><\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\n

Assignment 5 Due: \u00a0Python and JSON<\/p>\n<\/td>\n<\/tr>\n

\n

3\/17<\/p>\n<\/td>\n

\n

In-class exercise: JSON & Pandas<\/strong><\/a>\u00a0<\/p>\n

(by Jaeyeon Jeong)<\/p>\n<\/td>\n

\n

PowerPoint:\u00a0JSON and Pandas<\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n<\/tr>\n

\n

3\/19<\/p>\n<\/td>\n

\n

Hypothesis Testing<\/p>\n

Principles of Data Visualization<\/p>\n

In-class exercise: Data Visualization<\/strong><\/a><\/p>\n<\/td>\n

\n

PowerPoint:\u00a0Hypothesis Testing<\/a>
\nData Visualization<\/a><\/p>\n<\/td>\n

\n

Assignment 6 Due: Pandas<\/p>\n<\/td>\n<\/tr>\n

\n

3\/24<\/p>\n<\/td>\n

\n

Review for Exam 2\u00a0<\/p>\n<\/td>\n

\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
\n

3\/26<\/p>\n<\/td>\n

\n

Exam 2<\/strong><\/p>\n<\/td>\n

\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
\n

3\/31<\/p>\n<\/td>\n

\n

Introduction to Advanced Analytics<\/p>\n

Classification using Decision Trees<\/p>\n<\/td>\n

\n

PowerPoint:\u00a0Advanced Analytics \u2013 Introduction<\/a><\/p>\n

Classification using Decision Trees<\/a><\/p>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

4\/2<\/p>\n<\/td>\n

\n

In-class exercise: Decision trees in Python<\/strong><\/a><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n
\n

4\/7<\/p>\n<\/td>\n

\n

Analysis Scenario: Identifying similar customers (clustering and segmentation)\u00a0<\/p>\n<\/td>\n

\n

PowerPoint:\u00a0Clustering and Segmentation<\/a><\/p>\n<\/td>\n

\n

Assignment 7 Due: Decision Trees<\/p>\n<\/td>\n<\/tr>\n

\n

4\/9<\/p>\n<\/td>\n

\n

In-class exercise: Clustering and Segmentation in <\/strong>Python<\/strong><\/a><\/p>\n<\/td>\n

\n

\u00a0<\/h4>\n<\/td>\n

\n

\u00a0<\/h4>\n<\/td>\n<\/tr>\n

\n

4\/14<\/p>\n<\/td>\n

\n

Analysis Scenario: What products are purchased together? (Association Rules)\u00a0<\/p>\n

In-class exercise: Computing Confidence, Support, and Lift<\/strong><\/a><\/p>\n<\/td>\n

\n

PowerPoint:\u00a0Association Rule Mining<\/a><\/p>\n<\/td>\n

\n

Assignment 8 Due: Clustering<\/p>\n<\/td>\n<\/tr>\n

\n

4\/16<\/p>\n<\/td>\n

\n

In-class exercise: Association Rule Mining in <\/strong>Python<\/strong><\/a><\/p>\n<\/td>\n

\n

\u00a0<\/h4>\n<\/td>\n

\n

\u00a0<\/h4>\n<\/td>\n<\/tr>\n

\n

4\/21<\/p>\n<\/td>\n

\n

Review for Exam 3<\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\n

Assignment 9 Due: Association Rules<\/p>\n<\/td>\n<\/tr>\n

\n

4\/23<\/p>\n<\/td>\n

\n

Exam 3<\/strong><\/p>\n<\/td>\n

\n

 <\/p>\n<\/td>\n

\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

  Day Topics Course Materials Assignments 1\/13 Course Introduction and Syllabus The Things You Can Do with Data. The Information Architecture of an Organization PowerPoint:\u00a0Course Introduction The Things You Can Do with Data Information Architecture   1\/15 Understanding Database Schemas: Normalization, primary\/foreign keys, joins PowerPoint: Relational Data Modeling   1\/20 In-class exercise: Creating database schema […]<\/p>\n","protected":false},"author":17214,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"class_list":{"0":"post-22","1":"page","2":"type-page","3":"status-publish","5":"entry"},"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/pages\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/users\/17214"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/comments?post=22"}],"version-history":[{"count":184,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/pages\/22\/revisions"}],"predecessor-version":[{"id":1555,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/pages\/22\/revisions\/1555"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/media?parent=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}