I built a very basic solution on student evaluation.
Every student is evaluated on 7 human qualities. Attendance, promptness, listening, team spirit's, motivation, etc.
Those 7 qualities are part of an activity which I called 'sujet'.
In this snapshot the relationships:
Here the layout
I need to summarise the totals of each quality of each student in a unique number per student. I can't make it so far... Any suggestion?