Storing grades

[KDKMM]

I'm creating a db that will store student scoring of training. There are 10
categories each of which can have a scrore of 0 to 5. I need to know if I
should have a field in my table that will be a total of all the scores or
should I just calulate any totals as I need them in reporting?

In addition to having reports that will display each learners individual
scores totalled up, I will also need to get averages of all the learners
total scores.

Can someone let me know if I should have a field in my table called total
and if so, what would the best way to be capture that data that would be a
sum of the category scores?

Thanks!

 

[KARL DEWEY]

No totals and averages in the tables as data is always being updated. It
needs to be calculted each time it is needed.
One table for student information. Another for Subjects (categories). Each
of the students and subject to have an ID.
Third table combining StudentID, SubjectID, ScoreDate, and Score. If the
student retakes a subject then use the latest score date for your
calculations.