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





your photo name

6 comments

  1. Thank you Ms. Stephanie. Im running it tonight...Dr. Flores, Phoenix Az..

    ReplyDelete
  2. Nice! I have a HUB for staff but never thought to make one for myself. This will be nicer than just bookmarking. Thank you for sharing.

    ReplyDelete
  3. You can contact me for a peaceful time frame, a proper Call Girls in Vasant Vihar conference and even an occasion or a capacity; I will take a position right nearby and will complement and improve your area amongst the team. First of all hiring Russian Call Girls in Aerocity, Delhi does not mean you will get infected with immune diseases. Our Agency is a genuine and trusted escort agency and provides a call girl who is educated and well mannered.
    Escorts Service in Aerocity
    Escorts Service in Mahipalpur
    Body Massage in Kapashera, Delhi
    Massage Parlor in Manesar

    ReplyDelete
  4. Thanks so much for sharing. This is very helpful to have all links in one place. Can you share where you get the icons for each category?

    ReplyDelete
  5. This is so very helpful to our admin team. I will be making one for my teachers as well. Where can I find the icons that you used?

    ReplyDelete
  6. Stephanie,

    How did you link the pictures at the top of the boxes? When I try to add one or change one, it shows up with a white background instead of the color of the cell, even when I choose a transparent picture.

    ReplyDelete

Back to Top