Posts

Count by Color in Google Sheets

Image
 Hello everybody! Are you familiar with the function COUNTIF in Google Sheets? You can count how many cells match a certain criteria from a range. But what if what you need is to count the color of the cells? That is not currently possible. I came across a situation in which I had applied individual conditional formatting to 25 different columns. The words didn't match amongst them, but the colors were the significant piece. I needed to count how many cells had a certain color.  I Googled and looked to see if anyone had gone through a similar situation. Yay! I came across exactly what I needed! Count Cells by Color  (link here!) Here's the website I found. It shows 3 different methods. I chose to use Method 1. This method requires you add a script to your sheet. The link provides the script. All you have to do is copy/paste and follow the instructions. Once you have added the script you can start using the new function " =countColoredCells(RANGE, DESTINATION COLOR) ".

YouTube Clips - Life Saver!

Image
 Hi all! I was watching a YouTube video yesterday and suddenly noticed that in the options below the video is an icon called "Clip".  I was curious and clicked on it. Oh wow! This feature is so useful! I've been sharing parts of videos using the embed code and then tweaking it a little bit. Here's a video where I explain this . This is so much easier to use and share! It seems to be currently in a trial period. It only works if you are logged in to your YouTube account. Also, take note that the clips you create are saved in your Channel. There's a new tab for Your Clips. Allowing people to create clips on your videos seems to be an option that you can enable or disable. However I don't find that option yet in my settings. This page explains a little more on how Clips works. Stay posted and if you see it, give it a whirl! Cheers!

Auto-Translate Youtube Videos

Image
 Hello everyone! I was challenged recently on finding a way to translate a Zoom recording from Spanish to English. As we already know, Zoom provides closed captions but only in English. If the meeting was going to be in Spanish, the CC option wouldn't work for us. It seems you would need to add a third party option to translate the CC into another language. I remembered trying to translate a video on Youtube some time ago and decided to give it a try. It was a charm and worked just as expected! Here are the steps: UPLOADING VIDEO: 1- Record the video. 2- Upload video to Youtube channel (make sure your channel is verified in order to upload longer than 15 minute videos). 3- Wait for the video to be processed. 4- Get sharable link to the Youtube video. NEXT STEPS ARE FOR VIEWERS: 5- Open the Youtube video in another tab. 6- Wait until the CC button appears (it takes some extra processing time). 7- Turn on the CC option. 8- Go to Settings (gear) and turn on Subtitles. 9- Choose Auto-t

¿Qué aprendimos a un año de educación a distancia?

Image
Hello! This is my 5-minute participation at the ADE Virtual Summit 2021. I talked about the work we did this school year of gathering first hand data about what Distance Learning looks like at ASFM. This video is in Spanish. Cheers!  

Distance Learning Highlights

Image
Hello everyone! What a year! This whole school year has been in Distance Learning mode at my school. To gather a big picture perspective of what learning looked like, during the first semester the innovation team visited virtual classes from Nursery to Grade 5. The goal was to observe what was actually happening. We gathered a lot of notes and have summarized them in the following visual. We continued with the following grade levels throughout the second semester  and will share our key findings in the future. Cheers!  

Putting Together a Schedule Just Got Easier!

Image
For the past 6 years I have been putting together the schedule for the sessions for our conference Live Curious, Go Beyond . I have a large white writable wall behind my desk. I loved using color-coded sticky notes and placing them over a grid I would draw on the wall.  It was a system that worked quite well. I could easily make adjustments and the schedule was at a glance. I did have to be careful to take a picture before going home in case any sticky note fell over night. This is what the 2020 schedule looked like: However, at this time around, due to the Pandemic, I was not in school. So I tried a different approach. I had used occasionally Jamboard and seen how teachers were using it with their students and group work. So I gave it a try. Jamboard to the rescue! It was just what I needed! I was able to create colored sticky notes, move them around easily, and best of all, copy/paste and resize them. Another beauty is the ability to duplicate the page, therefore I could experiment

How I got started in education...

Image
 Hi all, I came across this today and sharing here. This cartoon depicts how I got started with education. 😉