Catherine Kirby (Work Log)

Fall Semester 2016

9/8/16 3:30pm-6pm: Introduction, create wiki page, brainstormed blog ideas

9/9/16 1pm-4pm: Create Bio, brainstormed and further developed blog ideas

9/13/16 1pm-4pm: Research for blog posts

9/14/16 2:20pm-5:20pm: Research for blog posts and begin outlines for two

9/15/16 2pm-5pm: continued on outline for drug patents and explored two new possible topics

9/20/16: 1pm-3pm: completed a first draft of the ACA and private practice blog post, continued to explore and work on other three topics

9/21/16: 2:20-4:20pm: put blog post draft on wiki, found possible photos to include, researched for other topics

9/22/16: 2pm-5pm: started editing election blog posts, worked with Avesh to research patent licensing

9/23/16: 1pm-4pm: researched patent licensing figures

9/27/16: 1pm-3pm: added to the how to write a blog post portion of the Help for New Staff page, researched for new blog topic

9/28/16: 3pm-5pm: continued research for entrepreneurship as diplomacy

9/29/16: 2pm-5pm: worked on editing blog posts, researched for other blog post

10/04/16: 1pm-3pm: worked on the small business development ecosystem of HTX

10/05/16: 3pm-5pm: worked on Alberts project for small business development

10/06/16: 2pm-5pm continued to work on small business development project

10/07/16: 10am-1pm: edited blog posts for the election posts

10/12/16: 3pm-5pm: edited ACA blog post

10/13/16: 2pm-5pm: finished edits on ACA blog post, helped Carlin plan McNair dinner

10/14/16: 1pm-4pm: edited ACA blog post, helped Julia look over SXSL blog post, researched entrepreneurship in diplomacy

10/18/16: 1pm-3pm; 5:30-6:30: finished edits on ACA blog post, dinner

10/19/16: 3pm-5pm: edited blog post, worked to prepare for call with Ankita

10/20/16: 12:40pm-3:40pm: edited blog post, work with Albert on Small Business Portal

10/21/16: 12:30pm-4pm: finished blog post and put it in the blog. continued research on entrepreneurship in diplomacy and brainstormed other blog post ideas

10/25/16: 2:05pm-4:05pm: edited Eliza's emerging entrepreneurial ecosystems: Austin, Tx post, researched entrepreneurship as diplomacy and looked into the new overtime rules.

10/26/16: 2:20pm-4:20pm: drafted 3/4 of a blog post on the new overtime regulations.

11/01/16: 1pm-3pm: edited draft of overtime law post, wrote bio for the blog, put blog post into the blog on private http://mcnair.bakerinstitute.org/wiki/New_Overtime_Labor_Laws_(Blog_Post)

11/02/16: 3pm-5pm: edited draft and prepared it for the blog. Began researching bayh dole act. Edited Julias blog post

11/03:16: 1pm-4mp: researched for the effects of the Bayh Dole on the biotech industry. did sql workshop

11/04/16: 1pm-4pm: outlined Bayh Dole Act blog post

11/08/16: 12:45-2:45pm: drafted Bayh Dole blog post

11/09/16: 3pm-5pm: finished drafting Bayh-Dole blog post

11/10/16: 2pm-5pm: had Eliza peer edit my post, made Anne's edits, discussed blog with Ed and began to make edits, brainstormed for future blog posts with ed

11/11/16: 1pm-4pm: edits on blog post

11/15/16: 1pm-5pm: work on project, found list of supreme court cases, executive orders, and council of economic advisors that all had to do with entrepreneurship and innovation.

11/16/16: 2:15pm-5pm: continue looking for executive orders for governance policy report

11/17/16: 1:45pm-6pm: continued working on project, edit blog post, find images for blog post, changed the general direction of blog post

11/18/16: 1:00pm-4:15pm: worked on project, edited blog post, went to blog meeting

11/22/16: 1pm-3pm: continued to work on project

11/29/16: 12:45pm-3:15pm: did supreme court case descriptive statistics

11/30/16: 2:15pm-5:00pm: worked on executive orders, edited Carlin's post, made edits on Anne's edits on my blog post

12/01/16: 1pm-4:15pm: continued executive orders, started compiling list of bills, discussed all with ed

12/02/16: 1pm-5pm: started and finished descriptive statistics of bills for E&I project. link to googledoc on wikipage

12/06/16: 4pm-5:30pm: edit blog post

12/07/16: 1pm-4pm: finalize blog post

Spring Semester 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

Fall Semester 2017

09/06/17: 10am-12pm: edit report

09/11/17: 10am-12pm; 3:30-5:00: edit report and figures, add the edited graphs to report

09/12/17: 10am-12pm; 3:30-5:00: simplify report

09/13/17: 10am-12pm; simplify report

09/18/17: 10am-12pm: edit graphs and figures

09/20/17: 10am-12pm; 3:30-5:00pm: edit graphs and writing

09/21/17: 10:15-12:15pm; 3:30-5:00pm: search for zipcode areas, edit graph

09/25/17: 10am-12am: edit paper

09/26/17: 10:30am-12pm; 2:00pm-5:00pm: find nsf, nih, clinical trial data for georgia and augusta university

9/27/17: 3:30-4:30pm: edit paper

9/29/17: 3:00pm-4:30pm: examine hospitals in zipcodes