Turning off a source, which is usually used in solving circuits with superposition method, means setting its value equal to zero. For a voltage source, setting the voltage equal to zero means that it produces zero voltage between its terminals. Therefore, the voltage source must insure that the voltage across two terminals is zero. Replacing the source with a short circuit can do that. Thus, voltage sources become a short circuit when turned off.
For a current source, setting the current equal to zero means that it produces zero current. Therefore, the current source must insure that no current flows through its branch. An open circuit can do that. Hence, to turn off a current source it should be replaced by an open circuit.
How about dependent sources? The voltage/current of a dependent source is dependent on other variables of the circuit. Therefore, dependent sources cannot be turned off.
Example I: Turn off sources one by one.
I) The voltage source:
Turning off the voltage source