Monday, January 30, 2017
Tuesday, January 24, 2017
10 Google Tricks to Learn
From Alice Keeler's Blog - http://alicekeeler.com/2016/12/26/10-google-apps-tricks-learn-2017/

1. Force a Copy
When I create templates I like to share the templates in a way that prompts the user to create a copy. Notice if you go to alicekeeler.com/poo that it does not take you directly to the document but rather asks you to copy it first.
To accomplish this remove the /edit at the end of a Google Apps URL and change it to /copy.
Example:
https://docs.google.com/spreadsheets/d/1RbBc22bEPp8eDoAhR3y7NnP4h7ThEz4TvZQIO9SsCiM/edit#gid=149517262
https://docs.google.com/spreadsheets/d/1RbBc22bEPp8eDoAhR3y7NnP4h7ThEz4TvZQIO9SsCiM/copy
I will usually create a short URL such as tinyurl.com or goo.gl out of the long Google Apps URL where I have modified the URL with slash copy.
2. Filter Google Drive
In the search bar of Google Drive (tip: use the slash key on your keyboard to put your cursor automatically in the search bar) is a tiny triangle. This allows you to filter by file type, date modified, or who you’ve shared a document with.


3. Add Clip Art
In Google Docs, Sheets, Slides, Forms, and Drawings you can add clip art images. When inserting an image look for the “Search” option. First search for an image. After the search results come up notice there is an option for filtering the image type. The default is “Any type” but this can be changed to “Clip art.”


4. Utilize Revision History
Google Docs, Sheets, Slides and Drawings have a revision history. (Not on Forms, sorry.) This shows the edit history of the document.


This is an important feature when collaborating with others. Do not be afraid of collaborators “messing up” the document. Use the File menu to “See revision history” and “Restore this revision” for a time when the document was not messed up.


5. Control Slash
In Google Apps you can hold down the Control key and press slash (/) to open up keyboard shortcuts. Learn one keyboard shortcut a week, you’ll be a ninja at the end of the year!


6. Plus Mention
When making comments in a Google Doc, Sheets, Slides, Drawing or Google Classroom you can mention someone to direct their attention to the comment. Start with a plus sign followed by their email address. +bob@myschool.org
A new feature when adding a plus mention to a comment is the ability to assign as a task to the person.


Notice in Google Drive you can filter your documents for items that need to be followed up. Follow up on “Action items only” shows you documents that someone has assigned you a task in a plus mention comment.


Next to the document title in Google Drive is a badge indicating how many action items you have in that document. Click on the badge to move to the action item.


7. Document Outline
When typing in a Google Doc utilize headings to outline the important parts of your document. Not only does this make your document more accessible for screen readers but Google Docs will automatically populate a table of contents.


The document outline (table of contents) appears on the left-hand side. Click on the headings in the outline to jump to that portion of the document.


8. Explore Tool in Slides
In Google Slides the Explore tool does more than just search the web (it does that too). It uses machine learning to read the content of the slide and suggest attractive slide layouts. As you change the content on the slide the slide layout suggestions change.


9. Use Templates
You can create documents using Google Drive but you can also go straight to the product website to create documents.
In each of these is an attractive interface to filter for that document type and also a template gallery. Locate the link to the template gallery in the upper right corner.


10. Explore Data in Google Sheets
Select data in a Google Sheets spreadsheet and use the Explore tool (bottom-right) to answer questions about your data. Ask in plain English.



Tuesday, January 17, 2017
Google Forms: Choose a Random Winner
From Alice Keeler's Blog - http://alicekeeler.com/2017/01/04/google-forms-choose-random-winner/
Google Forms: Choose a Random Winner
Choose a random winner from those who fill out your Google Form. Use this Add-on I coded in Google Apps Script to automatically select a winner, create a spreadsheet listing the winner and 19 runner ups and receive an email with the winner and links to the Form and spreadsheet.
If you are having participants at an event fill out an evaluation form you can use this Add-on to randomly select people for a drawing. Randomly select a student in class to share about their work.
Template
In order to use this template you must use the above link to create your Google Form or copy and paste my code from the script editor into the script editor of your existing Google Form. Note: Your form MUST automatically collect responses in order for this code to work.
Create Your Form
The link above will prompt you to make a copy of my Google Form template. Create your form questions just as you normally would.
Collect Responses
Just as you normally would, have people fill out the form.
Choose a Random Responder
At any point after collecting responses, use the puzzle piece icon in the Google Form to run the Add-on “Choose Random Responder.”


The Add-on will randomly select a winner from all form responses. A pop-up will indicate who won, by email address. The pop-up will also tell you the response number.


Individual Responses
In the Google Form, click on “Responses” and then click on “Individual” to see the individual responses. There is a spot to arrow to each of the individual responses. You can type in the winner’s response number and press enter to jump to that person’s response.


