Does your son's elementary school have a talent show? That might something for him to aspire to. There were a couple magicians in the talent show at my son's school, but they all did cheap kit tricks that were ill-suited for the stage. (This was one of those schools where every act gets in because everybody is gifted. It ran close to three hours!)
If he's looking for a talent show entry, I'd suggest any incarnation of "The Vanishing Bandana." It works well for small hands, plays well on stage, and has lots of room to ham it up, it that's in your son's personality.
Here's a demo if you haven't seen it before:
http://www.penguinmagic.com/p/S9916It may be out of production, as Penguin lists several versions as "out of stock." But a well-known online auction site usually has them listed.