Data Entry Procedures - Revision history

Jcora at 17:39, 17 September 2014

2014-09-17T17:39:37Z

Jcora at 19:22, 1 June 2011

2011-06-01T19:22:22Z

Jcora at 19:13, 1 June 2011

2011-06-01T19:13:43Z

Jcora at 20:51, 17 May 2011

2011-05-17T20:51:55Z

Jcora at 20:50, 17 May 2011

2011-05-17T20:50:18Z

Jcora at 20:48, 17 May 2011

2011-05-17T20:48:49Z

Jcora: Created page with "'''Introduction''' This section contains information on the practices for transcribing specimen data from specimens for the Ohio State University Fish Division (OSUM). The gener..."

2011-05-17T20:47:22Z

Created page with "'''Introduction''' This section contains information on the practices for transcribing specimen data from specimens for the Ohio State University Fish Division (OSUM). The gener..."

Jcora at 07:52, 1 March 2004

2004-03-01T07:52:52Z

Jcora at 06:03, 1 March 2004

2004-03-01T06:03:49Z

Jcora at 12:19, 29 February 2004

2004-02-29T12:19:02Z

@@ Line 6: / Line 6: @@
 === General ===
 The information presented in this subsection is related to conventions that used after the initial data entry process. During the data processing stage of the data entry pipeline, adhere to the following conventions regarding the formatting of column specific information.
 === Main Worksheet Column-specific Notes ===
@@ Line 29: / Line 47: @@
 |comments
 |Comments associated with a locality including the drainage and any additional information
-|When a drainage is specified, place the text ''Drainage: '' with a space after the colon followed by the drainage information. If additional comments for a locality are needed, separate the drainage information from addition comments by a semicolon (;). If a drainage is unknown, DO NOT use the drainage text within the comments. All fish localities must include the text ''Locality: Fish'' at the end of the comments.
+|When a drainage is specified, place the text ''Drainage: '' with a space after the colon followed by the drainage information. If additional comments for a locality are needed, separate the drainage information from addition comments by a semicolon (;) then a space ( ). If a drainage is unknown, DO NOT use the drainage text within the comments. All fish localities must include the text ''Locality: Fish'' at the end of the comments.
 |''Drainage: Wabash River-Ohio River; Locality: Fish''; ''Drainage: Lake Erie; Locality: Fish''
 |}
 == Resources ==
