Ok.., normally my app uses 1 sheet per class/instructor meaning each
instructor would input scores for a single class. In your scenario each
judge would have their own sheet for the same group of students. I was,
however, able to set up on a single sheet similar to how I did in my
rework sample.

Each module shows Total Score and AVG only because each is 'weighted'
in the Summary module. For example, your "Kicks" module has 13 score
items and if each item's perfect score was 10 then the total score
possible is 130. If the 'weighted' value of "Kicks" is 10% of the
entire course then the total possible mark for "Kicks" is 13 for the
entire course. If your courses are structures as belt levels then you'd
use 1 sheet per class per belt level per instructor (judge).
Optionally, you could put all instructor/judge data on a single belt
level sheet in two ways:

1 row per instructor/judge per student
1 row per student using formula style input from each judge;
Example:
=8+9+8
OR
=AVERAGE(8,9,8)

...where, in all practicality, each judge would have a printout that
gets hand written inputs to be entered into the class sheet later on.
I'm inclined to go with the latter method so the score item perfect
score value doesn't need fudging with, and reports currently process a
student list as 1 row per student.

Ultimately, each module makes up a percentage of the entire course...

Creeds: 2*20=40; Weight=10% (4)
Physical Training: 5*20=100; Weight=5% (5)
Strikes&Punches: 5*10=50; Weight=10% (5)
Combinations: 5*25=125; Weight=10% (12.5)
Forms: 5*20=100; Weight=10% (10)
Weapons: 4*50=200; Weight=10% (20)
Kicks: 10*13=130; Weight=10% (13)
Sparring: (3*10)+(6*30)=210; Weight=10% (21)
Self Defense: 10*10=100; Weight=10% (10)
Board Breaks: (4*15)+(2*20)=100; Weight=10% (10)
Bonus Material: 3*100=300; Weight=5% (15)

...which represents 100% of the course (not factoring if the Attendance
module has a weight). That amounts to 1455 possible score. When
weighted as indicated, final average is based on (actual score)/(total
score) expressed as percent where total score evaluates to the sum of
the weighted values.

The final grade/ptAvg is defined in the GradesTable for given ranges of
final average. I guess that you need to have something that automates
printing reports, but my app does this per student by module items, per
module, and final score values/grades. Reports can be displayed in
PrintPreview, and are generated for selected students only OR the
entire class.

If interested, I can prep 2 class sheets that example the above and
post a link. Please advise...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion