Going Google! An Introduction to G Suite for Education

 

WHO: Teachers that are interested in getting started with G Suite for Education (formally known as Google Apps for Education).

HOW: This tutorial video is under 20 minutes in length and is a simple introduction into the icons and options inside of Google Drive, Team Drives, Docs, and Forms. Viewers will learn how to navigate, organize, and utilize a small variety of G Suite For Education products.

WHEN: This video gives examples of how you could use G Suite in the classroom, as well as in School Administration.

Flippity.net Spelling Words – Create Online Spelling Word Practice!

Flippity.net

WHO: Teachers that are looking for an interactive tool to help students study spelling words.

HOW: Teachers visit http://flippity.net/ (a bunch of great tools for teachers!), click on instructions under Flippity Spelling Words, then follow the instructions given on the page.  Teachers need to have a G Suite for Education (Formerly known as Google Apps for Education) account as this functions through a Google Sheets spreadsheet.  After making a copy of the template and adding it to their Google Drive account, teachers will then be able to add in their own words and create their own categories.  In the example, flippity.net uses individual students names to have personalized lists.  Another option may be to put in the spelling lists by week, this would allow students to work ahead if they would like.  The teacher may also decide to put all of their students as the categories and keep the same words in each group, couple this style with the “e-mail to” row in the spreadsheet, and the teacher can have each individual students results e-mailed directly to them.

When adding in words, it is important to note that you can put in a sentence using quotation marks after the word, this will speak to the student and give an example.  This is needed in the case of homonyms.  Another important note to your students is that in the practice and quiz section, the words are case-sensitive.

Once the words are in place, the teacher will need to go up to “File” then “Publish to web….” and finally “Publish”. The user will be prompted to note the URL, this will need to be copied to the clipboard.  Next, go back to the spreadsheet and look at the bottom of the page, there the user will see some tabs.  Click on the “Get the link here” tab, and paste the URL into the highlighted cell. Once this is completed, the teacher can click on the “Click here to go to your Flippity.net spelling words” and see their list live in action.  Copy and paste the new link from the address bar, share the link with students, and enjoy!

WHEN: This tool is excellent for teachers that would like students to get some help with their spelling words.  This is an easy way to get parents involved as well.  Send the link in an e-mail to all of the parents and let them work on it with their students on the computer, tablet, or even on a smart phone!

 

Here are the step-by-step instructions from Flippity.net:

Want to Make Your Own Spelling Words Manager?

Note: Works with Google Chrome and iOS for iPhone/iPad.

Step 1: Modify the Google Spreadsheet Template

  • Make a copy of this template. (You’ll need to sign-in with your Google account.)
  • Edit the Student names. You can have up to 50 lists.
  • Edit the Words lists.
    • Add a phrase in quotes to clarify homonyms.
    • Note: Practice and Quizzes are case-sensitive.
  • Optional: Add an email address in the Email Results to line to automatically receive quiz results.
    • (You can have multiple email addresses separated by commas.)
  • Optional: Label your spelling words by changing the name of the worksheet (at the bottom).

Step 2: Publish Your Spreadsheet

  • Go to File, Publish to the Web…, then click Publish.
  • Copy the link under the Link tab.

Step 3: Get Your Flippity.net Link

  • Click on the Get the Link Here tab of the template (at the bottom).
  • Paste the link in the light green cell (A3) to get the link to your Flippity Spelling Words.

Step 4: Click, Bookmark, and Share

  • Click on the Flippity.net link to see, practice, or take a quiz on your spelling words.
  • Bookmark the page to find it again quickly.
  • Tell your friends and colleagues about Flippity.net.

Google Cast for Education – Free Screen Mirror Tool

Google Cast for EDU - Screen Mirror tool

WHO: Teachers that need an easy way to share student screens with the class.

HOW: Teachers install Google Cast for Education to their Chrome browser from the Chrome Web Store. Once installed, teachers then set up a name and sharing capabilities.  Students can be added via GAFE e-mails, groups, or classes. Using a future version of Chrome, students will be able to select the cast feature and show the class their work.

WHEN: Most commonly, this can be used to display student projects.  However, teachers can use it as a “show me how you solved this” moment. It is also useful for getting feedback from the class on a difficult problem. It could even be used for digital show and tell.

There are many options out there to mirror student displays. The difference here is that no additional hardware (e.g. AppleTV) or paid software (e.g. Reflector 2) is needed to purchase.  The system administrator simply adds the chrome app to the teacher computer that is connected to the classroom presentation system, and the student devices have an up-to-date version of Chrome when it is released.

Using Google Apps For Education in the past has allowed students to click the share button and have the teacher show the work from the front of the classroom.  Google Cast for Education now allows the student to control the screen from their seat. The added benefit is that the teacher can now walk around the classroom. Educators will be able to help students while the work is being displayed.

Here is a video from Google Apps for Education:

Google Forms Adds Option For Quizzes

Screen Shot 2016-06-28 at 11.45.44 AM

WHO: Teachers looking for an easy way to make digital assessments utilizing Google Apps for Education.  If you have used the Flubaroo Add-on in the past, you will enjoy how easy it is to assess student responses using Google Forms now!

HOW: Teachers create a new form in Google Drive, then under the settings tab, there are now three options:

“General” which contains selections regarding restrictions, collecting username, number of responses, editing responses, and viewing summary of responses.

“Presentation” which includes Progress Bar, Question Order, Link for Another Response, and Confirmation Message.

“Quizzes” which allows the creator to make the form a quiz, select when grade is released, and what the respondents can see such as correct answers, missed questions, and point values.

After selecting to make the form a quiz, the user can now add an answer key and point value to Multiple Choice, Check All That Apply, and Dropdown style questions.  Simply click the answer key button at the bottom of the new question and there will now be an area to select point value, and also click on the correct answers to create the key (image below).Screen Shot 2016-06-28 at 11.51.08 AM

After creating the key, the teacher can also add an option for answer feedback, both for correct and incorrect answers, including links (image below).

Screen Shot 2016-06-28 at 11.53.02 AM

Once the responses to the quiz start coming in, the teacher is given great data.  Insights include Mean, Median, and Range of points, a bar graph with total point distribution, frequently missed questions, and graphs for the responses of each question.  By clicking over to the “Individual” tab under responses, the teacher can see each students quiz individually.

WHEN:  Using Google Forms Quiz selection is great for quizzes, but it could also be used for formative assessment or as an exit ticket.  You can even go back and change old forms from before, click on settings, and turn it into a quiz.

SAS Writing Reviser: Proof Reading Tool for Writing Assignments

Screen Shot 2015-10-13 at 9.26.03 PM

WHO: Teachers and students looking for tools to help with proof reading.

HOW: Create a document in Google Docs, Select Add-ons, Get Add-ons, search for “writing reviser”.  You will need to create a free account with SAS Curriculum Pathways.  There are many other tools available at this website as well.  There are many writing tools built in to this add-on.  Be sure to check out the video from SAS Curriculum Pathways below.

WHEN: This tool is very beneficial for anyone who needs help with writing.  It is listed for grades 6-12, but it would be great for college students as well.

 

VexTab Music Notation: Write Music Notation in Google Docs

Screen Shot 2015-10-12 at 2.00.00 PM

WHO: Teachers looking to write sheet music in Google Apps for Education

HOW: Open a new Google Doc, click Add-ons, Click Get Add-ons, search for VexTab, and add it to your account.  Using the add-on will allow you to write the music, then click on insert.  This will then insert the music into your document as an image.

WHEN: This tool is beneficial for music classrooms, teachers, and students.

For more information on how to write the notation with this, click here.

Google Add-On: Form Mule by New Visions Cloud Lab – E-mail Merge Utility

WHO: Teachers and administrators looking to have automatically generated e-mails from Google Form responses.

HOW: Create a new form with name/e-mail address, and all other information you are looking to collect.  Go to Form Responses spreadsheet, click add-ons, and add Form Mule.  Follow the steps to create various e-mail templates and set up triggers.  Then e-mails will automatically be sent when requested.  In the video below, I demonstrate how to use Form Mule for a workshop registration.

WHEN: This is also very useful for order forms, various confirmations, or student referral system.  Another great option would be for Parent-Teacher conferences.

WEBSITE:  http://cloudlab.newvisions.org/scripts/formmule

Tutorial Video: Google Forms with Flubaroo for Automatic Grading

This month I am hosting workshops each Wednesday for teachers throughout the Diocese of Toledo.  This video is a tutorial on how to use Google Forms with Flubaroo for formative assessment.

WHO: Teachers looking to move away from worksheets and would like instant feedback on students understanding of topics.

HOW: The video below gives step-by-step instructions on how to create a Google Form with the Google Sheets Add-On “Flubaroo” for automatic grading.

WHEN: Great option for formative assessment or to replace paper worksheets you may have used in the past.

autoCrat: Google Sheets Add-on creating merged documents.

autocratGrey_lg

Who: Teachers who are looking for a way to turn Google Forms into merged documents. This documents can also be automatically sent via e-mail.

How: Create a form with questions (including an e-mail address if it is going to be sent out).

The questions will become the header row in the spreadsheet. The user will use these headers as the merge rows on their merged document, so the user needs to think ahead.  It is best to create the template that will be used first, so that you know what fields need to be added to your form.

After creating the form and template, open the Google Sheet with the responses.

Click on Add-ons, search for autoCrat, and install it.  You will need to grant permission. After this, click on Add-ons again, hover over autoCrat then click launch.

You will need to create a new merge job.  This is where is can get confusing the first time using this Add-On.  When you start a new merge, you will first need to select a template, this should be the Google Doc you created.

The next step is to map the tags.  This is where you will need to make sure that the tags from the header row match up with the merge fields you created on your template.

After this, you will then need to set up the merge settings.  This is where you can have an e-mail drafted to be sent to your audience.  You also select your naming convention here as well.   You can use the header row tags to merge information into the e-mail itself, as well as, select to have a Google Doc or .pdf sent to the recipient.

In the advanced settings section you can have autoCrat automatically run each time a new form is submitted.  When you are finished here, click save and you are ready to merge!

For those visual learners like myself, here is a great video by Amy Mayer taking you step-by-step through running autoCrat.

When: autoCrat is fantastic for creating certificates; either for your class or for professional development.  It is also very useful for creating invoices for summer programs or anything else your audience may need to pay for.  autoCrat can be a great addition for online registration forms.