Google Sites Header Image Template

Create a Header Image in Google Sites Previously I had posted a template for creating a header image in Google Classroom. Several people asked if I had one for Google Sites. Sites is a bit tricky because it is responsive. The crop of the banner image depends on the...

Google Sheets: Sort Names Randomly

Use Randomize Range It seems there is a new trick in Google Sheets. When you highlight a range and right click you can choose “Randomize range.” This sorts the selected range in a random order. I used to have to insert a column, type the formula =rand()...

TemplateTab: Reuse Template

Reuse Your TemplateTab Template I am always tweaking my TemplateTab Add-on. TemplateTab allows you to use ONE spreadsheet with your entire class. Instead of 30 documents to open, you have one. Students can crowdsource and learn from each other. I use it a lot. I have...

Google Sheets: Capitalize Text

Capitalize Your Text in Google Sheets Sometimes you need your text in capital letters (or all lowercase). If your information is in a spreadsheet you can use formulas to make your text in uppercase (or lowercase). =UPPER() In a spreadsheet cell type =UPPER( and click...
Page 1 of 3512345...102030...Last »