I don’t think it’s ever been a “normal way” of doing them.
In the old days of paper exams there were two opportunities plus resits. First exams in whichever month it was (March and also something later in the year) and then resits in May if I recall.
Since the introduction of Ultilearn Sqns have been left to decide their own approach to training and assessment but I think that the most common, or ‘normal’ way is to let cadets take the assessments whenever they are ready.
A spreadsheet which updates from SMS would seem like a good idea on the surface until one considers that instead we could have a report generated and displayed right there within SMS and not worry about linking the data to external spreadsheets.
The one area that SMS really lags is in the ability to generate useful reports.