Showing posts from January, 2021

Group Creator 🧐 w/Zoom CSV Groups

Creating planned, pre-assigned Zoom breakout groups, especially for larger groups, can be pain.  On the surface, uploading a CSV sheet is a simple task.  But, could the process and organization of groups be better managed? Problem: Creating pre-assigned groups is time consuming and rigid, especially when creating breakout groups for Zoom. Solution: Group Creator is a Google Add-on that keeps an organized collection of classes and groups.  It creates a CSV with a downloadable link and hyperlinks to navigate between the TOC and other sheets. Download: Click Here This is not an approved app, but is safe to run.  Feel free to review the script using Tools>Script editor. Hybrid Tip:  If you are teaching hybrid (1/2 the class at home and the other at school), consider creating class lists with only the students who are at home, or color code the names for the students based off of their at-home/school rotation.   If you use one Zoom for all of your classes, create your class groups,

Google Sheets: Script to Print As PDF, Save as CSV, XLSX

Hyperlinks can do more than just link documents and sheet pages.  They can also help you to quickly download the content as a CSV, TSV, XLSX or PDF.  Best of all, we can limit the range to be downloaded. Problem: If using a Google Sheet, exporting specific ranges as a PDF, CSV, etc., is difficult or impossible using Google's preselected menu bar. Solution & Skills: We will create one Google Spreadsheet where we utilize the hyperlink function to create download links.  This solution helps with the creation of invoices, grabbing CSV data that can then be uploaded to other programs/web applications. Skills: ✔ Write hyperlink function; ✔ Link to pages within spreadsheet; ✔ Modify link to create CSV, XLSX or PDF files by range. Hyperlink Function: Here's the breakdown of the hyperlink function in Google Sheet: = hyperlink ( "" , "Google" ) The equal sign tells Google Spreadsheets that we are using the hyperlink function.  Inside the firs