Carlin Cherry1 (Work Log)

Carlin Cherry Work Logs (log page)

041316 (Wed) 1:00: upload titles table to psql. join tables. reevaluate for how to proceed.

041316 (Wed) 3:00:

041116 (Mon) 1:00: play with data tables. We have a working table for total percentage of women, so now do it by state, city, round no. Try to get some solidified results that I can use in the research report. Management meeting @4.

041116 (Mon) 4:30: computer died. left early. need to upload table, join

040816 (Fri) 12:30: reformat tables w new data pulled

040816 (Fri) 3:00: IT WORKS! next steps are to refine data. need: to group by year by percent women CEO's? (although total percentage of women is already minuscule, so I'm not sure how revealing it would be to further group by jobtitle), still have the doctor subset of the data problem. figure out any other things we might want to discover (group by state? city? no rounds?)

040616 (Wed) 1:00: continue w lit review (1.5 hours), one last go at getting commonnames to properly work (1 hour), w remaining time work on either manually assigning womanman variable to names or proceed with data analysis if by some miracle the commonnames thing works.

040616 (Wed) 5:00: lit review, one last go at common names, prepped to join tables before realizing that neither of them had founding dates. repulled data from SDC, ran perl script on it. Friday, start with reformatting tables with new data pulled.

040416 (Mon) 1:00: clean up commonnames data sheet and get that thing up and running correctly! do some work on lit review since i was gone on Friday. management meeting at 4.

left from 2:30-3 for a meeting

040416 (Mon) 5:00:commonnames is still giving us issues. might go through manually on some of them, otherwise discount drs data??

033016 (Wed) 1:00: do a lot of work focusing on the subset of women data dealing w doctors

033016 (Wed) 5:00: did the work but conclusion is that we need to clean up the data sheet - script should be working fine, data is screwy

032816 (Mon) 1:00: sql database stuff (with lit review if i get stuck on databases) plus management meeting at 4

032816 (Mon) 5:00: made mr/mrs tables in sql, resolidified some of the data management

032516 (Fri) 1:00: met w ed for lit reviews, new best practice is going to be doing lit reviews on fridays/ when i don't have comp sci people to help with databases, and doing the data crunching mon/wed/when i have rachel and comp sci.

032516 (Fri) 3:00: worked on lit review list -- only compiled, no analysis yet.

032316 (Wed) 1:00: more database stuff w rachel and ed

032316 (Wed) 5:30: done

032116 (Mon) 1:00: database stuff, management meeting

032116 (Mon) 5:00: done

031816 (Fri) 1:00: meet with rachel and hopefully ed to figure out how to code in SQL

031816 (Fri) 2:00: done

031616 (Wed) 1:00: continue article

031616 (Wed) 2:00: I need to learn SQL coding to make graphs / interpret data before any more substantial progress on the article can be made. Learning to do this on Friday will help.

031416 (Mon) 1:00: sdc pulls with rachel, continue article, management meeting

031416 (Mon) 4:30: all of the above

031116 (Fri) 1:00: continue women article

031116 (Fri) 3:00: set up RDP and mapping software. 1.5 meeting with team. ended with a little research on women article.

030916 (Wed) 1:00: develop women article outline, set first draft goal, continue work

030916 (Wed) 5:00: continued researching article, did SDC platnium pull with Rachel. goal is to be finished with project in 2 weeks.

030716 (Mon) 1:00: post spring break reacquaintance with projects, continue researching environmental impact on small business as part of the larger article on regulation affecting small business, management meeting

030716 (Mon) 5:00: handed off regulation project to pedro, jason, meghana. Starting new issue brief on women in entrepreneurship. had meeting

022416 (Wed) 12:00: finish article, check in w other teams to see how they're progressing

022416 (Wed) 4:00: finished [Business Dynamism in High Tech], watched Rachel do VC data, now researching environmental impact on small business as part of larger article on regulation affecting small business

022216 (Mon) 1:00: write body paragraphs of Business Dynamism article, if Rachel does VC watch/learn from her, management meeting at 3 or 4

022216 (Mon) 4:53: wrote intro, outline, first pp of article, management meeting 3:30-4:40, met w team to get project updates

021916 (Fri) 12:30: continue to research Business Dynamism in High Tech. Meet with Pedro and Jason to see which projects are yielding interesting results.

021916 (Fri) 2:58: worked on short article about business dynamism, hopefully finish in 1 week. hop on with Jason and Pedro researching candidates/regulation after finishing business dynamism article. met w Pedro and Jason for gameplan, met w Rachel and Ed for VC.

021716 (Wed) 12:54: ed's presentation = done. move on to either cultivator article, SBA, or pres candidate-specific research. meet w ed to discuss (since skipped management meeting on Mon, can we hold today?)

021716 (Wed) 2:50-3:30: had to leave for meeting

021716 (Wed) 3:30-5:00: met w Pedro, Jason, Ed and decided how to proceed. I will be researching Business Dynamism in High Tech. Goal is to churn out academic paper or news article from either my, pedro, or jason's research.

021616 (Tues) 1:07: help ed with presentation prep

021616 (Tues) 2:19: wrote RTF doc with relevant slide background information

021516 (Mon) 12:52: meet w Ed's presentation team to crystallize research, I am taking over Julia's portion (market for ideas) because she's not here until Wednesday, management meeting. quick note: glitch happened with my log page and somehow linked it to Ramee's, so "Carlin Cherry1" is my new log page.

021516 (Mon) 4:53: team ed presentation met with ed to discuss presentation, reformatted presentation and ideas (quotes wiki page, etc) but presentation itself still needs a lot of work - will probably be passed off to Rachel and Claudio to finish tomorrow afternoon