This is an add-on that will allow you to see all of your students google doc written assignments in one
place without opening each of them individually AND let you easily provide written feedback to them.
I have had several teachers tell me that one issue they have with using Google classroom with assignments is
that it takes too long to open each student’s document to look at it and make comments. 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. The add-on was created by Alice Keeler, but it has not
been formally added to the list of Google add-ons at this point, but the steps below will show you how to get it
and start using it with your Google Classroom assignments.
Step 1: Create an assignment in Google Classroom
The first thing you need to know is that this only works with Google text docs (not with sheets or slides). Create your Google Classroom assignment and either give each student a copy or allow them to upload a google doc to the assignment. Again they have to do the assignment in Google Docs.
The first thing you need to know is that this only works with Google text docs (not with sheets or slides). Create your Google Classroom assignment and either give each student a copy or allow them to upload a google doc to the assignment. Again they have to do the assignment in Google Docs.
Step 2: Download the Pulltheparagraph template
Since the add-on itself is not one that you can get yourself through the normal method, you will need to make a copy of the template created by Alice. Here is a link to make a copy for yourself to use: [Make a copy of the template]. This sheets document will have the add-on already set up. You will use this document every time you want to see student work and leave comments for them.
Since the add-on itself is not one that you can get yourself through the normal method, you will need to make a copy of the template created by Alice. Here is a link to make a copy for yourself to use: [Make a copy of the template]. This sheets document will have the add-on already set up. You will use this document every time you want to see student work and leave comments for them.
Step 3: Run the Add-on
Open the Pull the Paragraph Template. Go to the add-ons menu and choose “Pull the Paragraph” then “start”. You will be asked for authorization, choose “continue” and then “allow”.
Open the Pull the Paragraph Template. Go to the add-ons menu and choose “Pull the Paragraph” then “start”. You will be asked for authorization, choose “continue” and then “allow”.
- On the right side you will see a button that says “Choose a folder”. Click this button and ”select folder” to choose the folder inside your classroom folder that has the assignment in it. Remember every assignment you make in Google classroom will automatically have a folder created for it inside your Classroom folder.
- You will be given a reminder that you can provide feedback in column C. Click “Ok”. The sheet will be created in which each row represents the work typed by a student.
- Scroll through the document to read each paragraph they typed.
- When finished add your comments in column C for any student you want to provide feedback. This feedback could include the grade you have given them.
- When all the feedback has been added, click the “Send Feedback” button on the right. This will add your feedback to each student's document.
Step 4: Return the student work
In order for the students to see your comments, you will need to go back into Google classroom and return their work.
For more helpful information and the archive of previous Check This Out! Digests, go to http://www.greenlocalschools.org/technology.aspx In order for the students to see your comments, you will need to go back into Google classroom and return their work.
