Green’s Dictionary of Slang

(US campus) an insignificant person, a weakling.

1856		B.H. Hall College Words (rev. edn) 442: spoops, spoopsy. [...] a weak, silly fellow, or one who is disliked on account of his foolish actions.
1860		Yale Literary Mag. XXV 192: [If he] makes a dull recitation, he is denominated a regular ‘spoops’ [DA].
1871		L.H. Bagg Four Years at Yale 48: Spoops or spoopsey [...] synonyms for a silly, insignificant fellow.