Add a Little Pizazz…

When using a Google Doc Table as a graphic organizer add some pizazz to jumpstart the thinking process. It may help a child or adult process a specific task faster.  Color filling the cells supports the writer with keeping track of where to type. Why not try simple tips such as this to save some precious time throughout one’s day?

How to Color Fill a Cell

  • Open Google Docs
  • In Doc Click the Cell you want Colored
  • In Toolbar Click Paint Bucket
  • Select the Color for the Cell

NOTE: Once the color is clicked the cell becomes filled with color.

fill cell color

 

Advertisements

Translate w/Ease TY @Google

We live in a global society where people are collaborating and conversing more than ever. Thanks to the “Internet World of Things” people may find themselves communicating with colleagues, relatives or friends located in a foreign country speaking  a foreign language. In our modern society it is becoming commonplace to use various translating methods to effectively communicate with someone who speaks a different language. Through both machine intelligence and various tools Google is helping to minimalize the language barrier.

In schools this may be an extremely helpful tool for multiple community stakeholders. Bilingual communication is one of those areas which should no longer enable teachers, parents or students. There is no reason why a language barrier exists when using email as a correspondence tool. Gmail makes it very easy to translate an email from a foreign language into the everyday language used by the user. Google Docs also offers a translate tool! One special feature I like about the docs tool is when it converts the document to a language of choice it makes a copy of the original document. This provides the user with both a copy in their native language and the foreign one for their records.

Of course if you don’t have either one of the aforementioned tools “No need to worry” as long as there is an Internet connection. One may copy and paste the information into the Google Translate website to convert the text to a different language.  The Google Translate Website even makes it easy for the user to copy the text. An extra bonus is one may listen to the text in both their native language & the foreign one too! I’m thankful for these tools which strengthen our ability to communicate globally.

Translate using GMAIL

  1. Open GMAIL Inbox
  2. Select the Foreign Language email
  3. Click Drop down Arrow (upper right corner across from user name)
  4. Select Translate Message
  5. May need to Select Language
    • Click Dropdown Arrow Next to “Detect Language”
    • Select Language
  6. Boom Email is Translated!

Gmail Translate

Translate using Google Doc

  1. Open Google Doc
  2. Create a New Doc, Click Blue +
  3. Give Doc a Title
  4. Click Doc to Start Typing Content
  5. Select Tools
  6. Click Translate Document
  7. Choose a Language
  8. Click Blue Translate Button

Docs Translate

NOTE: A new document will open with the language translation

Using Google Translate Website

  1. Type “Google Translate” in Chrome Omnibox (search window) or use the following link: https://translate.google.com/
  2. Type or paste text into first text box
  3. Choose a Language in the Second Text Box
    • Click drop down arrow next to Spanish
    • Select language
  4. Click Blue Translate Button
  5. Copy Text to Paste into another program
  6. Or Click Speaker to Listen (may support speaking face to face)

Linking Reading Log to Spreadsheet

Recently one of my blog readers requested a tutorial about linking a Google Forms Reading Log to a Spreadsheet. They explained they are a new teacher and not quite so savvy. This was a good lesson for me about simplifying my blog posts. If you are a teacher interested in creating a custom Google Forms Reading Log then the following directions are for you.

The first tutorial will explain how to create the Google Form. This will be followed by a tutorial for linking the Google Forms to a spreadsheet for collecting the student’s reading data. You will also learn how to copy a Form for making it possible to build a spreadsheet which includes a tab for each individual student’s data. This may provide individualized longitudinal data supporting the readers growth. It is possible to import group data onto a separate sheet for further study.

Beyond collecting data using a Forms & Sheets Reading log becomes a timesaver for teachers. It puts all the information in one single place making it easier for accessing the information.

Creating a Google Forms Reading Log

NOTE: You will need to make multiple copies of the Form. One Form per Student because this is the only way to link individual student sheets to One Spreadsheet.

Linking a Sheet to Create a Spreadsheet

 

NOTE: The above steps will allow the teacher to view all the students in one spreadsheet

1st Weeks of School: Community Builders

