{"id":457,"date":"2015-09-10T16:35:43","date_gmt":"2015-09-10T16:35:43","guid":{"rendered":"http:\/\/arlduc.org\/senseandscale\/?p=457"},"modified":"2015-09-24T16:56:16","modified_gmt":"2015-09-24T16:56:16","slug":"session-2-books-tools-sheets-queries","status":"publish","type":"post","link":"https:\/\/arlduc.org\/senseandscale\/?p=457","title":{"rendered":"Data Vis Session 2: Books, Tools, Sheets, Queries."},"content":{"rendered":"<h2>Announcements and Links<\/h2>\n<ul>\n<li>Groups<\/li>\n<li>Next week: NYSCI ideation, lit review exercise<\/li>\n<li>Punctuality and assignments<\/li>\n<\/ul>\n<h2>Agenda<\/h2>\n<ul>\n<li class=\"p3\"><span class=\"s1\">6:30-7:00-\u00a0Book Club<\/span><\/li>\n<li class=\"p3\">7:00-8:00-\u00a0Lecture: <a href=\"https:\/\/drive.google.com\/open?id=0B1KM70jlEfvpT3FSZzEzVkFaMDA\" target=\"_blank\">Data Vis Toolbox<\/a><\/li>\n<li class=\"p3\"><span class=\"s1\">8:00-8:10-\u00a0Break<\/span><\/li>\n<li class=\"p3\">8:00-8:45- Review of class blogs<\/li>\n<li class=\"p3\">8:45-9:15: Discussion of spreadsheet functions and database queries<\/li>\n<li class=\"p3\">9:15-9:20- Next Week&#8217;s Assignments<\/li>\n<\/ul>\n<h2>Notes<\/h2>\n<p>The <a href=\"http:\/\/arlduc.org\/senseandscale\/?p=483\" target=\"_blank\">full Socrata\/SODA\/SoQL tutorial<\/a> is now up! Please use it to complete the assignments below.<\/p>\n<h2><\/h2>\n<h2>Next Two Week&#8217;s Assignments<\/h2>\n<ul>\n<li><strong>Data Acquisition,\u00a0required by September 17.<\/strong> Expand the NYC Open Data exercise by looking at December 2014, the month of protests around Eric Garner&#8217;s death. Post or send me a CSV with the following attributes:\n<ul>\n<li>data source: NYC Open Data<\/li>\n<li>time period: December 2014<\/li>\n<li>CSV size: smaller than 1 MB, if you&#8217;re e-mailing it<\/li>\n<\/ul>\n<\/li>\n<li><strong>Blog Post,\u00a0required by September 17.<\/strong> Write a short blog post that contains a link to your CSV if possible, discusses your process, and explains your observations. Also, discuss other data sources you&#8217;d like to explore in future classes. Also, post a visualization if you get that far!<\/li>\n<li><strong>Visualization,\u00a0required by September 24.<\/strong> Use\u00a0<a href=\"http:\/\/dev.socrata.com\/consumers\/getting-started.html\" target=\"_blank\">Socrata&#8217;s example page<\/a> and the\u00a0<a href=\"http:\/\/d3js.org\/\" target=\"_blank\">D3 site<\/a> to start turning your dataset into a simple visualization. If you don&#8217;t get that far on the visualization part, that&#8217;s ok! We will do a deep dive with these technologies\u00a0on September 24.\n<ul>\n<li>If you&#8217;re having trouble deciding what to visualize, just try making a <a href=\"http:\/\/dev.socrata.com\/consumers\/examples\/simple-chart-with-d3.html\" target=\"_blank\">simple bar chart<\/a> of NYC data in December 2014.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Announcements and Links Groups Next week: NYSCI ideation, lit review exercise Punctuality and assignments Agenda 6:30-7:00-\u00a0Book Club 7:00-8:00-\u00a0Lecture: Data Vis Toolbox 8:00-8:10-\u00a0Break 8:00-8:45- Review of class blogs 8:45-9:15: Discussion of spreadsheet functions and database queries 9:15-9:20- Next Week&#8217;s Assignments Notes The full Socrata\/SODA\/SoQL tutorial is now up! Please use it to complete the assignments below. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-457","post","type-post","status-publish","format-standard","hentry","category-nyu-datavis"],"_links":{"self":[{"href":"https:\/\/arlduc.org\/senseandscale\/index.php?rest_route=\/wp\/v2\/posts\/457","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arlduc.org\/senseandscale\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arlduc.org\/senseandscale\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arlduc.org\/senseandscale\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/arlduc.org\/senseandscale\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=457"}],"version-history":[{"count":12,"href":"https:\/\/arlduc.org\/senseandscale\/index.php?rest_route=\/wp\/v2\/posts\/457\/revisions"}],"predecessor-version":[{"id":565,"href":"https:\/\/arlduc.org\/senseandscale\/index.php?rest_route=\/wp\/v2\/posts\/457\/revisions\/565"}],"wp:attachment":[{"href":"https:\/\/arlduc.org\/senseandscale\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=457"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arlduc.org\/senseandscale\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=457"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arlduc.org\/senseandscale\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=457"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}