google classroom pull student responses

Google Classroom: Pull Student Paragraphs and Give Feedback

I like to joke that the “Make a copy for each student” option is really the “Make a giant pile of paperwork for yourself” option. When you ask students to use the “Create” button and create a Google Doc or you give them a template on a Google Document you then have to go in and open each student’s individual document. Especially with slow internet speeds, this can be a chore.

I am always asking, how can we give feedback FASTER? Feedback faster is more motivating.

Template

alicekeeler.com/pulltheparagraph

This Add-on script allows you to grab what students wrote into a Google Doc and put all of the responses into a spreadsheet. This allows you to save time from opening each Google Doc individually. Note this only works with text documents, not Sheets or Slides.

pull the paragraph workflow

Add-ons Menu

Make a copy of the template. At the top in the Add-ons menu is “Pull the Paragraph.” Choose Start to activate the sidebar. You will need to authorize permissions. I personally coded this, I have zero access to your documents and files. It is safe to use. 
Add on menu choose pull the paragraph and start

Student Work in Google Drive

If you are a Google Classroom user, when students submit their work to an assignment it is collected in an assignment folder in Google Drive. In other words, there is one folder that contains all the students work for that particular assignment. In Google Drive there is a “Google Classroom” folder. In that folder is a folder for each class. In that class folder is a folder for that assignment. You want to mentally identify what that folder is called.

Sidebar Menu

The sidebar menu in the spreadsheet from the template  has a button to “Choose a folder.” Get started by pushing this button.
Push this button in the sidebar to locate the folder

Locate the Folder

You are identifying the folder in your Google Drive that contains student text documents. Note this will not show you the documents as it is searching for folders only. I number my assignments in Google Classroom which makes it easy to locate folders for the assignments in Google Drive. SINGLE CLICK on the assignment folder.
single click on the folder of choice

Enter Feedback

The Add-on script creates a list of all of the student documents in the folder. Suggestion to RETURN student work in Google Classroom before running the “Pull the Paragraph” Add-on so that student names will be displayed. If students have turned in work, you become the owner and your name will be displayed instead. Returning student work fixes this issue.

enter feedback in column c

The columns to the right show what information the students typed into the Google Doc. You will probably want to make the columns wider and turn on word wrap to make the text easier to read.

Enter feedback for students into Column C. Since all students are in a single list it can be significantly faster to go through each student’s responses and leave feedback.

Send Feedback

After entering feedback into Column C you will want to send the students the feedback. In the sidebar menu click the button that says “Send feedback.” Your feedback comment is copied and pasted into the top of the students Google Doc.

Email Feedback

Optionally you can email students to let them know you left them feedback on their document. Click on “Email Feedback” in the sidebar menu to send an email. Note: If you have not returned the students work in Google Classroom the email address listed in the spreadsheet is YOUR email and the student will not receive the email, you will.

Alice Script Add-On Projects

Find more of my script Add-on projects here: http://www.alicekeeler.com/scripts/ 

Digiprove sealCopyright secured by Digiprove © 2016