If you are feeling confined by how tables render on a wiki page to display teacher-created content, you can make a spreadsheet in Google Docs and embed it. For a sample, click here.
This takes a few steps and assumes that you already know about how Google Docs works, but it can be useful!



Create Your Spreadsheet



  1. Go to http://docs.google.com and log in with your Gmail account name. Make an account if you don't have one. (Google Docs limits users to those aged 13 and above.)
  2. Click on NEW > SPREADSHEET and create your spreadsheet. (Search for google spreadsheet tutorials online to find tips).
  3. When you are done making your spreadsheet, click SHARE in the top-right corner of the page and select PUBLISH AS WEB PAGE.

Get Your Spreadsheet Ready for Publication

  1. The PUBLISH AS WEB PAGE menu pops up. The bottom half of the menu will be blank.
  2. In the top half of options, select what to publish: Unless it's a complicated spread sheet, pick SHEET 1 from the pulldown menu.
  3. Click "Automatically republish when changes are made." This means that every time you update your spreadsheet in Google Docs, the new data will show up automatically on your wiki page.
  4. Click START PUBLISHING.
  5. This will make the bottom menu options become active. Now you have a few more options to select. As shown in the screen shot below, select HTML TO EMBED IN A PAGE in the top pull-down menu. In the second menu, it should have changed to reflect your option in Step 5 above (e.g., SHEET 1). If not, change as needed. In the third menu, you will type the range of cells you want to display. For this example, there are three columns (A, B, and C) and three rows (1, 2, and 3). So the range of data is from box A1 to box C3. You would express that range in the third box by typing A1:C3 . In the screenshot below, I decided to extend the range from A1:C50.

Slide1.GIF
Now you will see a bunch of weird codes show up in the bottom box. What you're seeing is the behind-the-scenes Web commands, known as HTML, that tells your wiki where to go and find your Web page. It will look something like this:

Slide2_final.GIF
The beginning of the code, where it says "width" and "height," tells your wiki how big to make your spreadsheet show up. 500 pixels wide and 300 pixels high will work, but it really isn't going to fill the page. So we're going to alter the width and height of the spreadsheet by adjusting those numbers in the code, like this:

Slide3_final.GIF


The Home Stretch! Getting and Inserting the Embed Code


  1. Now copy that code (highlight and CTRL+C) and go to your wiki page.
  2. Click the EDIT THIS PAGE button.
  3. Click the WIDGET button.
  4. From the options in the left column of the WIDGET dialog box, pick OTHER HTML.
  5. In the box, paste in your code.
  6. Click SAVE.
  7. Voila! Your spreadsheet now appears right in your wiki page with the column widths and row heights you specify. (See our sample here.) And, even better, every time you change the spreadsheet in Google Docs, it will be updated on your wiki page, too!