Easy Grader

September 13th, 2017

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