My favorite resource I found was from Stephanie at Falling into First - "Everyone is Smart." Stephanie wrote a fabulous book that explains the multiple intelligence theory to younger elementary students and then provides a great writing activity to help them think through which "smart" they relate to the most.
Visit Thinking Out Loud to learn more about multiple intelligence theory, how I used Stephanie's activity, other resources I found useful.