{"id":202,"date":"2017-09-27T22:00:07","date_gmt":"2017-09-27T22:00:07","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f17\/?page_id=202"},"modified":"2017-11-17T11:47:17","modified_gmt":"2017-11-17T19:47:17","slug":"midterm","status":"publish","type":"page","link":"http:\/\/miriamposner.com\/classes\/dh101f17\/assignments\/exams\/midterm\/","title":{"rendered":"Midterm"},"content":{"rendered":"<p>Your midterm exam, on December 1, will test your technical skills. You&#8217;ll be expected to be able to do the following. (If the skill lists a few different tools, you don&#8217;t have to be able to use all of them; just one. The exam will be open-book.)<\/p>\n<ul>\n<li>OpenRefine: Reorder and remove columns; cluster and merge fields; remove leading and trailing whitespaces; separate combined values into multiple columns; export project as a CSV.<\/li>\n<li><del>Excel: Summarize values using pivot tables; create simple bar and pie charts.<br \/>\n<\/del> Sadly, we didn&#8217;t have time to learn this skill this year! Sorry about that! If you want to be able to do this (it&#8217;s very useful!), check out <a href=\"http:\/\/miriamposner.com\/classes\/dh101f17\/tutorials-guides\/data-visualization\/summarize-values-with-excel\/\">this tutorial<\/a>.<\/li>\n<li>Tableau, Plotly, Fusion Tables, or Datawrapper: Create bar charts, pie charts, and line graphs from spreadsheets.<\/li>\n<li>HTML and CSS: Create a simple webpage and style it using CSS.<\/li>\n<li>Google Fusion Tables, MyMaps, or Carto: Geolocate, then map and publish data from a spreadsheet.<\/li>\n<li>Palladio, Cytoscape, or Fusion Tables: From a spreadsheet containing sources and targets, create a labeled network diagram.<\/li>\n<\/ul>\n<p>You can practice for the midterm using these datasets:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/s\/s0g69okini18g9t\/alww-us-2.1.csv?dl=0\">American Labor Who&#8217;s Who<\/a>\u00a0(people involved in the American labor movement)<\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/s\/08ulqw9i8p8uv73\/cushman_metadata.csv?dl=0\">Photographs in an archival collection<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/s\/6d30rvw3svfhpfk\/Shipwreck%20Database%20093015%20f.xlsx?dl=0\">Shipwrecks off the coast of New Jersey<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/s\/wn8wqlexrlfden3\/Tate%20Turners.xlsx?dl=0\">Turner paintings at the Tate Museum<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Your midterm exam, on December 1, will test your technical skills. You&#8217;ll be expected to be able to do the<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":200,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":"","footnotes":""},"class_list":["post-202","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages\/202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=202"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages\/202\/revisions"}],"up":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages\/200"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}