Monday, September 21, 2009




Google Apps in the Class: Creating Online Seating Charts

This year is my first year using Google Apps, and I'm discovering new ways to do many things- like the age-old seating chart. When you pass around the old seating chart, students inevitably write their name awkwardly or draw funny pictures, forget to put their name in, and if you don't pay attention, the seating chart gets stuck half-way around the room, and doesn't get completed! No more- I say. Let's fix this with Google Spreadsheets.




The great thing about this is that the actual time it takes students to put in their names is merely minutes. While this may take you a little time to set up, it can last forever (or at least until you move your desks around). If you have a substitute teacher, simply print them out for the sub, or share the link to view the spreadsheet online.

My final seating chart is available to view here:
http://spreadsheets.google.com/pub?key=tx8p65M_2w5zcKjM4Fp3S-g&output=html

Good luck in your teaching practice! I hope this was helpful.

DR
blog comments powered by Disqus