Iron Secretaries Conference: Using Google Docs

google-docs-logo.jpgThanks for coming to our session today on Google Docs for the Iron Secretaries Conference. Today we'll take a good close look at how to take your documents to the cloud, and do things that you could never imagine doing in Microsoft Word. Google Docs are not a replacement for Word, but there are some amazing collaboration tools and ways to share documents with your principal, staff, teachers, students - even parents!

Don't do this before I ask you to, but you can access our collaborative experiment here!

We'll be following the Google Docs Overview site for our agenda/instructions for this session. To get back to this online help document anytime, just click on 'Help' in the menu when you are in a Google Document and select 'Google Docs Help Center' as shown below:
Screen_shot_2012-02-06_at_11

Filed under  //  Google Apps   Google Docs  
Posted

Delta Secretaries Conference: Google Spreadsheets & Forms

google-docs-logo.jpg

Welcome to our session today on Google Spreadsheets and Forms! We'll be using the Google Spreadsheets Overview page for our session notes and agenda. Any other specific resources or answers to questions that come up during our session today I'll note below. You can always get back to the agenda/notes page when you are using a Google Doc or Spreadsheet by clicking on the 'Help' menu and selecting 'Google Docs Help Center' as highlighted in the image below.

Screen_shot_2012-02-06_at_11

Filed under  //  Google Apps   Google Docs   Google Forms   Google Spreadsheets  
Posted

Top Ten Uses for Google Apps for Education

Google Apps for Education has brought some amazing tools to Garfield School District, to the SEDC region, and to all that use this service around the US. I'm constantly finding new ways that these tools can and should be used in the classroom to make both teachers and students life easier. If I were to share them all with you, it would take much more than the time that we have allotted today, so I'll try to highlight 10 of my favorite uses or applications that you have access to simply by logging into your school email account. 

Before I begin, however, I'd like to direct you to an amazing resource that will help guide our time today, and will be a valuable resource after - the Google Apps Education Training Center. Whatever you'd like to learn how to do in Google Apps: Gmail, Calendar, Docs Sites, or some of their other tools, this site has easy to follow instructions and training modules that will help you learn how in just a few minutes. 

Now, let's go to the Top Ten List!
  1. Gmail: Creating contact groups for parents, classes, teachers, & organizations
  2. Gmail: Built in Chat using textvoice - even video!
  3. Calendar: Creating different calendars for classes, projects and school activities
  4. Calendar: Sharing your calendars as a web page
  5. Docs: Manage documents with multiple editors, up to 50 simultaneous editors/collaborators, adding and replying to comments
  6. Docs: Improving the writing process with feedback and revision, tracking progress, and publishing work
  7. Presentations: Collaborative presentations that student groups create from your template
  8. Spreadsheets: Collaborative editing of spreadsheets - up to 50 at once
  9. Forms: Collecting student/parent contact information, and then creating contact groups in Gmail
  10. Forms: Check and submit assignments, or delivering quizzes and assessment - even automatic grading and score notification!
If you've never seen or experienced a collaboration session in a Google Doc, feel free to join me here or type in http://goo.gl/s5aXd to take a look! Also, if you have any questions about what I've presented today, or anything else about Google Docs, let me know here.

Filed under  //  Garfield   Gmail   Google Apps   Google Calendar   Google Docs  
Posted

Google Docs: Project Based Learning & Collaboration Made Easy

How is Google Docs different than Word or whatever else you have used before?

If the above video space is blank, you can watch it here.

 or you can view the presentation here.

Filed under  //  Google Apps   Google Docs   Google Presentations   SUECON  
Posted

Google Sites - Calendar Uses The Wrong Time Zone

This question came from one of my teachers yesterday:

When I insert my Google calendar to the Google site I'm making, all the times are Pacific Time Zone.  My original calendar settings are Mountain Time Zone.  It's only when I insert it to my website?
Wow... I think I have a solution, but I don't think I could have ever found it by digging around myself - I had to scour the Google Sites Help Pages. There is a magic 'User Settings' page somewhere within Google Sites where you can set the time zone for your site. My calendars were not displaying correctly either - and this fixed it for me.

