Group items tagged

We've heard many ingenious ways that teachers have used Google Docs in the classroom. Here are just a few: * Promote group collaboration and creativity by having your students record their group projects together in a single doc. * Keep track of grades, attendance, or any other data you can think of using an easily accessible, always available spreadsheet. * Facilitate writing as a process by encouraging students to write in a document shared with you. You can check up on their work at any time, provide insight and help using the comments feature, and understand better each students strengths. * Create quizzes and tests using spreadsheets forms, your students' timestamped answers will arrive neatly ordered in a spreadsheet. * Encourage collaborative presentation skills by asking your students to work together on a shared presentation, then present it to the class. * Collaborate on a document with fellow teachers to help you all track the status and success of students you share. * Maintain, update and share lesson plans over time in a single document. * Track and organize cumulative project data in a single spreadsheet, accessible to any collaborator at any time.

Did you know that you can publish a spreadsheet and embed it in your website or blog? An embedded spreadsheet is a perfect way to display an event calendar, team checklist, or your favorite list of things.

"Save As Doc is a free Google Spreadsheets Add-on that enables you to select a series of adjacent cells and turn them into an easy to read Google Document."

FormEmailer is a Google Apps Script for Google Forms and Spreadsheets. With it you're able to easily set up flexible e-mail merge in your spreadsheets and automatic emailing to your forms. The best part is that you need NO javascript knowledge, and everything is set up in a simple interface.

Recently, we spent time at Google's headquarters in Mountain View, California, talking to some of the folks behind Google Docs & Spreadsheets, part of Google's web-based office suite. We asked the product experts we met for their favourite features that often don't get the limelight or that people simply don't know about. Here are five that we thought were worth sharing:

The link is broken on ZDNet

Correct link: http://goo.gl/uR6wb

"The place where you can easily convert a Google™ Spreadsheet into a set of online flashcards."

Google Spreadsheets adds gadgets that make interacting with data easy and powerful. via Jim Lehrman

Google Docs is an easy-to-use online word processor, spreadsheet and presentation editor that enables you and your students to create, store and share instantly and securely, and collaborate online in real time. You can create new documents from scratch or upload existing documents, spreadsheets and presentations. There's no software to download, and all your work is stored safely online and can be accessed from any computer

spreadsheet art

This is a very cool feature of Google Spreadsheets... try it, you'll like it.

Step 1: Assuming that your already have a Gmail account, go to your Google Contacts and create a new Group (let's say "Media"). Add all the contacts to this group who you want to send a personalized email. Step 2: Create a copy of this spreadsheet into your own Google Docs account. Step 3: You'll see a new "Mail Merge" menu in Google Docs near "Help." Click "Import Gmail Contacts" and authorize Google Docs to access your Google Contacts. Step 4: Click Mail Merge -> Import Gmail Contacts again and type the name of the Gmail group ("Media") that you created in Step 1. Google Docs will now automatically import the relevant Gmail contacts into the spreadsheet.

Import your data from spreadsheets, maintain it with fun tools, share with coworkers and friends, publish to the world. * Create a rich locator application * Create and view sales territories, analyze trends, and evaluate performance by geography with your own data. * Quickly visualize GIS datasets from Shapefiles, MapInfo files * Share geo-data among members of your organization * Geocode lists of addresses via http://googlemapsmania.blogspot.com/2009/09/google-maps-creation-tool.html

Beta is currently free.

To use the GoogleLookup function, enter the following formula in the desired spreadsheet cell:=GoogleLookup("entity" ; "attribute") where "entity" represents the name of the entity you want to access and "attribute" is the type of information that you want to retrieve.

Make a google map or google earth file using Google Spreadsheets. via kkohansen on twitter

You can create a form from the Docs list or from any spreadsheet.

"From search games to presentations on how to use Docs & Spreadsheets with your students, here you can find real-world examples of innovative ways that teachers and librarians are using Google tools to help students learn"

"GTA DC Gadgets One of the highlights of the Google Teacher Academy is Ronald Ho's run through of hidden features in Google Spreadsheets. On the plane home I was thinking about how some of the gadgets he shared and how I could use them with my teachers. Here's a few I came up with."