Google Drive Blog: April 2008

Find out what they're thinking, easily

Wednesday, April 30, 2008

Posted by: We're pleased to welcome back Chris Pirillo for another guest post. After discussing his use of Google Docs to coordinate the Gnomedex conference in his last post, he's here again, this time to offer instructions on how to host a live poll using spreadsheets.

I recorded this "live poll" video after discussing a situation with a few of my chat room moderators. We were trying to come up with a way we could all vote anonymously on an issue at hand. Suddenly, it struck me: why can't a Google Docs spreadsheet form do this? I created the poll, set the options I needed... and the vote was underway. We answered our question quickly and easily - all the while, feeling secure in knowing that none of us were influenced by another's answer.

So, if you want this secure feeling, and instructions on creating a live poll with spreadsheets forms, check out the video, right here:

Introducing Speaker notes and YouTube videos

Friday, April 25, 2008

Posted by: Dave Young, Save as PDFSave as PPT1. Speaker notes for your presentations

2. Inserting YouTube videos into slidesembedded presentation

View your presentations and spreadsheets offline, too

Friday, April 25, 2008

Posted by: Andrew Chang, Marketing Managerinitial offline rolloutlearn moreUpdate

Google Docs makes being green easy

Tuesday, April 22, 2008

Posted by: Matt Doublestein, teacher and earth-friendly Google Docs user
Recently, we talked to Matt Doublestein, who told us about how Google Docs helped him save huge amounts of paper, and go effortlessly green. We were impressed, and figured that there's no better way to celebrate Earth Day than by sharing his inspiring story.

I am a middle school band director. I teach nearly 300 students each day
and have communication with them and their parents - nearly 1000 people in
all.

With Google Docs, my program has reduced its paper use by as much as 90%.

Instead of using hard copies, thousands of times over, we can now set everything up to work online with documents, forms, and spreadsheets. Previously parents had multiple pieces of paper for certain functions. We can now eliminate these by using separate online forms. Rather than going through so many pieces of paper, parents can now just click the next link.

Most recently we have used spreadsheets forms to collect orders for an annual project, a professionally recorded CD of our students' performances, available for purchase. Our greatest goal is simply to pay for the cost of producing the CD, but we do also hope to raise additional funds to support music activities for families that cannot afford them on their own (instrument rental, equipment purchases, cost of band trips, etc.). Parents can now log onto the band website and enter their orders into the online form which dumps right into the Google Docs spreadsheet.

In the past I would spend hours sitting at the computer entering information from paper forms that kids brought in order to keep proper record of orders and money (as required by the state). Now I only have to match check numbers and amounts to what is already entered in the spreadsheet.

Perhaps the best part is that I can share the document with our treasurer and my team teacher so that we can collaborate and error check. Previously, I would have to print off hard copies of everything and then go through it line by line to proof. Now, since I have my spreadsheet formulas in place to do all the math for me, it is a simple matter of sharing the doc with another person to examine areas of concern.

Google Docs "cuts" both ways -- it cuts many hours off of the time needed to compile this information, and it cuts reams of paper from our materials cost.

Inspired by Matt's story? Tell us how you're celebrating Earth Day, with Google Docs or otherwise, on Google's Earth Day '08 site.

Organizing conferences with Google Docs

Thursday, April 17, 2008

Posted by: We're happy to welcome Chris Pirillo as a guest blogger to the Google Docs blog and a featured contributor to the Google Docs Community Channel on YouTube.

I founded, and host, an annual conference called Gnomedex, which brings together tech enthusiasts from across the globe, highlighting present and future trends as we see them taking shape. My wife/business partner helps produce it, and we have just hired an event manager for help in coordinating efforts.

As an integral part of getting an event of this size off the ground, I have a spreadsheet to store conference contacts and budget calculations. With Google Docs, I have been able to share this important info with various associates whenever they need the information. It's much easier than having to look up the accounts one by one, then pasting them over and over again into an email or instant message -- where the information would remain disorganized in any event (no pun intended). Also, keeping them stored online via Google Docs allows me to keep my hard drive cleaner, and not worry about the need to back them up so they are never lost (which would be disastrous when organizing a conference of this size).

Never having to ask if I'm looking at the latest version of a document or spreadsheet in the middle of the inevitable fire drills that accompany organizing Gnomedex? It's a dream come true. I don't have to worry about saving something, backing it up, copying it to multiple machines or anything of that nature. I simply create, save and be done with it.

Sharing achievements cross-country

Monday, April 14, 2008

Posted by: Nick Hodgson, Student, Massey University, New Zealand

We welcome Nick Hodgson: creative Google Docs user, and member of the AIESEC support team at Massey University.

My name is Nick Hodgson and I use Google Docs as a part of AIESEC, a student-run non-profit that develops leadership skills by running projects in which students and businesses from around the world collaborate.

Both my executive team here in Palmerston North, New Zealand, and our national leadership team (based all over the country) use Google Docs to update on our progress each week. Our team has approximately 20 members across the country whom we share the updates with, as well as the contact list for our Local Chapters.

We each update three categories in a shared document weekly: Achieved, Not Achieved, Priorities (goals set that week that are for the next week).

Here's how we create our updates:

We create a separate document for each member of the team.

Each document is shared with all other members.

At the top of each document, we enter the week-ending date, along with the categories Achieved, Not Achieved, and Priorities.

We updated our progress in these three categories throughout the week.

At the end of the week, we each just add a horizontal line (page separator) to the top of the document and start over, again entering the week-ending date, and the three categories.

Repeat, repeat and repeat :)

Here's a sample of a recent week to see how simple and easy it really is.

As you see, it may not be fancy, but it sure is functional. Our entire National Leadership team can easily view what is happening around the country, with everything all in one place. Doing it this way makes it very easy to do quarterly summaries of activity. I know at the end of my term I'm going to find this a lot easier to look at my performance over the year.