Tag Archives: google drive

Using Google Docs for Rubrics

At last year’s annual MassCUE conference, I went to a session presented by Katrina Kennett (@katrinakennett). Her presentation focused on how to use Google Docs to create rubrics, and she outlines the process in this video:

She further explains her process and goals in this blog post.

I was energized by the presentation and immediately implemented Google Spreadsheets to create my own rubrics.

You can create self-grading rubrics if you like, or you can create rubrics that tally the number of rubric points and convert it to a grade. The first might save a little time, but the second allows you more control over the final grade.

I had a little trouble figuring out what formula to use to convert total rubric points to grade. For instance, I have long used the ELA rubrics published by Greece, NY schools. Jay McTighe introduced me to these rubrics many years ago when he visited a school where I was teaching at the time. As a result of his presentation, I came up with a formula for converting these 30-point rubrics to 100-point grades.

What I can’t seem to do with my rubric is determine what formula to put in one of the cells that will convert, say, 25 points to a 90 on an essay. If you can help me with that, please chime in below or email me at dana dot huff at gmail dot com. I had to disable my contact form, unfortunately, because of a barrage of requests for advertising and guest posts. Very frustrating and a subject for a separate rant some other time. I think there should be a formula that can do this, but I wasn’t able to hit the right one. Update: Please see the comments. I have tested the formula suggested in the first comment with a few different configurations, and it works.

I am sharing a link to a Google rubric I have created combining Katrina’s method with the Greece Schools’ rubric. This Google rubric is view only, so if you want to edit it, you will need to make a copy of it. This rubric is Greece’s literary analysis rubric. As you can see, the rubric has five criteria: meaning, development, organization, language, and conventions. It also has six levels of performance.

The easiest way to see how all of this works is to look at the rubric, make a copy of it, and see what’s under the hood by clicking on cells, where you can see the various formulas and conditional formatting rules.

After reading a student’s writing, I determine which cell best describes their level of performance for each criterion and type an exclamation point (!) at the end of the description. Using conditional formatting, I have set up the spreadsheet so that an exclamation point tallies the points for each criterion in the Rubric Score column and turns the background of the selected cell purple so that students can clearly see where their level of performance falls on the rubric. A cell at the bottom of the Rubric Score column totals the points for all the criteria. I then use the chart I shared in my blog post about rubrics and how to convert point-based rubrics fairly (see link above). As I said before, I have not figured out how to get my rubric to convert these points to a numerical grade.

Katrina assigns weights to the different parts of her rubrics, so she was able to set up an auto-grading feature when she selects cells. Here is a link to her rubric so that you can see how it works. As with mine, this rubric is view only, so you must make a copy of it before you can edit it for your use; however, you can click on the cells to see her formulas. As you can see, her use of the Google Rubric is much more developed and more sophisticated than my own.

What is the advantage of using Google Rubrics over paper ones, especially given that I’m not making as sophisticated a use of them as Katrina is?

  • My classroom is almost completely paperless.
  • We are already using Google Docs in my classroom, and using Google Docs for rubrics enables me to put rubrics and docs in one place.
  • Using Hapara, I can create a Google Spreadsheets Workbook for each student and copy each rubric to their workbooks as I create them. They will then have access to each rubric in one workbook. At the end of the year, or even at more frequent intervals, they can look for trends.
  • I can share links to their rubrics in my comments on their essays themselves (in Google Docs) and also in our open gradebook comments area (we use PowerSchool).

Of course, if I can figure out the formula I need to convert rubric points to a grade without weighting, then I’m all set.

Feel free to ask questions (or help me out with my spreadsheet formula) in the comments.

Writing Workshop, Part 3: A Reflection

ReflectingFour students in each of my English classes have had what Ron Berger describes as an “in-depth” critique. I have graded some of those essays, and I can see a great deal of improvement. In some cases, I believe the student’s essay earned a full letter grade higher because of the editing and revision. Obviously, I’m very pleased with these results. Grades are not the most important thing to me. I see improvement in their writing, so naturally a higher grade is the result.

