This post will walk you through setting up your very first Google Apps Script to put some data in memory. We'll stick to a single spreadsheet and learn the basics of the GScript language. Want a video instead? The Sample Data and Our First Script Fi...

Tired of tedious crossword creation and students finding them dull? Let's revolutionize the traditional crossword puzzle! Discover how to leverage AI for effortless generation and add an interactive tech twist to make crosswords an exciting, en...

One out of three spreadsheet enthusiasts don't know how to use fractions. They try but they only get partially there. It's like the odds are stacked against them, they are fighting the percentages or just can't cross the great divide....

There is nothing more satisfying than checking a box and enjoying one thing off your list complete...wait, there is! The whole row strike through or the coloured row! Bold, italicize...<breaths into a paper bag> I'm back. Sorry about that, I r...

There is nothing worse than having to manually count anything on a spreadsheet...well, there are bigger life problems...but let's solve one thing at a time. Yes, you can make a new row at the top and then add in totals but that is not the best looki...

Sometimes, you need a drop-down list that automatically updates as you enter data. This guide will show you how to create a dynamic drop-down using data validation and a compound formula. Here is a preview: Example: Tracking Books We’ll set up a sh...

Using AI with students is a double edged sword. AI can be a powerful learning tool, but when students use it to replace learning instead of enhancing it, problems arise. The challenge is to help students see AI as an accelerator for learning rather t...

This guide will help you collect and monitor students’ first drafts while ensuring they can use AI tools for refinement, but not for dishonesty. It offers a step-by-step process to create a secure, editable, and trackable assignment workflow using Go...

I've spent many hours creating and modifying a spreadsheet only to have a user delete my formulas and then wonder why it just doesn't work anymore. I've tried protecting cells but then they get angry as to why I don't let them touch cells so I unprot...

At some point, while using a Google App, the thought will occur to you that "there has to be a better way". Sometimes, there is. I had reached the end of the utility of the Google Sheets formulas and needed more from it. This is when I started to di...

Having data spread over many, many sheets is a pain to combine. You have to type in each sheet name, remember the proper ";"s and try not to mess up. If it is 5+, there is no really nice way to do it manually.Here is a quick script that will create a...

This is a neat twist on the standard Jeopardy game. It's closer to a Mario Party game as the team that does everything right...still might lose which should keep everyone interested until the very end.Here is the FREE template you can use: https://pa...

As fellow busy professionals, we understand the demands of your daily schedule. However, we invite you to invest just 5-10 minutes a day to engage with AI. Even if you choose not to incorporate AI directly into your classroom, exploring its capabilit...

Engaging Classroom Activity: Reveal the Image!This activity is designed to captivate your students and encourage participation.Follow these steps to set it up:Insert an Image:Choose an image related to your lesson or topicInsert the image into your p...

Google Docs has limitations when it comes to handling images, and its layout features can be cumbersome unless you resort to unconventional table setups.Google Slides offers a much better solution as it can:be customized to any sizetext and images ca...