post icon

Google Document publishing to html embed

I’m not sure if this is new or just whether I have not seen it before, however, it might prove quite useful for many different purposes.

As some of you know, I’m now working with 10 Year 5 pupils who are currently Level 2-3 in Maths and Literacy. Part of my initial drive (obviously) is multiplication facts and related division facts. I have a little system that I use that seems to get the pupils motivated. I run a Champions’ League. Each child chooses a name for their team. Every few days they complete a speed table and have up to 12 minutes to complete it. If they complete it they record the time taken, if they have spaces left at the end, they record how many spaces they have left after 12 minutes. The pupils get points based on whether they beat their previous record (5 points), in addition, they are awarded 3 points for beating the targets set by me! This is all recorded in a league on a Google Spreadsheet.

This league then displays the current position of progress being made at the level of that child. I asked the pupils if they wanted this displayed on their blog and EVERY pupil was really keen to see it publicly displayed. Here’s the clever bit…

If you click on the ‘share’ option in the top right of the page and select ‘publish as a web page’, you can then change the selection from ‘web page’ to ‘html to embed in a page’. Make sure that ‘Automatically republish when changes are made’ box is checked, embed the code and if you tweak the size down to 210 x 300 you can display a google document that will update automatically in a text widget on your blog.

See this link to see their league table as it stand in a text widget on their blog!

This may have been around for a while but it is the first time I have seen it!

3 Comments

Leave a comment
  1. Mike Reading
    May 26, 2011 at 10:37 pm #

    That’s great…I’ve seen the option but not know what to do with it. Now I need to work out how to make a widget bigger.

    • David Mitchell
      May 26, 2011 at 10:51 pm #

      You could always embed in a blog post or any html space if you need it to be bigger? I only place in a widget to be displayed all the time in the same place so that my pupils can find it quickly!

  2. Simon Hunt
    May 31, 2011 at 11:49 pm #

    I know this is not strictly what this blog post is about, but I have found sumdog.com to be an excellent resource to use with low achieving maths students (and high achieving ones for that matter).

Leave a Reply