Edit 26/10/2016 – Please also look at a more recent addition to this post – https://davefoord.wordpress.com/2016/10/26/automatically-pull-an-entire-sheet-of-data-between-google-spreadsheets/
I have been using Google Docs for quite a few years now, and in particular Google spreadsheets.
One feature of Google spreadsheets is there is a function called ImportRange that allows you to pull data out of one sheet and into another. This can be really useful, if for example you have a spreadsheet that you are using to collaborate with others, and then somewhere along the line you want another person to be able to see some of the data in the sheet but not all of it. e.g. if you are using this to track student grades, you could have a master sheet that you and other tutors can see all of, you could then create a separate sheet for each student, and pull through only the data that refers to them (you then share that sheet with the student) and they have a live constantly updating record of what they have achieved etc.
Or you could have a mechanism where each subject tutor has their own spreadsheet to record class grades, then the course leader has another sheet which pulls all of this data into one place, so they can at any point in time see how the class is doing without having to ask tutors to email over their latest version of their standalone spreadsheet (which I see happening all to often).
Here is a video showing the basic principle of this idea.
Filed under: CPD and reflective practice, e-learning, Excel, google, How do I...?, social software (web 2.0) | Tagged: across, another, data, google, grades, import, importrange, move, one, pull, range, Spreadsheet, workbook | 287 Comments »