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 Slides: Data Management Basics<\/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 Because the class has a wide range of experience with Excel, today’s 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’s 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’re 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’t let you open OpenRefine, press CONTROL, click on the OpenRefine application, and select OPEN from the menu.<\/p>\n\n\n\n Once you’re 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’ll 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 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. Read, view,… Continue reading 4: Jan. 28<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":18,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":"","footnotes":""},"class_list":["post-92","page","type-page","status-publish","hentry","entry"],"_links":{"self":[{"href":"https:\/\/miriamposner.com\/classes\/is270w25\/wp-json\/wp\/v2\/pages\/92","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/miriamposner.com\/classes\/is270w25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/miriamposner.com\/classes\/is270w25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/is270w25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/is270w25\/wp-json\/wp\/v2\/comments?post=92"}],"version-history":[{"count":0,"href":"https:\/\/miriamposner.com\/classes\/is270w25\/wp-json\/wp\/v2\/pages\/92\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/is270w25\/wp-json\/wp\/v2\/pages\/18"}],"wp:attachment":[{"href":"https:\/\/miriamposner.com\/classes\/is270w25\/wp-json\/wp\/v2\/media?parent=92"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Read, view, and listen<\/h4>\n\n\n\n
In-class activities<\/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