Changes

==Fall Semester 2017==<onlyinclude> [[Catherine Kirby]] [[Work Logs]] [[Catherine Kirby (Work Log)|(log page)]] 2017-12-07: 1pm-3pm: work on report 2017-12-06: 1pm-3pm; work on report 2017-12-01: 3pm-5pm: work on report 2017-11-30: 4pm-5pm: work on report 2017-11-29: 10am-11am; 3:00pm-5:00pm: work on report 2017-11-28: 4pm-5pm: work on report 2017-11-27: 10am-11am; 3:00pm-5:00pm: work on report 2017-11-22: 10am-12pm: work on report 2017-11-21: 3:30-4:30pm: work on report 2017-11-20: 10am-11:30am; 3:30-5:00pm: work on report 2017-11-16: 3:30pm-5:00pm: work on report 2017-11-15: 10am-12pm; 3:30-5:00pm: work on report 2017-11-14: 4:00pm-5:00pm: work on report 2017-11-13: 11:00am-12:00pm, 3:30pm-5:00pm: begin writing 2017-11-10: 1:00pm-3:00pm: work on graphs 2017-11-07: 11:00am-12:00pm: edit graphs, begin intro 2017-11-02: 11:00pm-12:00pm; 4:00-5:00pm: make graphs 2017-11-01: 10:00-12:00pm; 3:00pm-5:00pm: make graphs 2017-10-30: 10:00-12:00pm; 3:00-5:00pm: make graohs 2017-10-26: 11:00-12:00pm; 4:00-5:00pm: zipcodes 2017-10-25: 3:30-5:00pm: zipcodes 2017-10-24: 10pm-12pm; 4:00pm-5:00pm: zipcodes 2017-10-23: 2pm-3:30pm: find hospitals in zipcode area 2017-10-20: 1pm-3:30pm: find hospitals in zipcode area 2017-10-18: 10am-12pm: look at code running results. Clinical trial data finished 2017-10-17: 11am-12pm; 3:30-5:00pm: run newbiotech code 2017-10-16: 10am-12pm; 3:15-4:45pm: finish pulling Texas Contract data. rewrite med center code with new zipcodes 2017-10-12: 10am-12pm: pull data for Texas Contracts 2017-10-11: 10am-12pm: pull data for all Texas Federal Grants from 2005-2017 2017-10-04: 10am-12pm; 3:30-5pm: find all government grants in Augusta 2017-10-03: 11am-12pm: work on DOD grants 2017-10-02: 10am-12pm; 3:45-6:15: work with new zipcodes, pull DOD grants 2017-09-29: 3:00pm-4:30pm: examine hospitals in zipcodes 2017-09-27: 3:30-4:30pm: edit paper  2017-09-26: 10:30am-12pm; 2:00pm-5:00pm: find nsf, nih, clinical trial data for georgia and augusta university 2017-09-25: 10am-12am: edit paper 2017-09-21: 10:15-12:15pm; 3:30-5:00pm: search for zipcode areas, edit graph 2017-09-20: 10am-12pm; 3:30-5:00pm: edit graphs and writing 2017-09-18: 10am-12pm: edit graphs and figures 2017-09-13: 10am-12pm; simplify report 2017-09-12: 10am-12pm; 3:30-5:00: simplify report 2017-09-11: 10am-12pm; 3:30-5:00: edit report and figures, add the edited graphs to report 2017-09-06: 10am-12pm: edit report </onlyinclude> ===Fall 2016=== 

==Spring Semester 2017==

02/06/17: 1pm-4pm: outline Entrepreneurship as Diplomacy, cutting and using parts of Dylan's post (see blog post page on wiki), finish rough draft 02/08/17: 1pm-3pm: flush out blog post more, begin drafting on deliverables for biotech 02/13/17: 10pm-12pm; 1pm-2pm: table blog post (see wiki and googledoc for most recent draft), continue on deliverables of medical center+hospital information (see in server in biotech project file, medcenter data) 02/15/17: 1pm-3pm: med center address entering 02/16/17: 1pm-3pm: med center project continued 02/18/17: 1pm-4pm: med center project continued 02/22/17: 1pm-3pm: med center project continued 02/23/17: 1pm-3pm: med center project continued 02/24/17: 1pm-4pm: med center project continued, finished all main members of TMC, will go do additional members before moving onto cleveland clinic 02/27/17: 1pm-4pm: med center project continued 02/28/17: 1pm-3pm: med center project continued 03/01/17: 1pm-3pm: med center project continued 03/02/17: 1pm-3pm: med center project continued 03/03/17: 1pm-4pm: completed collecting addresses and zipcodes, created project page (see project management)...next time pull addresses needed and figure out hwo to find patents and clinical trials, and grants 03/06/17: 1pm-4pm: compiled zipcodes, waiting on Jeemin to rerun clinical trial data 03/08/17: 12:15pm-2:45pm: found zipcodes from clinical trial data...will have to do over as excel does not support all of the zipcodes, learned vlookup, countif, etc, edited wikipage http://mcnair.bakerinstitute.org/wiki /Medical_Centers_and_Grants  03/09/17: 1:30pm-3pm: finished finding the rest of the zipcodes and found the total number of clinical trials at the medical centers by zipcode. Looked into finding nih/nsf grant data as well. 03/20/17: 1pm-4pm: SQL lesson, made graph for E&I governance report 03/22/17: 10am-12pm; 1pm-3pm: figured out how to put NIH grants together, found NSF data, got patent data-->now I have all the research articles I need  03/23/17: 2:15-4:15: compiled all NIH grant zipcodes in on txt file, once draft they are fixed with regular expressions they will be ready. Compiled existing data into one sheet to refer to.  03/27/17: 1pm-4pm: finish compiling data set 03/29/17: 10am-12pm: work on brainstorming blog post 03/30/17: 1pm-3pm: meet with Ed 03/31/17: 10am-12pm: write up data wiki page things 04/03/17: 1pm-4pm: learn SQL create tables in data base 04/05/17: 1pm-3pm: create more tables 04/06/17: 1pm-3pm: create table 04/07/17: 1pm-4pm: troubleshoot tables 04/10/17: 1pm-4pm: troubleshoot tables pt 2: All my data is found in the Biotech folder in the Z drive, my SQL file is in that folder and a copy is finished)in the E:\McNair\Projects/Biotech Project folder as well  04/12/17: 1pm-6pm: worked loading NIH files and joining files together 04/13/17: 1pm-5pm: worked on the database and practiced SQL 04/17/17: 1pm-4pm: worked on database 04/19/17: 1pm-3pm: worked on database 04/20/17: 3pm-5pm: worked on database 04/21/17: 1pm-4pm: worked on database 04/24/17: 10:30-1pm: worked on research artifacts 04/27/17: 10am-11am, 3:30-4:30: work on research artifacts

05/02/08/17: 1pm1:30pm-3pm5pm: **tbd but hopefully finish up draft begin project**long weekend ahead**work on outlining report

[[Category:InternalWork Log]]