See Russell’s posts on spreadsheets and pivot tables for a complete walk through of our in-class exercises.
We looked at formulas to find the
=MEDIAN() of a range of cells (working with MLB salary data)
We downloaded Google’s data on flu related searches. We used
data > text to columns ... to break the text block into columns, and then used some Excel formulas to find
We didn’t use the auto filter button to set up filters that let us sort the data by a single column, but we could have. We also didn’t use
paste special > transpose to shift rows into columns, but we could have, if we wanted to.
We used data Matt got from iCasualties.org to play with pivot tables, in Google Spreadsheets and Excel.