Thank you for your post.
Your script looks fine, but you should make a few modifications.
Insert the script step:
Go to Record/Request/Page [ First ]
at the beginning. This will ensure you start with the first record in your found set.
In your "Save Records as PDF" script step, you may want to select the option "Perform without dialog", "Specify the output file" (and reference a field name for the file name), and "Specify options" Save current record. Then, the next script step Send Mail is probably fine where you attach the PDF file referenced above.
Since the teachers are using Excel, FileMaker will allow you to import Excel files, so use this option when importing.
If certain fields are empty, you can insert the script step:
If [ IsEmpty ( <fieldname> ) ]
That is, if a specific fieldname is empty, then do something. Or, you could use:
If [ not IsEmpty 9 <fieldname> ) ]
... to check if a specific fieldname is not empty.
This should get you pointed in the right direction.
I have been working on the project and finally wrapped it up. We went with another route to the problem via a through of nested IF Then statements.