On Monday, we had what Berger calls a “gallery critique” of the remaining essays in each class. Students asked that we simply share Google Docs with view/comment privileges only with everyone in the class. Hapara makes this very easy, as it creates groups for each of your classes. Sharing a document requires that either the student or the teacher click on Share, and then type in the name of the group. We changed the settings to “Comment,” as the default is “Edit.” That’s it.

One of the things I noticed during our gallery critique: Students were reading and reflecting on the comments of their peers in addition to the essays themselves. In fact, some were even replying to the comments of others, which is a great Google Docs feature I think few people know about, much less use. One student called across the room to another, asking her to read his paper because he noticed she had really helpful comments.

A roomful of editors brings out some interesting talents I might otherwise not have known about. For instance, one of my students is really great at making a suggestion that leads the writer to generate ideas. His suggestion might be a subtle nudge. I wrote about one of his suggestions in my second post about Writing Workshop. In that post, I described how one student suggested perhaps Queenie in “A&P” didn’t really “boss” the other two girls around, and it was this other student who suggested perhaps describing the girls would be a good opportunity to bring in the metaphor Updike uses of describing the customers as sheep. Then, the student himself thought he could describe Queenie as herding the girls around the store. Leading a peer toward coming up with the perfect revision on his/her own is truly an outstanding gift.

We have another student who comes up with excellent ways to bring in vocabulary. I assign vocabulary from the literature we read, so the words are in context, but they are also common SAT words. One thing I’ve found frustrating over the years is watching my students study long list of vocabulary words given to them by their SAT tutors. The words are completely out of context, and I would be surprised if students really learn most of them. The other day, one of my students mentioned to me that he had the word “sacrilege,” one of our recent words, on another vocabulary list in World Civilizations (our 9th and 10th grade history course).

Another student uses the commenting feature to talk to himself about his writing. He makes notes about where to bring in textual evidence or where to flesh out details. On a short story assignment he’s working on, I noticed he is making notes about a symbol he wants to incorporate into the ending. If not for Google Docs, I would not be able to see this metacognitive process in action, and it’s fascinating to watch him think.

The culture shift in the classroom was subtle, but palpable. After critiquing a few papers, they all suddenly became a community of writers. There is an openness and camaraderie among them. Writing Workshop days are so much fun for all of us. There is an energy in the room that’s hard to describe.

If you do Writing Workshop in your class, my suggestion is that you start with an in-depth critique rather than a gallery critique. I think students learn how to help their peers when they see it in action. Like anything else, peer editing should be modeled. Another strong suggestion I have is to use Google Docs. Google Docs have made the whole process much easier. I am also seeing students use Google Docs for their other assignments and for taking notes, too.

I came up with the following potential criticisms:

  1. This takes a lot of time. Yes, it does. We have an open gradebook, so I did fear students and parents would not like the amount of time that elapsed between an assignment and feedback on that assignment. I think the answer is in the results. So far, I am seeing much better and more thoughtful writing from my students. I used our open gradebook to communicate on the assignment about what we were doing, and why there might be a delay in feedback and evaluation as a result.
  2. Yes, but what can the students do on their own? I would argue that they will learn much more about writing in this way than they would if they did a one-and-done draft, barely glanced at my comments or rubric, and only hunted for the final grade. I have seen much more active revision, even after workshop is over. Students are thinking longer and harder about their writing. When in our adult lives do we have to write anything that we are forbidden to obtain feedback on?
  3. Won’t this lead to higher grades? What will happen when it comes time to recommend students for Honors/AP? We can’t let all of them in! Cards on the table: I have issues with AP. I think students, parents, and colleges are overly concerned with AP courses. I am not convinced by teachers who describe AP courses as loaded with material that they must absolutely cover that AP necessarily does our students much good. That said, students, parents, and schools seem to be invested in AP courses. My school, like some other schools, requires students have an A- average and teacher recommendation to take AP. If students have a lower/close average, they can appeal to take AP, and the English department reads their three common prompt papers (all students in a given grade write on the same topic; for example, our common prompt this trimester was about Updike’s short story “A&P”). So, the concern is that students might actually have a really good portfolio of common prompts, and perhaps their grades will actually be higher because they are turning in better final drafts. Well, essays are not the only form of evaluation I will do, but I admit I am looking at higher grades. I don’t know how many of my students have the desire to take AP Language and Composition next year. I don’t know if I am looking at recommending large numbers of students to AP. I have been upfront about what I’m doing with colleagues, and my administration is supportive (ecstatic, actually). So, I suppose I will just worry about this problem if it arises later this year.
  4. What about a timed writing situation? Fair enough, English teachers like to assign timed writing. Deadlines are a very real part of every person’s life, but outside of school and standardized tests, I have never had to produce a coherent, organized, well-developed piece of writing in under a half hour. Or a class period. Have you? I do not get the fetish for timed writing, I admit. I’m not sure what we learn about students’ ability to write thoughtfully on a topic in a timed situation. I think it confuses students when we think we emphasize the writing process and then ask them to produce a timed writing, no chance for editing and correction. No wonder they turn in first drafts and don’t edit them. And then we complain about that! Students can’t figure out what we want!

