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();
}

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