Welcome to Smogon! Take a moment to read the Introduction to Smogon for a run-down on everything Smogon, and make sure you take some time to read the global rules.
A moderator is normally only responsible for the moderation and policy of one (or a few) subforums on the site. A super moderator is responsible for site policy as a whole and can moderate every forum on the site. So basically superman.