264
edits
Changes
Jump to navigation
Jump to search
no edit summary
}}
==Project Description==
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 artifact, I plan on finding how many of each article is filed under each zipcode. At this time, I have all the raw data for each research artifact and through using regular expressions, I plan on finding out how many of each article is filed 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
week 20-24: learn SQL and database stuff
week 27-31: continue learn SQL
week 3-7: if SQL fails then condense all grant files into one excel thing and do it by hand, find way to get patent stuff
week 10-14: finish grant stuff then work on and finish up patent stuff
week 17-21: look at all data, make outline
week 24-28: finish outline, write draft, edit draft
2. search to see if medical center names and/or zipcodes correspond with already found zipcodes
===NSF/NIH Grants===
Raw Project data is in:
E:\McNair\Projects\Federal Grant Data
Compiled Excel Data for NIH grants can be found in my Biotech Project folder in the grants section.
1. Find a way to combine all the excel data onto a couple of spreadsheets
2. search to see if medical center names and/or zipcodes correspond with already found zipcodes
