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.
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.
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.
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.
The sidebar menu in the spreadsheet from the template has a button to “Choose a folder.” Get started by pushing this button.
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.
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.
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.
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.
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://alicekeeler.com/scripts/