Carlin Cherry (Work Log)

Spring 2017

6/18/17 7:50-8:50 - finish the last pivot table for percent over time, pivot for bar graph of women by industry (2/3)

6/16/17 3:00-4:00 - continue the pivot tables for percentages over time (2/3)

6/14/17 2:30-4:00 - finish filling in data about data itself (1/3), start doing pivot tables to graph percentages over time (2/3)

6/10/17 2:30-4:00 -revisiting project - started to fill in data about data itself

4/21/17 12:00-2:00 - meeting with ed to determine what to do for the rest of my project

4/19/17 12:45-2 - continue analysis and filling in report https://docs.google.com/document/d/1RHC0Namt9VpmUxINmRvHw4U34dDmgYPcUMbwhhthcCA/edit

4/18/17 1-3:30 - continue analysis and filling in report https://docs.google.com/document/d/1RHC0Namt9VpmUxINmRvHw4U34dDmgYPcUMbwhhthcCA/edit

4/17/17 11:45-1 - continue filling in report https://docs.google.com/document/d/1RHC0Namt9VpmUxINmRvHw4U34dDmgYPcUMbwhhthcCA/edit

4/14/17 11:45-1 - built the "does this company have data" variable, now that data set is clean (hopefully) i'm going to start playing around in stata and see if i can get something to come out of this! rigorous analysis to start next week.

4/12/17 12:45-2 - the thing that ed and i talked about yesterday which i can't remember right now but will revise here later

4/11/17 2:15-5:15 - continue writing article (see RDP), called SDC for ~45 min to determine how they gather various aspects of their venture data. Results from call can be found here: [1]

4/10/17 11-12:15 - double check that dr data worked, after that add column in stata for unidentified people (not male or female assigned), continue writing article

4/7/17 12:45-2 - helped Will with SDC, start to write issue brief [2]

4/5/17 12-1:30, 4-5:30 - export and start to do stata things? make new control variable for the people whose genders aren't classified, start to do regressions? [3]

4/4/17 1:30-4 - continue plugging away at dr problem in data

4/3/17 12:30-2 - download list of most common names for genders, piece through back to doctor data, download doctors and assign match to most common names for genders

3/31/17 12:45-2 - [4]

3/29/17 12:15-2, 4-5:15 - reexamining the data and making list of what needs to happen with Ed versus what I can do myself

3/28/17 2-4:30 - redoing lit review with updated dates for [5]

3/24/17 12:45-2 - [6]

3/22/17 12:45-2, 4-5:30 - [7]

3/21/17 2:15-4:45 - write up plan for rest of semester, think of ways to fix doctor problem in data + redo c-level to include everything in addition to ceo+founder

3/20/17 11:00-12:15 - refamiliarizing self with project since I've been gone for 2 weeks, starting some analysis, making plan to complete project by end of term

3/8/17 12:45-2 - run regressions and analysis, hopefully write and finish blog post

3/7/17 2:30-5 - finish cleaning Women2017 dataset, data analysis, hopefully start to write article

3/6/17 11:50-1:05, 4-4:30 - finish cleaning Women2017 dataset

3/3/17 10:30-10:45, 12:45-2 - finish cleaning Women2017 dataset

3/1/17 12:45-2 - continue cleaning Women2017 dataset

2/28/17 2:20-4:50 - load company, people, title lookup, statalookup

2/27/17 11:45-1 - going through excel sheet and assigning 1's to people in relevant positions of power

2/24/17 12:45-2 - [8]

2/22/17 12:45-2, 4-5:30 - stata with Ed, continue writing report [9]

2/21/17 2:30-5:15 - run regressions on new "realbig" dataset using performance measure, men in power, etc.

2/20/17 11:50-1:05 - build new dataset to contain men and year variables, stata practice at very end for a bit just to remember what I'm doing

2/16/17 12:45-2 - stata learning

2/15/17 12:30-2, 4-5:30 - continuing drafting report, regression hopefully this afternoon with ed

2/14/15 2:20 - 4:50 - building combined table with coname, womenceo?, womeninpower?, #powerpos, state, yearfirstinvest, norounds, tot$invest

2/13/17 12-1:15 - detailing plan for building combined table with coname, womenceo?, womeninpower?, #powerpos, state, yearfirstinvest, norounds, tot$invest

2/8/17 12:45-2 - [10]

2/7/17 2:20-4:50 - [11]

2/6/16 12:45 - 2 - try to find some results grouped by state

