At my son's school last year, there was a community award given in memory of a former student who had passed away in an accident. They also gave out a Principal's award. In addition, 6 students were given an academic award for getting all 4's/A's from 4th-6th. All students also get a "diploma" and get to hear their name called.
At my school of employment, we give out a Music/Art/PE award. Students who participated in All-County Chorus also get a certificate. I believe they also give out a few other awards for News Show, and a community award. Again, all students get to hear their name called, and get a certificate from the principal.