Week 4

Data Analysis & Visualization

It’s spreadsheet time! You’ll learn to do some data manipulation in Excel (or similar) and how a simple spreadsheet can become many different visualizations.

Read, view, and listen

In-class activities

Slides

Additional Materials

One dataset, visualized 25 ways

Summary of good data management practices

The bad spreadsheet!

Sign up for office hours with mads

Backchannel

Download Excel for free as a UCLA student (please note the instructions in red for which email address to enter)

Hands-On Tutorials

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.

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.)

I need to learn some Excel basics

The second slide of the Excel tutorial 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.

I need to learn to make a pivot table and use VLOOKUP.

Start with the Excel tutorial. When you’re done, you can continue on to the Flourish tutorial.

I already know how to make a pivot table and use VLOOKUP.

Learn about OpenRefine instead. OpenRefine is a tool that helps you clean up data. You can download it here. If your Mac won’t let you open OpenRefine, press CONTROL, click on the OpenRefine application, and select OPEN from the menu.

Once you’re done with OpenRefine, you can continue to the Flourish tutorial.

I already know about OpenRefine and Flourish.

Get better at OpenRefine! Work through chapters 3 and 4 of Using OpenRefine. (You’ll need to use the UCLA VPN and click on the EBSCO link for online access.)

Alternately, you can learn how to use R for data cleanup. (You might find this quick intro to R helpful.)

Leave a comment

Your email address will not be published. Required fields are marked *