G Suite Developers Blog: Grading Made Easy using Apps Script

G Suite Developers Blog

Information for G Suite Developers

Grading Made Easy using Apps Script

April 1, 2011

Editor’s Note: Guest author Dave Abouav is a Google employee who is a part-time instructor for a night class in physics. He created Flubaroo as a 20% time project at Google based on his own teaching experiences.Google Apps ScriptFlubaroo

I wanted to build a simple application which can be easily integrated with Spreadsheets without the need to compile and deploy code.

I liked its ability to integrate right into the spreadsheet as a menu, easily giving teachers access to all of Flubaroo's features.

Apps Script provided UI Services which allowed me to build UI applications very easily from within a browser. I did not have to install complex tools to create a UI.

Apps Script Services makes it very easy to integrate other Google APIs such as Google Charts API for the grade histogram.

A JavaScript syntax is easy to program and without the need to learn more complex languages like Java and Python.

Apps Script gave me the ability to easily share my grading technique with other teachers through the Apps Script Gallery. It is very easy for anyone to install the Flubaroo script in their Apps Script editor.