Can you post some dummy data so we can see what your data looks like? Are you importing this from somewhere or entering it manually? The reason I ask is that the structure is somewhat puzzling. Why are all the columns defined as floats? (Even a StudentID? Normally, that's an INT).

Once you normalize, querying/summarizing this thing would be a walk in the park. Any reason you can't do that? What if you need to add a third set of values for each student? When I see structures like this, I worry.

Do you have control over the structure of the database? I get the feeling it could use some normalization. Then querying it for answers should get a lot easier.