I've attached a script that will allow you to import grades using the XLS format you provided.

For the script to work you need to:

1. Stop the schooltool service:

$ sudo service schooltool stop

2. Download and make the script executable:

$ sudo chmod +x import_grades.py

3. Run the script providing the spread sheet with your grades:

$ sudo import_grades.py /path/to/your/grades.xls

4. After the script finishes running you may see either:

***** THERE WERE ERRORS: ***** plus a list of the errors found

The errors will have a format like:

(SPREADSHEET_NAME, ROW, COLUMN, ERROR_MESSAGE)

for example:

(Grades, 4, 1, 'invalid school year')

and so on.

If everything goes well, you'll see:

***** GRADES WERE IMPORTED SUCCESSFULLY *****

After running the script, you should restart the schooltool service:

$ sudo service schooltool start

Let me know if you have any trouble or questions.