In Canada we don't do either in public schools. Singing the national anthem is pretty much reserved just for Remembrance Day, maybe with a little bit of practice for a few days beforehand to avoid embarrassment at not knowing the lyrics. Certainly no prayers are ever said at school.