Easy Grader

September 13, 2017G Suite Add-onmarking, 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
  google.script.run
    .withSuccessHandler(function(availableTags) {
      $('#tags').autocomplete({
        source: availableTags,
        autoFocus: true,
      });
    })
    .getAvailableTags();
}
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.