Wednesday, May 25, 2016

Hacking Docs: Preformatting Student Worksheets

I recently received this question from a teacher…

If I push out a Google Doc worksheet to my students, and they complete it with their own writing, is there an easy way for me to see what they wrote versus my original questions?

That is a reasonable question. As a teacher you want to assess student work thoroughly and accurately, but also quickly. Anything that helps speed up that process means more time to use for planning creative activities, working directly with students, getting professional development, and more.

If you provide students with a Google Doc that has a series of questions to answer and resources to explore, when they fill in their answers and writings, the Doc could easily become one big block of uniform text from beginning to end, with no easy way to pick out what the students wrote versus what you provided.

One option to consider for addressing this is preformatting your Google Docs templates so the student work looks clearly different from your text. See the rest of the blog post below to learn how to do this, and to see what the final result can look like.

Monday, May 23, 2016

66 Question Checklist for Rolling Out Google Apps

Every day more and more schools move to Google Apps for Education. It is a powerful solution to meet many needs for students and staff. Some benefits include:

  • Programs - A wide variety of online tools including Drive, Docs, Sheets, Slides, Forms, Gmail, Calendar, Sites, Classroom, Hangouts, and much more.
  • Third Party Tools - Thousands of useful Add-ons, Web Apps, and Extensions to provide more features.
  • Modularity - Choose just the tools you want to use, and who has access to them.
  • Updates - Frequent automatic updates to all the tools so you always have the latest versions with the newest features.
  • Central Management - Simple online management of all users, programs, and devices,
  • 21st Century Skills - Support for the skills our students needs for their future including collaboration, communication, creativity, and critical thinking.
  • Price - It’s free!

So it is easy to see why so many schools are adopting Google Apps for Education. However, what may not be as easy is the process of deploying Google Apps for your district. There are a lot of questions to consider, options to choose, and steps to take to get from start to finish in a complete roll out.

I get the privilege of working with loads of schools on all aspects of Google Apps including initial setup, Active Directory Sync, email migration, Chromebook deployment, admin console settings and best practices, and all related professional development for teachers, techies, and administrators. One of the first steps in the roll out process is a checklist of questions I have the schools work through to determine their unique wants, needs, steps and plan for Google Apps.

See the rest of the blog post below for my list of deployment questions, as well as a Google Doc version you can copy and use for your own district. Hopefully these questions will help you think through all the options, catch some issues you may not have considered, and work out a plan for your next steps.

Sunday, May 22, 2016

4 Ways to add Clipart to Google Docs

“Where’s my clipart!?”

When someone first moves from Microsoft Office to Google Docs, that is often one of the early questions that comes up. Certainly Google Docs offers many excellent new features to explore (revision history, voice typing, sharing and collaborating, and more) but we still tend to notice the things that are missing rather than the new tools that are there.

So, yes, it is true that Google Docs does not have a simple Insert Clipart menu option, but that does not mean there is no way to include clipart. In fact, quite the opposite! Google Docs provides (at least) 4 ways to add clipart to your documents.

These options are great for students creating stories, reports, projects, posters, and more, as well as teachers making instructional material, hyperdocs, templates, and such. In addition, all of these options allow you to respect copyrights and teach students about the proper use of media.

See the rest of the blog post below for 4 easy options for adding clipart to Google Docs, with explanations of how to do each.

Monday, May 16, 2016

Googlink: Using Google Drawings like a Thinglink

Google Drawings is often overshadowed by the other Google Drive tools such as Docs, Sheets, Slides, and Forms. However, it is an excellent tool for students and teacher to do many tasks including graphic organizers, teaching math, and desktop publishing (see here for examples of each).

One more educational use for Google Drawings is to create an interactive multimedia poster. This is very much like creating a Thinglink. Let’s call it a Googlink.

If you are not familiar with Thinglink, it is a powerful online tool that lets users annotate images with pop-up text, pictures, videos, weblinks, documents, and more. It can be a great way for students to demonstrate their learning. You can see many examples of Thinglinks here: www.thinglink.com/featured

Although Thinglink is an excellent tool, its free version does have some limitations. As an option, Google Drawings can be used very much like Thinglink, and might be the perfect alternative for you and your students.

See below for information on how to use Google Drawings in a similar way as Thinglink to create, edit, and share interactive multimedia posters, as well as a sample Googlink to test out.

Sunday, May 15, 2016

12 Excellent Add-ons for Google Docs

Google Docs is a powerful word processing program with many unique features including voice typing, the research tool, revision history, web fonts, and much more. However, Google knows that even with all of those features, Docs may not be able to do everything you want it to do. So Google Docs allows you to install Add-ons to extend the capabilities of the program.

Add-ons are third-party tools that provide extra features for Docs. Over time the amount of available Add-ons has grown tremendously. There are currently 179 Add-ons for Google Docs (as of the writing of this post).

So how do you wade through all of the available Add-ons to find the best ones and the hidden gems? To help out I have collected a list of 12 of my favorite Add-ons for Docs. Certainly this is not a comprehensive list, and there are other awesome Add-ons beyond my list, but these will give you a good place to start. Some of these Add-ons will likely be familiar to you, but hopefully you will find a few new ones or be encouraged to dig deeper into one you have tried before.

See below for my list of 12 recommended Docs Add-ons, what they do, ideas for how they can be used in schools, and a quick overview of how to install, use, and remove Add-ons.

Friday, May 13, 2016

Student Reading Log Template with Google Sheets

Reading for pleasure produces great benefits for students. These can include increases in reading ability, writing ability, comprehension, grammar skills, vocabulary, self-confidence, general knowledge, cultural understanding, decision-making abilities, empathy, social skills, imagination, motivation, positive friendships, and more. (For more details see this summary of studies.)

Studies also show that reading for fun is a preferred alternative to traditional homework, especially for elementary students (see details).

It makes sense then that we should find ways to support and encourage students to read. One way to do this is by having the students set reading goals and then track their reading in a log to help reach those goals.

Traditionally a reading log is a piece of paper that students bring home for the summer, or for the course of the school year, to fill in their progress. Unfortunately papers can easily get lost or damaged, and do not give any cumulative feedback on their own.

One way to improve the old reading log is to convert it into a digital format. To help with this, I have created a free Google Sheets template for a reading log. It lets the student set goals and record their reading, and also calculates and displays their progress toward the goals, while making the form easy to share and view by parents and teachers as well.

See below to get your own copy of the Reading Log template, directions for how it works, and suggestions for how to implement this with your students.

Tuesday, May 10, 2016

20 Instant Google Searches your Students Need to Know

Google strives to make their search as useful as possible, bringing back the most appropriate results for the terms you entered. Sometimes though Google goes above and beyond the normal list of search results by providing instant search cards at the top of the page.

These cards contain the information you searched for, but often also include interactive controls to let you dig deeper, branch off, or experience the information in a more engaging manner. As students learn to become better at searching and researching, many of the instant search cards can be useful to them in a variety of their school subjects.

See below for 20 examples of instant searches students can do, the interactive results they get, and ideas for how these could be used to improve learning in school.