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…
Tag: Advanced
Google Sheets: Find and Replace within a Range
This week I am meeting with each student to look over their digital portfolio. Students fill out a Google Form to self-evaluate before meeting with me. I have a column where I indicate the students evaluation and if they need to make corrections. I use these codes to send individualized email messages to the students. After sending…
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…
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…
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…
Google Sheets: Concatenate … You’re Welcome
Ready to get super excited?! Here is a simple spreadsheet technique that is wicked useful!! Like me, you may want to name your next child “concatenate.” Concatenate smashes stuff together. Replace the word concatenate with the word “AND.” I want to smash this And this AND this…. Anywhere you say the word “AND” you put…
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…
Learn to Code – Do it For the Kids
There is a shortage of people who know how to program. These are high quality, high paying jobs. How do we encourage students to learn how to code? Learning to programming not only is a skill that is in high demand, it is also incredibly useful. We have all wished we had an app or…
Math Teachers: Alice’s Guide to LaTex
Do not ask me how to pronounce LaTex, but as a math teacher it is a useful thing to know! In a nutshell LaTex let’s you put pretty print math symbols on the web. If you need fractions and square roots it can be very helpful to know just a little LaTex. Most websites will…
Insert Google Drawing into Google Slides Presentation
You have created Google Drawings in Google Draw. Now how do you add Google Drawings to Slides?
You must be logged in to post a comment.