Reordering Sheets…

Today I was asked how to reorder sheets from within a Google Spreadsheet. Google Spreadsheets is one of my favorite collaboration tools. It provides the capabilities for assigning different sheets to individual students or a collaborative group. Sheets can become out of order when collaborators use one spreadsheet. No worries! It is easy to drag the sheet into an alpha or numerical order. Just click down on the sheets tab and drag to the right or left to reorder sheets.

Reorder Sheets in a Spreadsheet - drag to the left or right

Easily Ungroup Shared Calendars

In the Google Help Forums, I spotted the following question. “If there was a tool for ungrouping and grouping shared Google Calendars?” Naturally, my reply was you can group shared calendars by checking them off individually. However, there is a tool for users to ungroup all at once by using the following steps.

  1. Open Google Calendar
  2. Click Option Settings (3 vertical dots) for the Calendar to leave open
  3. Select “Display this Only”

I suggested to the user about grouping calendars together and embedding into a New Google Site. My idea would provide a simple method for viewing several team member calendars at once.

You may find the following Google Help Center resources beneficial:

  1. CALENDAR: Add a Google Calendar to your Website
  2. NEW SITES:Add Google Files Video & More
    • Scroll to Section: Add HTML, CSS, or JavaScript code to your site

If you would like more detailed instruction please leave a comment.

The Secret of Publishing a Google Site

During the creation of a collaborative Google Site, I discovered the “Publish to Specific People” setting. This share setting provides the ability to restrict a website with a chosen group of people instead of sharing it with the world. In an education setting, this provides the teacher with the power over privacy concerns.

Teachers have the control to share a collaborative website between two classrooms or small groups of students. Connecting classrooms is an easy method a teacher may use for nurturing young students with becoming respectful digital citizens. It also provides the opportunity to practice communication and collaborative skills along with creativity.

Publish to Specific People

Click Publish

  • Type a Website Name
  • Under “Who Can View My Site” click Manage

Type Name Click Manage

  • Add Specific People by typing name or email in box under “Invite People”

add email here

  • Click Edit Pencil to Select what the Specific People can do when visiting the site
    • Can Edit
    • Can View Publish

Can Edit or View.gif

Steps to Publish a Google Site

Click Manage

  • Choose one of the following:
    • Anyone can find and view the published version
    • Anyone at “Domain name” can find and view the published version
    • Specific people can view when published
  • Click Blue Publish Button

 

 

Lesser Known Tools Residing in GMAIL…

If you ask a teacher or student which G Suite for Edu tool they use most often I bet the response would be “GMAIL”.  They probably feel pretty confident about their mastery of composing and sending an Email. Some might even say they are ninja’s or Guru’s when it comes to using GMAIL. But are they really more than proficient users? Most people only really use the very basics of sending and receiving email.

I created the following GMAIL Learning Square to support colleagues, friends and students with learning about some of the hidden treasures residing within GMAIL.

GMAIL LEARNING SQUAREScreen Shot 2018-03-08 at 6.00.47 AM.png

Click here to Open the Learning Square

  • TYPE USING DIFFERENT LANGUAGES
    • Useful for Support ELL Students and their families
    • Supports Connecting Globally with Classroom from other countries
    • May be integrated into a foreign language or social studies unit
  • CREATE LABELS
    • Similar to a Folder or Cabinet for storing Email
    • Supports proficient Email Search
    • Helps students organize important messages
  • FILTER EMAIL
    • Automates EMAIL Filing process
    • Timesaver for organizing Email
    • Basis for an efficient Email search
  • UNDO SEND
    • Provides set amount of time to undo a sent Email
      • This is for those with a “Trigger Happy Finger”
  • CONTACT GROUPS
    • Eliminates having typing individual Emails
    • May use in to share Google Drive Files
    • Timesaver enter one name versus multiple Email addresses
  • USE TASK SPECIFIC ADDRESSES
    • May use to sign up to different educational websites
    • Makes it easy to filter the incoming mail from “Free Sites”
    • Use to create a “Help Desk” specific Email address
  • CANNED RESPONSES
    • Timesaver by providing a template for common responses
    • Use to correspond with parents or students
      • Create set answers to questions about:
        • Field trips
        • Special Project Assignments
        • Classroom Events
  • GMAIL OFFLINE
    • Allows the user with limited internet access to compose Email
    • Email may be read and organized off-line
    • Changes sync and update once connected to the internet
  • TYPE USING DIFFERENT LANGUAGES
    • Correspond with ELL students
    • Supports correspondence with non-english speaking guardians
    • May be used in a foreign language class or other content area

One beauty of using G Suite tools is the hidden helpful extra features. These extra features or tools often add a powerful punch to the usability. So the next time you open a Google APP click around and see what you can discover.

 

Why Dim Google Calendar Past Events???

The “New Google Calendar” user interface (UI) offers quite a few helpful updates such as brightness control for past events. You might be thinking, “Why is it important to dim the color of past events?” In the world of education this is one of those “No Brainer” answers in support of visual learners. If a students maintains a Google Calendar as a schedule for school assignments and events it supports them with visually keeping track of daily activities. When a student is absent or behind and notices an event appears a brighter or pastel color this sets a signal off to check the event. The new calendar also offers both notification and reminder tools. When all three calendar tools are used together this becomes a powerful support for helping students keep track of everyday school activities.

G-cal Past events

How to Reduce Google Calendar Event Brightness

  1. Open Google Calendar
  2. Click Gear Icon (upper right corner)
  3. Select Settings
  4. Scroll Down to View Options Section
  5. Uncheck “Reduce the brightness of past events”
  6. Click Settings Back Arrow