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==

03/08/17: 12:15pm-2:15pm45pm: 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 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 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/17: 1:30pm-5pm: work on outlining report

[[Category:InternalWork Log]]