Difference between revisions of "Medical Centers and Grants"
CatherineK (talk | contribs) |
CatherineK (talk | contribs) |
||
| Line 12: | Line 12: | ||
==Deliverables== | ==Deliverables== | ||
| + | |||
| + | 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 | ||
| + | |||
===Med Center Data=== | ===Med Center Data=== | ||
Catherine collected all center, institution, and hospital address, zipcode, and phone number data from all United States medical centers. Intending to use this as the basis analyzing the other data gathered. | Catherine collected all center, institution, and hospital address, zipcode, and phone number data from all United States medical centers. Intending to use this as the basis analyzing the other data gathered. | ||
Revision as of 12:57, 20 March 2017
| Medical Centers and Grants | |
|---|---|
| Project Information | |
| Project Title | Medical Centers and Grants |
| Owner | Catherine Kirby |
| Start Date | Spring 2017 |
| Deadline | |
| Keywords | Entrepreneurship, Start-ups, Patents, Grants, Medical Centers, Biotechnology |
| Primary Billing | |
| Notes | |
| Has project status | Active |
| Copyright © 2016 edegan.com. All Rights Reserved. | |
Contents
Project Description
Project data is in:
E:\McNair\Projects\Biotech Project
Deliverables
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
Med Center Data
Catherine collected all center, institution, and hospital address, zipcode, and phone number data from all United States medical centers. Intending to use this as the basis analyzing the other data gathered. Project data is in:
E:\McNair\Projects\Biotech Project\medcenter data
Clinical Trial Data
Project data is in:
E:\McNair\Projects\FDA Trials
Jeemin collected all data in textpad. There are more entries than excel rows, need to fix the textpad things before looking at stuff again
1. Find the zipcodes that correspond with medical center zipcodes
2. See if the names of medical centers can be matched as well
3. go back and fix the problems encountered
Patent Data
Project data is in:
E:\McNair\Projects\PatentData
- not sure if ready to use yet*
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
NSF/NIH Grants
Project data is in:
E:\McNair\Projects\Federal Grant Data
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
