First reading, he had to take stock of himself:

He’s not the steady, industrious type
He’s not the grasping, ambitious type
And cowardice is a flaw —
But smart he was always supposed to be
And so he inferred, as he read, that was He —
He was a Ravenclaw

Then he looked again at the end of the books:

That he would be a loyal to all his friends
But he could still strive for his personal ends
And try to be brave at that —
So maybe the Ravenclaw part of He
Is good, but not all that he can be
For he is more
Than that