Faster, No Math Required Feedback

I am on a quest this semester to make feedback as fast and effortless with the least amount of mathing.  I hate trying to math by myself.  Give me four numbers and unless they’re all 2, I’ll have a different answer each time I add them up.  It’s mind blowing how terrible I am.  I’ve pretty much decided that from this point on in my life, I am going to math only with the help of a spreadsheet because it’s just less frustrating for everyone.

In the past, I’ve never used Google Forms as a way to “grade” (give feedback) on student presentations because I couldn’t figure out how to have it automatically add up the points.  Then, my friend told me about Form Publisher Add-on.  And I thought, how did I not know about this??!!

Form Publisher is a Google Form Add-on that allows you to publish your form entry to a doc or an Google Sheet.  (And the Google sheet means no mathing by yourself!)  Add-ons are amazing little programs that help you do great stuff in Sheets, Forms, Docs and Slides.  In Forms, to get an add on, click on the three dots then choose “Add-ons.”  Search for Form Publisher and then click add.  To run it, go to the puzzle piece and chose it. (You’ll run it after you set up your form. )

The Why

For as long as I can remember, I have always had intermediate students do a two minute oral exposé once a month or once a chapter.  I give them the topic:  Research a store, a country, a famous scientist, a problem, present your survey results, etc – you get the idea.  When I had my combined level 3 and AP class, I used the topics to help the AP students prepare for AP.  (I tricked them and had them preparing even in level 3!  They had no idea.)  I continued this even with my college classes. Sometimes I have it really structured- sometimes I don’t.  This unit for college they doing some reading and comparing and presenting a thesis.  The first one was, “Tell me about yourself,  your family and friends and what role do they play in your life.” I like it.  Students like it.  It’s a nice way to have some presentational speaking on a specific topic that goes along with your theme.    I needed a paperless way to add up these points.

The Set Up

There are two things to set up for Form Publisher.  One is the form and the other is destination document.  For my form, I took the student email addresses from my Google Classroom and entered this into the first question.  This way I could click on the student and populate the column that Form Publisher would use to share the document.  (You won’t see this in the example.)  Next, I added the names of all of the students in the class along with my own.  I have always had students peer grade for oral exposés.  A student would get two reviews: One from me and one from the reviewing student.

The Rubric:

I really like the presentational speaking rubric for AP.  It’s easy to follow.  It’s clear enough without being too wordy.  And I’ve used this for years in the high school as well in my college class.   (Note: When I had the combined 3/AP class, I used the same rubric for the 3s.  Only “appropriate structures” has a different meaning for level 3 and AP.)  I wanted the rubric to add itself up, so I made one question with a number  for the points (5,4,3,2,1) and one with the comment for that point value.  I wanted them to be side by side, but without fancy coding in your sheet you’ll need to have two questions.  I repeated until I had all of the criteria.

The Destination Sheet:

I made a template sheet in Google Sheets.  Form Publisher had a pretty picture in their example, so I tried to mimic that idea with relatively little success.  Because the destination sheet pulls information from the form, you have to have “markers.”  These are marked by << >>.  (I don’t know what their English name is, so I refer to them as “French quotation marks.”)  These have to match EXACTLY what is on your form questions or it won’t work.

I used a basic formula to have the points add up.  Here’s an example of what it looks like for the student.  (This was a test one.)

Each time you submit the form, Form Publisher creates a new document (or sheet) and can share it with the student.  It’s brilliant!  No paper!  Instant Feedback!  I have a section on mine for the students to do a little reflection after their exposé and after they review their feedback because if you give feedback and you don’t have them do something it’s a waste of your time.

You can make a copy of my form here.

You can make a copy of my destination sheet here.

Form Publisher has its own really easy to follow tutorials here.

Data Validation Saves You Time

I’m always surprised how little teachers use Google Sheets (or Excel) because it has so many features that help make all the little tasks we need to do as teachers less time consuming. One of these is Data Validation.

Data What?

Data validation is a neat little feature that adds a drop down menu to your cell so that you have some pre-set choices.  You set the choices.  Highlight the cells in which you want the drop down menu to appear, then in the tool bar choose Data>Validation.  From there, I generally choose “List of Items” and list what I want my choices to be.  (You can also require that the cell be filled in with a number or a certain text, but I never use those.)  Click to view a video that walks you through the steps.

 

Applications for Education

Faster Feedback

When I give an assignment, I have a general idea of all of the items I may need to comment on.  For example, I know I want to give at least one positive comment, at least one “work-on” comment and then tell them what to do next.  I’ve used data validation to give feedback faster, by setting up data validation with the most common comments I think I’ll use.  Then I don’t have to type them in one by one, over and over for each student.  It makes the mechanics of giving feedback much faster.  I can still type in a unique comment if needed, but I don’t waste time typing in the same thing multiple times.  I use a Google Sheets Add-On like Autocrat or FormMule to send or share the feedback with the students with a few clicks.

Story/Sentence Creation

Students who can’t produce their own language just yet, can create stories using data validation.  Here’s an example I made with vocabulary from the first hours of French.  Click on the image to make your own copy and to see all of the choices. It’s like structured sentence creation.

Student Choice

I use data validation to set the choices for my homework choices sheet.  Students click on the arrow and it gives them a list of approved choices.  I’ve also used it for Flipgrid review.

Attendance

You probably keep attendance in your classes in your school’s student information system (SIS), but data validation can be a quick way to keep track of attendance for clubs or extra curricular activities or anything else you might need to “check-off” over a period of time.

Grading

I use a spreadsheet to grade my end of unit assessments.  I have four columns for each of the four sections.  I use data validation to put in the possible scores and then as I’m listening to students or reading what they wrote I use the drop down menu to input their score.  I set the spreadsheet up to automatically add up the points.  It’s much easier to click as I’m walking around with the iPad listening than to type.

Go ahead, open a Google Sheet and see how Data Validation can save you time!