Asee peer logo

Google Sheets for Realtime Assessment and Analysis of Less-Structured Problems

Download Paper |

Conference

2016 ASEE Annual Conference & Exposition

Location

New Orleans, Louisiana

Publication Date

June 26, 2016

Start Date

June 26, 2016

End Date

August 28, 2016

ISBN

978-0-692-68565-5

ISSN

2153-5965

Conference Session

Curricular Issues in Computing and Information Technology Programs II

Tagged Division

Computing & Information Technology

Page Count

19

DOI

10.18260/p.25413

Permanent URL

https://peer.asee.org/25413

Download Count

211

Request a correction

Paper Authors

biography

James D. Palmer Louisiana Tech University

visit author page

Virgil Orr Professor of Chemical Engineering
Director of Biomedical and Chemical Engineering

visit author page

Download Paper |

Abstract

Universities are under increasing pressures for efficiencies in education with declining budgets, increasing enrollments, and increasing expectations/accountability by students. A traditional approach with engineering or science computations is to parse the answers in a multiple choice selection. Grading of these problems are efficient and have evolved from scan-tron systems to Clickers, to open source online solutions such as Moodle, Google Forms, or WebWORK. This method does have its limitations. An investment is required in identifying the array of possible answers. In addition, multiple choices allows a student to provide guesses when they might not have an idea how to approach the problem. In the grading that is performed as a batch, the instructor looses the temporal resolution which is most helpful in determining which areas are giving students particular issues.

The controlled sharing and import of individual data through Google Sheets provides educators an opportunity to utilize a spreadsheet for collecting and assessing answers real-time. This is easy to do in a manner where all students see all answers, but individual shared sheets can be setup to provide a private interaction with each student. There are several advantages to this system over many current approaches: students can continue to change their answers until the time that the instructor "grades" the assignment, the instructor has a real-time view of the student's answers and grades at any instant (with the opportunity to provide direction), tolerance values can be built in along with a median value of student answers, and sort features in Google provide real-time information on the students and concepts that are having the most issues.

This approach has been piloted in a Capstone Senior Design class for Chemical Engineering where structured concepts were taught and assessed (economics, relief sizing, etc.) and open-ended designs were utilized (where the instructor did not have a "right"/"wrong" answer, but significant deviations could be discerned).

Palmer, J. D. (2016, June), Google Sheets for Realtime Assessment and Analysis of Less-Structured Problems Paper presented at 2016 ASEE Annual Conference & Exposition, New Orleans, Louisiana. 10.18260/p.25413

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2016 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015