{"id":264,"date":"2022-03-12T14:46:47","date_gmt":"2022-03-12T22:46:47","guid":{"rendered":"https:\/\/conniedavis.ca\/home\/?p=264"},"modified":"2025-01-02T12:46:52","modified_gmt":"2025-01-02T20:46:52","slug":"that-new-project-feeling","status":"publish","type":"post","link":"https:\/\/conniedavis.ca\/home\/that-new-project-feeling\/","title":{"rendered":"That new project feeling"},"content":{"rendered":"\n<p>Every new project has a honeymoon period. There&#8217;s the anticipation of what might be discovered and the pleasure of setting up the project so that the research proceeds smoothly.  Here&#8217;s a glimpse into my project set-up process.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Research Log<\/h2>\n\n\n\n<p>A little over a year ago I started using <a href=\"https:\/\/airtable.com\/\">Airtable<\/a> as my research log. I have enough understanding of programming to be dangerous. I even took a class in Fortran in college and I learned how to use Microsoft Access when I worked in a health services research setting. I love relational databases even more than I love spreadsheets. Airtable is a &#8220;spreadsheet-database hybrid with features of a database but applied to a spreadsheet&#8221; according to <a rel=\"noreferrer noopener\" href=\"https:\/\/en.wikipedia.org\/wiki\/Airtable\" target=\"_blank\">Wikipedia<\/a>. Nicole Dyer of Research Like a Pro (RLP) with <a rel=\"noreferrer noopener\" href=\"https:\/\/familylocket.com\/\" target=\"_blank\">FamilyLocket<\/a> has shared terrific bases (templates) in the Airtable Universe. I developed my own adaptations to Nicole&#8217;s <a rel=\"noreferrer noopener\" href=\"https:\/\/www.airtable.com\/universe\/expavk53jZXsM49bx\/rlp-with-dna-multiple-testers\" target=\"_blank\">RLP with DNA Multiple Testers Base<\/a>. <\/p>\n\n\n\n<p>Below is a screenshot of the documentary research log I use based on Nicole&#8217;s template. I&#8217;ve grouped this log by surname (4th column), then sorted it by date of event (3rd column) then locality (5th column). Dates are written in YYYY-MM-DD format to sort the records (rows) by a field (column).  Place names begin with the two-digit state abbreviation, followed by county,  and town. This arrangement also supports sorting without creating multiple fields to sort. And if you are looking at column 8, yes, I do create the citations when I first look at the document. I have a citation template (also in Airtable).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"448\" src=\"https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.08.30-PM-1024x448.png\" alt=\"\" class=\"wp-image-266\" srcset=\"https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.08.30-PM-1024x448.png 1024w, https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.08.30-PM-300x131.png 300w, https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.08.30-PM-768x336.png 768w, https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.08.30-PM-1536x672.png 1536w, https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.08.30-PM.png 1829w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><figcaption>Documentary Research Log in AirTable<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Digital Filing<\/h2>\n\n\n\n<p>Every project has a folder on my drive which is backed up to Dropbox.  The folder organization varies by project.  The snapshot below is for my mysterious 2x-great grandmother, Mattie Childress. Each research question has a numbered file. &#8220;00-Mattie death date&#8221; and &#8220;01-Parents for Mattie&#8221; are examples. Nested within the folder are sub-folders for phases of research. &#8220;Archive&#8221; holds prior drafts and will be discarded at the end of a project. &#8220;Analysis&#8221; contains tables for census or timeline analysis. &#8220;Images&#8221; has screenshots of diagrams.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"280\" src=\"https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-1.40.54-PM-1024x280.png\" alt=\"\" class=\"wp-image-265\" srcset=\"https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-1.40.54-PM-1024x280.png 1024w, https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-1.40.54-PM-300x82.png 300w, https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-1.40.54-PM-768x210.png 768w, https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-1.40.54-PM.png 1174w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><figcaption>Digital Filing System<\/figcaption><\/figure>\n\n\n\n<p>I&#8217;ve used Google Docs and Sheets and struggle to use the filing system in Google Drive. Many people use them to good results. Using Google docs, sheets and drive allows sharing through links. I get around this by sharing Dropbox folders for large files.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Naming conventions<\/h2>\n\n\n\n<p>File names for individual items (documents, images, spreadsheets) have evolved. There are two styles I use consistently: Name of document first or date first. When I am writing a report, the name of the document is written with underscores, then the date, always in YYYY-MM-DD format. <\/p>\n\n\n\n<p>Childres_father_2022-01-31.docx<\/p>\n\n\n\n<p>For sources (scans of originals, downloaded census, birth, marriage, death, etc.) I lead with the date, followed by the last name in caps, then location and type of record. I use dashes between elements of the date in YYYY-MM-DD format. This creates an instant timeline in my folders. Locations are organized from large geographic region to small.<\/p>\n\n\n\n<p>1879-05-08_CHILDRESS_Bill_TN_Tipton_indictment_riot.jpeg<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Report template<\/h2>\n\n\n\n<p>I set up the project report using a template and &#8220;write as I go.&#8221; Writing the report while I&#8217;m working supports the analysis process and I&#8217;m not faced with a blank page at the end. When working on client projects, writing-as-I-go also helps me stay within hourly limits for a project. The template, like naming conventions, has evolved over time. I use a Microsoft Word .dotx file which includes sample paragraphs I often need (such as explaining the usages of different types of DNA tests or how autosomal DNA is used to predict relationships).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"568\" src=\"https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.20.49-PM-1024x568.png\" alt=\"\" class=\"wp-image-267\" srcset=\"https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.20.49-PM-1024x568.png 1024w, https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.20.49-PM-300x166.png 300w, https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.20.49-PM-768x426.png 768w, https:\/\/conniedavis.ca\/home\/wp-content\/uploads\/2022\/03\/Screen-Shot-2022-03-12-at-2.20.49-PM.png 1508w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><figcaption>Report template<\/figcaption><\/figure>\n\n\n\n<p>I started a new project two weeks ago and set it up as described here. I can spend a few minutes or several hours researching knowing that I can focus on the research and analysis. And I&#8217;m enjoying the honeymoon! <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Every new project has a honeymoon period. There&#8217;s the anticipation of what might be discovered and the pleasure of setting up the project so that the research proceeds smoothly. Here&#8217;s a glimpse into my project set-up process. Research Log A little over a year ago I started using Airtable as my research log. I have &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/conniedavis.ca\/home\/that-new-project-feeling\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;That new project feeling&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,5],"tags":[24,21,25],"class_list":["post-264","post","type-post","status-publish","format-standard","hentry","category-documentary-research","category-genetic-genealogy","tag-citation","tag-genealogy-foundations","tag-research-log"],"_links":{"self":[{"href":"https:\/\/conniedavis.ca\/home\/wp-json\/wp\/v2\/posts\/264","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/conniedavis.ca\/home\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/conniedavis.ca\/home\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/conniedavis.ca\/home\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/conniedavis.ca\/home\/wp-json\/wp\/v2\/comments?post=264"}],"version-history":[{"count":1,"href":"https:\/\/conniedavis.ca\/home\/wp-json\/wp\/v2\/posts\/264\/revisions"}],"predecessor-version":[{"id":268,"href":"https:\/\/conniedavis.ca\/home\/wp-json\/wp\/v2\/posts\/264\/revisions\/268"}],"wp:attachment":[{"href":"https:\/\/conniedavis.ca\/home\/wp-json\/wp\/v2\/media?parent=264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/conniedavis.ca\/home\/wp-json\/wp\/v2\/categories?post=264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/conniedavis.ca\/home\/wp-json\/wp\/v2\/tags?post=264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}