The video provides a practical, step-by-step tutorial for a common teacher need (organizing digital resources), using readily available tools (Google Sheets, Canva). The creator's clear instructions and visual demonstration make it easy for viewers to follow along and replicate the process, addressing a specific user request from a previous video.
Summary
The creator demonstrates how to build a digital dashboard using Google Sheets. The process involves setting up the sheet with headers and icons, choosing a color palette, and then adding hyperlinks to various resources. The creator also mentions using Canva for icons and a Chrome home button trick for easy access.
Structure
1Introduction and request for tutorial
2Showcasing the sample dashboard
3Setting up the Google Sheet structure
Original caption
Replying to @Kerry Casey Oppenhei Teachers, let’s build a digital dashboard! 💻✨ I use Google Sheets to keep all of my most-used links and resources organized in one place—and then they’re just one click away. 🔗 Save this one and build yours later! #teacherhack #GoogleSheets #TeacherTips #TechTips
More from @teachingbetweenri
More breakout videos from this creator.
4Adding colors and icons (using Canva)
5Adding text and hyperlinks
6Final tips and call to action
Product placement
Google Sheets: it ACTS as a tool to create a digital dashboard by organizing links and resources. Removing it would change what happens in the video.
Canva: it ACTS as a tool to create icons for the dashboard. Removing it would change what happens in the video.
Linktree: it APPEARS as the creator's bio link, which is a link aggregator. Removing it would not change what happens in the video.
Call to action
Save this one and build yours later!
On-screen text
DIGITAL
DASHBOARD
Reply to Kenny Casey Oppenhei
I can't wait to try this. But...directions for the dashboard?
Transcript
Previously I showed you guys how to make your digital dashboard one click away with the little home button in Chrome, but some of you asked if I could back it up a step and show you how to make the actual digital dashboard. So, let's make one together. Go ahead and hit that save button so you can come back to these directions when you're ready to build yours. Here's an idea of this sample dashboard we're about to build together. It's just a Google sheet that we've made cute and filled with our most used links. So, start by opening a blank Google sheet. I adjust my columns to give myself some space. I make the top row fairly tall because we'll add some icons to these boxes. And then the box directly below that will be our section headers. Then I skip down to about row 10 and adjust the spacing there as well for another stock of headers and icons. Decide what categories you want to organize your links into and fill those category names into your small header rows. Then I play around with changing the font and centering all of my text. Next, I want to decide on what colors to use. I often just Google color palettes to find one that I like. I'll just copy the image of the color palette I like and then paste it right into my Google sheet so I can reference it. Now, when I go to fill the color of my header row, I can just click the dropper icon to select a custom color. I'll hover over the color palette that I pasted and select the exact color. And then I'll continue that for all of my header cells until I've got the coloring that I want. Next, I want to add some cute icons. I personally find this easiest to do in Canva. So I just open up a square Canva design and I start searching for icons that will go with my category headers. I put each icon on its own page. Once you find all the icons that you want, download them as PNGs. Be sure that the toggle on the option for a transparent background is on. Now, back in your Google Sheet, you're going to click on the tall header, go to insert and click image in cell. Choose the option to upload and then just drag the icon that you downloaded from Canva. You're going to repeat this process for each category icon. Then under each header, I start brainstorming some things that I want right at my fingertips. Type the name of what you're going to link. Next, you're going to start hyperlinking. So go find the website or the resource that you want to link to. Copy the URL, highlight the words in your Google sheet and click the link icon. Paste your link. You're going to continue this for all of your links. If you don't already see the little link icon, you can always go to insert and then choose link and do it that way as well. And boom, you've built your digital dashboard and the nice thing is you can continue adding links to it throughout the year as need be. And don't forget to use the trick that I showed in part one to set your Chrome home button to this digital dashboard. Send this to the teacher whose bookmarks are getting a little out of control and follow along for more teacher tech tips.
