Changes

{{Project|Has project output=Data|Has sponsor=McNair ProjectsCenter

This project revolves around examining Medical Centers and viewing their research to see how innovative it is and whether or not Medical Centers in the U.S. are using the grants and money they receive to discover and create new treatments and services. For this project, I plan on collecting data on patents, NIH and NSF grants, and clinical trial data based on zipcodes of medical centers to show how much innovation occurs in these centers. For each research artifactdataset, I plan on finding how many of each article type of event (patent, trial, grant) is filed under each zipcode. At this time, I have all the raw data for each research artifact dataset and am going through using regular expressions, I plan on finding out how many of each article is filed matches I have by the end of this week (March 23). After examining these results, I will decide how to present the data and create a paper around it. Project data is in: E:\McNair\Projects\Biotech Project ==Deliverables==

week 20-24: learn SQL ==Progress Report==Catherine matched patents, grants, and clinical trials to Medical Centers. She is currently working on putting all the data into a database stuff.

week 27-31==Project Data Location== E: continue learn SQL\McNair\Projects\Biotech Project

week 3-7==Dependencies==*Patent Data: http: if SQL fails then condense all grant files into one excel thing and do it by hand, find way to get patent stuff//mcnair.bakerinstitute.org/wiki/Patent_Data week 10-14*Federal Grant Data: http: finish grant stuff then work on and finish up patent stuff//mcnair.bakerinstitute.org/wiki/Federal_Grant_Data week 17-21*FDA Trials: look at all data, make outline week 24-28http: finish outline, write draft, edit draft//mcnair.bakerinstitute.org/wiki/FDA_Trials_Data