Meghana Pannala (Work Log)
Spring 2017
2/8/2017:10:00AM - 12:00PM Set up RDP and personal wiki page
2/13/2017: 1:00PM - 3:00PM Starting working with Julia on the lit reviews for University Patenting
2/17/2017: 2:00PM - 5:00PM Continued with lit reviews for University Patenting
2/20/2017: 1:00PM - 3:00PM Searched assignee list to come up with Key words to search for universities
2/22/2017: 10:00AM - 12:00PM - analyzed key words to search for universities among assignee list
2/24/2017: 10:00 AM - 12:00PM - got the US restricted assignee list from Marcela to re-evaluate key words
2/27/2017: 1:00PM - 3:00 PM - finalized new list of key words to get American universities - looked for additional sources of data
3/1/2017: 10:00AM - 12:00PM - looked for additional sources of data and evaluated existing sources to explain what useful items were contained within
3/3/2017: 10:30AM - 12:00PM; 1:00PM - 4:00PM - continued looking for additional data, worked on cleaning up Carnegie classification data to restrict to what was useful for us. Calculated aggregate columns for what we need.
3/6/2017: 1:00PM - 3:00 PM - cleaned up and filtered Carnegie data and consolidated
3/22/2017: 10:00AM - 12:00PM - looked at grant data and came up with a plan to use and get counts
3/24/2017: 10:00am - 12:00PM; 1:00pm - 4:00PM - looked at patent data and came up with a consolidated list of universities with high patenting activity to use in the actual ranking
3/27/2017: 1:00PM - 3:00PM: got counts of NSF grants received
3/29/2017: 10:AM - 12:00PM: cleaned up NIH data and got counts
3/31/2017: 10:00AM - 12:30 PM: cleaned up STTR data and got counts
