Spreadsheets B106, Session 3

It's Homecoming, but that didn't stop students from showing up to their ITA session, and everyone was excited to get to work. We started by sharing stories about our past two weeks, and Carrie shared a story about rehearsals for her performances, and Elizabeth talked about her orchestral performance of Michael Jackson's "Thriller."

After that, we moved onto a review of what we've learned so far in Excel--conditional formatting, formulas, and the projects that we've done. Elizabeth then launched into some new stuff, showing them a great video of a Swedish professor explaining a world population chart he made, including the animations that went into it. Motion charts are a great way to add visual flair to data, and so Elizabeth showed Google Docs, in which you can make them. As a great way of explaining Google Docs, she showed them the "Google Love Letter" video. It went over very well, everyone getting a laugh, and at the same time they learned the advantages of using Google Docs.

Elizabeth then showed them how to link data from one spreadsheet to another, leading the students into the Football spreadsheets. It took a little explaining for the students to realize that they didn't have to know anything about football in order to do the exercise--they had to link data :). That led them into other projects, such as the Jungle Book sheet that Kevin made. Everyone did a great job! Anny and Carrie were sure they couldn't do it, but in the end, they figured it out on their own, getting functions like COUNTIF and OR to work exactly right! Great job!

Here's what Anny did in Google Spreadsheets: