If you want to know more about how each tool works "under the hood", you can view the code here.
This page contains scriptless versions of the Google Sheets/Slides templates. To enable them, you will need to create the file(s) in the Apps Script editor and paste the associated code. You can access the editor in the Extensions menu in Sheets or Slides.
Wordle in Google Sheets
After making your copy of the Sheet template, you have only the UI and the word lists, but not the code. To enable your copy of the sheet with the Wordle in Google Sheets script, you will need to paste the code from Wordle in Google Sheets v2.0 Code.gs into your Apps Script Editor (click on the 'Extensions' menu to find the Apps Script editor).
Click on the floppy disk icon button(💾 ) to save your script.
Give your project a name, something like "My copy of Avi Megiddo's Wordle in Google Sheets".
Go back to the sheet, and click refresh. You should now see the menu item 'Wordle' appear in the toolbar.
Give Permissions: A window will pop up saying "Google hasn't verified this app." This is expected.
Click on Advanced.
Click on Go to EMF Converter (unsafe).
Note: It's marked unsafe only because it's a custom script and not officially verified by Google. It's safe to proceed.Choose your Google account and click Allow to give the necessary permissions. This only has to be done once.
After this, you should be able to run the functions from the 'Wordle' menu bar item that appears.
Student Comment Generator
To enable the Sheet, you will need to create two files in the app script editor:
After making your own copy of the Sheet template, create the files above in your Apps Script Editor.
Make Random Orders, Partners, Groups
To enable the Sheet, you will need to create two files in the app script editor:
After making your own copy of the Sheet template, create the files above in your Apps Script Editor.
Insert Images from Drive: auto-center, auto-left, insert/remove text box.
To enable the Slides, you will need to create 2 files in the app script editor:
After making your own copy of the Slides template, create the files above in your Apps Script Editor.
Word Search Maker
To enable the Sheets, you will need to create a file in the app script editor:
After making your own copy of the Sheet template, create the file above in your Apps Script Editor.
Tournament Bracket Manager
To enable the Sheets, you will need to create a file in the app script editor:
Copy and paste the code from the file(s) below.
Aquarium of Appreciation (a.k.a. Box of Thanks)
To enable the Sheet, you will need to create 3 files in the app script editor:
After making your own copy of the Sheet template, create the files above in your Apps Script Editor.
Or if you prefer, the original Box of Thanks look and feel, with buttons:
Suggestion Box:
To enable the Sheet, you will need to create 2 files in the app script editor:
After making your own copy of the Sheet template, create the files above in your Apps Script Editor.
Interactive Mood Meter:
To enable the Sheet, you will need to create a file in the app script editor:
Copy and paste the code from the file(s) below.
_________:
To enable the Slides, you will need to create a file in the app script editor:
Code.gs
After making your own copy of the Sheet template, create the file above in your Apps Script Editor.