Practical Teaching Ideas

Peer Grading in a Speech Class using Google Forms

2015-01-22 11.03.18A simple way to increase student involvement during a speech class is to have listeners fill out a form answering questions about the speech content. Another idea is to engage students in peer assessment. This can reinforce the skills being taught and reduce the burden on the teacher for a fair assessment of the speakers[cite num=”1″].

As an example, I often use the textbook Speaking of Speech[cite num=”2″]. The text is fairly straightforward, and the skills taught are universally useful. I have created a Google Form based on the skills taught in the text which I use for peer assessment. I share it with my students using a QR code. A template can be found here. All that remains is to add a list of the students names in the first drop-down list.

Grading based on this form can be done in Google Sheets using basic formulas such as:

=SUM()
=AVERAGE()

peer assessment sheets

Additionally, results can be sent to a chart and shared back with students.

Taro

Also, a summary of responses can be had from within the from creation app.

peer assessment sheets

A look at the summary of responses from one class grading session can show major trends. This can help to pinpoint areas which may need additional attention in a course.

summary of responses

In conclusion, Google Forms can be used to increase students involvement with the course through peer assessment. It can also provide useful metrics for both students and their teachers to assess progress.

References

  1. [cite num=”1″ return=TRUE]Toping, K. (1998). Peer Assessment Between Students in Colleges and Universities. Review of Educational Research, 68(3), 249-276. Retrieved from http://rer.sagepub.com/content/68/3/249.short
  2. [cite num=”2″ return=TRUE]Harrington, D., & LeBeau, C. (2009). Speaking of Speech. MacMillan. http://www.macmillanenglish.com/courses/speaking-of-speech/
Tech for Teach

Awesome Tables: Easy Database Querying with Google

AwesomeTable

For anyone who has ever tried to create a web interface for a database, you know that doing it yourself means either coding using a PHP/MySQL pairing, or using something like Microsoft Access in conjunction with a SharePoint site. However, I┬áhave recently discovered a free and extremely easy way to set up a database querying web interface using Google Sheets in conjunction with a Google Gadget called Awesome Tables. The best part is, you don’t even need to mess around with Google Apps Script!

Continue reading “Awesome Tables: Easy Database Querying with Google”