Web Trends & Strategies

To enter our Discussion Space, simply go to:

http://www.calt.insead.edu/eis/EagleRacing/WTS

During the last simulation round, Shashank invited his group to a gather the different views in a more efficient way.

---

For those who always want to know “How did he do it? How could I do it too?” here are Shashank’s enplanations. Thanks a lot!

Introduction

Using Google docs is very easy and intuitive. In the following note I explain how to create a new Google online spreadsheet and then set it up to receive entries automatically using a form that you can embed into an email or publish on the web. The end result is a simple system that allow different users (some of whom may not be super Google docs savvy) to add information to your spreadsheet using a simple form.

Get Started

1. The very first thing you want to do is get a Google account. You probably already have one. If you don’t you should ask yourself why don’t have one! Just get one, believe me, it’s worth it.
2. Now having created your handy-dandy new Google account, navigate to docs.google.com and login and answer their fairly simple startup questions.
3. You are now ready to create your first spreadsheet. Click the New menu on the top left in Google Docs and choose ‘Spreadsheet’.
4. You are now presented with a spreadsheet which looks much like Excel. Name your columns and then name and save your spreadsheet.
5. When satisfied with the structure of your spreadsheet, i.e., the data fields you want your collaborators to fill out, click on the Share tab on the right.
6. Use the Invite people feature and check the ‘to fill out a form’ checkbox. At this point you will be prompted to add some text to introduce your teammates to your form. Provide this information, and then choose who you want to send this to by typing out their email addresses.
7. Send the invitation and you’re done! Your team can directly fill out the form using the email or alternatively navigate to the link provided in the email and fill out the form online.
8. Navigating to the very same link will also show you the current responses.

References

http://computerworld.com/action/article.do?command=printArticleBasic&articleId=9001087

http://googledocs.blogspot.com/2008/02/stop-sharing-spreadsheets-start.html

Here is his original email as an example: