OneTab – Share Resources and Save System Memory

WHO: If you are like me, or many educators that I have met, you have quite a few tabs open in your Google Chrome browser right now.  OneTab is great for teachers that are looking for a quick and easy way to share a large number of websites with students.

HOW: Start by installing the OneTab Google Chrome extension.  In a Google Chrome browser window, practice by opening a few tabs with different websites in each.  Click on the OneTab extension and watch the magic happen!  OneTab will close all of the tabs in that window and create a link on the OneTab page that opens.  If you select “Restore all”, the tabs will be reopened.  “Delete all” will remove the links.  Share as a webpage creates a unique URL including a QR code, allowing for a simple way to share resources. You can also name, share, and lock a tab group under the “more…” menu.  OneTab is not only great for sharing links with students and conference audience members, but it also saves precious computer system resources by closing all of those open tabs. Best of all, it is FREE and does not require registration!

WHEN: OneTab is an option for sharing resources at the beginning of a new chapter/unit.  It can function as a central location for students to find websites that teachers have found useful for the class.  I have also found it to be a great option during conference sessions.  I typically open all the resources I talk about (including the Google Slides link), activate OneTab, hit “Share as a webpage” and then copy the link over to a URL shortener such as YellKey or Bit.ly.

Google Science Fair 2016 – Now Open!

WHO:  Teachers and students looking to turn an idea into reality.

HOW: Students ages 13-18 can enter their science project in to the Google Science Fair.  If students need help coming up with ideas for a project, they can use the “Make It Better” generator or teachers can use the “Idea Toolkit” to help inspire students.  Visit https://www.googlesciencefair.com/en/ to register and find more information.

WHEN: Deadline to register is 5/18/16, to view the entire timeline, click here.

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.