When Music Monitor was first developed, it was used only by schools in Victoria, and the exam entries were primarily for AMEB Vic examinations. Now, schools all over Australia use the Exams section for AMEB exams (and different States have different fees!), ANZCA exams, Trinity, Rockschool, and internal exams. (Some schools even use this section to record student performances.)
I haven't added ALL the entry forms for ALL these institutions to the system, however, I have now added this new script that allows you to quickly and easily produce an excel spreadsheet of exam entries. Many institutions now accept excel spreadsheet enrolment, and if not, you can use the spreadsheet as a data source to merge with your own documents.
To produce an excel spreadsheet, click this button. The computer will work through a number of steps:
1. Firstly, it will take you to another screen, asking you to enter your Teacher Code, if required (you will only need to do this once).
2. Click 'Continue'.
3. Enter the session and the year to find a specific group of records. (You can also enter a additional search criteria here if required.)
4. Click 'Continue'.
5. The computer will then find the records you have asked for, sort them alphabetically by Last Name, and then save the records as an excel spreadsheet, which should open on the screen in front of you. All key fields are exported to the spreadsheet (name, date of birth, candidate number, subject code, subject, grade, fee, etc.) You will notice, though, that some of the headings include the word 'AMEB'. Obviously, if your enrolments are for a different institution, you will need to change these headings.
6. You can edit and save the spreadsheet to a different location to work with later. When you close the spreadsheet, you will see that Music Monitor has taken you back to where you began the script.