Here's the fix: Once you are logged into your site, open up a new window/tab in your browser and head to this page:

Once there, choose your correct time zone - for Utah it would be GMT -7:00 - Denver or Boise option (which one probably does not matter as long as you don't choose the Phoenix one since they don't observe Daylight Savings as we do). Save your settings and refresh your calendar page and hopefully the issue will be gone.

Thanks for the message. I gave up a while ago on trying to solve this problem - now we all know. :D

Filed under  //  Google Apps   Google Sites  
Posted

Beyond Gmail: Docs, Calendar & Sites

You can find this information later by heading to the Google Apps tag on my blog at http://sedcclint.com/tag/googleapps

First, let's REALLY go beyond Gmail. Google keeps a page of tips that will take you from a Gmail White Belt to a certified Ninja Master!  Here is a friendly, downloadable document version in PDF that you can save and print.

How is Google Docs different than Word or whatever else you have used before?

(download)

If the above video space is blank, you can watch it here.

 or you can view the presentation here.

DEMO: Using Google Forms and Flubaroo to create and grade a quiz - complete with auto-emailing results. Take the quiz now!

Additional Resources for Google Docs:
Google Calendar & Sites:

Additional Resources for Google Docs:

Click here to download:
gmail_tips.pdf (591 KB)
(download)

Filed under  //  CTE   Gmail   Google Apps   Google Calendar   Google Docs   Google Sites  
Posted

Flubaroo - A quick and simple quiz grading tool for Google Docs

Media_httpwwwflubaroo_timsv

Very cool - Flubaroo is a script that you can install for free if you are a Google Docs user will take a quiz or test created with a Google Form and grade it, summarize the results, chart the scores, and even email the students back with their scores.

The good news is that I have a Google Docs training tomorrow that I can demo this with. The bad news is that I have 28 minutes to put it together.... Start the clock!

Filed under  //  Formative Assessment   Google Apps   Google Docs  
Posted

A Gmail Solution for Classrooms (Especially in Elementary)

Media_http2bpblogspot_tcfaj

There is a little-known trick in Gmail (and in turn Google Apps users) that will let you delegate multiple 'virtual' Gmail addresses to a single account.

In Gmail, account names with periods anywhere in them are ignored. Also, and more importantly for schools, Gmail will ignore anything following an account name appended with the '+' plus sign.

Yeah, it took me a second as well to grok what that can mean for teachers....

I have worked with a few different elementary schools, and they would really love to have their students be able to use Gmail, along with some of these new, amazing Web 2.0 tools such as Animoto and Prezi. These services require that you have an email account to create an account. The problem is that Gmail requires (by mandate of federal law) that account holders be at least 13 years of age. If the school/district does not have a student email solution, or if their solution is that students can use Gmail, that leaves anyone under 13 out of luck.

If I would have known about the Gmail addressing trick, the problems would have been solved for these teachers and students. Now I know that 1 Gmail account can be managed by 1 teacher, but have as many unique 'users' delegated by using the + addressing trick.

Let's explore... Let's say that you teach 5th grade, and you create a new Gmail account called 'tanners5th', so your address is tanners5th@gmail.com. Now, if you wanted your students to use any web services that require an email address, you allow them to sign up as:
- tanners5th+janeb@gmail.com
- tanners5th+samh@gmail.com
- tanners5th+codyr@gmail.com...

...and so on using whatever naming convention you want. The tanners5th@gmail.com account will receive any and all messages addressed to any of these delegates - Gmail ignores the + and what follows, but keeps it in the address so that you can easily use filters or can see what message was directed to whom in your class.

One account for the entire class, but as many unique email addresses as you need to sign up for these excellent Web 2.0 tools. A very neat and clean solution!

Filed under  //  Gmail   Google   Google Apps  
Posted

Advanced sign-in security for your Google account - Official Gmail Blog

Media_http4bpblogspot_gkdhb

Great advanced authentication tool for when users log in from a new or different computer to GUARANTEE that they are who they say they are by texting a code to the users cell phone - keeping your Google Mail account that much more secure.

Turn this option on for your domain in the 'Advanced Tools' tab under Authentication.

Filed under  //  Google   Google Apps  
Posted