Easy Grader

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) {
      source: availableTags,
      autoFocus: true