{"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-04-08T16:16:44","modified_gmt":"2026-04-08T20:16:44","slug":"schedule","status":"publish","type":"page","link":"https:\/\/community.mis.temple.edu\/mis2502sec004spring2026\/","title":{"rendered":"Schedule"},"content":{"rendered":"\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
Wk<\/strong><\/span><\/em><\/td>\nDates<\/strong><\/span><\/em><\/td>\nTopics | ICA’s<\/strong><\/span><\/em><\/td>\nCourse Materials<\/strong><\/span><\/em><\/td>\nAssignments<\/strong><\/span><\/em><\/td>\n<\/tr>\n
1<\/td>\n01\/13<\/td>\n\n
    \n
  • Course Introduction and Syllabus<\/li>\n
  • The Things You Can Do with Data<\/li>\n
  • The Information Architecture of an Organization<\/li>\n<\/ul>\n<\/td>\n
\n\n

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

\u00a0<\/td>\n01\/15<\/td>\nUnderstanding Database Schemas: Normalization, primary\/foreign keys, joins<\/td>\n\n\n

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

2<\/td>\n01\/20<\/td>\n\n

In-class exercise #01: Creating database schema\u00a0
\n<\/strong><\/strong><\/span>\u00a0 \u00a0\u2666<\/span> ICA#1: Task<\/a>
\n<\/span>\u00a0<\/p>\n<\/td>\n

\n\n

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

\u00a0<\/td>\n01\/22<\/td>\nGetting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE<\/td>\n\n\n

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

3<\/td>\n01\/27<\/td>\n\n

In-class exercise #01: Creating database schema\u00a0<\/span>
\n<\/strong>\u00a0 \u2666<\/span>\u00a0Submit ICA #1 on Canvas<\/a><\/p>\n<\/td>\n

\n

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

\n

Assignment 1 Due: Database schema<\/span><\/a><\/p>\n

\u00a0<\/td>\n01\/29<\/td>\n\n

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

In-class exercise #02: Pen and Paper exercise<\/span>
\n<\/strong>\u00a0 \u2666<\/strong><\/span>\u00a0<\/strong>ICA #2: Task<\/a>
\n\u00a0 <\/span>\u2666<\/span>\u00a0Submit ICA #2 on Canvas<\/a><\/p>\n<\/td>\n

\n\n

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

4<\/td>\n02\/03<\/td>\n\n

Getting data out of RDMS: Joining tables
\n\u00a0 \u2666<\/strong><\/span> ICA #3: Task<\/a><\/p>\n

In-class exercise #03: Working with SQL, part 1<\/span>
\n<\/strong>\u00a0\u2666<\/strong><\/span> Submit ICA #3 on Canvas<\/a><\/p>\n<\/td>\n

\n

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

\n

Assignment 2 D<\/a>ue: SQL #1<\/a><\/span><\/p>\n

\u00a0<\/td>\n02\/05<\/td>\n\n

In-class exercise #04: Working with SQL, part 2<\/span>
\n<\/strong>\u00a0\u2666<\/strong><\/span> ICA #4: Task<\/a>
\n\u00a0\u2666<\/strong><\/span> Submit <\/a>ICA #4 <\/a>on Canvas<\/a><\/p>\n<\/td>\n

\n\n

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

5<\/td>\n02\/10<\/td>\n\n

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

\n\n

Assignment 3 Due: SQL #2<\/a><\/span><\/p>\n

\u00a0<\/td>\n02\/12<\/strong><\/td>\n\n

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

\n
    \n
  • Exam #1<\/strong><\/li>\n<\/ul>\n<\/td>\n
\u00a0<\/td>\n<\/tr>\n
6<\/td>\n02\/17<\/td>\n\n

Introduction to Python<\/p>\n

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

\n\n
\u00a0<\/td>\n02\/19<\/td>\n\n

Python Data Structures<\/p>\n

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

\n\n

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

7<\/td>\n02\/24<\/td>\n\n

Semi-structured data<\/p>\n

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

\n\n

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

\u00a0<\/td>\n02\/26<\/td>\n\n

Python and JSON<\/p>\n

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

\n\n

Assignment 4: \u00a0Python Basics<\/p>\n

8<\/td>\n\n

3\/1 – 3\/7<\/p>\n<\/td>\n

\n

Spring Break – No Class<\/strong><\/p>\n<\/td>\n

\n

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

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

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

\n

Python Pandas<\/p>\n

In-class exercise #09: Working with Python Pandas
\n<\/strong>ICA #9: Task<\/a>
\nData<\/a>
\nICA #9: Submit on Canvas<\/a><\/span><\/strong><\/p>\n<\/td>\n

\n

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

\n

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

\u00a0<\/td>\n03\/12<\/td>\n\n

In-class exercise #10: More practice with Pandas<\/strong><\/p>\n<\/td>\n

\n\n

Assignment 5: Python and JSON<\/p>\n

10<\/td>\n03\/17<\/td>\n\n

Principles of Data Visualization<\/p>\n

In-class exercise #11: Data Visualization
\nICA #11:\u00a0Task<\/a>,\u00a0Data<\/a>
\nICA #11: Submit on Canvas<\/a>
\n<\/strong><\/p>\n<\/td>\n

\n

PowerPoint: Data Visualization<\/a><\/p>\n<\/td>\n

\n

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

\u00a0<\/td>\n03\/19<\/td>\n\n

Hypothesis Testing<\/p>\n

In-class exercise #12: Hypothesis Testing and Visualization in Python
\n<\/strong>ICA #12: Notebook<\/a>, NBA<\/a>, Sales<\/a>
\nICA #12: Submit on Canvas<\/a><\/span>
\n<\/strong><\/p>\n<\/td>\n

\n\n

Assignment 6: Pandas<\/p>\n

11<\/td>\n03\/24<\/td>\nReview for Exam 2<\/a><\/td>\n\n
Study Guide<\/a><\/div>\n<\/td>\n
\u00a0<\/td>\n<\/tr>\n
\u00a0<\/td>\n03\/26<\/td>\nExam 2<\/strong><\/td>\n\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
12<\/td>\n03\/31<\/td>\n\n

Introduction to Advanced Analytics and Python<\/a><\/p>\n

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

\u00a0<\/td>\n\u00a0<\/td>\n<\/tr>\n
\u00a0<\/td>\n04\/02<\/td>\nIn-class exercise #13: Decision Trees in Python<\/strong><\/td>\n\u00a0<\/td>\n\n
13<\/td>\n04\/07<\/td>\nAnalysis Scenario: Identifying similar customers (clustering and segmentation)<\/td>\n\n

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

\n

\u2022\u00a0\u00a0\u00a0 PowerPoint: Clustering and Segmentation<\/p>\n<\/td>\n<\/tr>\n

\u00a0<\/td>\n04\/09<\/td>\nIn-class exercise #14: Clustering and Segmentation in <\/strong>Python<\/strong><\/td>\n\n

ICA #14:<\/p>\n

\n

Assignment 7: Decision Trees<\/p>\n

14<\/td>\n04\/14<\/td>\n\n

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

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

\n

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

\n

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

\u00a0<\/td>\n04\/16<\/td>\nIn-class exercise #16: Computing Confidence, Support, and Lift<\/strong><\/td>\n\u00a0<\/td>\n\n

Assignment 8: Clustering<\/p>\n

15<\/td>\n04\/21<\/span><\/td>\nReview for Exam 3<\/strong><\/td>\n\n

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

\n

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

\n

 <\/p>\n

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

04\/23<\/td>\nFinal Exam<\/strong><\/td>\n\n

PRO points project (optional): Due<\/p>\n

\n

Assignment 9: Association Rules<\/p>\n