Sorry to be a long time in replying but I have already used the method you suggest. What i am searching for is an automatic link to the school's MIS.
The upload and download of excel files is inelegant and inefficient!
I think that somebody needs to give greater thought to the management of the enrollment of students on courses - particularly for the school environment.
An immediate improvement would be to recognise that the Course ID Number of a course does not need to be unique in Moodle and then take advantage of this. This would allow the automatic linking of two courses in Moodle to 1 group of students in the school MIS timetable. At the moment the first course is enrolled but the second and subsequent course are ignored.
We link to Subject and year to enroll all students studying subject X in year Y into a particular Moodle course. Of course there is usually more than one class in each year but there seems to be no way of creating groups in the Moodle courses using this information.
So a lot of this has to be done by hand which is not efficient.
Sometimes we want two years to access the same course and this again requires manual intervention.
I realise that Moodle came out of Higher Education but surely there are sufficient schools now on board who would welcome these sort of facilities?
Manchester High School for Girls