I think you'll probably want to create a different worksheet for each subject and place them all on a dashboard together (use an Applied filter to have the filters apply across the different sheets). Then, create a calculation similar to the following:
Place this on the color shelf, right click and have it computed by Student ID. That will show the lowest SEM. The calculation may get more complex with the dates.