Lifelong learner/educator, Google Sheets Expert, Google Certified Edu Trainer, Google Workspace Trainer and Integrator. All musings are my own. PURA VIDA
Cove, Oregon
Joined September 2009
- Tweets547
- Following91
- Followers248
- Likes49
Apps script to create student notebooks that the teacher can update from... youtu.be/OUAZRgnIJdE?si=bJTX… via @YouTube
Use Apps script to remove all the timestamps from a ZOOM transcript reco... youtu.be/ua68AoMNkac?si=KOfa… via @YouTube
Using New Tables in google sheets formulas youtu.be/nRt--kjZHSw?si=ykRU… via @YouTube Google released the new Tables features a while ago. Here is how you can use the tables feature in formulas.
Apps Script To clean a list of phone numbers that are in different forma... youtu.be/hVTWwZ2nA1g?si=X18j… via @YouTube I needed recently to clean a list of contact's phone numbers that were exported form google contacts in order to import them into MailChimp. However the list of
contacts had randomly formatted phone numbers, and I wanted to make then consistent when I imported them. I wrote an Apps Script to clean up the list. docs.google.com/document/d/1…
#googleedu #edchat #edtech #edtechchat #googlesheets Apps script to build a chart on a sheet using data on the sheet to have ... youtu.be/w7lE3cF5aRg?si=wrSo… via @YouTube
In this video, I go over the new features and simplification of the reading log system I recently posted.
Enhanced Version 2 of Apps Script Based Reading Logs System youtu.be/YeQZNA_TPDI?si=pzVF… via @YouTube
Apps script Reading Logs system for educators to collect reading data fr... youtu.be/SN_xyzC_VZ0?si=SYSh… via @YouTube In this video I share a new system I have developed that creates a student reading log for each student, then allows the teacher to pull the data from each student
Use the 'SWITCH' formula with a 'QUERY' to make a dynamic dashboard to s... youtu.be/G-U-WwRy-IY?si=H9GF… via @YouTube In this video I demonstrate how you can use the 'switch' formula along with a 'query' to dynamically show data based on Quarters, Current Year, Last, year, all years
AppsScript to index all files in your google drive owned by you, name, U... youtu.be/ShKJEXwNyVo?si=7hhQ… via @YouTube In this video I demonstrate a simple way to index all the files in your google drive owned by you and save it to a google spreadsheet with the Name, URL, ID, Date Crea
Limit the data source to use a pivot table and a pivot table group to su... youtu.be/riTJ_dIW1Dw?si=pgL4… via @YouTube In this short video I demonstrate how to use a pivot table group in a column to summarize the google form data. A little work around to first limit the amount of data
#googleedu #edchat #edtech #edtechchat #googlesheets Use a special QUERY to summarize student data submitted on a form. youtu.be/NXsBdTz651E?si=vP1B… via @YouTube In this video I show how to use a special Query to display data that was collected on a google form.
Sports Tracker - A tutorial on how you can build a Spreadsheet to track... youtu.be/aKdt54Riw7A?si=3Uao… via @YouTube In this video I demonstrate a system I have built that will track the weekly practice activities for you volleyball season as well as a summary of the full season.
#googleedu #edchat #edtech #edtechchat #googlesheetsUse Special Formatting plus formula to calculate the next time based on ... youtu.be/qqEjozRlWjE?si=5Ej_… via @YouTube Learn how to calculate the next time in column A when adding minutes in column B automatically
Using Apps Script to Update a Standards sheet on each student sheet that... youtu.be/PpSNPfpLg3g?si=_yVD… via @YouTube Add a new sheet or replace an existing sheet on all the student sheets from your master sheet. Here is an example of using apps script to update an incorrect standards
How to use Looker Studio to analyze data, share without sharing the shee... youtu.be/bzvuthhWj9g?si=PUm9… via @YouTube Use Looker Studio to display your sheets data (and many other data sources). Keeps your data source secure, but allows others to analyze the data on embedded web page.
Create a new google doc in a folder, rename it, and replace an email pla... youtu.be/8Tf0JN6FKvU?si=eLQI… via @YouTube Enhancement to my student Portfolio system, runs all three scripts from the first script and now places the actual student email address in the newly generated documen
#googleedu #edchat #edtech #edtechchat #googlesheets Add Google Sites Student Portfolios to Student Folders youtu.be/Corn00hHP4Q?si=U9Vg… via @YouTube In this video I demonstrate a system to add Google Site Portfolios to student folders, also creates the student folders and adds files
#googleedu #edchat #edtech #edtechchat #googlesheets Make a timesheet to track your payroll, lot's of automations, apps scrip... youtu.be/_aeDATDmvsg?si=NBRE… via @YouTube