Create a Google Dashboard for Administrators using Google Sheets

Here is a true story.  Every day, I have about 50 tabs open on my computer, and I use two search engines. Don't ask me why I use Google and Safari.  I think 100 tabs is better than 50...I guess.  As you can see how anyone with OCD would just go nuts.  That chaotic mess is me on any given day.  I started making a google hub or dashboard early in the school year, and I didn't keep that project going.  I have made it my life goal to keep this system of organization going for the remainder of the year.  I need some simplicity. 

So let me get you started on creating a dashboard for your own documents.

HOW TO CREATE A GOOGLE DASHBOARD


1. GOOGLE DASHBOARD TEMPLATE

Feel free to use my own template in Google Sheets: Google Dashboard for School Administrators.  The icons are generic, so your titles can be easily renamed.  Every part of this file can be edited to fit your own school.  If you love the idea, please create one for your staff too.  This particular document is for all the admin in the district to access, but you can create one for teachers too.


The Google Dashboard for School Administrators link will ask you to make a copy.  This will protect my own file and protect you from sharing your files with the rest of the world to see if you accidentally start to fill my document with your own links.  


2.  ADD YOUR OWN LINKS TO THE CELLS





WEBSITE LINKING


Enter the website text you wish to have quick access to.
For example, District Calendar.



Select the words to hyperlink.  "District Calendar" is selected.  Now click the hyperlink symbol.  





DOCUMENT LINKING FROM GOOGLE DRIVE

Open another tab and find your file in Google Drive.  Copy and paste the website url link or the google drive file url link in the link field and click apply.



I hope you have found this very helpful.  If you have questions, please let me know.  I can do a quick Live tutorial on Instagram or Facebook.

Google Dashboard for School Administrators




4

your photo name

Technology Tips and Tricks for School Leaders

Currently, I am snowed in enduring the massive snow storm here in Texas.  This time has given me a jumpstart on my to-do list at work and time to share items with you too.  


Texas Snow (10-12 inches)
I feel like I live in Colorado, because we have real snow not just ice and sleet.

If you aren't signed up for my newsletter, you may have missed some Technology Tips and Tricks in your inbox.  My newsletter subscription is 1x a month.  I try not to ever send more than that because I certainly don't have much time for that and people tend to not enjoy a lot of emails filling up their inbox.  

Let's take a look at my recent creations.

RECORD USING CANVA

If you struggle making a professional powerpoint and presentation, CANVA has some amazing templates. In addition, it can be used to record!  The steps are listed above and extremely easy.  

CREATE A PERSONALIZED AND PROFESSIONAL SIGNATURE 


Creating your email signature doesn't have to be difficult.  I created a document that will give you step-by-step directions on how to build your designs in CANVA and Google.  The directions work best if you add your new signature in CHROME.  

VOICE TYPING IN GOOGLE DOCS



Did you know that Google Docs has a new feature for Voice Typing?  Well...it might be new for me?  I saw this feature a few weeks ago, and thought I would never use it.  I brainstormed over and over again about why this might be needed.  I feel like I am a very fast typer.  I think blogging has increased that over the years, so why would I need it?  But the more I looked into this feature, I noticed more people using it for note taking. They could listen to the presenter while the computer scripted the presentation.  It might be good to use in meetings for documenting conversations or scripting during teacher observations.

Something to note: It will not stop and form new paragraphs or end sentences unless commanded verbally to begin a new sentence or paragraph.  For more formal writing, I wouldn't recommend this.  However, I can find some use from using it and maybe you can too.



Let me know if you have enjoyed these new tech tips and tricks.  If you do, I will continue to share some each month.  


0

your photo name
Back to Top