I think a good essay is one that gives a detailed explanation as to why you would like to be admitted into the program. It should also explain why you are choosing a particular specialty. I am really nervous too.
I'm interested and in fact, I recently went in for the AE MSN open house. I'm glad you started this discussion. What track are you interested in? For me, it's the Family Psych/Mental Health NP.