I am sure there are other issues I haven’t considered. Feel free to ask in the comments.

Writing Workshop, Part 2

WritingIn my previous post about Writing Workshop, I explained what an In-Depth Critique looks like in my class. Logistics and tools may be a concern, especially for teachers with a large number of students.

My school has Google Apps for Education, but as we do not use the Gmail feature, Google Docs/Drive is probably the most frequently used Google App at our school. I am piloting a tool called Hapara that works with Google Drive (and also Blogger, Gmail, and Google Sites, if you like) to make it easier to track student work and push documents out to students.

What I like about it is that I don’t have to remind students to share their docs with me; their docs are automatically shared. Google Docs has an excellent commenting feature that I much prefer to track changes in Word. If you haven’t used this feature, this video gives a succinct demonstration of what it looks like:

As you can see in the video, if a student clicks on the comment, the highlighted text changes color so that the students can easily see what the comment is referring to. They can use the feature themselves to make notes to themselves about what to change. I have a student, for instance, who uses it to talk to himself about areas where he knows he needs to do some more editing or thinking. Once the student addresses the comment, he or she can mark it resolved, but the history is still visible if the student clicks on the large Comments button at the top.

Google Docs makes it much easier for me to conduct Writing Workshop because the student whose paper we are workshopping can have it open in Google Docs and make suggested edits on the fly as we discuss the paper and can take notes on others that he/she needs to consider.

At this stage, we are not sharing our documents with each other. Rather, one student’s essay is projected on the screen, and both the student and I have the doc open so that we can both add the peers’ comments and suggestions. Later, we may decide to share docs as we build our community of writers and gain that trust.

Today, we workshopped a student’s paper. He did a fabulous job integrating quotes, which allowed us all the opportunity to learn. I mean, it really was masterful. His title was clever, but we wondered if it really fit the ideas expressed in the essay, which was an analysis of John Updike’s short story “A&P.” The image of the customers as “sheep” mindlessly pushing their carts through the aisles really appealed to this student, and he wanted to work the image of the sheep into the title. In his paper, he argued that the protagonist, Sammy, made an unwise decision in quitting his job. I should mention that each trimester, all students taking a particular course, in this case World Literature II, write on the same given prompt, which we call a common prompt. The common prompt for this trimester asked students to determine whether or not they felt Sammy made the right decision in quitting his job, and yes, either yes or no can be argued successfully based on the text.

We began, as before, by asking the student to identify his goal for the writing and what, in particular, he especially wanted feedback on. Then we read the essay as a whole, commenting on what we liked and noticed and on what questions we had. Then we read almost sentence by sentence.

