Q&A Session for Managing Google Docs with Your Classroom

March 8, 2011 5:00PM/8:00PM ET

Q: We're looking at an iPad pilot and use Google Apps for Ed. I'm a little concerned because Google Apps still seems to have some issues when editing on an iPad. Do you know if this is something that will be improved soon?

A: Mobile editing is definitely important to our engineers - we just released mobile editing in 45 languages for Google Docs! In 2010 we had over 200 features/updates to Google Apps and I'm sure mobile editing will be a big improvement in 2011!

________________________________________________________________

Q: Can we using Google Spreadsheets as a database to query? If posible, how to built such type of forms in google spreadsheets.

A: Your Google Spreadsheet can be "Published" as an RSS feed which could be used to query. However, it does not create another kind of typical database file.

________________________________________________________________

Q: When sorting can you click on the very top left block to highlight all like you can do in Excel?

A: Yes, you can click the the column to select all.

________________________________________________________________

Q: How to create a QUERY form where someone can enter school ID and get his information from the spreadsheet.

A: Unfortunately, I'm not familiar with this syntax. I imagine you could publish the spreadsheet as an XML, HTML, or CSV file and write a query to reflect the syntax published.

________________________________________________________________

Q: I was running into problems with freezing rows when I had merged cells.  How can I get around this?

A: Merged cells can cause problems as it's hard to determine which row/column it should be associated with. If you need to freeze rows, I would recommend not merging the cells...

________________________________________________________________

Q: I have no problem editing Google Apps on an iPad, but I think there may be some problems when it is in a Google Apps for Education domain. Haven't checked lately.

A: It shouldn't matter if it's an Apps account or a regular Google Account... Hopefully you are not experiencing any issues.

________________________________________________________________

Q: can you embed a spreadsheet into a google doc?  Say a student group lab report in google docs, and they want to embed a google spreadsheet into that doc?

A: It's not possible to embed a spreadsheet, however, you can use the "Web Clipboard" to copy the cells, then paste it into the Google Doc and it will maintain a table format... For more information: http://docs.google.com/support/bin/answer.py?answer=161768

________________________________________________________________

Q: Revision history always scares me. If I revert to an earlier version, and then realize I didn't

A: Yes, you can still "revert" to any version.

________________________________________________________________

Q: One reason to publish just one tab of a spreadsheet is if you want to provide info, like how many seats are left in a workshop and not publish the list of participants. Or the highest bid for a silent auction (like eBay) for a school fundraiser.

A: Great idea, thanks for sharing!

________________________________________________________________

Q: Also, how about embedding a chart made from a google spreadsheet into a google doc?  possible?

A: You can save the chart as an image file and upload the image.

________________________________________________________________

Q: Revision history records anything that has been changed?

A: It records just about everything, especially related to content/text changes. For more information see: http://docs.google.com/support/bin/answer.py?hl=en&answer=190843 

________________________________________________________________

Q: Does the 50 simultaneous collaborator limit apply to Google Apps in Education?

A: Yes, it does apply.

________________________________________________________________

Q: Sorry, but I missed the self grading quiz.  Where do I find that once I am in the Teacher section?

A: The easiest way is to search in the Template Gallery for self grading quiz.

________________________________________________________________

Q: pivot table feature someday?

A: There is a pivot table gadget available to use.

________________________________________________________________

Q: will you demonstrate a live google search in a spreadsheet?

A: To use the live google search, you can use the “Google Lookup” function. For more information see http://docs.google.com/support/bin/answer.py?hl=en&answer=54199 

________________________________________________________________

Q: Does the 50-user limit just mean simultaneous users ... meaning if someone leaves/closes the document, someone else can get in?

A: Yes, you can have up to 200 editors or viewers individually for a document, but only 50 can be simultaneously editing at the same time. For more information on sharing limits see http://docs.google.com/support/bin/answer.py?answer=182027 

________________________________________________________________

Q: Does the create form automatically put responses in the excel?

A: When you create a form in Google Docs, it automatically inputs the results into a spreadsheet in Google Docs. If you need to, you can then export the Google Docs spreadsheet into the excel file format, or you can edit the spreadsheet directly in Google Docs.