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

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

70+ Google Forms for the Classroom | edte.ch

Google Forms is a great tool and I hope to use it more throughout this year. Take a look here for a more detailed introduction and guide to using and creating a Google Form – this was written prior to Google bringing forms into the NEW menu.

I have created example forms for each of the different topics, follow the links in each of the ten sections. With help from a Googler I have included a link so that you can get your own copy of the form – click on the appropriate link and it should open in your docs home.

1 ) Get to know your class

Use this form to gather some indication from your new class about their likes and dislikes, their favourite lessons or after school clubs they enjoy. It will help you to build your relationships with children as you quickly learn more about them. Get your own copy.

2 ) Emotion graph

An emotion graph is a simple line graph comparing a range of happiness to sadness against different points (time) in a story or film. This technique of graphing the emotional ups and down within a story really helps children to visualise the whole story in a different way. Use a Google Form to gather the children’s responses to different parts of any type of linear narrative, written or visual. We used it here in a film narrative literacy unit. You can read a more detailed explanation of how to generate the line graph from the form here. Get your own copy.

3 ) Spelling test

For your weekly spelling test use simple 1-10 or 1-20 numbered form (with a name question too of course) and ask the children to type in their answers as you read out the list of words. Once these are submitted apply formula to judge if they are correct or not and it becomes self marking. Steve Kirkpatrick had this brainwave a while back so check out his excellent post for more information about setting up the spreadsheet. Danny also added in his comment about using the font Wingdings for smiley faces which is a nice idea although this font is not available in Google Spreadsheets. Get your own copy.

4 ) Comprehension questions

I spent quite a bit of time last year looking for some reading comprehension resources that could be used on a class set of laptops. A Google Form could be created as a way to collate the children’s comprehension answers in one place for any given text. You could also share the answers with the class so that they can review what their peers are doing. This could be a formalised assessment of their understanding of a text or something more informal to start class discussions. Again Steve has grabbed this idea by the horns and tried it with his kids – well worth a look, especially at his reflective comments and lessons learned. Get your own copy.

5 ) Weekly reading record

The children in our school have a reading diary that they use to record information about times that they read during the week. They take it home as well as using it at school. A form could be created by the children as a place to enter data about their reading. I hear “I haven’t got my reading diary,” so many times during the year, this way they have no excuses and can access it from any computer. Alternatively a class form could also be setup to gather together everyone’s record. Get your own copy.

6 ) Maths data handling

Perhaps the easiest to pick up and run with, the idea of using a form to gather together maths data handling information. The form could be a simple way of collecting information about the class – shoe size, eye colour etc. It is obviously about what you do with the data that counts but their is no reason why children couldn’t design and implement their own forms – with the attached spreadsheet for analysis – as part of independent data investigations. Get your own copy.

7 ) Guided reading record

As part of the old literacy hour in England we take part in small focused group reading sessions. They are guided sessions usually 15-20 minutes long and we talk and work on a piece of text that is relevant to the work going on in that unit. Sometimes small written tasks are completed or it may just be a speaking and listening activity. It is widely practiced in English primary schools and this form could act as a class record for those sessions. Get your own copy.

8 ) Prior learning assessment

Use a form to assess what the children already know about any given topic that you are beginning. The form could be a formalised assessment with specific questions about the topic or it could be more general and open for the children to explain what they know. Either way such an assessment would allow you to have a better understanding of the current level of knowledge the children have about a topic. This same form could be returned to at the end of the unit of work to help review what they have learned. Get your own copy.

9 ) Library book review

We have a little corner of our classroom dedicated to our library. There is a broad range of fiction and non-fiction books for the children to enjoy whenever they want. This form could be a simple way of collecting the children’s thoughts about what they read. The children in the class could use it as a reference to help them choose a book to read. A simple and easy way to collate book reviews. Get your own copy.

10 ) Learning success

This is one of the ten ideas I would most like to explore this year as we continue to use Google Docs as part of our tech toolbox. Use a form to assess the relative success of the learning that has taken place during a single lesson or after a series of lessons on a topic. Invite the children to assess their own confidence after practice of something – such as a lesson on one of the written multiplication methods. The form would collate the views of all of the class very quickly and allow you to make a quick judgement in terms of pupil feedback, about whether to consolidate what has taken place, to start afresh or in fact to move on. We make our learning targets for the lesson so clear these days, along with work scrutiny, dialogue with the students, a generic student response form would allow you to further judge the lesson’s success.

This is very much dependant on the quick and easy availability of a computer in the classroom – this after all should be a small 2 minute task as part of a plenary. If the lesson involves the use of the computers then that is easier – but if it does not then perhaps a handful scattered at the side of the room for students to go to at the end of the task or as directed. Of course the students completing such a form as if it were second nature to them, would be what you aim for – so the laptop, form and technology disappear and you are left with a lucid evaluation from your students. Get your own copy.

I hope that you have found something to inspire you here or perhaps you can use these straight away. If you have not had time to explore Google Forms it is most definitely worth a look. If you have time drop me a note saying how you got on with your own ideas.

UPDATE

Here a more than 60 further ideas to keep you going.

Similar Ideas

Thanks to @tombarrett for sharing these great strategies for using Google Forms in the classroom. It's another tool that made my head explode when I first learned about them.

Filed under  //  Google Docs  
Posted