DEVELOPMENT AND APPLICATIONS OF SEMI-STOCHASTIC COUPLED-CLUSTER METHODS FOR OPEN-SHELL SYSTEMS AND ELECTRONIC EXCITATIONS IN MOLECULES