Tim Welch

Apps script to create student notebooks that the teacher can update from... youtu.be/OUAZRgnIJdE?si… via @YouTube

Use Apps script to remove all the timestamps from a ZOOM transcript reco... youtu.be/ua68AoMNkac?si… via @YouTube

Using New Tables in google sheets formulas youtu.be/nRt--kjZHSw?si… via @YouTube Google released the new Tables features a while ago. Here is how you can use the tables feature in formulas.

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/10Y…

Apps Script To clean a list of phone numbers that are in different forma... youtu.be/hVTWwZ2nA1g?si… 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

#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… 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… via @YouTube

Apps script Reading Logs system for educators to collect reading data fr... youtu.be/SN_xyzC_VZ0?si… 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… 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… 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… 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… 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… 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… via @YouTube Learn how to calculate the next time in column A when adding minutes in column B automatically

A little off topic for my posts, but had to share the hummer tracking a shower at sunset!

Using Apps Script to Update a Standards sheet on each student sheet that... youtu.be/PpSNPfpLg3g?si… 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… 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… 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… 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… via @YouTube