Wednesday, November 09, 2011

Embedding Google Calendar in Another Language

This question came up today in the Google Apps Certified Trainer Group. It is actually pretty easy to do. 


To make the change you add &hl=XX where XX is the language code to the embed code.


So - this calendar



With this embed code: 

<iframe src="http://www.google.com/calendar/embed?src=jkloc408t9h5rdv686c8d567hs%40group.calendar.google.com&ctz=America/Chicago" style="border: 0" width="400" height="200" frameborder="0" scrolling="no"></iframe>

Requires a simple change to display in Spanish (&hl=es) 


<iframe src="http://www.google.com/calendar/embed?src=jkloc408t9h5rdv686c8d567hs%40group.calendar.google.com&ctz=America/Chicago&hl=es" style="border: 0" width="400" height="200" frameborder="0" scrolling="no"></iframe>



Pretty simple! Some of our ESL teachers are displaying their homework calendars in multiple languages now.

Note: 

This actually is then converted to a longer code - the key piece of code actually is having ;hl=XX (where XX is the language code) after the timezone (such as "ctz=America%2FChicago&amp") in the final version of the calendar embed html.

Friday, October 28, 2011

Using Google Scripts to Move Data Like a Bulldozer - Forms to Documents


As we gather more data using Google Forms and Spreadsheets there are a lot of questions out there about how we can reformat and share this data in a more consumable understandable way. In the last couple of months the Maine 207 technology team of Mark Ordonez and Janice Cacciatore and Hank Thiele have tackled this issue on several projects and as a result have created a reproducible Google Script that takes the information off a spreadsheet and ultimately creates a unique document that can be shared with anyone.

Our initial purpose of attempting this was not that exciting of a project, however it proved a concept that we believe will make gathering and sharing data in Google Docs a more powerful, dynamic, and interactive process. What we initially set out to do was take a spreadsheet with information about school payments and create letters that would be mailed out to individual families. This has developed into this repeatable process:



To make this easier to replicate we created a sheet in Google Spreadsheets that contains all of the variables you would need to run this process with the data in any Google spreadsheet or gathered through a Google Form. When the variables are used in combination with a Google Script they can replace fields on a Google Document that is used as a template, just as one might do with a desktop office suite. However, in this case the product is multiple letters all placed in a Google Docs Collection that can be shared individually or as a group.

We have already seen several other uses for this such as one example where we helped Dan Rezac take a teacher walk-through form and create individual feedback letters for each teacher observation. We are generating letters to parents and to teachers using data gathered through forms or on shared spreadsheets and disseminating information in a much more readable format than a typical spreadsheet view as is illustrated below:

Typical Spreadsheet view of Data:

Reformatted Merged Document View

For those of you interested in repeating this type of evaluation process here are some instructions, screenshots, and links of an example that will help you recreate it for your own purposes. The easiest way to get started is to make a copy of this Google Docs collection and follow the instructions.


Posted by:

Dr. Henry Thiele - CTO Maine Township High School District 207
Mark Ordonez - Manager of Data Services Maine Township High School District 207
Janice Cacciatore - Technology Specialist Maine Township High School District 207

Wednesday, October 05, 2011

Gmail Message Translation

Here is a tech tip I just sent out to my staff:



I wanted to share a neat feature that Gmail Labs offers us for communicating with our students, parents, and community. You have the ability to turn on "Message Translation" which will use Google Translate to convert a message from another language to English (or to another language of your choice). Here are the simple steps to turn this on in Gmail (link).
Of course, it isn't as good as having a live native speaker translate for you, but it will allow you to receive messages in 58 different languages (and growing) and it translated. I showed this to a group of parents last night and they were empowered with the idea that they could reach out, in a language where they are comfortable writing, to someone at school. Even understanding that it might not be perfect, but getting a general idea across was possible, brought tears to one mother's eyes.
Please take a moment to set it up and ask a student or co-worker to help you try it out. 

Is anyone else using this? Successes? Drawbacks?

Friday, September 16, 2011