Spreadsheet of Winners
Each time you use the Add-on a spreadsheet is created. You will receive an email with the link to the winner spreadsheet. The Add-on chooses one random winner and 19 runner ups. (There may be duplicates, the formula does not take into consideration if someone has already been chosen.) Use the spreadsheet to view the 19 runner ups.
Add the Add-on to YOUR Google Form
If you already have a Google Form, you will need to copy and paste the code into your Form.
If you used my template you do NOT need to do these directions.
If you used my template you do NOT need to do these directions.
Open the code and use Control A to select all. Use Control C to copy.
In the Google Form, click on the 3 dots icon in the upper right. Choose “Script editor.” You will want to paste (Control V) the code into the script editor.


In the script editor you will need to do a few things.
- Suggestion to remove the default function already there. (Control A, delete).
It does not matter if you leave it there, but you also don’t want it in the way of your code. - NAME the script. What you name it is what shows up in the Add-on menu. I named mine “Choose Random Responder.”
- Click SAVE. It’s in the toolbar.
- Select the “onInstall” function from the toolbar. It probably says “Select function.”
- Run the script. You want to install the Add-on. Press the triangle icon in the toolbar.
- Close the script editor, you don’t need it anymore.
You need to do this PER FORM. This Add-on is NOT available in the market place.
Tuesday, January 10, 2017
Google Training - right when you need it
Awhile back Google bought a company, Synergyse, that integrates G Suite training into the Google Apps. Using Gmail, Google Drive, etc… tutorials will pop up directing you through how to use the product.
See this link for more information: http://alicekeeler.com/2016/11/28/g-suite-google-apps-training-chrome-extension/
See this link for more information: http://alicekeeler.com/2016/11/28/g-suite-google-apps-training-chrome-extension/
Tuesday, December 6, 2016
Creating and Using a Google Form Quiz
Thank you Tony for sharing this week's tip!
Google can do a lot of things and most recently they have updated their Google Forms to have a built in feature to grade quizzes. Below is an image that is a link to a document that will walk you through these steps!
Google can do a lot of things and most recently they have updated their Google Forms to have a built in feature to grade quizzes. Below is an image that is a link to a document that will walk you through these steps!
Tuesday, November 22, 2016
Google Sheets: Split Text to Columns
The following is a blog post by Alice Keeler. (If the images below don't work, go directly to the blog post).
When you copy and paste into Google Sheets you will notice an option will automatically appear allowing you to split the text into columns. Choose the delineator and poof, text is split.


Data Menu
You can also manually activate text to columns by highlighting your data and choosing “Split text to columns” from the Data menu.
Eats Data
Note that choosing to split text to columns will eat the data in adjacent columns. Tip to insert blank columns before splitting your text to columns.
Tuesday, November 15, 2016
Printer Settings and Presets
With our new copiers, you can set them to double side, hole punch and/or staple. Below is a quick screencast on how to create those settings.
Tuesday, November 8, 2016
Pin Tabs in Chrome - Keep important tabs right in front
Google Chrome allows you to pin a tab in the browser. Pinning a tab moves the tab to the front and locks it to the front. This can be really helpful for websites you visit a lot.
Alice Keeler has a great blog post tutorial on how to do this. Take a look:
http://alicekeeler.com/2016/10/21/pin-tab-google-classroom-email-gradebook/
Alice Keeler has a great blog post tutorial on how to do this. Take a look:
http://alicekeeler.com/2016/10/21/pin-tab-google-classroom-email-gradebook/
Tuesday, November 1, 2016
Google Forms in Google Classroom
This post is a quick tutorial on how to use Google Forms and how to integrate it into Google Classroom. Your tech liaisons are always here to help if you have any questions.
http://www.alicekeeler.com/teachertech/2015/10/07/google-classroom-google-forms-magic/
http://www.alicekeeler.com/teachertech/2015/10/07/google-classroom-google-forms-magic/
Tuesday, October 25, 2016
Database of YouTube Channels for Education
YouTube Channels for Education Database
The spreadsheet linked below is a collection of YouTube channels that are good for your classroom. The spreadsheet is organized by subject area and they are always looking for more suggestions.
https://docs.google.com/spreadsheets/d/1jqRf5BQ2nZ-Og12jTfxPIxtr9pDohckx38wXfhhi_Xs/edit#gid=0
The spreadsheet linked below is a collection of YouTube channels that are good for your classroom. The spreadsheet is organized by subject area and they are always looking for more suggestions.
https://docs.google.com/spreadsheets/d/1jqRf5BQ2nZ-Og12jTfxPIxtr9pDohckx38wXfhhi_Xs/edit#gid=0
Friday, October 21, 2016
Changing Staples Preferences at the Copy machine
Sometimes you may arrive at the copier and find that it out of staples (as someone nicely put a note on it and informed Janet), and you need to make sure that you can still get your job. You can make sure that your job comes out by telling it not to staple your job. To do this open up your queue of print jobs
Highlight the job you would like to print and click on the options button.
Be sure that the stapling option is on "no stapling."
Now press print and you are all set!
Tuesday, October 18, 2016
Google Forms Quick Start Guide
If you are looking to start using Google Forms in your classroom, this post from Alice Keeler might be helpful. It goes over how to add questions, the various questions types, formatting your form and more.
http://www.alicekeeler.com/teachertech/2015/04/06/google-forms-quick-start-guide/
http://www.alicekeeler.com/teachertech/2015/04/06/google-forms-quick-start-guide/
Tuesday, October 11, 2016
7 more Tips for learning Google
The full post can be found at http://alicekeeler.com/2016/03/14/7-more-tricks-to-learn-during-spring-break/ Alice Keeler is great and always has the best tips and tricks.
This post will include:
This post will include:
- Hint Text in Google Forms
- Commenting in Google Docs
- formatting a cell in Google Sheets
- Editing the slide master in Google Slides
- Making straight lines in Google Drawing
- Quickly closing a number of tabs in Chrome
- Linking to assignments in Classroom
Friday, September 23, 2016
ViewPure - Remove ads from YouTube
If you are concerned with showing YouTube videos in the classroom because of the related videos, ads and comments, try ViewPure. Simply visit ViewPure and search for a video. If you know the URL for the video you can also just paste it there. It's that simple and you will be viewing your video without any distraction.
Saturday, September 3, 2016
Rolling over your homework website to this school year
As a reminder, you'll want to roll over your homework website to this school year or create a new one. Below is a quick video to show you how to do that.
If you have any questions, feel free to contact your TILs.
Tuesday, June 7, 2016
SymbalooEDU - visual bookmarking tool
|
It's all about the tiles and students just click or touch the tile to navigate right where you want them to be online. With a free account, one can access your bookmarks from anywhere with any device and share online resources with "yourself" other teachers, or your students for unique lessons.
Here is a screen shot of the WEBMIX for our NYS Teacher Centers with a tile/link to our Partner Companies. Just search "New York State Teacher Centers" in the public webmixes and you can keep this as one of your tabs.
You can search SymbalooEDU for any topic and grab the tiles, like "Math Grade 3".
|
Wednesday, June 1, 2016
Reducing the File size of a PDF
There are times when a pdf that you have created is too big for things like sharing via e-mail. You can use Preview to reduce the file size so that it is more manageable for the purpose that you need it for. You should note that this will also reduce the quality of the document.
1 -Open your PDF in Preview. If your PDF files are set to open in Preview, then simply double-click the file. If not, secondary/right click on the document and choose to open it in Preview. (If you aren't sure how to use secondary click you can view this video.)
Create a copy of the original file to test this method before applying it to your final PDF. This method can result in a lot of quality loss.
3 - Save the file. Select your desired location, then click Save. Your file will be saved in a much-reduced size. This may result in a noticeable drop in quality.
1 -Open your PDF in Preview. If your PDF files are set to open in Preview, then simply double-click the file. If not, secondary/right click on the document and choose to open it in Preview. (If you aren't sure how to use secondary click you can view this video.)
Create a copy of the original file to test this method before applying it to your final PDF. This method can result in a lot of quality loss.
2 - Click File and select export. In the options, click the Quartz Filter menu, and select "Reduce File Size."
3 - Save the file. Select your desired location, then click Save. Your file will be saved in a much-reduced size. This may result in a noticeable drop in quality.
Wednesday, February 24, 2016
Flubaroo is an Add-On for Google Sheets spreadsheets that will automatically grade student responses to formative assessment submitted through a Google Form. Flubaroo has the option to email students their results. Since not all schools have email turned on for students, Flubaroo has another option. Flubaroo recently added the feature to create a summary report on a Google Doc that is shared with the student through Google Drive. Click here to view the Flubaroo blog post.
To learn more about this and how to create an assessment in Google Forms, visit Alice Keeler's blog.
To learn more about this and how to create an assessment in Google Forms, visit Alice Keeler's blog.
Labels:
classroom data,
Google,
student work,
teacher resource
Self Paced Google Training
If you are looking to get some Google Training, but need to do it on your own time I encourage you to check out the LHRIC MLP catalog. At the bottom of the list you will see listing for self-paced courses in: Google Doc, Google Forms, Google Sheets, Google Slides as well as Digital Citizenship, Smart Notebook and Wiki.
Just go to www.mylearningplan.com to see what course are offered (plus they are free!)
A playlist of video tech tips
https://www.youtube.com/watch?list=PLtx-qUNKJwDwazAWE7UaLATKaV0gcpNYv&v=W4eKfe-fNYs
Subscribe to:
Posts (Atom)











