{"id":93,"date":"2018-08-21T16:37:28","date_gmt":"2018-08-21T20:37:28","guid":{"rendered":"http:\/\/community.mis.temple.edu\/mis3580sec001f2018\/?page_id=93"},"modified":"2026-04-02T10:54:13","modified_gmt":"2026-04-02T14:54:13","slug":"ica","status":"publish","type":"page","link":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/ica\/","title":{"rendered":"In-Class Activities"},"content":{"rendered":"<p><strong>In-class Activities Policy\u00a0<\/strong><\/p>\n<ul>\n<li><em>You<\/em>\u00a0should submit\u00a0<strong>your own<\/strong>\u00a0solutions to the in-class exercises, even though you work as groups in class;<\/li>\n<li>You are\u00a0<em>allowed to miss two<\/em>\u00a0in-class activities without\u00a0penalty.<\/li>\n<li>The grade will be evaluated based on completeness and correctness and as \u201csuccess or fail\u201d. You will get a score of 1 if you succeed and 0 if you fail.<\/li>\n<\/ul>\n<p><strong>#<\/strong><strong> 13 In-class Activities: Decision Trees in Python [Due by 11:59 pm on 4\/2]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/ztk22aiemy9ve73rcnjn6\/ICA-13-Decision-Trees-in-Python.docx?rlkey=s94uu5r3oym56ei539sww2gro&amp;dl=1\">In-Class Exercise #13 \u2013Decision Trees in Python<\/a>\u00a0\u00a0<\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/hm0shn4dburnbykaery6l\/ICA13_Decision_tree.ipynb?rlkey=k28dfzqoj8jtttfy0s3guv3cc&amp;dl=1\">ICA13_Decision_tree.ipynb<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/nn2xlxeupmy6enmozwyz7\/OrganicsPurchase.csv?rlkey=o3wfkrc6ir6kzl0dqljbi5lw7&amp;dl=1\">OrganicsPurchase.csv<\/a><\/li>\n<\/ul>\n<p><strong># 12 In-class Activities: Data Visualization [Due by 11:59 pm on 3\/19]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/x7umy47f9chowjbp2dpuq\/ICA-12-Data-Visualization-Principles.docx?rlkey=rz32wmf6uw5pw8yxdda9uff5s&amp;dl=1\">In-Class Exercise #12 \u2013 Data Visualization Principles<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/escq4syicf2aq0zs7slwr\/ICA-11-Food-Emporium_Dashboard.xlsx?rlkey=iogd8fq9aswbeb2xj4fan9w1n&amp;dl=1\">In-Class Exercise #12 \u2013 Food-Emporium Dashboard.xlsx<\/a><\/li>\n<\/ul>\n<p><strong># 11 In-class Activities: Working with JSON and Pandas [Due by 11:59 pm on 3\/17]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/1a0p5xegfn1b2umvafcfp\/ICA_11-JSON-and-Pandas.ipynb?rlkey=e4dntpy1aopnp1xh92fxsji2t&amp;dl=1\">In-Class Exercise #11 \u2013 JSON and Pandas<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/5muf7fhdttjlpkd9yj9vm\/airbnb.json?rlkey=lxhair9kpzo8ea0a3pteq9mni&amp;dl=1\">In-Class Exercise #11 \u2013 airbnb.json<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/zt9yek1r68po7f4b4peql\/NYC_Restaurant_Inspection.csv?rlkey=b4wen8w98lxhabqa7czz289a9&amp;dl=1\">In-Class Exercise #11 \u2013 <\/a><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/mqwgq63tlaskbqqlypsss\/NYC_Restaurant_Inspection.csv?rlkey=z8wcf8hxn4uvt53vbrl6e2cup&amp;st=nz972jqi&amp;dl=1\">NYC_Restaurant_Inspection.csv<\/a><\/li>\n<\/ul>\n<p><strong># 10 In-class Activities: Working with Pandas in Python [Due by 11:59 pm on 3\/12]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/ojx7ser3phf33vmqfoorw\/ICA_10-Pandas.ipynb?rlkey=2xavn2tqypmcctlgkuxas2htz&amp;dl=1\">In-Class Exercise #10 \u2013 Pandas in Python<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/mqwgq63tlaskbqqlypsss\/NYC_Restaurant_Inspection.csv?rlkey=z8wcf8hxn4uvt53vbrl6e2cup&amp;st=nz972jqi&amp;dl=1\">In-Class Exercise #10 \u2013 NYC_Restaurant_Inspection.csv<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/qp0r0pmcrpno7g0bf32kh\/NBA14Salaries.csv?rlkey=fk75i0471rl215au4v74vg5o4&amp;st=2djrqh8d&amp;dl=1\">In-Class Exercise #10 \u2013 NBA14Salaries.csv<\/a><\/li>\n<\/ul>\n<p><strong># 8\/9 In-class Activities: Working with JSON in Python [Due by 11:59 pm on 2\/26]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/cvopqf4994nsqf4pmf2rf\/ICA_8-JSON.ipynb?rlkey=shfgvpo19us6625nsv5swnqr4&amp;dl=1\">In-Class Exercise #8 \u2013 JSON in Python<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/3gvov731hwsty6qdyg4hv\/airbnb.json?rlkey=fvr7r97vurs41qs73ahp91bk3&amp;dl=1\">In-Class Exercise #8 \u2013 airbnb.json<\/a><\/li>\n<\/ul>\n<p><strong># 7 In-class Activities: Python Data Structures [Due by 11:59 pm on 2\/24]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/x7mzcwdy7d0q2l5u0lk9w\/ICA_7-Lists_Sets_Dictionaries.ipynb?rlkey=wk5ff9dog4wqe9rcxpqp4v8t8&amp;dl=1\">In-Class Exercise #7 \u2013 Python Data Structures<\/a><\/li>\n<\/ul>\n<p><strong># 6 In-class Activities: Python Basics Data Types [Due by 11:59 pm on 2\/19]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/ecc4f8akf0cjc4n7fdbt9\/ICA_6_Python_basics_Data_types.ipynb?rlkey=qxa8gqmd3u6xp61309acco291&amp;dl=1\">In-Class Exercise #6 \u2013 Python Basics and Data Types<\/a><\/li>\n<\/ul>\n<p><strong># 5 In-class Activities: Semi-structured Data [Due by 11:59 pm on 2\/17]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/2klu2lnbcnnmz6goolttu\/ICA-5-Working-with-Semi-Structured-Data.docx?rlkey=h5x1399cfri8hk4g91zjqu8bl&amp;dl=1\">In-Class Exercise #5 \u2013 Working with Semi-Structured Data<\/a><\/li>\n<\/ul>\n<p><strong># 4 In-class Activities: SQL Part 2 [Due by 11:59 pm on 2\/5<\/strong><strong>]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/lbffnpe92sqnzfyfyip7q\/ICA-4-SQL-Part-2.docx?rlkey=f3e3ncld34fjwbjrpv7wvv2by&amp;dl=1\">In-Class Exercise #4 \u2013 SQL Part 2<\/a><\/li>\n<\/ul>\n<p><strong># 3 In-class Activities: SQL Part 1 [Due by 11:59 pm on 1\/29<\/strong><strong>]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/fdzwcctfu1b8bxmod0frl\/ICA-3-SQL-Part-1.docx?rlkey=pz50pqgwtu1adq7a98i8bk56u&amp;dl=1\">In-Class Exercise #3 \u2013 SQL Part 1<\/a><\/li>\n<\/ul>\n<p><strong># 2 In-class Activities: SQL Pen and Paper [Due by 11:59 pm on 1\/27<\/strong><strong>]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/esiav3mrjtuq5ptgjutow\/ICA-2-Pen-and-Paper-Query-Exercise.docx?rlkey=lgm8adhgt6wcyqu65wo7xxtau&amp;dl=1\">In-Class Exercise #2 \u2013 Pen and Paper Query Exercise<\/a><\/li>\n<\/ul>\n<p><strong># 1 In-class Activities: Creating Schemas [Due by 11:59 pm on 1\/20]<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/iaxwqcf4so84lkxrdlw19\/ICA_1_Database_Schema.docx?rlkey=72u4yqn1aihngqgu072uejem6&amp;dl=1\">In-Class Exercise #1 \u2013 Creating Schemas<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/bhk8ntdeu02bkveefwf43\/Schema-Template.pptx?rlkey=69pnxparvnnkpy9gy6e23hga4&amp;dl=1\">Schema template<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In-class Activities Policy\u00a0 You\u00a0should submit\u00a0your own\u00a0solutions to the in-class exercises, even though you work as groups in class; You are\u00a0allowed to miss two\u00a0in-class activities without\u00a0penalty. The grade will be evaluated based on completeness and correctness and as \u201csuccess or fail\u201d. You will get a score of 1 if you succeed and 0 if you fail. [&hellip;]<\/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-93","1":"page","2":"type-page","3":"status-publish","5":"entry"},"_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/pages\/93","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=93"}],"version-history":[{"count":163,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/pages\/93\/revisions"}],"predecessor-version":[{"id":1556,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/pages\/93\/revisions\/1556"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/media?parent=93"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}