Using Google Docs Forms and Spreadsheets to Document Classroom Visits

Web 2.0 Tools & Tips
Publish date:
Social count:

Google Docs spreadsheets have a feature that allows you to capture information in a web form, and instantly add that information to a spreadsheet. I have been using a Google Docs spreadsheet to keep track of classroom visits and observations. With the form feature that Google as added to Google Docs, it is now very easy to create a form for collecting and analyzing data. I have replicated in Google Docs an observation form I use to to note classroom visits. I try to visit each classroom at least 2 times a week for an extended period of time. During these visits I note the subject matter being taught and the methods being used, I also have a space for notes and comments. With the web address of the form bookmarked on my phone, I can easily pull up the form interface and add the data. Once I submit the form, the information is automatically entered into my spreadsheet. Google has also reacently added an analysis feature to Google Spreasheets, and I have instant access to all kinds of charts and graphs that visual help me to keep track of my classroom visits and the subjects being observed. In an upcoming post I plan to talk more about this form feature and how students and teachers at my building are using it to gather and analyze information.



Google Docs

Tip: Google Docs is an easy-to-use online word processor that enables you to create, store, share, and collaborate on documents. You can even import any existing document from Word and Simple Text. You don't need to have the same program on your computer. You can work from anywhere to access your documents. As

Using Web Forms on an iPhone

I recently purchased a new Smart Phone — of course for use as a mobile phone, but also as an Internet device. I have owned various Smart Phone devices including those from Palm and those under the umbrella of Windows Mobile. This time I decided on an iPhone. I did it for a number of reasons, but mainly I wanted

Web-based Spreadsheets

Tip: Have you wanted to be able to create and share a spreadsheet — online? "Num Sum" is a Web-based spreadsheet application with many of the same features as Excel as well as with some pretty cool social aspects tied in. This means you can share progress reports, track reports, or do any other number of

Share Spreadsheets Online

Tip: Google Spreadsheets is a Web-based spreadsheet product that makes it easier for people to create and share spreadsheets on the Web. It enables people to create simple Web-based spreadsheets that others can simultaneously update from their own computers. You must have a Google or Gmail account to sign up for

Getting Good With Google Docs

--> from Educators' eZine I have been using Microsoft Word for decades. There have been passing relationships with Clarisworks and WordPerfect, but for all its flaws MS Word has stood the test of time and seen me through hours and