Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Save Hours: Pull The Tables

Pull the Table Google Docs Add On by Alice Keeler
Save Hours: Pull The Tables
Pull the Table and save hours

Pull Student Responses From a Google Doc

I’ve said many times, I would rather hit myself in the head with a brick than open 30 Google Docs (or Slides, or Sheets…). My rule of thumb is to only assign individual student work that I have to open 20% of the time or less. For those times when I do need individual student docs I try to let coding make the workload lighter.

Math Recess Online WOrkshop
alicekeeler.com/goslow

Template

alicekeeler.com/pullthetable

Previously I had created alicekeeler.com/pulltheparagraph which will take a folder of your students Google Docs and pull the paragraphs of text out of each Google Doc and put them into a spreadsheet as if all your students had filled out a Google Form. You then give feedback in the spreadsheet and push the feedback back to the Google Docs without opening any!

However, Pull the Paragraph does not work with tables. Pull the Table solves this problem.

Create a Google Doc with Tables

When creating a Google Doc that students will fill out digitally you do NOT use the underscore key to make lines. ______________ This is what we do when the intention is to print the document. For digitally responding to a question in a Google Doc, use a table.

For your template that you push to each student use a table to ask students to respond to the question.

Note: Do not put the question in a table unless you want the question to be pulled into the spreadsheet.
Note: Do not make tables with multiple rows and columns.

A Folder in Google Drive

For Pull the Table (and Pull the Paragraph) you will need all of the student Google Docs in a single folder in Google Drive.

Google Classroom

The easiest way to make a copy of the document for each student is to use Google Classroom. Not only does Google Classroom create a copy for each student and puts their name on it, it organizes all of the students’ documents into a folder in Google Drive.

Sample student Google doc with boxes filled out.

Add-on Menu

After assigning the Google Docs to the students and students have filled in the boxes, create a copy of the spreadsheet template. Wait possibly about a minute for the code to load in the spreadsheet. Go to the Add-on menu and choose “Pull the Table.” Select “Show Sidebar.”

Pull the Table from the Add-on menu

Authorize the Add-on Script

I have not (and probably will not) submitted this Add-on to Google to add to the Chrome Webstore. A pop up will warn you that this Add-on has not be reviewed by anyone at Google. You may see a button that says “Return to Safety.” DO NOT CLICK THAT. Instead, click on the tiny words “Advanced” and then click on “Unsafe” at the bottom. IT IS SAFE I CODED IT MYSELF. You need to authorize YOURSELF access to your Google Drive and documents.

Choose the Folder

Click the button in the sidebar that says “Choose folder.” You will locate the folder in Google Drive that contains the student Google Docs. Single click on the folder, remember you are selecting the folder not the files within the folder.

Wait For It

The spreadsheet will populate with each students responses from each of the answer boxes.

Spreadsheet of students responses in one spot

Give Feedback

You can read student responses horizontally, each box response in it’s own cell in the spreadsheet row.

In Column C is a spot for you to give overall feedback.

Note: This Add-on does not currently allow you to provide question specific feedback. If you need to insert feedback on a particular question there is a link in the spreadsheet to make it easy to open the student’s Google Doc and insert comments.

Send Feedback

Use the Add-on menu to choose “Send feedback.” This will push your feedback from the spreadsheet to the students’ Google Docs.

Top of the Document?

You will be prompted as to if you want your feedback pushed to the top of the document.

If you click the “Yes” button the feedback will append to the TOP of the students’ documents. If you select “No” the feedback will append to the BOTTOM of the students’ documents.

Instructor feedback at the TOP of the Google Doc

Email Feedback

Students will not know you have left them feedback unless you let them know. Use the Add-on menu to choose “Pull the Table” and “Email Feedback.” This will send an email along with the feedback in the email and a link to the Google Doc to the student.

Caution: If students have “Turned in” in Google Classroom you are the owner of the student documents. When you ran “Pull the Table” it pulled in your email address because you are the owner. Be sure to RETURN the student documents before you Pull the Table so that the student in the owner of the document.

12 thoughts on “Save Hours: Pull The Tables

  1. This looks amazing but my only question is how to make only one border show up in tables in Google Docs. I’ve always had to resort to Word when I wanted to do that. Is there something more advanced than the ‘Table Properties’ found by right-clicking?

  2. OMG, this is like MAGIC! I can’t wait to try it. Over Spring Break I had to grade over 250 paragraphs from tables. Thank you, thank you!

  3. I’m so thrilled to have found this! My colleagues and I are grading learning targets to show mastery in standards-based-grading and it’s taking FOR-EV-ER! Is there a way to add parameters into the code that would allow me to select column/row, so ‘Pull the Table’ will work with multi-column/multi-row?

  4. This looks great! It looks like it will save loads of time. I am having trouble finding the add-on to be able to use it. I have looked under Add-ons, and in the G Chome Webstore, though I did see that you said you had not submitted it there. Any ideas?
    Thank you.

  5. Hey Alice, could you move the disclaimer reminder to return your student documents back to students before running this add-on to the TOP of this post? I made this mistake and I know I will make it again if I use your add on in the future (I definitely will). Thanks! Great stuff!

    1. Ha won’t matter where the disclaimer is. I make that mistake often myself. Once I run the script and see it put me as the owner… I return and then rerun the script in the same Spreadsheet

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.