Skip to content

Basic Mail Merge Template for Google Docs

2014 July 27
Comments Off
by SSedro

Finally played with this basic mail merge template for Google Docs. I like it. It’s a great tool for teachers.


monosnap-window title-1


In the data tab create a spreadsheet of your class with the following information:

  • student first
  • student last name
  • the correct pronouns (he/she, him/her, his/her)
  • email of each parent
  • parent names.

Set that up once and you are in mail merge Nirvana for the rest of the school year. Easily send personalized info to parents all year long. It should work for mailings of less than 100, so secondary teachers may need to organize it by day of the schedule.

Check out this LifeHacker post for directions and the link to the template:



iTunes – Regifting an App

2014 May 14
Comments Off
by SSedro

Our school is in the process of migrating from school-managed to family-managed iPads.  I think it is a good move since it will allow us to better differentiate the iPads for each learner.  However, getting there is a bit of a slog.

Today I created these directions to help parents whose children either didn’t receive or managed to delete the iTunes email letter which allows them to redeem a gifted app.  Fortunately, the sender is not charged for the app until it is redeemed. There is no additional charge incurred to resend the gifting letter. You can find an easier to print version here.



iTunes – How to Regift and App


Occassionally, your child may not receive or may delete the iTunes email message letting him or her download an app you have gifted to them. Fortunately, you are not charged for an app until it is redeemed, and it is easy to resend the gifting message. Follow the steps below.

Open iTunes on a computer.

Open iTunes on a computer.

Click on the iTunes Store.

Click on the iTunes Store.

Sign in with your account.

Sign in with your account.

In the Quick Links section click on Account.

In the Quick Links section click on Account.

Scroll down to Purchase History. Click on Manage Gifts.

Scroll down to Purchase History. Click on Manage Gifts.

Locate the gift.

Locate the gift you sent to your child. Click on View.

Locate the gift.

Click Resend Gift.

Your child will receive another email message containing a link which allows them to redeem the gift.

Click Resend Gift.

Thank you.

Thank you for sending the link again. If your child still does not receive the email, please double check the address to which you sent it. If you sent it to the wrong email address, go back to the app in the app store and gift it to the correct address.

Google Presentation: Printing Speaker Notes

2014 April 8
Comments Off
by SSedro

Every now and then someone asks me how to print speaker notes for a Google Presentation.  I made this video to go with a particular unit, but these steps can easily be generalized.


Google Docs Chat: Changing a Distraction into a Powerful Tool

2014 March 31
by SSedro

The Ed Tech team at my school has been sipping the Google Apps kool-aid for a long time. I still remember how enchanted I was the first time that four of us in different parts of our geographically large school were collaborating in real time on a budget document. The chat window was open and comments were being added.  It was powerful, effective collaboration.


Our elementary students dearly want to chat while working, but that usually comes at the cost of their productivity.  During work time, some are irresistibly drawn to filling the chat box with illuminating sentences such as these:

I like cheese!
I am awesome!!!!!!

Today I was happy to have a chance to teach a grade 4 class how to effectively use the communication tools in Google Docs. In their homeroom they have been working in groups to research endangered environments.  They took notes in a variety of formats, some on posters, some on sticky notes, and some on iPads. Our next step was to have the group members combine their notes into a reference document.  As their final step, each student will use their group’s reference document to create their own Haiku Deck presentation which will be presented and then posted on their blog.


Before class we set up a blank document for each group in a collaborative folder in Google Docs.  That saved time and put the documents where we could easily find them.


To start class I explained that they were going to have a chance to use Google Docs in the way that adults use them on the job. They were going to make one document that contained the notes for their entire group. To help them work efficiently, they were going to use the chat box and the comments feature.


I opened one of the team documents and had a student open the same document on her computer so we could review how you can tell where someone else is working in a document.  Next, I typed some sentences which included errors. The student modeled correcting those, since that is one way people collaborate.  After that I used the comment feature to ask a clarifying questions about something.  Finally, I used the chat to ask her a question.

I gave the students these guidelines for their work.

Screen Shot 2014-03-31 at 1.38.48 PM


Knowing that the chat feature  could prove to be too distracting, I also let students know that if needed, we would move them to Mircosoft Word and then we could paste their notes into Google Docs at the end of the period.


Students took the assignment very seriously.  They got right to work.  At first the chats were full of organizational questions about who would do what and where it would go in the document.



After they had been working for a while, the chat discussion turned to the contents of their document. They asked clarifying questions and shared new information with the people writing those sections.
monosnap-window title-5         monosnap-window title-4

It became clear as the students worked that they were taking the time to read over each others writing. You could tell by the colored cursor marks that sometimes one student was following behind making corrections.


monosnap-window title-6


It was a highly productive 35 minute work time.  All of the documents were well-underway by the time we logged off the computers. One highly distractible student commented that he only managed to add two notes.  I was not too worried about that because he really was following the chat and reading what people were writing.  He was more focused than I’ve ever seen him before and I suspect he learned quite a bit from what the other children were writing.