Back to School - AUP Review


Each year when staff return to school I send out a review (through email) and sign-off form (using Google forms) related to our district acceptable use policy (AUP). This is something I do to help my staff clearly understand what responsible use of technology is, and it helps protect the district when someone acts inappropriately. Just in case you are doing something similar, follow this link to read the email and gain access to our FAQ's regarding our AUP. 
After I sent this out last week, no more than five people followed up with questions. Most of them had to do with copyright and accessing personal email. In the past week two-thirds of the staff have followed up and have signed off on the agreement. I will continue to follow up with every last staff member until their questions are answered and everyone is comfortable signing off on the form. Having an AUP only protects the organization if people understand how to follow it.


Image Credit: "Back to SchoolBy Avolore

Wednesday, September 07, 2011

Midwest Google Apps Summit 2011



I am excited to help to announce an upcoming first time ever event. The Midwest Google Apps Summit on November 3rd and 4th at the Glacier Canyon Lodge in Wisconsin Dells, WI. The summit will feature several Google Certified Trainers from across Illinois, Iowa, Wisconsin, and Minnesota, will feature members of the Google Apps for Education Team, and will also have representatives from vendors listed in the Google Marketplace. 

The two days will offer presentations around a variety of Google Apps topics and tools. Sessions will include from hands-on, best-practice, classroom examples, success stories, and much more. The conference costs $250 and includes breakfast, lunch, snacks, refreshments, and LEARNING! Rooms are available for $70 per night. 

Details and registration for the conference can be found at tinyurl.com/MWGS11 and a flyer is here: http://goo.gl/NQqrE

We hope to see you there!


Sunday, August 28, 2011

Interesting Finds This Week (weekly)

Posted from Diigo. The rest of my favorite links are here.

Friday, August 19, 2011

A great start to the year

Although many of our teachers have been back for a few days, today kicked off the opening events in our district. By all accounts it was a great morning, and the room was electric with the energy of a new school year. In each of the past 4 years there has been an announcement about the changes we have made, or the cool new tools available. I actually covered this in a big email to the staff the other day.

What is striking about today is that it was different because it wasn’t about stuff and nobody talked directly about technology. What happened this morning was remarkable. We had several speakers and the morning culminated with a panel of teachers discussing the work they have done as a PLC. Throughout these discussions there were all kinds of indications to the advances in technology in our district. Statements like: “check our blog for information on this topic” (from the Union President), and “everything you need is available form the website” (from the Educational Foundation), and “we are making great progress in staff development through our many programs, like the Google Apps for Teacher's workshops this summer” (from the Superintendent). No talk of tools, just talk of how our organization works, all things that would have never been mentioned as boring or basic in past years.

I was sitting in the front row thinking “WOW, this is an interesting change”, when we moved into the panel discussion with our teachers. They were incredible in describing their dedication to the craft and to their students. As they talked they dropped in snippets that mentioned how being able to collaborate on Google Docs, or using Google Forms to gather data, or using data analysis software to understand student progress, or how sharing lessons via Google Sites has made what they do possible. Here is an example of an actual exchange:

Teacher in the audience: “How does your team manage time, how do you communicate with other members of the team, and how do you document that you are actually getting work done when you are given time to collaborate as a team?”


Panelist: “That is easy. We just have a member of the team take notes on Google Docs and the whole team can see the notes. People who are on another team that need the information can see the information too. At the same time our department chair can see the work we are getting done”


Here was a key exchange about how the team gets work done, with a process that totally relies on technology, yet nobody talked about how to use the tool, or why, or where to get instructions. They talked about it just like talking about writing on a chalkboard or on a piece of paper. Everyone in the room, the entire district staff, just absorbed and understood that this was how this team gets business done.

All morning there was talk of technology, but it was integrated into the discussion. Technology never stood alone, it was a key component of accomplishing what was do around here. My hope as we go into the school year is that what I saw this morning continues into each of our classrooms. That we don’t work to integrate technology, it just becomes part of the way that we get work (learning) done.