Google Tools

Use Google Scripts to organize student work and give timely feedback

Google Scripts are add on features in google documents or google drive

To access Google Scripts create a spreadsheet from Google Drive and go to Get Add-ons…

Please Note Some Tools Require Old Google Sheets. Just click g.co/oldsheets

______________________________________________________________________________________________

gClassFolders:  is a free, Google-Spreadsheet-based add-on for Google Apps for EDU that create electronic portfolios or class folders for students and teachers. This simplifies and streamlines your experience using Google’s productivity and collaboration tools in the classroom.  Trial and Error Tips (Many thanks to Nicola Onnis who also helped test these tools) Currently Requires Old Sheet (Just click g.co/oldsheets) but is expected to work with the new one soon.

  • I use G-class Folders as an electronic student portfolio that won’t get lost. Students do not have the rights to delete the folder (Only you can do this). It is an time saving method to have students submit work to this folder. If you use other scripts like Doctopus you can automatically put assignments for students to complete into their folders.
  • To set this up quickly create a Google Form to capture student data. Ask for First Name, Last Name, Google E-mail, and class period. You can copy this data into a new spreadsheet and run the script.
  • More Information and Resources  http://www.gclassfolders.com/ (G-Class Folders) https://www.youtube.com/watch?v=A6dr9lcfKUU (G-Class Folders)

Each Classroom set up a Teacher, Class Edit, Class View, and Assignment folder.  

______________________________________________________________________________________________

Doctopus is a document management script for student projects in Google Docs. Written by an educator for educators, the free Doctopus script gives educators the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects. This works with the new or old sheet.

Tips:

  • Using Doctopus allows you to automatically name and put assignments into each student’s GClass Folder. This is great because you don’t have to worry about students not attaching a file or naming a file correctly.
  • If you use Doctopus with an assignment you can attach a Goobric (Rubric). This will let you grade and give comments on assignment. These comments will be automatically sent to the student.
  • You can lock and take away editing privileges from a student if you use doctopus. I have been using this to see multiple drafts of student writing. For example on my last essay students had three files a draft 1 (Locked with comments only no grading, i like this because my comments will never be deleted), draft 2 (revised with comments, highlighted accorded to checklist, graded by me), and draft 3 (open until the end of the grading period so that students can always submit revision.
  • If you use Doctopus it will automatically create an assignment folder. You can download this file as a ZIP and Print all of you student essays at once. My students do not all have access to internet at home. I like to print their draft 1 with my comments so that they can revise at home. Also i keep student portfolios i enjoy allowing my students to place a printed copy into their portfolio if they wish.

More Information and Resources

______________________________________________________________________________________________

Goobric is an rubric extension for Doctopus.  You have to download Goobric from the Chrome Web Store–as circles here in a Google Chrome Browser. Once in the Chrome Web Store, search for Goobric and download the extension to your Google Chrome browser.  When available for use, Goobric’s eye will display within the web address bar.

  • Tips: When you grade using goobric the scores and comments are automatically added to a spreadsheet. Synergy does not allow me to easily see growth between drafts/ revisions. I enjoy having this data in a easier to use method.  When you grade using goobric your score and comments are automatically e-mailed to the student.
  • More Information and Resources: https://www.youtube.com/watch?feature=player_embedded&v=T_5Kx9j35YM

______________________________________________________________________________________________

autoCrat Script helps you automate the creation of personalized documents and emails from a google form.The autoCrat Script was written to be a multi-purpose document merge tool that allows you to take any personalized, row-based spreadsheet data and create, save, attach to email, and share templated documents.Use cases: socratic discussion feedback, writing workshop, classroom observations, sending out certificates, getting student feedbackhttp://www.youpd.org/autocrat // https://sites.google.com/a/atwoodphoto.com/sandbox/googleapps-scripts/demo-slam

______________________________________________________________________________________________

Flubaroo helps you quickly grade multiple-choice or fill-in-blank assignments automatically using Google Forms. This script was also written by an educator for other educators and in addition to automatically grading, Flubaroo also computes average assignment score, computes average score per question, and flags low-scoring questions. It can show you a grade distribution graph and gives you the option to email each student their grade, and an answer key.  http://www.flubaroo.com/http://blog.synergyse.com/2013/07/synergyse-top-10-google-apps-scripts-for-education.html#sthash.DZtHtV5f.dpuf

______________________________________________________________________________________________

Form Folio: Great for auto-organizing and managing ownership of student or teacher artifact submissions. Can function like a dropbox, allowing users to add or copy Drive resources via form to folders they otherwise cannot access. http://cloudlab.newvisions.org/scripts/formfolio

______________________________________________________________________________________________

Lessons Learned when Using Google Documents to Give Feedback

  • Providing Comments
    • If a student has editing power comments on the side can be resolved and deleted by students. To solve this problem i have tried to embed comments in text or lock their first draft and take away editing rights so that my comments are permanent.
    • If a student comments in the side with a question there is a setting to have it automatically e-mailed to you. Through your email you can reply to the comment. It will be embedded in the students google doc. This is a huge time saver and allowed me to give more feedback throughout the writing process.
  • To have students demonstrated understanding
    • I have had students self-grade and highlight according to a revision checklist. I ask the students to write a comment in the side to identify how they met the learning target
    • I have had students demonstrate understanding using google forms. I have created a form that asks students to copy their thesis, hook, evidence, analysis, etc. I like using this tool because it automatically complies responses. When it is time to do a revision lesson the best student models are already pulled out to show with the class.

______________________________________________________________________________________________

Other Resources

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>