mod = modification
Bethesda uses a plugin system, has released a level editor tool, called the GECK, and it authors plugins, called esp or esm files. Modders have used that to add additional fan made content to the game, it works in much the same vane as Bethesdas own DLC expansion content.
there are no mods for consoles, only for PCs