{"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":"2025-12-08T23:32:59","modified_gmt":"2025-12-09T04:32:59","slug":"schedule","status":"publish","type":"page","link":"https:\/\/community.mis.temple.edu\/mis2502sec003fall2025\/","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\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
WEEK<\/th>\nDATES<\/th>\nTOPIC<\/th>\nTASKS DUE<\/th>\nMATERIALS<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\n8\/25<\/td>\n\n

Course Introduction and Syllabus<\/p>\n

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

\u00a0<\/td>\n\n
\u00a0<\/td>\n8\/27<\/td>\n\n

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

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

\u00a0<\/td>\n\n
\u00a0<\/td>\n8\/29<\/td>\nUnderstanding Database Schemas: Normalization, primary\/foreign keys, joins<\/td>\n\u00a0<\/td>\n\n
2<\/td>\n9\/01<\/td>\nLabor Day \u2013 No Class<\/strong><\/td>\n\n

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

\n

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

\u00a0<\/td>\n9\/03<\/td>\nIn-class exercise #01: Creating database schema<\/strong><\/td>\n\n\n
\u00a0<\/td>\n9\/05<\/td>\nGetting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE<\/td>\n\u00a0<\/td>\n\n
3<\/td>\n9\/08<\/td>\nGetting data out of RDMS: SQL SELECT, DISTINCT MIN, MAX, COUNT, and WHERE<\/td>\n\n

Assignment 1: Database schema<\/p>\n

\n
\u00a0<\/td>\n9\/10<\/td>\nIn-class exercise #02: Pen and Paper exercise<\/strong><\/td>\n\n

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

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

 <\/p>\n

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

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

\u00a0<\/td>\n\n

 <\/p>\n

4<\/td>\n9\/15<\/td>\n\n

 <\/p>\n

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

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

\n

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

\n

 <\/p>\n

\u00a0<\/td>\n9\/17<\/td>\n\n

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

\n

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

\n

 <\/p>\n

\u00a0<\/td>\n9\/19<\/td>\nIn-class exercise #04: Working with SQL, part 2<\/strong><\/td>\n\u00a0<\/td>\n\n
5<\/td>\n9\/22<\/td>\nReview for Exam 1<\/td>\n\n

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

\n
\u00a0<\/td>\n9\/24<\/td>\nReview for Exam 1<\/td>\n\n

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

\n
\u00a0<\/td>\n9\/26<\/strong><\/td>\nExam 1<\/strong><\/td>\n\u00a0<\/td>\n\n

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

6<\/td>\n9\/29<\/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>\n10\/01<\/td>\n\n

Python Data Structures<\/p>\n

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

\u00a0<\/td>\n\n

 <\/p>\n

\u00a0<\/td>\n10\/03<\/td>\n\n

Python Data Structures<\/p>\n

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

\u00a0<\/td>\n\n

 <\/p>\n

7<\/td>\n10\/06<\/td>\n\n

Semi-structured data<\/p>\n

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

\n

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

\n
\u00a0<\/td>\n10\/08<\/td>\n\n

Python and JSON<\/p>\n

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

\n

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

\n
\u00a0<\/td>\n10\/10<\/td>\n\n

Python Pandas<\/p>\n

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

\u00a0<\/td>\n\n
8<\/td>\n10\/13<\/td>\n\n

Python Pandas<\/p>\n

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

\n

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

\n

 <\/p>\n

\u00a0<\/td>\n10\/15<\/td>\n\n

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

\n

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

<\/p>\n
\u00a0<\/td>\n10\/17<\/td>\n\n

Fall Wellness Day (no classes held)<\/strong><\/p>\n<\/td>\n

\u00a0<\/td>\n\n

 <\/p>\n

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

9<\/td>\n10\/20<\/td>\n\n

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

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

\n

Assignment 6: Pandas<\/p>\n

\n
\u00a0<\/td>\n10\/22<\/td>\n\n

Principles of Data Visualization<\/p>\n

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

\n

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

\n
\u00a0<\/td>\n10\/24<\/td>\n\n

Hypothesis Testing<\/p>\n

In-class exercise #12: Hypothesis Testing and Visualization in Python<\/strong><\/p>\n<\/td>\n

\u00a0<\/td>\n\n
10<\/td>\n10\/27<\/td>\nReview for Exam 2<\/td>\n\u00a0<\/td>\n\n

 <\/p>\n

\u00a0<\/td>\n10\/29<\/td>\nReview for Exam 2<\/td>\n\u00a0<\/td>\n\n

 <\/p>\n

    \n
  • Practice for exam-Key<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n
\u00a0<\/td>\n10\/31<\/td>\nExam 2<\/strong><\/td>\n\u00a0<\/td>\n\n

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

11<\/td>\n11\/03<\/td>\n\n

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

Classification using Decision Trees<\/p>\n

 <\/p>\n

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

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

 <\/p>\n

Classification using Decision Trees<\/p>\n

In-class exercise #13: Decision Trees in Python<\/p>\n

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

\u00a0<\/td>\n\n
\u00a0<\/td>\n11\/07<\/td>\nIn-class exercise #13: Decision Trees in Python<\/td>\n\u00a0<\/td>\n\n
12<\/td>\n11\/10<\/td>\n\n

PRO points project<\/p>\n

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

\n

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

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

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

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

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

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

\n

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

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

Assignment 8: Clustering<\/p>\n

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

Thanksgiving holiday – no class<\/p>\n<\/td>\n

\n

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

\u00a0<\/td>\n<\/tr>\n
\u00a0<\/td>\n11\/26<\/td>\nThanksgiving holiday – no class<\/td>\n\u00a0<\/td>\n\n

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

\u00a0<\/td>\n11\/28<\/td>\nThanksgiving holiday – no class<\/td>\n\u00a0<\/td>\n\n

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

15<\/td>\n12\/01<\/span><\/td>\nReview for Final Exam\u00a0<\/strong><\/td>\n\n

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

\n

 <\/p>\n

\u00a0<\/td>\n12\/03<\/span><\/td>\nReview for Final Exam<\/strong><\/td>\n\n

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

\n
\u00a0<\/td>\n12\/05<\/td>\nFinal Exam<\/strong><\/td>\n\n

PRO points project (optional): Due on 12\/08<\/strong><\/p>\n

\n

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

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

  WEEK DATES TOPIC TASKS DUE MATERIALS 1 8\/25 Course Introduction and Syllabus The Things You Can Do with Data \u00a0 Course Introduction Things You Can Do with Data \u00a0 8\/27 The Information Architecture of an Organization Understanding Database Schemas: Normalization, primary\/foreign keys, joins \u00a0 Information Architecture Relational Data Modeling   \u00a0 8\/29 Understanding Database […]<\/p>\n","protected":false},"author":28539,"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\/mis2502sec003fall2025\/wp-json\/wp\/v2\/pages\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec003fall2025\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec003fall2025\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2502sec003fall2025\/wp-json\/wp\/v2\/users\/28539"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2502sec003fall2025\/wp-json\/wp\/v2\/comments?post=22"}],"version-history":[{"count":723,"href":"https:\/\/community.mis.temple.edu\/mis2502sec003fall2025\/wp-json\/wp\/v2\/pages\/22\/revisions"}],"predecessor-version":[{"id":1591,"href":"https:\/\/community.mis.temple.edu\/mis2502sec003fall2025\/wp-json\/wp\/v2\/pages\/22\/revisions\/1591"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec003fall2025\/wp-json\/wp\/v2\/media?parent=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}