It\u2019s spreadsheet time! You\u2019ll learn to do some data manipulation in Excel (or similar) and how a simple spreadsheet can become many different visualizations.<\/em><\/p>\n\n\n\n One dataset, visualized 25 ways<\/a><\/p>\n\n\n\n Summary of good data management practices<\/a><\/p>\n\n\n\n The bad spreadsheet!<\/a><\/p>\n\n\n\n Sign up for office hours with mads<\/a><\/p>\n\n\n\n Backchannel<\/a><\/p>\n\n\n\n Download Excel for free as a UCLA student<\/a> (please note the instructions in red for which email address to enter)<\/p>\n\n\n\n Because the class has a wide range of experience with Excel, today\u2019s activities have a bit of a choose-your-own-adventure aspect to them. Please select the path that reflects your own experience and interests.<\/p>\n\n\n\n Please note that this week\u2019s homework will require you to use VLOOKUP and create a pivot table. (An alternative assignment is available for the tech-confident.)<\/p>\n\n\n\n The second slide of the Excel tutorial<\/a> will show you how to brush up on some basic Excel skills and terminology. Then continue through the Excel tutorial, followed by the Flourish tutorial.<\/a><\/p>\n\n\n\n Start with the Excel tutorial<\/a>. When you\u2019re done, you can continue on to the Flourish tutorial<\/a>.<\/p>\n\n\n\n Learn about OpenRefine<\/a> instead. OpenRefine is a tool that helps you clean up data. You can download it here<\/a>. If your Mac won\u2019t let you open OpenRefine, press CONTROL, click on the OpenRefine application, and select OPEN from the menu.<\/p>\n\n\n\n Once you\u2019re done with OpenRefine, you can continue to the Flourish tutorial<\/a>.<\/p>\n\n\n\n Get better at OpenRefine! Work through chapters 3 and 4 of Using OpenRefine<\/a><\/em>. (You\u2019ll need to use the UCLA VPN and click on the EBSCO link for online access.)<\/p>\n\n\n\n Alternately, you can learn how to use R for data cleanup<\/a>. (You might find this quick intro to R <\/a>helpful.)<\/p>\n","protected":false},"excerpt":{"rendered":" Data Analysis & Visualization<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[4],"tags":[5],"class_list":["post-526","post","type-post","status-publish","format-standard","hentry","category-readings","tag-readings","entry"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/posts\/526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/types\/post"}],"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=526"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/posts\/526\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/media?parent=526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/categories?post=526"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/is270s23\/wp-json\/wp\/v2\/tags?post=526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Read, view, and listen<\/h4>\n\n\n\n
\n
In-class activities<\/h4>\n\n\n\n
Slides<\/h4>\n\n\n\n
\n
Additional Materials<\/h4>\n\n\n\n
Hands-On Tutorials<\/h3>\n\n\n\n
I need to learn some Excel basics<\/h5>\n\n\n\n
I need to learn to make a pivot table and use VLOOKUP.<\/h5>\n\n\n\n
I already know how to make a pivot table and use VLOOKUP.<\/h5>\n\n\n\n
I already know about OpenRefine and Flourish.<\/h5>\n\n\n\n