In Canada even in university I don't think it was expected to be memorized.

My prof did offer extra credit to anyone who could sing the entire element song in front of the whole class, which was very fun, and some people nailed it.

My highschool teachers did the same.

I've always liked those efforts to make bohring content engaging