Data 1: Use a CSV file and Excel to make a chart

The resources we used in class: Week 8 and Week 9.

Of course, we also needed Yau’s book.

The assignment is to use Excel to create a clear and attractive chart of 365 days of high temperatures from your assigned city for your assigned year (see the Week 9 resources for that link). Requirements are listed below. Your chart will look similar to this one: Read more of this post


To learn more about data journalism …

If you liked what we did in the past two weeks, here are some things to consider:

You could learn Python. Yeah, actually learn it. Here’s how.

When you read Yau’s chapter 8, you probably noticed he gave you three different examples. The first one used R, a programming environment that’s good for making statistical graphics. The second example used Python (yay! You have that!). The third example used Flash, in a particularly horrible way.

If you want to learn more about this stuff, you can’t try to learn three things at the same time.

But you can learn them one at a time. You could do the Python stuff in Yau’s chapter 8. You can try it. You can make it work. Read more of this post