You can earn House Points by doing well in class, completing main quests, and making certain dialogue choices. The house with the most points at the end of each year wins that year's House Cup!