Tag: code
-
Loops with Control Variables
Understanding how to limit the amount of times a loop repeats is conceptually challenging. Especially if you only learned what a loop is the day before. Successfully declaring a variable, then using it that variable iterate a loop takes practice – and an infinite loop or two. Originally, I created this worksheet as part of…
-
Loops in the Real World
Loops are confusing. Especially if you are encountering them for the first. In this lesson, I use real world examples to make loops more approachable – more tangible. Originally, I created this worksheet as part of a middle school computer science lesson. It is handy for students or adults who are beginning to learn how…
-
How to Code a Google Calendar Appointment Booking System
Need an appointment booking system for Google Calendar? Daring enough to look at a bit of code? This program enables people to be able to make appointment requests using a Google Form. After the user hits submit the program checks for conflicting calendar events. If there are conflicts, the user receives an email asking them…
-
Search a Google Sheet for Duplicates with this Macro
Page moved: http://techyesplease.com/education/google-sheets-menus-prompts-user-interface/
-
Google Sheets: Menus and Prompts in Google Apps Script
Google Apps Script is endlessly versatile. Automating small and large tasks makes working within Google Sheets more convenient. However, it is difficult to share your work with those that aren’t familiar with coding. User interfaces solve this problem. Thankfully Google makes it easy to create menus and prompts that appear on spreadsheet itself, meaning there…