- Seth Kurke
- Jul 28, 2020
- 2 min read

My second deliverable was completed this week, and it is the first series of metadata of my own creation. For the "Historical Materials" section, I had three different tabs in my spreadsheet because each series of resources had specific metadata different from the other resources in its section. While the "Indian Wars" and "Civil War" subpages had little material, by the time I reached World War 2, there was a vast expanse of documentation that posed unique challenges. Sometimes this made the going a bit slow, but never boring. If one is to use this material for research, as a primary resource there is much to delve into. This is especially true if one is interested in the trials of war criminals from Nazi Germany or the Japanese empire.
One of the greater challenges with some of the materials is that there wasn't a truly definitive writer or publisher. Sometimes it was a just an organization responsible for the report. I would use the name of this organization as the contributor/writer AND publisher. Also, one of the pieces of metadata I used for this section was "Dates". This is because often there were multiple dates within a resource that played an important role. The same could be said for "Locations Mentioned." For example, if there is a document about a massacre during World War 2 and a subsequent trial, the location of the massacre and the trial are both important, so they were each given weight as an article of metadata. All in all, I spent a lot of time browsing documents looking for keywords that would be relevant to use. For me, that has been an approach where quality data input supersedes quantity of resources added into the spreadsheet.
With four weeks to go, I am in a solid position to continue to sharpen my skills with Microsoft Excel. However, now that this deliverable is finished, I am going to broaden my scope and work with OpenRefine. The reason for this is because it never hurts to have another tool in your bag to work with, or in artist parlance, the broader the color palette the more shades you have to paint a picture. Stay tuned for next week as I will talk about my experience with a new program!