This week, I've been busy using Google Docs to create an online spreadsheet that can be updated by our teaching staff at Kings Road Primary School as we begin our Gold Challenge, raising money for Kids Inspire.
What was particularly revealing is that not only does Google Docs allow multiple users to work with the spreadsheets, but it also allows this data to be published in other sites. I played around with using the Graphs function to create a thermometer come totaliser graph as an easy way for our pupils to follow the progress so far and it is this graph that I'm able to publish, keeping all the other sheets containing the names of pupils, private. Essential for any organisation where you don't wish to publish sensitive information.
I've written a news article about the Gold Challenge and was able to insert a live view of the distance achieved so far. I'm really impressed by just how easy this is to achieve. This is a live view of the distance travelled by the staff and pupils in our school, so far.