Blog has moved, redirecting... ...

Google just keeps killing it.

by Deirdre Bailey,

I work at an innovative and creative institution. Perhaps it is because of the freedom we have to explore possibilities that we are often unaware of the depth to many of the simplest resources that are available. It is also without a doubt hard to be constantly adapting one's practice to ever-updating technology applications. Certainly, in this day and age, the sheer volume of resources available in education can be overwhelming. Navigating options and rating their relative value is always intimidating, particularly on the heels of a full 7 hours in front of students. But google docs is so worth it. In the last 9 months, it has become one of the most valuable learning tools for me as I continue to inquire into teaching and learning and I am constantly excited by the facility with which google docs allows me to guide student collaboration, research and writing while tracking their progress, providing feedback and involving parents. And while my presence on twitter often gives me the impression that all educators are connected, deeply familiar with technological resources and employing them in their every day practice; it occurred to me, after a conversation I had today that this might not be representative of all cases.

As I continue to stumble upon features in google docs that make my job incredibly easier, I thought it might be valuable to share the simple features I have discovered and am so thankful for. This is either a biased and likely limited overview of how GDocs has been used in our classroom this year, for those who have not had the time or opportunity to explore, or it is a simple plug for the brilliance of google documents and their value in the classroom.
                                                                                                    

For our most recent science lab data collection. We used GDocs to create spreadsheets...


...which we linked to our google site


and shared these with student groups who edited in their own colours, uploaded photos, and separated their qualitative data from their quantitative data by inserting additional sheets

Qualitative Sample


Quantitative Sample


Students used the functions feature in google spreadsheets to verify their calculations:


 They were able to graph various data using the insert chart function


We used google forms to create a survey allowing students to provide feedback on others' work...



...which transferred their feedback to a sortable spreadsheet which we were able to cut and paste into their original Science Lab spreadsheets.


The second time around prior to designing our labs, we brainstormed relevant vocabulary in one google document which all students had access to. 50 students in one google document is a pretty powerful collaborative experience...


For lab reports and documenting observations we had students create and share their own google documents to design plant growth experiments.


We had them insert a link from this google doc to a spreadsheet in which they would track their data...


We have been able to provide feedback on particular sections of their work using the new comments feature which allows us to send them notifications and which allows them to reply and/or resolve the comment. Resolving a comment removes it from the document but does not remove it from the discussion stream.


We have also been SO grateful for the revision history function which allows us to see every edit that has been made to the document since creation including accidental deletions and who has made each change and when... Furthermore, previous revisions can be restored!! Pure genius.


Google docs can be edited from any computer which makes working from home simple. It is so easy to hold kids accountable for the work they do. It takes collaboration to a whole new level and it is only getting better. I should mention that our students are only 9 and 10 years old and they have had no trouble navigating these features through their own google accounts. Here's a clip of an excited student after noticing that his classmate was working with his group while home sick using images posted to their google doc.


I can't even imagine what the future might hold for a creative mind provided with these tools. Please comment if I've missed anything particularly useful or obvious. It would make my day.

Cross-posted on Savouring the Ish

9 comments:

Claire Thompson said...

Wow, thanks for sharing all of the amazing ways that you are using Google Docs with your students! I have a couple of questions;
Is your school using Google Apps?
In your image 'Qualitative Sample' you have teacher comments. Do the students have access to the entire spreadsheet and therefore see your comments on their peers' work? Or do they receive the comments individually?
Thanks again, great post.

Unknown said...

Hi Claire!

Thanks so much for your comments!

Yes I believe our school is using google apps in that the kids' accounts are managed under one account and they log in with science school email addresses.

And yes in the case of the qualitative sample (or any feedback that we gave on a spreadsheet), group members sharing that spreadsheet had access to the entire document. For the most part however, the feedback we have been providing has been for the entire group. Students have also been sharing work on private blogs and working on private google documents in which case only they have access to the feedback we share.

Please let me know if you have any further questions. Happy to share!

Deirdre

Claire Thompson said...

Hi Deidre--thanks for your reply. I use Google Docs exclusively for all of my own stuff, but haven't had my students use it much yet. It's interesting to see how you've been using it with your students.
Cheers,
Claire

Mr. Clark said...

Hi Deidre (and Amy) - In case Claire sees this,

I have been using Google Docs for a while now too after seeing your Decomposition Lab work. Our organization is not using the Google Apps Education Suite yet but we are able to use Google Docs without any problem. All I do is open up the document and then share it through a link. This allows my students in to a document to collaborate on but only as Anonymous users. It works well for us at this stage. The only issue is the the accountability piece. I cannot see who has been in and what they did in there.

Cheers,
Steve (@stdevo37)

PS - I was talking to Amy today about your teaming together. I am in awe! You are both doing a great job there. I would love to come and check your classroom out soon. I'm going to try and find some dates.

Unknown said...

Thanks Steve for the info! Sounds fantastic. Would love to have you in our classroom. Looking forward to it!
Deirdre

Claire Thompson said...

Hi Steve,
Thanks for sharing your experience with Google Docs. It sounds like what you are doing is a good work-around. This has definitely given me some good ideas on how I could use Google Docs with my students!

Garry McKinnon said...

Deirdre, through your blog with rich references to your students' work, you highlight the unexplored opportunities for using Google Docs. I enjoyed reading your overview of how you use Google Docs in your classroom and I was impressed with all of the exemplars you shared to demonstrate the potential of Google Docs. It is great that you have generated a number of responses to your blog. The process of blogging becomes much more worthwhile when an ongoing dialogue and the sharing of ideas is generated.

Garry McKinnon said...

Deirdre, through your blog with rich references to your students' work, you highlight the unexplored opportunities for using Google Docs. I enjoyed reading your overview of how you use Google Docs in your classroom and I was impressed with all of the exemplars you shared to demonstrate the potential of Google Docs. It is great that you have generated a number of responses to your blog. The process of blogging becomes much more worthwhile when an ongoing dialogue and the sharing of ideas is generated.

Anonymous said...

Is it FOIPP compliant?

Post a Comment