The following scripts are able to take in a xlsx file that is available from myPearson and add all the grades to T-sqaure automatically. If anyone wants to use it and wants help setting things up, feel free to email me at pujun@gatech.edu
some cool things for refernce: http://www.whale.to/a/az_numbers.html