There is an option on Moodle (and maybe other systems - not sure if this is a SCORM characteristic) where the score reported to the system for a student's performance is the *highest* score achieved.

There are also other options like: *first* score achieved or *last* score achieved.

Is there any way of achieving these outcomes in formalms (hopefully 2.0)?

At the moment, it seems that all scores are reported to the student in the order in which they are achieved.

I guess I can produce a mysql query to identify these but not sure how to display them to students.

Thank you for any help.

In Forma's gradebook you are displayed the last score achieved + a number you can click on and that will display the list of all the scores achieved.
The same thing can be shown to students with the "gradebook" button available in the student menu. Yes, as you say scores are reported in the order they are achieved

Thank you very much Max but ALL the scores are kept, so we have to identify the highest score achieved manually (or using a script) and then find a way to report it to the student so that they always know the state of play.

well, they know the state of play since they see a green flag if/when they achieve the passing score. I agree that they need to manually check their highest score, if they want to know it.

The point is that in some cases, the passing score (or the first score or the last score) is the one that counts for the student and is given to them when adding up all the marks to determine a grade. There may be a minimum passing score but not a maximum passing score. The point for me is that if the teachers want to collect all of the highest scores then we need to find a way of doing that and then reporting it online, perhaps with a custom-made gradebook (perhaps not integrated into forma). Now, moodle has these features (which are used by some teachers) but I prefer forma and so need to find a way of reproducing them on forma.

So... where do I find all of the scores for an exercise? I guess it is in a mysql table but which one? Can you please advise?
Thanks

If you're referring to a test, all the execution results (not the details) are stored in learning_testtrack_times table.

Where can I find the scores reported for a SCORM module?

learning_scorm_tracking_history