what should i do

You should tell her not to give up and try again

If I were your friend who failed a final exam I would expect you to be a good friend and say nothing.

Tell her that we can't all be smart and then remind her that she is can at least tie her shoes, what more should she expect out of life?

Some times a well placed joke is better than a mundane sympathy plea..