GradeEntry provides a live-search interface to CSV files.
It allows data entry on only one column, and uses all the other
columns for searching. It is meant to help with entering
grades for large classes. In such a use case, the CSV file
may contain First Name, Last Name, and Student ID columns,
as well as a column to record the scores of an assignment. The
user can quickly find the row corresponding to a student by
typing in parts of the the name, the ID, or even typing
in the student's initials.
There are basically three steps to using this tools:
- Load a class roster or grade book in CSV format on to the page
- Find and enter student grades using the search interface
- Download a modified version of the original CSV file
Although this interface uses a browser, no data is uploaded. The entire CSV file and all the processing is done locally. An internet connection is needed only for the initial loading of the page (external JS, CSS, etcs.). Downloading the libraries
- JQuery
- Twitter Bootstrap
- normalize.css
will allow GradeEntry to run completely offline.
GradeEntry currently works best on Chrome and Firefox. Safari has some trouble downloading the saved file and instead displays the raw file in a new tab. It is completely untested on IE.
In addition to the heavy use of JQuery and React, GradeEntry is made possible with
- Papa Parse for CSV parsing
- FileSaver.js for file saving
- Twitter Bootstrap and [normalize.css] (https:/necolas/normalize.css/) for theming
- github-fork-ribbon-css for the CSS GitHub fork ribbons.