One popular method to get your students to learn is to categorise things or to put them in order. Here, we’re going to look at making a card sorting game, which could be used for both. This is the web app we’re going to make: The code There are two parts to the code, stored… Continue reading Card sorting game using Google Sheets & Apps Script
Category: Apps Script Posts
Apps Script Basics – Range class & triggers (pt 2)
This post continues from the previous post on the Range class and triggers with more examples of how to use it. changing the background colour based on edits to a range sorting a table by multiple columns copying part of a range and creating a new sheet with that range Example 4 – Change cell colour… Continue reading Apps Script Basics – Range class & triggers (pt 2)
Online exam maker using Apps Script
With all our classes moving from 99% face-to-face to 100% online, we had the situation where we needed to carry out all our exams online too. A relatively easy solution was to use Google Forms, which was easy for students to fill out and for us to receive the answers. The only issue is the… Continue reading Online exam maker using Apps Script
Ladder card game using Google Sheets
Moving to teaching on line has presented some new challenges and one of those has been how to convert some great classroom activities so they can be done on line. One of those is a simple card game where in our foreign language classes, we help students learn new language by printing phrases onto card,… Continue reading Ladder card game using Google Sheets
How to make a ladder card game with Apps Script
Here we’re going to make a simple ladder card game using Apps Script and Google Sheets. In our foreign language classes, one of the classic activities we do to help students learn new language, is to print phrases onto card, then cut the cards up. We then write the answers on the back of the… Continue reading How to make a ladder card game with Apps Script
Parents Evening Appointment System – Part 3
In this final part of a 3-part post (see part 1 and part 2), we’re going to look at how we get the parents form submissions, send them a confirmation email with the appointment details, and record the appointment on the appointment list for the teacher. The main steps are: Get the form responses. Get… Continue reading Parents Evening Appointment System – Part 3
Parents Evening Appointment System – Part 2
This is part 2 of a 3-part post on setting up a parents evening appointment system. Part 1 looked at setting up the documents and in particular the pre-filled form links. Here, we’re going to look at the code which will create the forms for each class and which will create appointment list sheets for… Continue reading Parents Evening Appointment System – Part 2
Parents Evening Appointment System – Part 1
This is the first of a three-part post, where we’re going to look at how you can create an appointment system using Google Forms and Sheets and with the use of Apps Script, how you it will update the available times on the forms and how it will send automate confirmation emails to those making the appointments.… Continue reading Parents Evening Appointment System – Part 1
Apps Script Basics – Making quizzes in Google Forms
In this post we’re going to look at how you can set up a Google Forms quiz with Apps Script. As an example, I’m going to take you through the example that was posted on the G Suite Developers blog here. I’ve tweaked it a little just to create a new form instead of editing… Continue reading Apps Script Basics – Making quizzes in Google Forms
Apps Script Basics – Form page navigation
In this post, we’re going to expand on my previous post on setting up form validation and improve the clocking in and out form we set up, so that the same form can be used for different employees. We’re going to use this example to see how page navigation can work, both to move to… Continue reading Apps Script Basics – Form page navigation