2/2/17 12:45-2 - redo sdc pulls so I can group by state, etc.

2/1/17 - 12:45-2, 4-5:30 - start building tables [12]

1/31/17 1:45 - 4:30 - a lot of working with sdc and pulling appropriate data, put new sdc pulls through normalizer script

1/30/17 12:45-2 - redid the sdc pulls so they could be put through normalizer script

1/27/17 12:45-2 - start building tables using normalized sdc data

1/25 12:45-2, 4-5:30 - SDC pull, rerun through tables w new added variables (i.e. industry, etc)

1/24/17 11:45-1:00, 2:30-5:15 - revisiting women in entrepreneurship [13], oil&gas industry innovation project planning [14]

1/20/17 12:30-2 - accelerator data, hopefully the last day!

1/19/17 2:30-4:15 - accelerator data....still....

1/18/17 12-1:30 - accelerator data

1/17/17 2:30-4:30 - backtracked blog posts and posted them on facebook

1/13/17 12:45-2 - twitter, accelerator data

1/12/17 2-4 - accelerator data

1/11/17 12-2, 4-5 - accelerator data

1/10/17 2:30-4:30 - accelerator data, mining for twitter articles

1/9/17 12:45-2 - review and analysis of past semester per Ed's request, possibly hootsuite and twitter

Fall 2016

8/31/16 3:00-5:00 - Set up Bio page, Work Logs, poked around on Wiki.

9/1/16 2:20-3:50 - Hootsuite setup and tweets.

9/2/16 3:00-5:30 - Classified all remaining uncategorized pages, wrote norms for blog posts and tweeting, worked with Anne on Hootsuite.

9/6/16 2:30-4, 5:30-6 - Helped new staff members set up their pages, worked with Twitter/Hootsuite, started writing workplace norms on Help for new staff

