• Technology Toolkit

    Technology Toolkit: Introducing You To Web 2.0 is a book I and Gary Bass authored. If you're interested, click on the image for further information and an order form.
  • Categories

  • Where Are You?

  • My Latest del.icio.us Links

  • RSS My Posterous Posts

  • Downloads

    Click on the link above to access support documents about blogging and other things Web 2.0
  • Archives

  • Pages

  • QR Details

    My QR Code Details

I’m Going Google Over The Spreadsheet

It has finally happened, Google has included a graphing function in their Google Docs Spreadsheet and it is pretty cool indeed. The spreadsheet has always been pretty neat to use but now with the this latest function things have really stepped up a notch. One thing that is quite attractive for me as a teacher is that it doesn’t have all of the “bells and whistles” of the commercial alternatives. This means that my students are not distracted by making lots of cosmetic changes instead they can better concentrate on the task of dealing with the data.

Just because it is simpler though doesn’t mean it only has basic functionality. Using the Tabs you can do simple sorts, freeze frames, add formulas and best of all graph your work choosing from a range of basic graphs. The graphs are dynamic too, changing as the data is modified, nice.

Now all I need to know is how I can embed them into a blog, (though I’ve looked around I can’t seem to find how you can do this and ‘cos I’m off to bed that will have to wait for another time :) . Click the pic though and you can see my test.

google.jpg

One Response

  1. “Now all I need to know is how I can embed them into a blog”
    Go to the “publish” tab (upper right).
    Click “more publishing options”.
    Under the format selector – choose “HTML to embed in a web page”
    Choose the other options you want – and “Generate URL”, which, in this case generated HTML you can copy and paste in your blog…

    You can easily publish a chat only by selecting the range of cells which encompass that chart ….
    A hidden option is to turn grid lines off by adding &gridlines=false to the URL…
    Have Fun!

Leave a Reply