Easy Grader

September 13, 2017Productivity, Portfoliomarking, teacher tasks, teacher tools, google apps script, google add-ons

Entering student marks… the easy way!

Have you ever spent 5 hours marking work, and then realized it was going to take you another 45 minutes just to type those marks into a spreadsheet?

I wanted to create an easier way to enter those marks into a computer. Now you can even get it as an add-on!

In the documention for add-ons, it is advised to not import libraries such as Jquery into your projects because they are pretty code heavy. However, I wanted to use the autocompleting methods provided in order to quickly sort through a roster of students.

You can easily import Jquery and Jquery-UI from Google libraries.

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script>

<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.11.4/jquery-ui.min.js"></script>

Using the methods is as easy as below!

function getStudents() {
  //get the student names from the spreadsheet for fuzzy search
    .withSuccessHandler(function(availableTags) {
        source: availableTags,
        autoFocus: true,

The code for this project is available on Github and it may still be live on the Chrome Store

jordan rhea

Jordan Rhea - I’m a front-end web developer. Follow me at @rheajt if you want to talk, discuss, or fix any of my code! I am passionate about using JavaScript in Google projects, but there are many more applications. I want to learn them all.