Tag Archives: script

Email Each Student a Note

Send Personal Emails to All Your Students If you have ever wanted to email an individualized note to each student, it can be tedious to compose an email per student. Use the template below to easily write a note to each student and send the note through email. Template alicekeeler.com/sendcomments Use the Add-ons menu to locate […]

Read more

List Scramble: Create Sublists of a Vocabulary List

List Scramble is an Add-On script that takes a list of vocabulary words (or list of student names or anything you like) and creates sublists randomly. I saw a blog post by Catlin Tucker on an activity called Word Sneak. I thought it might be helpful to have students be given a random sublist of vocabulary or […]

Read more

Create a Google Drive Folder for Each Student

A teacher was having her students work on an ongoing project where the students would save multiple documents to a folder in Google Drive. To make this process easier, I wrote a Google Apps Script file to automatically create and share the folders with the students. Template alicekeeler.com/makefolders Directions The template above will prompt you to […]

Read more

Google Apps Script: Create Your Own Mail Merge

I use peer evaluation quite a bit in my class. My data is collected via a Google Form and are in a spreadsheet.  I use mail merge to send students back the comments of the peer evaluations. While there are pre-made Add-On’s to send out emails, there can be an email limit. This tutorial will […]

Read more

Google Apps Script: Create an Alert

Google Apps Script allows you to customize Google Apps. Part of your script can alert the user to provide them information or inform them that the script ran correctly. Here is the sample code to create an alert. Script Editor In a Google Sheets spreadsheet or in a Google Doc use the Tools menu to […]

Read more

Google Apps Script: Create an Add-On

Create an Add-On Menu For most of my scripts I have written you access the script through the Add-On menu. In my group maker script you create a copy of the template and then go to the Add-On menu to locate “Group Maker.” You can create your own Add-On for your scripts you create. The […]

Read more

Google Apps Script: Format a Sheet

How do we promote STEM (Science, Technology, Engineering and Math) with students if we do not engage in these activities ourselves? Learning a little code is one way we can model the importance of these skills to our students. Also, it is really cool to manipulate Google Apps. Here is a little activity to get […]

Read more

Kyle’s Spelling Activity

My friend Kyle asked me to code a way for his son to practice spelling words. Clearly the answer is always a spreadsheet. Enter spelling words onto this spreadsheet and use the Add-On menu (Kyle spells) to practice spelling words. Template http://tinyurl.com/kylespelling How it Works After making a copy of the template, locate the Add-On […]

Read more

Google Classroom: Create Group Documents

One request I am often asked about Google Classroom is how to create documents for small groups. If you create a copy of a document for each student then each group member receives a copy, which can be confusing. I have created a script that will assign students into random groups (or non random) and […]

Read more

Google Classroom: List ALL Your Student Files

While I love Google Classroom, it can be a lot of clicking to locate student files. I created a script that will list all of the files in a Google Classroom class folder. The script lists all of the assignment folders in the class folder, creates a tab for each assignment and lists the files […]

Read more

Google Drive: Students Turn In a Folder

If you are having students organize multiple work samples and files into a folder, you may wonder how it can be organized and submitted. I have written a script to allow students to submit a folder. Template http://alicekeeler.com/turninfolder How it Works Distribute a copy of the template to students. You can do this through Google […]

Read more

Connected Educator Game

For my class I am taking I was asked to visually represent Connectivism, Communities of Practice (CoP), and Personal Learning Environments (PLE). For this activity I created a board game prototype to allow you to move around the board as you engage with the images. To play the game, make a copy of the game […]

Read more

Bathroom Sign Out Sheet Template

I had a friend using a Google Sheets spreadsheet to have students sign out and in for the bathroom instead of the paper sign out. The problem became the amount of scrolling after many students had signed out. I created a template to help with this. The Template http://tinyurl.com/bathroomsignout Bathroom Menu After making a copy […]

Read more

Create Personalized Teacher Newsletters for Each Student

One reason a parent might not read the classroom newsletter is that it is not about their child. Here is a solution for creating weekly newsletters for parents that are individualized for their child. Newsletter Templates http://tinyurl.com/newslettertemps Add the above Google Drive folder of newsletters to your Google Drive. You can make copies and use […]

Read more

Create a List of Rubrics – Automagically

Previously I had created a template for creating rubrics to assess students. http://alicekeeler.com/rubrictab2 Assuming you may use rubrics for multiple assignments, I created ListRubrics to make this process easier. RubricTab RubricTab is an Add-On script I wrote to make assessing with a rubric a snap. Design the rubric Use the Add-On menu to call up a […]

Read more