Blog post 5: Metadata spreadsheet

First, download and open this spreadsheet. You’ve already created catalog records for your three artifacts, so you should have the information that you need in order to fill this out. However, now, for some of the fields, you will need to use controlled vocabularies and include identifiers:

  • Enter the full Title in column B.
  • For “Creator” and “Contributor”, look them up in the Library of Congress Name Authority File. Enter them into columns C and E of the spreadsheet as they appear in the Name Authority File. If names do not appear in the Name Authority File, enter the names in Last, First format. If there is no contributor, leave columns E and F blank.
  • For “Creator identifier” and “Contributor identifier” (columns D and F), enter the identifier as it appears in the Name Authority File. If names do not appear in the Name Authority File, leave the columns blank.
  • Enter “Date” in column G in DD-MM-YYYY or YYYY format.
  • For “Coverage”, look up the place where your artifact is from in the Getty Thesaurus of Geographic Names. If the place you are looking for does not appear, you might need to think of a different geographic location (for example, chose a country instead of a city, etc.). Enter the place into column H as it appears in the Getty Thesaurus.
  • For “Coverage identifier” (column I), enter the identifier as it appears in the Getty Thesaurus.
  • For “Subject”, look up the subject in the Library of Congress Subject Headings. If the subject that you are looking for does not appear, then it may not be in the controlled vocabulary. Think of a different subject term and keep searching until you find one that the Library of Congress has in its Subject Headings. Enter that subject in column J.
  • Enter the Subject identifier in column K.
  • Enter the Description in column L.
  • Enter the Publisher in column M.
  • For “Language”, look up the ISO-369-3 codes for the language of your artifact. It should be three letters. Enter that three letter code into column N.
  • For “Type”, look up the DCMI Type that fits your artifact and enter that in column O. Note: this is a very limited vocabulary, with only nine options, so you probably won’t find what you are expecting. Pick the most appropriate option of the ones that are there.
  • For “Format”, look up the file format in this list of Internet Media Types. If you do not know the file format, make your best guess. Enter that file format in column P.
  • For “Format reference” (column Q), enter the reference for the file format in the list of Internet Media Types.
  • For “Rights” (column R), enter the complete rights statement, including the URI.

After you’ve filled out the spreadsheet, create a new blog post and upload the spreadsheet to that blog post. It should appear as a link that I can then download.

Then write one short paragraph (3-5 sentences) describing a challenge that you had or an interpretive decision you had to make while filling out this spreadsheet. For example, were you able to find the creator or the subject terms that you wanted to use in the controlled vocabularies? If not, why not? And what do you think that means?

To earn credit for this assignment, the spreadsheet should be filled out as accurately and completely as possible, and the paragraph description should demonstrate some understanding of the uses and limitations of controlled vocabularies.