Tag Archives: Apps Script

Google Forms: Choose a Random Winner

Google Forms: Choose a Random Winner Choose a random winner from those who fill out your Google Form. Use this Add-on I coded in Google Apps Script to automatically select a winner, create a spreadsheet listing the winner and 19 runner ups and receive an email with the winner and links to the Form and spreadsheet. […]

Read more

Mock Twitter Chat with Your Students

mock twitterchat with discussiontab

Mock Twitter Chat with Your Students I love Twitter chats. They are exactly one hour Allow for everyone’s voice to be heard It is okay to have a side conversation about one part of the topic to go deeper while the rest of the conversation continues Guaranteed to get through 5-10 questions in an hour […]

Read more

Self Reflection Reading Goals @JSerravallo

reading self reflection tool

Self Reflection Reading Goals @JSerravallo I saw this tweet about Jennifer Serravallo’s Reading Goals Self Reflection form from her book. My first thought is of course that this would be better as a Google Form. My biggest beef with PDF’s is they do not collect data. Switching to a Google Form allows the teacher to […]

Read more

TemplateTab: All Students on One Spreadsheet

templateTab

View Upcoming events at alicekeeler.org for TemplateTab workshops. TemplateTab TemplateTab is an Add-on script I wrote to make it easier to have all students working on the same spreadsheet. Instead of collecting 30 digital documents, you have ONE where all students contributed to the same one. This makes it easier to manage digital work and […]

Read more

Google Sheets: Merge Data into One Column

onecolumn google sheets spreadsheet merge columns of data

Merge Data into One Column Sometimes I need to have a need to take columns of data in a spreadsheet and put them into one column. What I normally do, if it isn’t a lot of data, is use Control-X to cut out one column of data and put it underneath the other. However, why […]

Read more

Share a Copy of A Google Form

share-a-copy-of-a-google-form

Share a Copy of a Google Form To share a copy of Google Docs, Sheets, Slides or Drawings is pretty easy. If the person has view access to the file they can simply use the File menu to “Make a copy.” Alternatively, editing the URL of a Google Doc from /edit to /copy and sharing […]

Read more

Google Apps Script Picker Tutorial

Google Apps Script Picker Template

Google Apps Script Picker Google Apps Script allows you to code Google Apps such as Google Sheets spreadsheets and Google text documents. One thing I do when coding Google Apps Script is ask the user to give me the ID of a file or folder so that my code can call up or manipulate that […]

Read more

templateTab: Collaborate with Students using Spreadsheets

templateTab

templateTab I love spreadsheets and I love students collaborating. This comes together by using Google Sheets spreadsheets. Template alicekeeler.com/templatetab Roster After making a copy of templateTab, paste your roster into column A. I recommend that you have a spreadsheet in your Google Drive that has a list of your students names and email addresses. This […]

Read more

Google Apps Script: Create New Tabs

google apps script tutorial make tabs

Create Tabs in Google Sheets Google Apps Script allows you to customize what Google text docs and Google Sheets can do for you. It is based on JavaScript, but you need to know very little to be able to do Google Apps Script. Here is a scripting activity to help you practice your Google Apps […]

Read more

Alice’s Quick Way to Make a Google Form

Create a Google Form FAST

Alice’s Quick Way to Make a Google Form I am a ninja with keyboard shortcuts and using the Tab key. I try to avoid touching the mouse whenever possible. I am getting pretty good with the keyboard shortcuts to create a Google Form with the new Google Forms, but it’s still too slow for me. […]

Read more

Kids Start Coding Their Vocab

Coding Vocab Words with Google Apps Script

Shamelessly, I bribed my 8-year-old daughter to learn JavaScript. I’ve shown her a couple of things with Google Apps Script (which uses JavaScript). Imagine how delighted I was when a week later she comes home and exclaims “I am teaching my class how to code.” First, major kudos to her teacher who when seeing how […]

Read more

Agenda Doc: Send a Google Form and Create an Agenda

I have created an Add-On script that allows you to create a Google Form with the list of agenda items for a meeting and then merge the responses of participants to an editable Google Doc. I have noticed that many meetings I attend the agenda is created on a Google Doc and shared with those attending […]

Read more

Google Apps Script: Code Insert a Sheet

A coffeeEDU is a one hour unconference style get together of educators. At a coffeeEDU I attended in Connecticut this week, the conversation turned to Google Apps Script. We did a really simple script to add a sheet to a Google Sheets spreadsheet. I used this technique to create http://alicekeeler.com/rostertab. RosterTab takes your list of students and […]

Read more

Google Classroom: Add Other Documents to Class Folder

I added collaborative notes documents to Google Classroom as “Students can edit file.” I did not want to push out a copy of the document to each student since the students are working in groups. This means that the collaborative document does NOT show up in the Google Classroom class folder for the student. Template […]

Read more

Start Here: A Quick Google Apps Script Project

Here is a very quick project you can do to make your first program. Then you can brag to your students that you can code. Do not be embarrassed that you do not know very much, the fact that you coded at all is braggable. If we want to encourage students to think about learning […]

Read more