You must restart the game to see any new mods. The name of the directory will be the name of the mod. Mods work by providing the different files to use. The engine will attempt to find the files it needs in mods before searching the root game path.
Hopefully this will be sufficient to get you started. Note: This early draft of the modding instructions is far from completion. 5 Converting Sins data files into binary.