The student had an amazing breakthrough when were looking at a sentence in which he described the girl Sammy dubs “Queenie.” My student described her as “bossing” the other two girls around, which is how Sammy realized she was in charge. Another student suggested we didn’t really see any “bossing,” and I agreed. But we all agreed it was obvious she was the group’s leader. How did we know that? Well, the students said, the way they walked around. She was in the middle. She was directing them around the store. Wait! One student had an idea. Why didn’t the writer tie the way the girls walked around the store back to the image of the sheep? And the student writer said, maybe he could revise the sentence to describe Queenie as herding the other girls around the store. It was brilliant! I actually jumped up and down and then gave a student a high five.

I am telling you that this is the kind of thinking we WANT students to be doing about their writing. And it worked because one student suggested a word change, another had an idea about a way to think about the word choice, and the STUDENT HIMSELF came up with the best word to use.

In addition to word choice, we were able to talk about commas and why they can be problematic, but also how we can figure out when to use them. Students were able to see an excellent model for integrating quotes and clever word choices. Students had an opportunity to help a peer think critically about his word choices and correct a few grammatical issues. I can’t even tell you how much easier Writing Workshop makes writing instruction. The kicker is that the writing instruction is much more meaningful because it comes from the students’ own writing. We are establishing ourselves as a community of writers with the goal of improving everyone’s writing.

After class, one student hung back to ask a question about using a semicolon, as it came up when we examined the essay today. Another student asked about integration of quotes in literary analysis as opposed to the kind of writing she does in history, which was a great opportunity to discuss audience and writing for different purposes.

I only offer a couple of examples here. In truth, I do not think I could cover nearly as much writing instruction in a traditional writing assignment graded with comments, which the student might examine for the grade. Perhaps the student might read the comments, but certainly I would see the same problem areas in the next paper, ad infinitum, mainly because the comments alone really don’t help the student understand how to improve. And frankly, I am as guilty of this as anyone, but such feedback never seems to celebrate what went right with the writing. Putting the essay up on the screen and taking a period to discuss it hits all of these common problems in writing instruction. What I like to see in Writing Workshop is the way in which it encourages the students to think about what makes good writing.

Do you have questions regarding logistics? Please ask in the comments.

A Poll: What Would You Like to Read?

I have been trying out quite a few new things, and I don’t know where to start in terms of talking about them here. Take a look at this list and let me know in the comments which topic piques your curiosity, and I’ll do my next blog post on the topic that generates the most interest.

  • Using Google Docs to create rubrics
  • iMovie book trailers
  • (Almost) Paperless Classroom with Google Docs and Schoology
  • Carving out a hybrid position (or how I’m teaching two English classes and working as a Technology Integration Specialist at the same time)
  • Writing Workshop: going beyond peer editing with partners
  • Teaching The Catcher in the Rye

iPad Apps for School

A teacher on the English Companion Ning recently posed a question about which apps to buy with the $50 her school was giving her to outfit her iPad. You can find these sorts of posts all over the edublogosphere, so perhaps my contribution isn’t worth much, but for what it’s worth, these are the apps I think an English teacher should have, along with their current prices.

notability_iconNotability ($1.99). Notability is a note-taking app that allows you to type your notes or write them with your finger or stylus. You can import PDF’s, annotate them, and export them out again, which is great for literary analysis and annotating texts. It has a fairly intuitive interface with several kinds of editing tools, including a pencil, highlighter, eraser, and scissors for cut/paste. You can record and play back audio and incorporate other media. It does a lot more than the Notes app that comes with your iPad, though that is the app I frequently see people use when they are taking notes on the iPad. It’s an incredibly useful note-taking app.

imovie_iconiMovie ($4.99). iMovie is a great movie-making app. The iPad app is a scaled-down version of the iMovie app for Macs, but it still has a lot of options. You can use the app to create tutorials for students or presentations, and students can use it to demonstrate their learning of a concept through digital storytelling. One of our teachers reported that he liked it better than the Mac version because it was more intuitive on the iPad.

