The coupled cluster based linear response theory which is applicable to the direct calculation of atomic and molecular properties are presented and applied to compute the ionization potentials and excitation energies of light and moderately heavy atoms. The effect of electron correlation on the ground and excited states is studied using Hartree-Fock, Dirac-Fock and approximate two-component relativistic spinors.