completed functionalities for college sec