Julia Wang (Work Log)

Fall 2017

Julia Wang Work Logs (log page)

12/4-12/8 finalizing University Patents report

• 12/4 9-12 edits, sent to Ed, confirming catering for party
• 12/5 9-12 final edits, sent to Ed
• 12/6 1-4 making City Agglomeration graphics
• 12/7 1-3 wrapping up everything

11/27-12/1

• 11/27 10-12 edits, sent to Ed
• 11/29 10-12 catering order for lunch party, wiki page organization
• 11/30 2:30-4:30 edits
• 12/1 10-12 met with Ed, edits

11/20-11/22

• 11/20 10-12 edits
• 11/21 10-12 met with Ed, edits
• 11/22 10-12 met with Ed, edits

11/13-11/17 deadline 11/16 final draft

• 11/13 10-12 redoing reg table
• 11/14 10-12 edits
• 11/15 10-12:30 edits
• 11/16 2:30-4 met with Ed, edits
• 11/17 10-12 edits

11/6-11/10 deadline 11/16 final draft

• 11/6 10-12 4th draft
• 11/8 10-12 met with Ed, editing
• 11/9 2:30-5:30 redoing graphs, restructuring introduction
• 11/10 10-12, 3-4:30 redoing charts, rewriting body

10/30-11/3 deadline 11/16 final draft

• 10/30 10-12 revisions
• 10/31 10-12 revisions
• 11/1 10-12 revisions, new data for basic funding
• 11/2 10-12 revisions

10/23-10/27

• 10/23 10-12 editing University Patents
• 10/24 10-12 reran regressions, fixed problem with Cornell!
• 10/25 10-12 sent 2nd draft to Anne
• 10/26 2:30-4:30 revisions
• 10/27 10-12 sent 3rd draft

10/16-10/20

• 10/16 10-12 pulled Houston patent addresses
• 10/17 10-12 pulled Houston patent addresses
• 10/18 10-12 edited University Patents
• 10/19 2:30-4:30 edited University Patents, tabled patent database reorganization until it is cleaned by Oliver/Shelby/Ed
• 10/20 10-12 edited University Patents

10/11-10/13

• 10/11 10-12 pulling Houston patents
• 10/12 10-12 University patents, sent draft to Anne

10/2-10/6

• 10/2 10-12 work on University Patents draft, close to sending
• 10/3 10-12 Distracted by Augusta project, Reorganizing patent database
• 10/4 10-12 Reorganizing whole patent database by city, state, pulling Crunchbase data for Augusta
• 10/5 2:15-2:45 Augusta patents
• 10/6 10-12 Reorganizing patents, figure out misspellings

9/25-9/29 finish draft

• 9/25 10-12 remaking charts
• 9/26 10-12 data pull for Augusta University
• 9/27 10-12 data pull for Augusta University
• 9/29 10-12 reran log regressions

9/18-9/22/2017

• 9/18 10-12 cleaning data
• 9/19 10-12 cleaning data
• 9/20 10-12 created time-series data set
• 9/21 2:30-4 reran regressions
• 9/22 10-12, 2-3 remade charts

9/11-9/15/2017 Deadline: 9/15 - convert data to time-series, new charts

• 9/11 10-12 Converting to time-series
• 9/12 10-12 Check accuracy, converting to time-series, talked to Jeemin about next project
• 9/13 10-12 Fix R&D data, previous SQL code
• 9/14 2:30pm-4pm, 10:30pm-12am Fix R&D data
• 9/15 10-12, 2-3 join data

9/5-9/8/2017 Putting together University Patents report

• 9/5 10-12 Looked at report, created artifacts, cleaned University Patents folder
• 9/6 10-12 Spoke with Ed about project organization
• 9/7 2:30-4:30 Writing report
• 9/8 10-12 Making data into time series: gyear, make tables and charts

Spring 2017

1/10/2017-1/20/2017 Finished Accelerator Seed List (Data)

1/23/2017 Working on blog settings, images for the slider, published Patents and the Cancer Moonshot: How Subject Matter Eligibility Affects Research

2/6/2017 Began proposal on Berkeley/Broad (Harvard+MIT) CRISPR patent dispute

2/13/2017 Working on University Patents, Lit Reviews, determining how to identify patents in database

2/16/2017-2/17/2017 Worked on Working with Wordpress, determined best practices for photo dimensions, created wiki image for the slider, received list of patent assignees from Marcela (in University Patents folder of RDP)

2/20/2017 Working on University Patents, figuring out misspellings within patent data

3/29/2017 Matched ~46,000 entries, working on the ~90,000 that didn't match

4/5/2017 Matched ~128,000 entries, working on the ~6,000 that didn't match

