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

Time Saving Tips and Tricks for School Leaders: Part 2

Do you find yourself sending the same email often or replying the same response often?  If so, here is a very quick shortcut that can generate your email in just a few seconds.  


Create an Email Template 

Enable Templates

1.  Open Gmail
2.  At the top right, click Settings > See all Settings
3.  At the top, click Advanced.
4.  In the Templates section, select Enable.
5.  At the bottom, click Save Changes.

You can create up to 50 templates.


Create Templates

1.  Open Gmail and Click Compose.
2.  In the compose window, enter your template text.
3.  Click More > Templates.
4.  Choose an option
    To create a new template, click Save draft as template > Save as new template.
    To change a previously saved template, click Save draft as template and  under Overwrite Template, choose a template and click Save overwrite it.
5.  To send an email, compose your message and click Send.




Insert Templates

1.  Open Gmail and click Compose
2.  Click More > Templates
3.  Insert a template, under Insert Template, choose your saved template to insert in your email.

Here is an example for a meeting request.  Recently, I shared how to create a calendar for viewing and scheduling.  In the email generated below, I shared a link over to my email for them to sign up for a meeting.  




I hope you find these shortcuts fun and helpful!
1

your photo name

Time Saving Tips and Tricks for School Administrators: Part 1

Every minute of the day counts.  Managing can seem overwhelming.  Time management and shortcuts are essential.  Over the next few weeks, I plan on sharing several resources that help you make the most of your time and focus on what truly most important rather than what is most urgent. Here is Part 1.

Time Saving Tips for School Leaders

Have you started using Calendly?

Calendly can really be your best friend.  It can be used to schedule any appointment with ease.  When teachers need to sign up for an evaluation, pre-conference, post conference, etc... Having a calendar link keeps scheduling a hassle free situation.  

Let me show you how to use it and then you determine how it best fits your job position.

Here is a look at some current appointments on my calendar.


1.  First build common weekly/daily appointments that always reoccur or need to be scheduled. 

Such as student meetings (ARD's) or teacher evaluations, or parent appointments.  Name them very generic so you aren't finding yourself renaming them over and over again.  


2.  Integrate Calendly.  

This is an important step.  Integrate your calendly account to your platform.  For me, this is Google Calendar.  This helps the appointments not to overlap.  No one will see what is on your calendar.  They will only see open/available appointment slots.  You can also connect to GoToMeeting, Google Meet, Zoom etc...



When you connect it, you can pin it to the top of your calendar.  




3.  Share the link.

You can share the link in multiple ways.  
    1. Copy Link and paste in an email.  
    2.  Embed available times directly into an email.


This is the view that will be viewable.   They pick the time that doesn't overlap any scheduled appointments on your calendar.  Click Confirm and it goes directly to your calendar.



For this to really save you time, set up all of your regular occurring appointments and keep the link handy.  

For more advanced features, it requires purchasing these add-ons.  

I do have some added features, but I have been using Calendly for years and just decided to purchase the extra features.  

For example, Notifications and Workflows have been added to my account.  I have set up email confirmations, email reminders, and text reminders.  


I hope you have found this tutorial helpful.  Stay tuned for another tip and trick for saving your a lot of time.




2

your photo name
Back to Top