Wednesday, May 30, 2012

Managing Google Docs in the Classroom

 "How do I manage my Google Docs with so many  documents coming in from so many students?" 
Google Docs makes it easy for teachers to collaborate with their students and not have to worry about losing their homework, but tracking down assignments can be a nightmare. There are a number of ways to approach this from the teachers perspective and the students perspective here. This is how I manage them  step by step.



Step 1) Students create a new Collection (aka  Folder) for my class and title it: Subject - Name
For example: Science - Johnny

Step 2) Students then share the Collection/ Folder with me.

Step 3) I make a new Collection/Folder called Period 2 or whatever makes sense. Find the student Collections (in the lower left under Collections shared with me) and drag them to my newly created Collection.

Step 4) Click here to copy the Assessment Collector Google Spreadsheet
(You must be logged into your Google Account).

Step 5)  I embed this Google Form into my class website.
Don't have a website yet? Think about using a student as a webmaster.

Step 6)  Once I've edited the names of the assignments and students have copied and pasted their  links, I can filter the list by period or assignment.


Then I can use the built-in Viewer tab. (You may see a button asking you to load the tab).



This tab allows me to view, comment or edit the Google Doc, Spreadsheet or Presentation 'handed in' without ever having to leave the window. I can then click NEXT through all the collected  assignments.

An important aspect of this process is that the students are sharing work in a way that teachers can edit while simultaneously building their own collection of assessments.



Optional
Step 7) One limitation of the viewer is that it only reads URLs that begin with http not https. You can use the built in Find and Replace feature or if you're a little adventurous, set it up a script to do it automatically. The script is included in the spreadsheet, you just have to turn on the Form Submit trigger.

Step 7a) Select Tools > Script editor
Step 7b) Select Resources > Current script's triggers...

Step 7b) Click the link No triggers set up. Click here to add one now.
                      Change On open to On form submit and click Save


Step 7c) Click Authorize > Click Close and Exit that tab.



This means whenever a student copy and pastes a URL that starts with https it will replace it with http.

[Printable version of these steps HERE]

To learn more about managing Google Docs in the Classroom (and to see Kern Kelley speak) come to the Google Apps for Education Maine Summit on August 17 & 18, or to a summit in a region near you.


37 comments:

  1. Thanks for the post. Well I am a teacher in Dubai, It's such a nice way to incorporate using Docs in schools. Well, I am also planning to start such a session in my class but with Google docs there is this problem of sharing our spreadsheet online but how do we hide a column from someone who has the access to edit? Anyone can just unhide the column and see all the data along with your tiny internal notes. Recently a colleague of mine shared about this tool called CollateBox http://www.collatebox.com/ which allows to share just parts of spreadsheet data.

    ReplyDelete
  2. Seriously helpful. I have Google doc files from students I taught four years ago. Need to clean house and keep it from happening again!

    Thanks!

    ReplyDelete
  3. Thank you for the cool tip. I love pure Google solutions. We are working on a more complete solution at our school board. I suggest you try Edmodo it has «Google docs integration» and is a great way to manage and grade assignments. The idea is for the teacher to post the assignment in Edmodo and the students use Google Docs to do the work. We are in a test phase so I cannot say if I am a fan or not. Try it...it is free.

    ReplyDelete
  4. This comment has been removed by a blog administrator.

    ReplyDelete
  5. This comment has been removed by a blog administrator.

    ReplyDelete
  6. Google doc is a great application that enables the students to manage their class assignments properly.
    essay service

    ReplyDelete
  7. Amazing Blog Post. Blog Post provide acceptable obsession. The offer impacts on numerous standard worries of your brain..
    Essay Writing Services Pakistan

    ReplyDelete

  8. Academic is the route and it is the clarification for all kinds’ examine and advance to make consciousness for students with assignment writing help can fulfill the best edification need with a superiority is imminent.

    ReplyDelete
  9. This comment has been removed by the author.

    ReplyDelete
  10. Teachers and Student can get full co-operation in their assignment work, it is the best factor to get assignment service UK student to support them in quality and professional writing from expert writers.

    ReplyDelete
  11. What an interesting way for teachers to be organized! Students can welcome this organization with an online custom assignment writing company!

    ReplyDelete
  12. I am so thrilled and your blog is so remarkable. Stay ups the superior work and credit for allocation this editorial.... Order Coursework


    ReplyDelete
  13. This comment has been removed by the author.

    ReplyDelete
  14. I've wrote about this a year ago - I use(d) google forms to keep student work organized. Here is what I said: http://bit.ly/1syYZAl

    Doctopus is also a great add-on to google docs that helps keep you organized.

    ReplyDelete
  15. Not sure why that link didn't turn into a link, here is the original url:
    https://talesofan8thgradenothing.wordpress.com/2014/01/27/staying-organized-using-google-apps-for-ed-in-the-classroom/

    ReplyDelete
  16. Mobile phones prices are here
    www

    ReplyDelete
  17. Magnificent blog. Appreciation for distribution such a pleasant blog. I truly enjoyed understanding it excellent effort..
    hr research paper help :: Do my research paper

    ReplyDelete
  18. Thank your post. It is a very useful information with everyone....Love it. keep posting
    ---
    Signature:
    i like play games descargar whatsapp gratis | descargar whatsapp plus| descargar whatsapp

    ReplyDelete
  19. Good work always appreciable and you did the same. Really appreciate your work.

    ReplyDelete
  20. My partner and I stumbled over here from a different web page and thought I might check things out. I like what I see so now i am following you. Look forward to going over your web page repeatedly.
    sales training Sydney

    ReplyDelete
  21. Never seen these kinds of great informative collection on a same website. Glade I found it.

    ReplyDelete
  22. I dont think no one has seen this information before. Really great information.

    ReplyDelete
  23. After reading this kind of helpful information. Hats off to those who shared this.

    ReplyDelete
  24. Thanks for this information you shared with us, its really helpful.

    ReplyDelete
  25. I am glad I found this website because it has great information for everyone.

    ReplyDelete
  26. First Time when I seen Google Doc.. I am really confused.. But you are giving right tutorials with images.. Thanks for adding valuable information.

    ReplyDelete
  27. Google docs is an excellent thing to learn and practice .Its of essence to get higher qualification as its tough to find good jobs . if you only have work experience but no degree to go along with it then you should go for online life experience degree program that provides highly recognized and accredited degrees only based on your prior work experiences.My friend also got the degree in Business Management.

    ReplyDelete
  28. Segala informasi yang diperlukan nantinya ada di Blog Pertanian ini, kami juga tidak menutup kemungkinan untuk menerima saran dan masukan dari pengunjung blog ini untuk menampilkan suatu wacana tentang masalah yang sekiranya sangat berguna. atau Anda juga bisa gabung layanan kami yang lain seperti: distributor pulsa salam sukses ?

    ReplyDelete
  29. Thank you very much! My friends and family members will be happy after hearing about this
    jam tangan online murah
    jam tangan online

    ReplyDelete
  30. Things are very open and intensely clear explanation of issues. was truly information. Your website is very beneficial.
    glenn colton
    pretty social
    jual jam tangan

    ReplyDelete
  31. Thanks for Nice and Informative Post. This article is really contains lot more information about This Topic
    hidup sehat alami

    ReplyDelete
  32. I dont think no one has seen this information before. Really great information.


    Cara belajar Bisnis Online
    Jam Tangan Online Murah

    ReplyDelete