-* Specimen Data Template: [[File:Data_Entry_Template_20-Feb-2007.xls]]
+* Specimen Data Template: [[File:Data_Entry_Template_28-Aug-2014.xls]]
 * [[Data Transcription Procedures#Data Entry Template Information|Data Entry Template Information]]
 [[Category:Fish]][[Category:Data Entry Assistant]]

@@ Line 7: / Line 7: @@
 The information presented in this subsection is related to conventions that used after the initial data entry process. During the data processing stage of the data entry pipeline, adhere to the following conventions regarding the formatting of column specific information.
-=== Column-specific Notes ===
+=== Main Worksheet Column-specific Notes ===
 {|
 !Column Name
@@ Line 18: / Line 18: @@
 |Separate multiple collecting methods for a single record with a forward slash (/) without any spaces between the methods. The number of seines, traps, etc. used should be omitted, but use the dimensions of the method with a space separating the elements. DO NOT ABBREVIATE. Also when a size of seine, etc. is used, order the methods from the smallest to largest.
 |''4' x 8' seine/20' bag seine''; ''4' x 20' 1/4" square mesh bag seine''
 |}

← Older revision		Revision as of 19:13, 1 June 2011
Line 3:		Line 3:
	This section contains information on the practices for transcribing specimen data from specimens and preparing the specimen data for database entry for the Ohio State University Fish Division (OSUM). The general procedures for transcribing data are found at [[Data Transcription Procedures]], although the focus of this document is mainly on insect specimens. Below are derivations from the OSUC data entry protocol adapted to OSUM-specific data entry needs.		This section contains information on the practices for transcribing specimen data from specimens and preparing the specimen data for database entry for the Ohio State University Fish Division (OSUM). The general procedures for transcribing data are found at [[Data Transcription Procedures]], although the focus of this document is mainly on insect specimens. Below are derivations from the OSUC data entry protocol adapted to OSUM-specific data entry needs.

		+	== Data Processing Notes ==
		+	=== General ===
		+	The information presented in this subsection is related to conventions that used after the initial data entry process. During the data processing stage of the data entry pipeline, adhere to the following conventions regarding the formatting of column specific information.
		+
		+	=== Column-specific Notes ===
		+	{\|
		+	!Column Name
		+	!Description
		+	!Convention
		+	!Example
		+	\|-
		+	\|coll_method
		+	\|Collecting method, technique, or tool used to collect the specimen(s)
		+	\|Separate multiple collecting methods for a single record with a forward slash (/) without any spaces between the methods. The number of seines, traps, etc. used should be omitted, but use the dimensions of the method with a space separating the elements. DO NOT ABBREVIATE. Also when a size of seine, etc. is used, order the methods from the smallest to largest.
		+	\|''4' x 8' seine/20' bag seine''; ''4' x 20' 1/4" square mesh bag seine''
		+	\|}

	== Resources ==		== Resources ==

← Older revision		Revision as of 20:51, 17 May 2011
Line 1:		Line 1:
	'''Introduction'''		'''Introduction'''

−	This section contains information on the practices for transcribing specimen data from specimens for the Ohio State University Fish Division (OSUM). The general procedures for transcribing data are found at [[Data Transcription Procedures]], although the focus of this document is mainly on insect specimens. Below are derivations from the OSUC protocol adapted to OSUM data entry needs.	+	This section contains information on the practices for transcribing specimen data from specimens and preparing the specimen data for database entry for the Ohio State University Fish Division (OSUM). The general procedures for transcribing data are found at [[Data Transcription Procedures]], although the focus of this document is mainly on insect specimens. Below are derivations from the OSUC data entry protocol adapted to OSUM-specific data entry needs.

← Older revision		Revision as of 20:50, 17 May 2011
Line 1:		Line 1:
	'''Introduction'''		'''Introduction'''

−	This section contains information on the practices for transcribing specimen data from specimens for the Ohio State University Fish Division (OSUM). The general procedures for transcribing data are found at [[Data Transcription Procedures]], ~~but~~ the focus of this document is mainly on insect specimens. Below are derivations from the OSUC protocol adapted to OSUM data entry needs.	+	This section contains information on the practices for transcribing specimen data from specimens for the Ohio State University Fish Division (OSUM). The general procedures for transcribing data are found at [[Data Transcription Procedures]], although the focus of this document is mainly on insect specimens. Below are derivations from the OSUC protocol adapted to OSUM data entry needs.

@@ Line 1: / Line 1: @@
 '''Introduction'''
-This section contains information on the practices for transcribing specimen data from specimens and preparing the specimen data for database entry for the Ohio State University Fish Division (OSUM). The general procedures for transcribing data are found at [[Data Transcription Procedures]], although the focus of this document is mainly on insect specimens. Below are derivations from the OSUC data entry protocol adapted to OSUM-specific data entry needs.
+This section contains information on the practices for transcribing specimen data from specimens for the Ohio State University Fish Division (OSUM). The general procedures for transcribing data are found at [[Data Transcription Procedures]], but the focus of this document is mainly on insect specimens. Below are derivations from the OSUC protocol adapted to OSUM data entry needs.
 == Resources ==
 * Specimen Data Template: [[File:Data_Entry_Template_20-Feb-2007.xls]]
-* [[Data Transcription Procedures#Data Entry Template Information|Data Entry Template Information]]
+* [[Data Transcription Procedures#Data Entry Template Information]]
-[[Category:Fish]][[Category:Data Entry Assistant]]
+[[Category:Fish|Data Entry Assistant]]

← Older revision		Revision as of 07:52, 1 March 2004
Line 117:		Line 117:
	=== Determination Comments (text1) ===		=== Determination Comments (text1) ===
	Addition comments related to a determination of a specimen or lot. Used in the form: ''det_comments:[text]'' where ''[text]'' are the determination comments. Example: '''''det_comments:INHS 78678'''''		Addition comments related to a determination of a specimen or lot. Used in the form: ''det_comments:[text]'' where ''[text]'' are the determination comments. Example: '''''det_comments:INHS 78678'''''
		+
		+	=== Preparation (preparationmethod) ===
		+	The preparation used to house the specimen or lot. Used in the form: ''preparation:[text]'' where ''[text]'' is one of the normalized [[#Preparation Codes\|preparation methods]]. Example: '''''preparation:alc'''''

@@ Line 47: / Line 47: @@
 |comments
 |Comments associated with a locality including the drainage and any additional information
-|When a drainage is specified, place the text ''Drainage: '' with a space after the colon followed by the drainage information. If additional comments for a locality are needed, separate the drainage information from addition comments by a semicolon (;). If a drainage is unknown, DO NOT use the drainage text within the comments. All fish localities must include the text ''Locality: Fish'' at the end of the comments.
+|When a drainage is specified, place the text ''Drainage: '' with a space after the colon followed by the drainage information. If additional comments for a locality are needed, separate the drainage information from addition comments by a semicolon (;) then a space ( ). If a drainage is unknown, DO NOT use the drainage text within the comments. All fish localities must include the text ''Locality: Fish'' at the end of the comments.
 |''Drainage: Wabash River-Ohio River; Locality: Fish''; ''Drainage: Lake Erie; Locality: Fish''
 |}
@@ Line 102: / Line 102: @@
 === Accession Number (number) ===
 The accession number associated with a specimen or lot. Used in the form: ''accession_number:[text]'' where ''[text]'' is the accession number. Example: '''''accession_number:1987:V:11'''''
 === Determination Comments (text1) ===
-Addition comments related to a determination od a specimen or lot. Used in the form: ''det_comments:[text]'' where ''[text]'' are the determination comments. Example: '''''det_comments:INHS 78678'''''
+Addition comments related to a determination of a specimen or lot. Used in the form: ''det_comments:[text]'' where ''[text]'' are the determination comments. Example: '''''det_comments:INHS 78678'''''

@@ Line 97: / Line 97: @@
 The comments column is a dump for any additional information related to a specimen or lot. Although the information currently does not have a discreet home in the database, some bits of information added to the comments should follow a formatting convention. All "marked up" elements, those defined below, should be present after any general comments (i.e. condition of specimen, status of storage container, etc.) and separated by a semicolon (;).
-=== Modifiers ===
+=== Modifier (modifier) ===
-Addition IDs (not actually sure) associated with a specimen or lot. Used in the form: '''''modifier:[text]''''' where ''[text]'' is the modifying text. Example: '''''modifier:INHS 78678'''''
+Addition IDs (not actually sure) associated with a specimen or lot. Used in the form: ''modifier:[text]'' where ''[text]'' is the modifying text. Example: '''''modifier:INHS 78678'''''
 == Resources ==