9/7/16 12:30-2, 3-5:30 - Hootsuite/Twitter scheduling, recategorized Projects on Project management page by adding Priority, Due Date, and Stage (see https://mcnaircenter.slack.com/messages/wikicategorization/ for details), brainstormed ideas for mcnair center for this semester w Julia, Ramee, Albert

9/8/16 2:30-3:40 - http://www.mcnaircenter.org/wiki/Women_in_Entrepreneurship_(Issue_Brief), meeting with Twitter team

9/9/16 12:30-2 - helped Catherine set up her pages, read Health Innovation documents sent by Accenture, brainstormed potential collaboration with them

9/13/16 2:00-4:00 - research on Space startups for a potential blog post, research ideas for cross collaboration project with law professor, twitter

9/14/16 3:00-4:30 - reading Tay's blog post on Women in Entrep, brainstorming topics for women in entrep blog series, researching my topic area for said blog series Women in Innovation and Entrepreneurship: 2nd In Blog Series

9/15/16 10:30-12, 2:30-4 - Women in Innovation and Entrepreneurship: 2nd In Blog Series

9/20/16 9:30-10:30, 2:30-4 - Hootsuite, Forbes's Women in Entrepreneurship, Women in Innovation and Entrepreneurship: 2nd In Blog Series, meeting w albert and ed

9/21/16 12:45-2, 3-5:30 - Hootsuite, general article research, working connections to get patent lawyer here, started Spotlight on Innovation: Space

9/22/16 2:20-3:50 - mcnair shirt design, doodle poll for mcnair party, continue researching Spotlight on Innovation: Space

9/23/16 12:30-2 - call tshirt people, write shirt proposal, doodle poll for mcnair meeting

9/27/16 10-12, 2:30-4 - Clinton/Trump Debate - will finish on 9/28

9/28/16 12:45-2, 2:45-5:15 - Clinton/Trump Debate, organize the mcnair staff meeting

9/29/16 1:15-4 - met with Albert, Ed, and Anne to discuss McNair management things, space research, podcasts, linkedin

10/4/16 2:20-3:50 - Small Business Development Ecosystem of Houston

10/5/16 12:45-2, 3-5:30 - Small Business Development Ecosystem of Houston

10/6/16 10-12, 2:20-3:50 - finishing resource descriptions for Small Business Development Ecosystem of Houston

10/7/16 12:45-2 - linked blogs to external sources (http://mcnair.bakerinstitute.org/blog/trumppence-entrepreneurship/ and http://mcnair.bakerinstitute.org/blog/clintonkaine-entrepreneurship/), wrote final edits before they were published

10/12/16 12:30-2, 3-5:30 - twitter, Small Business Development Ecosystem of Houston - write up the institution wiki pages (https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web) and integrate graphics that Julia did into the wiki page

10/13/16 2:20-3:50 - met with anne re mcnair admin (mcnair center meeting logistics coordination, blog update, work logs logistical issues, table overlay of graphic for small business htx page), continue institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web

10/18/16 9:30-11:30, 2:20-3:50, 5:30-7 - finish institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web, check in w Julia, Ed, and Albert re status of Small Business in HTX, McNair center meeting from 5:30-7!

10/19/16 12:30-2, 3-5:30 - thought we were finished but turns out someone still copied and pasted so we are finishing institution description write-ups on https://docs.google.com/a/rice.edu/spreadsheets/d/1PLs8gUZkT_bRJQGBjbNsTQSVm2AaYZX70d02JAOwwEc/edit?usp=drive_web, developing Ankita meeting agenda with Catherine, phone conference with ankita at 4:30

10/20/16 2:20-3:40 - meeting with Ed, Albert, and Catherine re Small Business Development Ecosystem of Houston - link to meeting notes can be found here HTX Small Biz Meeting Notes. Developing ideas for patent thingies

10/21/16 12:45-2 - Fall 2016 Project Ideas Page, email from anne re shirts

10/25/16 9:45-11:45, 2:30-4 - morning: news from weekend, working on idea #2 from Fall 2016 Project Ideas Page (researching open v closed innovation, read introduction to Henry Chesbrough book [15]) afternoon: learn more about patent data, talk w avesh, start getting info from SDC Innovation in the Oil and Gas Industry

10/26/16 12:30-2, 3-5:15 - mcnair admin (20 min), SDC acquisitions and mergers data (play around with it)

10/27/16 2:30-4 - work on project page Innovation in the Oil and Gas Industry, twitter articles, SQL workshop from 3-4

10/28/16 12:45-2 - Innovation in the Oil and Gas Industry SDC planning, help julia with caricatures

11/1/16 10-12, 2:30-4 - morning: mcnair admin (semester performance reviews and meeting 1x a week on thurs from 3-4 to do sql training), upload pics to facebook, afternoon: avesh and i discuss Innovation in the Oil and Gas Industry

11/2/16 12:45-2, 3-5:30 - interview with East-West tea in early afternoon, writing Spotlight on Rice Entrepreneurs: East-West Tea in late afternoon

11/3/16 2:30-4 - SQL training

11/4/16 12:45-2 - responding to edits on Spotlight on Rice Entrepreneurs: East-West Tea and getting peer review

11/8/16 9-12, 2:30-4 - came in a little early this morning since I'll be missing my shifts later this week. finished Spotlight on Rice Entrepreneurs: East-West Tea and published it on the blog. worked on organizing data from SDC pull of companies (created sql database and tables)

11/9/16 12:45-2 - organizing data from SDC pull of companies (created sql database and tables)

11/15/16 2:30-4 - ed is repurposing me VC Policy Report

11/16/16 12:45-2, 3-5, 6-7 : first chunk - articles, looking up dates for Ed, editing Julia's moonshot article, admin. second chunk - working with avesh on VC Policy Report. third chunk - elevator pitch competition for spotlight series

11/17/16 10-12, 2:30-4 : first chunk - writing new blog post article Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post), VC Policy Report second chunk - VC Policy Report

11/18/16 3-4: finishing up the aggregate data table sql for VC Policy Report

11/22/16 10-12, 2:10-3:40 - twitter, making interview questions for Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post), interview with the winners from 11-12, afternoon: IPO aggregate table work on VC Policy Report.

11/23/16 12:45-2 - ask ben how far he got on ipo aggregate table and act accordingly with VC Policy Report, add some tweets in hootsuite

11/29/16 10-12, 2:30-4 - accelerator data with dylan, fixing east-west page yet again, interview with elevator pitch people from 11-12. afternoon: accelerator data

11/30/16 12:45-2, 3-5:30 - first: finish Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post), second: accelerator data

12/1/16 1:30-3:30 - accelerator data

12/2/16 3-4:15 - accelerator data

12/5/16 10-12 - accelerator data

12/6/2016 9-12 - accelerator data

12/7/16 10-12 - hootsuite, revise Spotlight on Rice Entrepreneurs: Elevator Pitch Competition (Blog Post), accelerator data

12/8/16 9-12 - accelerator data, hootsuite, check w/ anne re elevator pitch blog post