The first week of school is here and teachers are looking forward to greeting both old and new students. The first few weeks of school are crucial for building new relationships along with strengthening old ones. This helps to pave the way for student success!

The very first day isn’t too early for introducing community building activities. Community building activities may consist of both digital and non-digital formats. The most important step to remember is remaining focused on the objective of learning about your students. When facilitating a community building activity it is important for the adult to participate too! It is amazing when students find a common bond how differently they interact with you.

Following is a list of a few digital ideas to assist with building classroom community.

Create a Google Slide

  • Use a Google Slide Deck to build community by having students answer a few basic questions.
    • What is your name?
    • Do you have a favorite summer food?
      • Add an image if you do
  • How do you feel about reading?
NOTE:
The first time the slide deck is presented it is with teacher created questions. You can continue this activity by using Poll Everywhere or Answer Garden to create a word cloud for input to create a Slide Deck. The second slide deck will focus upon what the students would like to learn about each other

Please click here to Make a Copy of the Template

I like to thank Alice Keeler for inspiring this template! Please click here to visit a list of Google APP Templates created by Alice: http://alicekeeler.com/scripts/templates/

Drop location pins on Google Map

  • Create a Google Map
    • Students Drop Pins on towns, cities, states, or countries they’d like to visit
    • The student will edit location card
      • Add name
      • Favorite movie, TV, Book or Game Title with image
NOTE:
The first time the Google My Map is presented it is with teacher created directions. You can continue this Answer Garden to create a word cloud or a Google Form to collect ideas from the students. After all the students will probably want to know different information about each other. Providing the students with this type of input may be empowering and supports building a stronger community bond. This method supports by giving a voice for choice to everyone in the classroom community.

 

Use a Google Spreadsheet

  • Add several Sheets to a Spreadsheet
  • Label tabs with food, colors, hobbies, towns and etc…
  • Merge several columns in the first row
    • This is where the question is typed
    • Title 1st Column with Named
    • Title 2nd Column with Answer
  • Share Spreadsheet as group activity
NOTE:
Students don’t have to provide an answer on every sheet. However suggesting a minimum amount of sheets to be answered will help the teacher learn more about the student.

Please Click Here to Make a Copy of the Template

Share a Google Drawing Graphic Organizer

  • Use Google Drawing to Graphic Organizer
  • Compare and Contrast what students like
  • Create one Graphic Organizer for each topic
  • Do this as a group
NOTE:
You may use the data collected from each Graphic Organizer and enter it into a Google Sheet. Create a spreadsheet with one sheet  for each topic. This will allow you to make separate charts to compare. This community builder leads into an introduction to graphing.

 

Please Click Here to Make a Copy of the Template

Navigating Chrome Made Easy…

Please Click here to Make a Copy of the Slide Deck

The above slide presentation was created for a workshop I’m facilitating about “Tips & Tricks for Supporting SPED Students” by using Google Tools. My day job is as a K-12 Special Education Teaching Assistant who has spent approximately two decades working with both elementary and middle school students. One of the biggest issues I’ve noticed across the board and throughout time is the limitation of organizational skills. In this digital age there are many tools which could be used to assist with organization. These tools when implemented as supports may help students quickly access the teacher’s lesson materials.

You might ask what does this mean to a student with physical, emotional or cognitive exceptionalities? Organization and quick access to information may be a game changer for some students. Over the decades I’ve noticed the “Stress” build on some student’s faces as they stumble locating lesson materials. This only sets them behind as they focus on finding the materials and unintentionally miss hearing or seeing the directions provided by teachers. It is my belief with the support of digital devices some of this stress may be eliminated for both the student and their teachers.

Using Chrome Navigation is only one of many Google Tools which may be used for supporting the student of exceptionalities. In an earlier post this year I shared about adding images to Google Calendar.  Visuals images assist some students with understanding information. Adding images such as Favicon’s without text to the Chrome Bookmark manager are less overwhelming then images with text. Of course it supports the student who has low reading skills. It also provides a cleaner look with less distraction supporting the students with focusing issues. Simple tips & trick which tend to be overlooked may eliminate stress for some students as well as the adults who support them. I hope you find the content in the slide deck to be helpful.