explaineverything_iconExplain Everything ($2.99). This app is great for demonstrating concepts, similar to Khan Academy-type videos. One of our teachers uses apps like this to have students explain their learning. The videos can then be exported and posted in a place where others can view them. If you are looking for lighter apps, Educreations (free) and ShowMe (free) are also good, but they don’t have all of the features that Explain Everything has. If you teach younger students, you might also look at ScreenChomp (free).

evernote_iconEvernote (free). Evernote is fabulous. I take almost all my notes on the computer in Evernote. Be sure to check out Nick Provenzano’s Epic Evernote Experiment to learn more about using this app. It is so easy to clip websites and insert images into this app, and what makes it nice is that you can use it on all your devices, and it will sync so that your notes are available everywhere you go. You can even log in to your account on the web and access your notes from a computer that doesn’t have the program installed.

flipboard_iconFlipboard (free). You can use Flipboard to create personalized magazines full of content you are interested in. What makes Flipboard a game-changer and nudges Zite, a similar app, out of the way is Flipboard’s ability for you to follow Twitter hashtags using the app. One I would recommend you follow right now is #engchat. A few others, particularly if you are integrating iPads are #ipadchat, #ettipad, #ipadedu, and #ipaded. You can also integrate the app with Facebook, and there are several suggested topics if you don’t know how to start. Browsing on Flipboard is as much like browsing through a print magazine as is possible on an iPad. I love it.

sonnets_iconShakespeare’s Sonnets ($13.99). This app is expensive, but it is so worth it if you spend any time teaching Shakespeare’s sonnets in your classes. It includes all of Shakespeare’s sonnets, both in print and read by actors and scholars such as Sir Patrick Stewart, David Tennant, Stephen Fry, and James Shapiro. In addition, it includes the Arden Shakespeare notes and commentary by David Paterson. It’s a fairly large app, as you might imagine with all that media. I am continually having to remove it to free up space when I’m desperate, but I always wind up adding it again. It is the 800-pound gorilla of Shakespeare apps.

shakespearepro_iconShakespeare Pro ($9.99). Shakespeare Pro has all of Shakespeare’s plays, all of the sonnets, other poems, and Charles and Mary Lamb’s Tales from Shakespeare, as well as a concordance and a glossary. It also includes, if you care about that sort of thing, a collection of portraits and quotes. I find I don’t use them that much. Through the app, you can also create an account with Shakespeare Passport, which will give you discounts at all kinds of Shakespeare venues.

bookcreator_iconBook Creator ($4.99). Book Creator allows you to create multimedia books on the iPad. You can send them to friends, submit them to the iBookstore, or read them in iBooks. Students of all ages can use it, from pre-K to college. Teachers can use it to create their own books, too. It has an intuitive interface and allows for importing pictures, video, music, and even recording your voice.

haikudeck_iconHaiku Deck (free). Haiku Deck is a presentation app that allows you to create beautiful presentations. It finds images that match your words, or you can personalize it with your own photos and screenshots. You can share it via the web to be viewed on any device capable of surfing the web.

blogsy_iconBlogsy (if you blog, $4.99). Blogsy is great for blogging on your iPad. It connects to WordPress (.com and self-hosted), Blogger, TypePad, Movable Type, Joomla, Drupal, and Tumblr, among others. You can drag and drop images into the post using Picasa, Flickr, Facebook, or Instagram, and you can even pull videos from YouTube and Vimeo into your posts. Text formatting is easy.

googledrive_iconGoogle Drive (free). Using Google Docs used to be painful on the iPad if it even worked at all, but Google Drive’s app is really easy to use and WORKS. It does not have all the features that Google Drive on the web has… yet. For instance, you can’t see the revision history, and it doesn’t allow access to multiple Google Drive accounts, which makes it harder to use in schools when you have students continually signing out and signing back in, but you can get around these issues with an app called GoDocs ($4.99) if these are features you need right now. My advice would be to wait because I have a hunch that Google Drive will include at least revision history in a future update.

You will notice that most of these apps are not English/literature/language arts-specific. You are better off establishing use of a series of apps that allow you to work and create on your iPad rather than focusing on subject-specific apps, which too often are simply drill-and-kill and lower quality.