Category: Code
-
Script and User Properties Google Apps Script
Saving a variable as a user or script property is an essential feature of Google Apps Script. However, it is one I didn’t use for months because I found it too complicated. Eventually it clicked, I use the properties feature in Apps Script regularly. Having hunted for tutorial and found little, I made this video…
-
Using Alerts in Google Apps Script
Google Apps Script can be intimidating at first. On of the early functions I needed to use was alerts. This simple and quick coding tutorial walks you through step-by-step how to create alerts using JavaScript and Google Apps Script. Alerts work in Google Sheets, Docs and Forms. Feel free to copy / steal / edit…
-
Automatic Email Sending Add-on with Word Detection
Google Apps Scripts is a powerful tool. All you need is a basic understanding of JavaScript and you can create any add on your heart desires. Hoping to make Google Apps Script more accessible, I started a new project. This create a simple application that notifies you when a user has submitted a particular word…
-
HTML Heading Tags Worksheet
Introducing HTML one tag leads to students rapidly master key concepts of my computer science course. I used this as a warm up on the second day of introducing my students to HTML. Day we focused on learning paragraph tags. The warm up was done individually, then students partnered up and helped each other conquer…
-
HTML Paragraph Tags Worksheet
Learning HTML can be intimidating. Particular for middle school students who have not encountered any type of code or mark up language before. Obviously, starting with the basics is key. Paragraph tags is one of those essential basics. In my classroom we use Code.org to introduce HTML. Students completed this worksheet as a warm up.…
-
Variable Controlled Loops Worksheet
Loops are a powerful basic building block of computer science. Loops can be a challenging concept for students to master. In my middle school computer science classroom we spent several days on the concept. Students did well on this worksheet. I used it on my third day of introducing loops. For classes that struggled, I…
-
Loop Diagram Worksheet
Loops are essential to programming. However, when first encountered, loops can be a confusing topic. The idea that a few lines can make other code repeat, it is not an intuitive concept. My students understood the idea of repeating code, but struggled to understand the iteration and control elements of a loop. I used this…
-
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…
-
Doctors’ Office Reservation System for Google Calendars
Need a system to manage bookings for multiple calendars at the same time? Want the convenience of a booking system that using Google Calendar? This program is great for you. The system is perfect for a doctors’ office that has multiple physicians sharing several different rooms. Patients submit their requests for appointments using a Google Form.…
-
Room Reservation System Using Google Apps Script
Need a room booking system for Google Calendar? Willing to learn a bit of code? This program allows people to reserve meeting or study rooms using a Google Form. After the user hits submit, the program checks the corresponding calendar. If the room is already reserved at that time, the user receives an email asking…
-
Java: Recursive Handshake Function
This was an assignment for an advance java class at my local community college. I was required to use a static recursive method calculate the number of handshakes that would occur with n number of people in a room. Each person shakes hands with everyone once.