#!/usr/bin/env bash

# Find top scores in grading history.

# $var:t    ${var##*/}
# $var:h    ${var%/*}
# $var:e    ${var##*.}
# $var:r    ${var%.*}

tempfile=/tmp/topscores.$USER.$$

cd ~/teaching
empty $tempfile

for gradesfile in [ce][0-9]*/[sfu][0-9]*/grades.txt
do dir=${gradesfile%/*}
  pushd $dir > /dev/null
   sc2txt grades.sc &> /dev/null
   stripgradestats grades.txt | excol NAME SEM | egrep '100$|9[0-9]$' | tr -s ' ' '_' | sed 's+\(.*\)_\([0-9]*\)$+\2 \1 '"$dir+" | sed 's+^\([0-9]* \)_+\1+' \
     >> $tempfile
   popd > /dev/null
done
sort -nr $tempfile > topscores.txt

rm $tempfile