Tag Archives: script

Google Sheets: Students Send Tab of Work to Teacher

One of my favorite tools to teach with is Google Sheets. I create spreadsheets to crowd source information from students, which gives all students 30x more research information to work with. I create spreadsheets to have class discussions. This gives every student a chance to voice their ideas and for students to hear from everyone. […]

Read more

Google Apps Script: Debugging Tips from Alice

This week I worked on several Google Apps Scripts projects. Part of coding is failing. You write your code and cross your fingers. Most likely there is something that needs to be “debugged” or fixed. Productive struggle is highly motivating. With programming, you have an end goal and something functional after you get your code to […]

Read more

Google Classroom: Creating a Discussion Board

While I want threaded discussions in Google Classroom, I do not want them in the stream. Multiple student responses will clutter up the Google Classroom stream quickly. I always say “the answer is always a spreadsheet” so I created a way to use Google Sheets for a threaded discussion and use it in Google Classroom. […]

Read more

Making a LOT of Copies of the Same Google Docs

Sometimes I have need to make a lot of copies of a document in my Google Drive. For example, I have a template for creating badges in Google Draw. However, I need a lot of badges for my project. Manually duplicating the template 50 times is tedious. I wrote a script to accomplish this faster […]

Read more

Google Classroom – Using RubricTab to Assess Students

Previously I created a rubric template that allows you to create a rubric, paste your class roster, and then create a copy of the rubric for each student to make evaluation for your class easy. I have upgraded the script (Add-On) so that it now creates a spreadsheet for each student to share with them […]

Read more

Webinar: Use FilterRoster on your Google Forms for Individual Student Spreadsheets

This is a webinar that is a result of @edtechchic exclaiming on Twitter how much she loves the Google Sheets formula =importrange(). I told her that if she loved that she might like my script I wrote that creates and individual spreadsheet for each student based on filtered data from a Google Form. The process uses […]

Read more

Google Forms: Streamline your Data with FilterRoster Script

If you re-use a Google Form for attendance, turning in homework, daily warm-up, peer evaluation data, or anything where there are multiple rows per student  in your Form data my script FilterRoster may be helpful. It creates a tab for EACH student with a filter to show just that students data. Rather than filtering the Google […]

Read more

Google Sheets: Create Tabs Quickly

If you have ever clicked the plus icon to create a new tab and renamed the tab multiple times you know how tedious this can be when using a spreadsheet. I wrote a script that allows you to take a list and create a tab for each item in the list. I previously posted the […]

Read more

Google Docs: Mark As Graded

When assessing student work done in Google Docs it can be a challenge to know which student documents you have looked at and which ones you still need to look over. When looking in my Google Drive folder with student work I need a system for looking at the titles of the files in Google […]

Read more

Creating a Quiz with a Google Form and use Flubaroo to Grade it.

One way to quiz students is to use Google Forms. This tool is expecially handy because all of the students answers automatically are gathered. You will instantly be able to see a summary of responses that make some very nice charts and graphs to help you to modify your instruction on the spot. You can […]

Read more

Take the Hassle Out of Students Turning in Assignments

Updated Note: This script works with old Google Sheets. Click Here to make a copy of a blank Google Sheet that is the old version. You will want to connect your Google Form to the old style spreadsheet. In the new Google Sheets there is an Autocrat add-on, however it will not merge the document […]

Read more