4/10-4/28/2017 Joining information, working on issue brief

Fall 2016

08/31/2016 3:00-5:00 Set up work log, looked through new wiki and blog, categorized pages

09/02/2016 1:00-4:00 Categorized and reorganized pages

09/07/2016 1:00-3:00, 4:00-5:00 Worked on classification systems for blog posts, reports, and other pages, brainstormed event/project proposal ideas

09/09/2016 1:00-4:30 Examined healthcare innovation and M&As, looked at social entrepreneurship, researched/brainstormed blog post ideas

09/12/2016 1:00-3:00, 3:45-4:45 Read Kauffman reports on immigration and entrepreneurship, looked at new Annual Survey of Entrepreneurs and census data

09/14/2016 1:00-4:30 Researched U.S. government programs that promote entrepreneurship (domestic and foreign), began drafting blog post on Rice entrepreneurial ecosystem

09/19/2016 1:00-4:30 Finished first draft of blog post on Entrepreneurship at Rice in 2016, began researching US and women's role in social entrepreneurship for Women in Innovation and Entrepreneurship: 3rd in Blog Series

09/21/2016 1:00-4:30 Continued Women in Innovation and Entrepreneurship: 3rd in Blog Series, drafted two political cartoons

09/23/2016 1:00-5:00 Finished political cartoon

09/26/2016 1:00-4:00 Helped reorganize blog, added a couple of posts, edited Trump and Entrepreneurship

09/28/2016 12:30-4:00 Drafted Women in Innovation and Entrepreneurship: 3rd in Blog Series

09/30/2016 1:00-5:00 Researched SXSL, brainstormed blog post ideas for SXSL, regressed Trump poll numbers and DOW average for blog post

10/03/2016 1:00-5:15 Small Business Development Ecosystem of Houston

10/05/2016 1:00-4:00 Small Business Development Ecosystem of Houston

10/06/2016 5:00-6:30, 9:30-12:00 Graphics for Small Business Development Ecosystem of Houston

10/10/2016 1:00-4:00 Proposed new blog post, edited "A Conversation with Bob McNair" [1]

10/11/2016 1:00-4:00 Worked on slider for website, Drafted South by South Lawn

10/12/2016 3:00-5:00 Blog posts, slider graphics

10/14/2016 1:00-4:00 Uploaded graphics for Small Business Development Ecosystem of Houston, edited South by South Lawn

10/17/2016 1:00-5:00 Edited South by South Lawn, began research on Cancer Moonshot patent data visualization, tweaks to Small Business Development Ecosystem of Houston

10/19/2016 1:00-4:30 Final-ish edits to Small Business Development Ecosystem of Houston

10/21/2016 1:00-4:00 Tweaks to South by South Lawn, meeting with bloggers

10/24/2016 1:00-2:00, 2:30-5:00 Tweaks to South by South Lawn, reorganization of wiki and Guide to Small Business

10/26/2016 1:45-4:45 Graphics for blog, South by South Lawn

10/28/2016 1:00-4:00 Caricatures, South by South Lawn, Weekly Roundup posts

10/31/2016 1:15-2:45 South by South Lawn

11/2/2016 1:30-5:30 Entrepreneurship at Rice, graphics for Small Business Guide and blog

11/4/2016 1:30-4:00 Entrepreneurship at Rice, graphics for Small Business Guide

11/7/2016 1:00-5:00 Entrepreneurship at Rice, edited Dylan's Business Dynamism in High-Tech, proposed Cancer Moonshot: Patent Eligibility & Cancer IP

11/9/2016 1:00-4:00 South by South Lawn, Entrepreneurship at Rice

11/11/2016 1:00-4:00 edited Tay's post, cancer patenting

11/14/2016 1:00-4:30 Reviewed blog posts

11/16/2016 1:00-5:00 Reviewed cancer patenting with Ed, added information about Lilie to wiki, blog posts

11/18/2016 12:20-2:50 Obama and Innovation, Entrepreneurship at Rice

11/21/2016 1:00-4:30 Emailed Dr. Larson interview questions (unable to meet in person), edited Eliza's DC post, edited Obama and Innovation, sent Patents and the Cancer Moonshot: How Subject Matter Eligibility Affects Research

11/28/2016 1:00-5:00 Re-emailed Dr. Larson, edited Obama in the White House, edited Patents and the Cancer Moonshot, regex tutorial by Ed

11/30/2016 12:30-3:00, 3:45-5:30 Accelerators

12/2/2016 1:00-5:00 Accelerators, Patents and the Cancer Moonshot: How Subject Matter Eligibility Affects Research, South by South Lawn, Entrepreneurship at Rice in 2016 are all in Wordpress