Found at Common Tasks > Exams > Produce exam entries spreadsheet.
This script 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, select this button. The computer will work through a number of steps:
First it will take you to another screen, asking you to enter your Teacher Code, if required (you will only need to do this once).
Select Continue.
Enter the session and the year to find a specific group of records. (You can also enter a additional search criteria here if required.)
Select Continue.
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.
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.