Data Transcription Procedures

Introduction

This section contains information on the practices for transcribing specimen data from specimens into a Microsoft Excel worksheet using the data entry template (File:Data Entry Template 20-Feb-2007.xls).

Procedures

Sort Specimens

Sort the specimens by collecting event (Locality, Date, Collecting Method, Collectors) for a taxon (scientific group). Do not mix up the taxa. If the specimen labels appear to be entirely heterogeneous, this step may be skipped.

Barcode Specimens

Apply the unique identifier (barcode) to the bottom of the specimen careful to avoid the encoded barcode area of the media. Some pins will have a blunted tip making it difficult to penetrate the barcode media. In this case, use a loose pin with a sharp tip to carefully pierce but not fully penetrate the media. The slight piercing of the barcode media will avoid potential "spinning" of the label in the future.

If you come upon a misprinted barcode whether it be the encoded part being smudged or a digit being unreadable, do not use! The barcode is used to uniquely identify the specimen unambiguously. If the barcode number is not correct, the reference in the database for that specimen will not be correct, thus causing a number of serious problems if not rectified quickly. Copying the correct barcode number is extremely important!

Save New File

Open the data entry template and save the file according to this standard: [most specific taxonomic name for all specimens in drawer]_[collection or location that the specimens belong to; empty if OSUC specimens]_[the date for today].xls

Examples:

• Scelio_AEIC_22-Mar-2007.xls
• Misc_Scelionidae_Colombia_17-Feb-2007.xls
• Misc_Coleoptera_06-Apr-2007.xls

Each drawer or box of specimens should be entered in a single file. Do not overwrite the data entry template file and always begin from the data entry template.

Transcribe Data

Transcribe the specimen labels into the Raw Data worksheet of the spreadsheet. Each label of the specimen will correspond to the numbered label columns in the worksheet with the top-most label being label1. Copy all of the label data as is including any misspellings, incorrect information, or apparently extraneous characters. The goal of transcribing specimen labels is to have as close to an electronic reproduction of the labels as possible. Any additional information about the specimen that does not have its own column such as condition, preservation medium, etc. should be added into the comments column. Any supplementary specimen identification information should also be included in the comments columns to avoid the loss of any useful information.

Any of the columns that are not needed for transcription (i.e. type, life_status, etc.) can be removed with a few exceptions, but new columns cannot be added. If a column is inadvertently removed, the removed column can be re-added but must bear the exact same column name. Reference the data entry template for the original column names. A few columns are required to be present within a data entry spreadsheet: date, name, comments, at least one identification column, and all of the label columns. Do not remove these columns.

Specimen Container Marking

When transcription of all specimens is completed, place a Post-it Note or another form of adhered stationery on the finished drawer or box. Finding a specimen post-transcription is far easier when the specimen container is marked after specimen transcription. There will always be transcription mistakes, so finding offending specimens quickly and easily is essential.

Mark the specimen container in the following format:

Into Excel: [date finished]

By: [your name]

Filename: [data entry filename]

Example:

Into Excel: 18-Apr-2007

By: Joe

Filename: Misc_Scelionidae_USNM_15-Apr-2007.xls