{"id":355,"date":"2022-01-28T06:11:57","date_gmt":"2022-01-28T06:11:57","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/is270s23\/?page_id=355"},"modified":"2023-04-25T23:14:05","modified_gmt":"2023-04-25T23:14:05","slug":"homework-3","status":"publish","type":"page","link":"http:\/\/miriamposner.com\/classes\/is270s23\/homework-3\/","title":{"rendered":"Homework 3"},"content":{"rendered":"\n<p><em>Due by classtime on Week 5.<\/em><\/p>\n\n\n\n<p>Download <a href=\"https:\/\/www.dropbox.com\/s\/xfjtwa24inmri47\/art_students.xlsx?dl=1\">this spreadsheet<\/a> (a student roster for a fictitious art college) and open it in Excel.<\/p>\n\n\n\n<p>The spreadsheet contains two worksheets: Student Roster and Photography Students. The Photography Students list is missing the students&#8217; names, but it does have their ID numbers. Using VLOOKUP, fill in the &#8220;Student name&#8221; column in the Photography Students worksheet.<\/p>\n\n\n\n<p>Now return to the main student roster. Create a pivot table that shows how many students from each state are in which program. <\/p>\n\n\n\n<p>Your spreadsheet document should now have three worksheets (i.e., <strong>tabs<\/strong>) in it: 1) the original student roster, 2) the photography roster <em>with the student names filled in<\/em>, and 3) a pivot table showing how many students from each state are in which program.<\/p>\n\n\n\n<p>Save your Excel spreadsheet as an Excel document (.xls) and submit it as Homework 3 on BruinLearn. (I know I said you should always transmit data as a CSV, but just this ONE TIME, send it as an Excel document!)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"alternative-for-the-tech-confident\">Alternative for the tech-confident<\/h3>\n\n\n\n<p>Create a generative drawing with <a href=\"https:\/\/p5js.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">p5.js<\/a>, using <a rel=\"noreferrer noopener\" href=\"https:\/\/adamherst.art\/introduction_to_generative_drawing_letter.pdf\" target=\"_blank\">this guide<\/a>. Share the link to your drawing.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Due by classtime on Week 5. Download this spreadsheet (a student roster for a fictitious art college) and open it in Excel. The spreadsheet contains two worksheets: Student Roster and&hellip; <a class=\"more-link\" href=\"http:\/\/miriamposner.com\/classes\/is270s23\/homework-3\/\">Continue reading <span class=\"screen-reader-text\">Homework 3<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":"","footnotes":""},"class_list":["post-355","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/pages\/355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/comments?post=355"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/pages\/355\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/media?parent=355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}