264
edits
Changes
Jump to navigation
Jump to search
Catherine Kirby (Work Log) (view source)
Revision as of 12:31, 11 December 2017
, 12:31, 11 December 2017no edit summary
==Fall 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===
9/8/16 3:30pm-6pm: Introduction, create wiki page, brainstormed blog ideas
12/07/16: 1pm-4pm: finalize blog post
==Spring 2017== 01/18/17: 1pm-3pm: begin research for blog post 01/19/17: 1pm-3pm: continue research for blog post, begin outline 01/20/17: 1pm-4pm: finish blog post outline, team meeting 01/23/17: 1pm-4pm: draft blog post, Julia peer edit, sent to Anne 01/25/17: 1pm-3pm: fix Anne's edits 01/27/17: 1pm-3pm: work on Ed's edits 01/30/17: 1pm-4pm: fix additional edits 02/01/17: 1pm-3pm: revisions on blog post, put in blog, added pictures, work on wiki 02/02/17: 1pm-3pm: revise blog post, look at foreign affairs blog post 02/03/17: 11pm-12pm; 1pm-3pm: add tweets to hootsuite, look over Jake's blog post 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 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 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 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]]
