This year I've rolled out using Google Drive for all Physics lab reports. Several people have asked me what this looks like, so I thought I'd share. Feel free to suggest a better/easier methodology- this is something that's come together based on how I know how to use Google Drive, and I certainly don't know all the ways to use Google Drive.
A big debt is owed to Katrina Kennett, whose posts and EdCamp Boston sessions on using Google Drive for paperless grading inspired my use, and for Frank Noschese, whose lab rubric I borrowed from heavily.
The setup
1- Creating shared folders. As soon as I get a finalized class list and my students' email addresses, I set up shared assignment folders in Google Drive for each student in my Physics class. This is a folder that is only shared between the individual student and myself, so anything I put into the folder they can see and vice versa.
Here's what it looks like for me in Google Drive:
It can be a tedious process to individually create individual folders for each student. Fortunately, you don't have to- there's a Google Script called gClassFolders, that will automatically create folders for all of your students from a spreadsheet with your students' information. I won't go into detail here about how to setup gClassFolders, as the official site does an excellent job walking you through the process.
2- Share the rubric. I created the lab report rubric in a Google Spreadsheet, then I make a copy of the rubric for each student, and share with them, and place the rubric in their individual folders. Again, this could be a tedious process. Fortunately it isn't, thanks to Doctopus. Doctopus will make copies of the rubric for each student, share it with that student, and put it into their GDrive assignment folder. Super easy.
To use Doctopus, you'll just need a spreadsheet with students' names and email addresses (which you probably already have from using gClassFolders in step 1), and then it'll walk you through your sharing and naming options. Again, I'll forgo the lengthy explanation of using Doctopus, because the official site has you covered.
At this point, when each student signs into GDrive, they'll see their shared folder, with a spreadsheet titled, "Josh- Lab Report Rubrics," for example.
Now we're ready for some student lab reports.
Google Drive in Action
3- Students write lab reports. In lab, students record their data in lab notebooks, graph their data using LinReg, and discuss their results in a post-lab Whiteboard Meeting. For their formal lab report, they create a Google Doc and type up their lab report. For graphs, they take screenshots of the graphs, and add them to the lab report as an image.
When they have finished the lab report, they drop it into their Physics Assignment folders, where I can then see it and have permissions to edit the lab report.
4- Scoring. Since I am able to edit their lab reports, I leave comments directly on their lab report, as shown below.
A nice feature of Google Docs is that students receive notifications when I leave a comment, so they know right away when I've commented on their lab report.
At the same time I'm commenting on a student's lab report , I'm filling out the Lab Report Rubric & Checklist for their lab report. An important note: For each student, I'm filling out the lab checklist on my copy of the lab report rubric, and not the copy that I've already individually shared with students. This may seem odd, but in the end it means that students will have one spreadsheet that contains the rubrics for every lab that they've done. Below I'll explain how to make that happen.
5- Copying the rubric to students. After I've finished filling out the lab report rubric and checklist for a student's lab report, I select the "Copy to..." option on the tab of the spreadsheet:
A window then pops up asking me what Google Spreadsheet I'd like to copy it to. Since I've already created a lab report rubric spreadsheet for every student (in step 2), I just search for the student's first name, and select their lab report rubric spreadsheet:
Once selected, the sheet is copied to that student's spreadsheet, where they can see it. On a student's spreadsheet, it'll show up as "Copy of [tab name]," as shown below:
Voila! Each student has one document that will contain every lab report rubric we do all year. This makes it easier for students to look back at previous lab reports and see where they made mistakes or needed more depth. It will hopefully also easily document their their growth over time.
Once I've copied a lab report rubric to the student's spreadsheet, I revert my copy of the rubric back to its original state so it's ready for me to start on the next lab report.
6- Rewrites. When a student turns in a less-than-stellar lab report, they're required to do a rewrite. A nice (and new) feature of Google Drive is the Activity Pane, which shows all the changes that are being made to documents in a specific Google Drive folder. As students work on their rewrites, I can check the activity pane for the folder with the students' shared folders and quickly see who has been updating their documents (and who hasn't).
Wrap Up
This is the first year I've used such a system, and it's definitely a work in progress. So far I've been quite happy with how the process has worked, and being able to create one document that contains the rubric for every lab report we do all year is a major plus.
Again, if you have any comments, questions, or suggestions for improvement, let me know. I'd definitely be open for suggestions that make the process even more streamlined.
Where I decided to write a blog post, which is something I haven't done in, well, 10 months. http://t.co/RnNXIdw1A6
RT @WillyB: Just published: My Google Drive Lab Report Workflow. http://t.co/RnNXIdw1A6
A paperless classroom workflow using Drive #njed #edtech #gafe http://t.co/Dp6Ab9yTc1
Google Drive Lab Report Workflow http://t.co/nTlRYkj26B
Google Drive Lab Report Workflow #google #fpsttwt http://t.co/IxA7el5MGE
Google Drive Lab Report Workflow. #dchspd http://t.co/NbZ3a1ydH6
Google Drive Lab Report Workflow. Great end-to-end process! #scichat #physicsed http://t.co/nI82PEYmin
Google Drive Lab Report Workflow. I'm all about the workflow. http://t.co/42QnlfBdNq
Google Drive Lab Report Workflow #NCEd #edchat #tlchat http://t.co/iVih7jy8d6
Very similar to my own process. One thing I do is have students reply to all feedback by explaining what they have changed to address it. So, they can't resolve my comments, just reply to them. A little moment for metacognition.
David´s last blog post ..Notes on the current state of open education.
Completely awesome way to power up the science classroom with #googleapps ping @aliceleung #edtech http://t.co/tX7Zfj6pEG
@David: That's a good suggestion- plus, it makes it more obvious when they haven't addressed the comment- which happens a bit more than I'd like. Thanks for the tip!
Thanks! You're clearly a gentleman and a scholar. MT @DavidKnuffke: @WillyB has GDocs labs figured out. http://t.co/RnNXIdw1A6
Google Drive Lab Report Workflow | What do you think @arosey? http://t.co/loVTdv8kkk
Google Drive Lab Report Workflow. Great use of docs! http://t.co/PrgUAa6o79
Great example here of how to use @googledrive to manage class projects. #edchat #pegeeks http://t.co/yG8rlZU8tt
I have used Google Docs for a while now and your post has made it easier for me to use in the lab.
Really like the access to the lab report rubrics. Got me thinking...
A Great Example of How to Use Google Drive for Science Lab Reports - http://t.co/LALiBxYk6Y #scichat #gcds
Google Drive Lab Report Workflow - Re:thinking http://t.co/6jMbQzh7E3 via @@WillyB
[…] Ben Wildeboer walks us through the process he has setup in his science classes for the distribution and assessment of his students lab reports, using Google Docs and associated utilities for creating student folders and distributing content to those folders. Read more >>> […]
Google Drive - Lab report workflow - create, distribute & assess content in your students' #gafe folders. http://t.co/YkTRrNoaMD
[…] Google Drive Lab Report Workflow […]