In the previous example, there was a bit of code that was repeated twice: the Logger.log series of commands. Whenever you see code being used more than once, it’s a good sign that you need to build a new function for it. However, in order for this to work in […]
Monthly Archives: February 2015
In this example we begin to look at variables. Just like in algebra, a variable can hold a range of values, but in coding they are also a little bit different. Variables in JavaScript have different types, the most basic of which are Strings and Numbers. Simply put, Strings contain […]
In this challenge, we’ll take the principles from the previous example one step further. Here, in addition to simply defining functions, we are also CALLING a function: newFunction. function myFunction() { newFunction(); } function newFunction(){ } Note here that the first function, myFunction, calls newFunction. You can tell that it […]
Google Scripts Lessons 1-10 Click on a lesson below for a written tutorial demonstrating the lesson. Lesson 1 – “Hello World!” Lesson 2 – Challenge: Calling Functions Lesson 3 – Variables Lesson 4 – Variable Passing Lesson 5 – Variable Passing Challenge Lesson 6 – Arrays of Variables Lesson 7 […]
In this final lesson, we will compile all the information we need into a new tab called “Merge data” and then we will send that out to all the students with the mail merge Add-on called Autocrat.Click here to view Example 9, then make a copy so you can play […]
In the last example, we used the functions INDEX and MATCH to reorient our data so that each student was listed on a single row with their peers assessments in columns to the right. If all of the groups were of equal size, we would be done manipulating the data. […]