Monday, September 4, 2017

Alternating Row Colors in Sheets



One of my favorite Google tools is Sheets. I use it for much more than just data spreadsheets. There are many tweaks that make Sheets extra cool. Conditional formatting, charts, cell formatting, and more. One of the things that is easy to do but can be labor intensive is alternating row colors for a whole sheet. The good news is that there is a quick and easy way to do this with just a couple of click! Follow the steps below to alternate colors for rows in an entire spreadsheet.



  1. In Google Sheets, click on “Format” and then click on “Alternating Colors.

  1. You can select a range in the “Apply to range” field if you only want part of the sheet to have this formatting or leave it as the whole spreadsheet.

  1. If your sheet has a header or footer select them in the options to make them bolder by default.

  1. You can use the default color options if they work for you, or you can make custom color options below.

  1. Click “Done” when finished!

  1. If you change your mind you can click “Remove alternating colors”.
  







Open up a Google Sheets and give it a try!

If you want these steps in a Document click Here!


Monday, August 21, 2017

TEAM Drive: Getting Started



We all collaborate with Google Drive, but many of us have been stung by losing access to files when a collaborator/owner leaves the district.​ No worries, TEAM Drive to the rescue! TEAM Drive allows you and your teaching team to collaborate like superheroes. This is a separate Drive within your Google Drive that you can share with select individuals or groups. The best part, no one who works in the Drive owns the files...meaning if they leave the files do not go with them, they remain in the TEAM Drive! Dig in and see what TEAM drive can do for you and your grade level, department, building, or other teaching teams.



Create a TEAM Drive:
  1. Open Google Drive and click on “Team Drives” to the left.




  1. Either right click in the Drive screen or click the blue “New” button.
  2. Name your new Team Drive.






Add Members:
  1. Click on “+Add Members” at the top.




  1. Enter in the members’ names (or Domain Group name). Choose what level of access each member (or group) should have.




  1. Here is a breakdown of the sharing options:




  1. Click “Send”.




Edit Theme:
  1. Click your TEAM Drive name in the top.




  1. On the drop-down choose “Change Theme”. You will have the choice to choose a template or upload your own (1280 X 144).






Add Content to Your TEAM Drive:
  1. Drag content from your Drive into the TEAM Drive.
  2. Things to keep in mind:
    • Anything put in TEAM Drive will belong to the TEAM Drive.
    • It will be removed from your Drive.
    • If the file is shared with others, that sharing is kept. You can edit these in the “Manage Members” option.
    • You can not drag folders into the TEAM Drive (Domain Admins can).
    • You can not put anything in the TEAM Drive that you are not the owner of.
    • Use the keystroke Shift + Z to add a copy of something from your Drive into a Team Drive.





Dig in and see what TEAM drive can do for you and your grade level, department, building, or other teaching teams.

If you want these steps in a Document, Click HERE!



Saturday, August 5, 2017

Using Google Cast for Education

One of the greatest things about having student devices is the ability for students to share their learning. Google Cast for Education is the perfect tool to help students share their work with others through the teacher’s computer screen. This extension allows students to project their computer screen to the teacher’s computer. While this computer is attached to the projection unit the student’s screen to be seen by the whole class. This is an easy way to have students share, teach, and collaborate with others. Follow the steps below to get set up and casting.


Teacher Set Up and Launch:
  1. Install the Google Cast for Education Extension from the Chrome Web Store.


  1. Click the Cast icon in Chrome to set up the extension.


  1. Choose a name for your device.


  1. The main landing page of the extension looks like this:


  1. You can click the “Settings” icon to rename your device. You can click the “Share” icon to select who to allow casting to your device.
  2. Choose who can cast to your screen. (Keep in mind that these must be from within your own domain.)


  • You can just click the box and all your Google Classroom groups will appear to select which you want to allow.


  • You can type in any group created in your domain contacts.


  • You can enter a specific email address to allow sharing


  1. You can also set up how they access:
  • Can request: Teacher will be notified that a student is requesting access
  • Can Cast: Student can cast with no assistance from teacher

Once the extension is installed all you need to do is click on it to allow students access. It needs to be running in order to allow students to cast to your screen.




Student Casting:
  1. Students will click on the 3 dots in Chrome and click on “Cast”.


  1. In the popup screen they will choose the device to cast to.


  1. Their screen will now be displayed on the teacher screen.
  2. When they are done they click the blue casting icon in the top of Chrome.


  1. Click “Stop”.




If you want these steps in a document, click Here!


Sunday, June 4, 2017

Format Multiple Text Entries in a Document



We have all been there. You have slaved away at a document and are looking it over for the last time. You have some headings, terms, or something that stands out that you really want to change the text formating for but do not want to go through and select each entry and manually edit them. You don’t have to! Google Documents has this awesome (and usually unknown) tool that lets you do it in one easy action! Follow the steps below and save your time (and your sanity)!




Keep in mind that you have text that is already different than the rest of the document


Example:
  1. In the document you have created, select a section that represents what you want to edit. Remember, you need to have this style formatting that is different from the rest of the text in your document...example: headings, vocab terms, listed items…
  2. Right click on the text.
  3. In the pop-up menu click “Select all matching text”.




  1. Change the formating color, size, font, etc as you want.



All the text that matches that formatting in now changed! No more going one-by-one to select and edit text! Now sit back and enjoy the moments saved (as well as your sanity)!



If you want these steps in a Document, Click Here!


Tuesday, May 30, 2017

Transfer Your GAFE Content to a Personal Gmail Account

The end of the school year always brings on changes in staffing or High School students moving out of school domain. In the past GAFE users had to download all their content and then deal with transferring manually into another Gmail account if they wanted to keep their Google files. There is now a very easy way to transfer all your GAFE content into a personal (or other school) domain easily! Follow the steps below to move your G Suite content to a new account!




  1. Click on your profile icon in the top right of your screen and click on “My Account”.




  1. The center column is “Personal Info & Privacy”. Click on “Control your content”.
  2. You will be given 2 options:



Download your data:
(Create an archive with a copy of your data from Google products.)
By clicking this you will create an archived copy of your content (any content you want including every Google App or Tool available.


Transfer your content:
(Copy and transfer your emails and Google Drive files to another Google Account.)
By choosing this option you will be asked to choose a Gmail account to make a copy of your content and transfer that copy to the new Gmail account.




  1. Choose "Transfer Content" and click “Start Transfer”.
  2. Enter in the email address you wish to have content sent to and then click “Send Code”.




  1. You will need to sign into the account you are sending content to and check for an email with a code. Click “Get confirmation code” and copy the code and enter it in the original account. You will be prompted to select/unselect Drive and Gmail to transfer.
  2. Once you start the process you can leave the page you are on. Your account that is receiving the content will get two emails:
    • The first one will state that “Your content is on its way”.


    • When transfer is completed you will receive a second one stating “Your content has arrived”.







Things to consider:
  • Google Forms do not transfer.
  • Google Sites do not transfer
  • I have had mixed reviews (the first time I did this not all my files transferred). You may want to visually double check that all your files do make it over.


If you want these steps in a document, click Here!