Create a composite custom column (column made from other columns). In the template, use something like
Code:
{rating:switch(10,Best,8,Good,6,OK,4,Passable,2,Terrible,0,Unread,Unread)}
then make your collection from the custom column. You can hide the column to prevent it taking up screen space.