At the end of class we debriefed the process. Here are their observations.

What went well:
  • We worked together well and we used the chat to help us figure out how to change what wasn’t right.
  • I asked for help and people responded positively.
  • Sometimes kids asked for something and they got it.
  • We could do what we did best to help our group.
  • On the chat we figured out what each person should do. Then on the last part we all had a job and we got it done.
  • Sometimes it worked better to walk over and talk to the person.
What was hard or needs improvement:
  • There were so many people doing things, like adding spaces and that made my words go down to a different page.
  • It was confusing to have so many people on a section while you were on trying to correct it.
  • It was hard because I had to watch the chat and do my own work.


I was able to tie that last comment back to the start of the school year. During our digital citizenship lesson we used Common Sense Media’s Digital Passport games. One lesson from the Twalkers game focused on the challenges of multi-tasking.  The children all lit up as they made the connection. A few students shared their successful strategies such as only checking the chat box occasionally.


Overall I was very pleased with the lesson.  It changed beguiling features from distractions to tools. The students had more chance to interact and their interactions were on task. To my delight, the students continued to use these tools later in the morning.  They  must have resumed working in their classroom using their iPads.  Since the chat is not available in the Google Drive app, students started using the commenting feature instead to ask questions regarding specific portions of the text.

monosnap-window title-7                 monosnap-window title


I hope this lesson is sticky.  I will be watching to see if in the future, they revert back to the I like cheese comments or if they continue to use the chat and comments productively.


How do you tame the distractions in Google Drive?  Please share strategies that are working well for you.



Do You Travel with Friends?

2014 March 30
by SSedro

Over the past decade I’ve had the delight of traveling with extended family and friends a few times.  The only negative part of the trips were tracking expenses as we were traveling.  When I saw the Let’s Settle Up Later app on the Apps Gone Free app, it sounded like just what I needed.


Last week my parents visited us. We spent time sightseeing in Singapore and Bali.  I used this app to track all of our expenses from taxi rides to concert tickets to restaurants. It worked beautifully.

To get started, I created an event. In this case, I created an event for Singapore and a different event for Bali since they have different currencies.



Inside the event I set up the participants. With that done, it was a simple matter to tap the expenses button and add a new expense.


The app automatically split the cost evenly. I could change the amount that each person owed. This was especially useful if only certain people were involved in an event. As I removed certain people from the expense the app recalculated what everyone else owed.


I could check totals at anytime.



When we were done, I was able to e-mail an itemized account and a summary to each person. In the summary, the app had already figured out the quickest way to settle expenses. It showed who should pay what to whom.


The app works so well that I was eager write to this blog post to share it with other people. When I went into iTunes, I was sad to see that the app is no longer available, at least not in the US app store.

I searched the app store for other apps with similar features. It looks like Splitty is the one which works the most similarly to Let’s Settle Up Later. It can even handle multiple currencies in a single event.

Screen Shot 2014-03-30 at 3.40.24 PM

If you give it a try, please let me know how you like it.


Editing Your Google+ Profile

2014 February 20
Comments Off
by SSedro

Our school has been slowly rolling out Google+.  We started in the high school where both staff and students are able to have access to it.  The principal now uses their HS community for his daily announcements.  They  are using Google+ for their groups and clubs.  Last spring we also began using it with select cross-school committees.

One reason for our slow roll out was the challenges Google+ was creating for YouTube channels and working with photos in Picasa web.  Now that those are mostly resolved, we wanted to roll it out to the rest of the faculty and staff.

Our first challenge was finding a compelling use for Google+ and to clarify when to use Google+, when to use email and when to meet face-to-face. We created an ES Faculty community and we allowed everyone to join the community being used by our research and development team.

We did a soft roll out in December. We flipped the switch and let staff know it was there and that there would be training at a later date. That way, eager adopters could get started and the rest know why the new link appeared in their Google Apps.

Next year our primary and intermediate schools will merge into one larger school.  The ed tech departments have already merged, moving into a shared space in the elementary library.  For the Google+ training, we worked with intermediate staff in one session and the primary staff a few weeks later. It was efficient to have all of us in there supporting the faculty.

Prior to the workshops we sent out directions to enable everyone to set up their Google+ profile and tweak the notifications.

In the workshop there was confusion around Google+ circles since that is the main organizational tool in Google+ but we are primarily using Communities.  Some people were relieved to realize they didn’t have to follow everyone back or add them to circles.

Within the week, we were having questions regarding editing their profiles. Specifically they wanted to know where to change their avatar and turn of the photos and videos tabs.  I created the following short tutorial to assist them.


Editing Your Google+ Profile

Open your Google+ profile.

1. Click on your avatar.

2. Click View profile

Open your Google+ profile.


If you want to change which tabs visitor can view on your profile…

If you want to change which tabs visitor can view on your profile...

Click Home > Settings.


Scroll down to the Profile section.

Tick or untick boxes to control which profile tabs are visible to visitors.