Statistics

WordPress 102 CMS 100 (should include all, in theory but does not) Joomla 11 Drupal 8 Magento 11 Occurence of the word x in reports at Office365 @BAAA (visited: Oct. 10th 2016) Take these numbers with a grain of salt. As far as I can see the system counts the occurrence of the word –… Continue reading Statistics

Trello and Google Docs

Tomboy is not the best project manager on earth. I decided to use Trello as my kanban. It’s very basic: Backlog Doing Wait Done Since you can link from Trello to Google Docs I made online versions of the project description and a sheet for the overall plan.

Ad URL field
Ad URL field to lit_noter

I found out that a URL field would be nice. So here’s the new and improved research database schema. During research I often meet online sources. In this way they are stored in one place.

Originally the database was an implementation of the “Liza Matrix” (named after Dr. Liza Castro’s talk on literature reviews). The original matrix was suited for a spreadsheet. But spreadsheets are not suited for notes.

I’ll name the fork “Per’s Review Schema“. Perhaps a timestamp would come in handy in the lit_noter table. That would open up for “visited the xxxx-xx-xx” type of output.

A JOIN of all rows was added. So the database is ready for queries.

select `litrev`.`lit_id` AS `lit_id`,`litrev`.`titel` AS `titel`,`litrev`.`forfatter` AS `forfatter`,`litrev`.`tidsskrift` AS `tidsskrift`,`litrev`.`udgiver` AS `udgiver`,`litrev`.`anno` AS `anno`,`litrev`.`researchsp` AS `researchsp`,`litrev`.`teorigrundlag` AS `teorigrundlag`,`litrev`.`metode` AS `metode`,`litrev`.`relevans` AS `relevans`,`litrev`.`anbefalinger` AS `anbefalinger`,`litrev`.`konklusion` AS `konklusion`,`litrev`.`url_projekt` AS `url_projekt`,`litrev`.`when` AS `when`,`lit_noter`.`lit_noter_id` AS `lit_noter_id`,`lit_noter`.`litrev_id` AS `litrev_id`,`lit_noter`.`side` AS `side`,`lit_noter`.`notat` AS `notat` from (`litrev` left join `lit_noter` on((`litrev`.`lit_id` = `lit_noter`.`litrev_id`)))

Cases ticking in

Read three reports today- I’m using the database for notes on cases. I wish access to more cases. On the other hand the literature review is somewhat time consuming. After 10 – 15 cases I guess that I’ll get the overall picture. Since I’m looking for qualitative rather than quantitative data it’s kinda ok-ish.