Google Docs..Using Forms...

Replies to This Discussion

Permalink Reply by Jason Bostic on November 19, 2011 at 7:51am

Thanks for your response!  I am creating a digital version of our teacher evaluations for our principals to use.  But, I think it could also be adapted for students to give the teacher feedback at the end of the school year.

• ▶ Reply

Permalink Reply by Swati Kakade on November 19, 2011 at 10:08am

I think you need to create the evaluation form in Word and responses sheet in excel then it will be okay.

thanks

• ▶ Reply

Permalink Reply by Jason Bostic on November 19, 2011 at 12:52pm

Thank you.  I forgot to add that I want to be able to use this evaluation form on the iPad.  I have it all set up and am able to complete the evaluations on the iPad its the spreadsheet view on Google docs that I am having trouble with as far as being able customize the spreadsheet.

• ▶ Reply

Permalink Reply by Colleen Young on November 19, 2011 at 3:06pm

As Ilja said - download the spreadsheet to Excel - I always do that. (File, download as...)

Then you can manipulate it in Excel as you want.

• ▶ Reply

Permalink Reply by Steve Guditus on November 20, 2011 at 8:17am

Jason -

I've encountered the same issue with GoogleDocs form - making all information horizontal and difficult to read anything beyond checkmarks.

 

In another forum, an administrator suggested creating just a GoogleDocs document, one per staff member, and have staff members respond to questions and wonders - with only the staff and observer having access.  I thought this was an interesting idea.

 

Great question...please post if you find any other ideas.

 

Thanks,

Steve

• ▶ Reply

Permalink Reply by Jason Bostic on November 21, 2011 at 6:38am

Steve,

 

Thanks for your reply!  Our school will be transitioning over to Google Docs in January.  I'll try creating a form with Documents.  Have a great day!

 

Jason

• ▶ Reply

Permalink Reply by Dergr on November 20, 2011 at 6:21pm

One thing I recently discovered when using forms for google documents is that they have a summary page of your form data.  It has been a real time saver for me, automatically generating graphs which interpret your form data. It might be what you're looking for.

On the spreadsheet of your form go to:

>Form>Show summary of responses 

 

• ▶ Reply

Permalink Reply by Jason Bostic on November 21, 2011 at 6:38am

Yes, the summary of responses is great!  Thanks!

• ▶ Reply