Embedded Files
Please go to this link, and open the spreadsheet using your Google Docs account.
Then, press file, make a copy, and you will make a copy that you can use.
https://docs.google.com/spreadsheet/ccc?key=0AjBRmhn9YDdTdDBZRWowVE1pbHF4bklIYjB4MDhKRVE&usp=sharing
Note, if the button “Make a copy” is greyed out, you need to log into your Google account first.
What you have currently should be an expansion of the first Exploratory Homework. Instead of having just 5 students, we expanded it out to 90 students. We would like to clean up this gradesheet to only display “what’s important”, as with so many students the data can be quite confusing. Of course, “what’s important” may change depending on what your current needs are.
Your page should currently look something like this.
<Click on me to make me bigger>
However, that’s a lot of numbers, and, if we care about looking at how people did, we definitely don’t need the clicker raw scores (Clicker 1, Clicker 2, Clicker 3), since we have their points calculated based on their raw scores. How about we clean it up by hiding them?
To hide the column, we just need to right click on the top of the column and press Hide Column. So let’s do that with Clicker 1 (Column F).
Once that’s done, let’s hide Column G and H as well, since those clicker points are also in the same boat.
Your excel sheet should look like this right now.
<Click on me to make me bigger>
Notice how even though Column F, G, H are gone, Column I isn’t renamed as Column F and so forth? Hiding a column or row only prevents the user from seeing it. It is still there in reality. The main focus of hiding a column is for human users to have a simpler time reading large data sets. Human brains have cognitive limits – and research shows that reducing the cognitive “load” (amount of things you need to attend to and deal with) improves humans’ ability to process and analyze.
Now what if we need to unhide those columns again? Sometimes, some formula could rely on those columns, and therefore they might need to be changed for whatever reason. The good news is… unhiding the columns is just a quick and painless 1 click process!
Between E and I, there are two arrows, one pointed at E and one pointed at I. Just click on that arrow and boom, all the hidden columns will be unhidden again.
Page updated
Report abuse