Inputting Data into WordSurv - Revision history

Admin at 01:27, 13 July 2011

2011-07-13T01:27:11Z

Admin at 00:10, 30 June 2011

2011-06-30T00:10:03Z

Admin at 00:07, 30 June 2011

2011-06-30T00:07:14Z

John Carter at 06:46, 27 June 2011

2011-06-27T06:46:47Z

John Carter at 06:42, 27 June 2011

2011-06-27T06:42:26Z

John Carter at 06:41, 27 June 2011

2011-06-27T06:41:30Z

John Carter at 06:38, 27 June 2011

2011-06-27T06:38:11Z

John Carter at 06:31, 27 June 2011

2011-06-27T06:31:52Z

John Carter at 06:20, 27 June 2011

2011-06-27T06:20:57Z

John Carter at 06:11, 27 June 2011

2011-06-27T06:11:19Z

@@ Line 72: / Line 72: @@
 )	You are now ready to begin [[Comparing Word Lists|comparing your word lists]]! Note that sometimes you have to reselect your desired comparison from the drop-down box under ‘Comparison Information’ to get it to appear. Be sure to double-check that your sort order is CreationDate.
 Here’s what it looks like (Figure 11). Happy comparing!
-[[Category:Methodology]]
+[[Category:Word_Lists]]

← Older revision		Revision as of 00:10, 30 June 2011
Line 72:		Line 72:
	15) You are now ready to begin [[Comparing Word Lists\|comparing your word lists]]! Note that sometimes you have to reselect your desired comparison from the drop-down box under ‘Comparison Information’ to get it to appear. Be sure to double-check that your sort order is CreationDate.		15) You are now ready to begin [[Comparing Word Lists\|comparing your word lists]]! Note that sometimes you have to reselect your desired comparison from the drop-down box under ‘Comparison Information’ to get it to appear. Be sure to double-check that your sort order is CreationDate.
	Here’s what it looks like (Figure 11). Happy comparing!		Here’s what it looks like (Figure 11). Happy comparing!
		+	[[Category:Methodology]]

@@ Line 1: / Line 1: @@
 [[Image:WS6-1.jpg|thumb|Figure 1. Create New Survey]]
-*Note: It is important to complete each step of lexicostatistical comparison completely before moving on to the next. This applies to the steps detailed below as well as the greater process.
+*Note: It is important to complete each step of [[lexicostatistics|lexicostatistical]] comparison completely before moving on to the next. This applies to the steps detailed below as well as the greater process.
 [[Image:WS6-2.jpg|thumb|Figure 2. Create New Variety]]
 [[Image:WS6-3.jpg|thumb|Figure 3. Import Gloss Dictionary]]
-Before entering your word lists into WordSurv (WS6), be sure your data has been edited according to your chosen methodology and is ready for comparison (e.g. doublets removed). Each step should be done with the bigger picture in mind. When removing doublets, for example, if ‘leg’ and ‘foot’ are doublets, you don’t want to remove ‘leg’ in one variety and ‘foot’ in another.
+Before entering your word lists into [[WordSurv]] (WS6), be sure your data has been edited according to your chosen methodology and is ready for comparison (e.g. [[doublets]] removed). Each step should be done with the bigger picture in mind. When removing doublets, for example, if ‘leg’ and ‘foot’ are doublets, you don’t want to remove ‘leg’ in one [[variety]] and ‘foot’ in another.
 It is difficult to backtrack and edit the various databases you’ve created if you find you’ve done something incorrectly. Be thorough!
@@ Line 18: / Line 18: @@
 [[Image: WS6-11.jpg|thumb|Figure 11. Ready for Comparison]]
-)	Have the word lists you intend to compare readily available in Excel, perhaps all in one document. Each list should be carefully labeled to prevent mix-ups. The glosses and the number of each item should be readily apparent for the same reason.
+)	Have the word lists you intend to compare readily available in Excel, perhaps all in one document. Each list should be carefully labeled to prevent mix-ups. The [[gloss|glosses]] and the number of each item should be readily apparent for the same reason.
 )	Open WordSurv 6.0.2. Click ‘File’ and ‘New Database.’ This database will be a Microsoft Access database, and you will enter all the data you plan to compare in WS6 directly into it later in the process. Save it in a memorable location, as you will need to open it apart from WS6. New databases should be created for each survey.
@@ Line 24: / Line 24: @@
 )	Under ‘Survey’ click the ‘New’ button. A box will pop up (Figure 1); fill in the boxes to your desired level of specificity – they are for your reference. Click ‘Save.’
-)	Under ‘Variety’ click ‘New’ to create a new variety (Figure 2). Again fill in whatever details you wish. This information should be documented elsewhere, as WS6 should not function as your primary record-keeping program. Each variety you create will correspond with one of your word lists, so name them accordingly. Click ‘Save.’
+)	Under ‘Variety’ click ‘New’ to create a new variety (Figure 2). Again, fill in whatever details you wish. This information should be documented elsewhere, as WS6 should not function as your primary record-keeping program. Each variety you create will correspond with one of your [[word lists]], so name them accordingly. Click ‘Save.’
-)	Repeat step 4, entering further varieties as desired. In a recent survey, the PNG survey office compared eighteen lists without issue.
+)	Repeat step 4, entering further varieties as desired. In a recent survey in Papua New Guinea, a survey team compared eighteen lists without issue.
-)	Now you need to add your gloss dictionary. This is a Microsoft Access database with the item numbers and glosses of your branch’s word list; if you use a standard word list for all your surveys, you can use the gloss dictionary for each new comparison. Remember where you save it!
+)	Now you need to add your gloss dictionary. This is a Microsoft Access database with the item numbers and glosses of your word list; if you use a standard word list for all your surveys, you can use the gloss dictionary for each new comparison. Remember where you save it!
 *Note: If you don’t have a gloss dictionary you can use WS6 to create one. Click ‘New’ under ‘Gloss Dictionary,’ name and save it, then add entries. This surveyor hasn’t had to do this, so good luck venturing into unknown territory. Don’t forget your compass.
@@ Line 42: / Line 42: @@
 *Note: Putting it in 'CreationDate' order assumes that the gloss dictionary was created in the same order as your standard word lists, and that this is the order you intend to use to import your word lists in and to make comparisons in.
-Enter an abbreviation into the first three items in each variety to identify it (Figure 5). Be sure your abbreviations are clear so you don’t confuse them. For example, if you have Karnai and Kasu varieties, ‘KA’ is not a good choice.
+Enter an abbreviation into the first three items in each variety to identify it (Figure 5). Be sure your abbreviations are clear so you don’t confuse them. For example, if you have [http://www.ethnologue.com/show_language.asp?code=bbv Karnai] and Kasu varieties, ‘KA’ is not a good choice.
 It’s important to enter the abbreviation into more than one row – three to be safe. This acts as a check to insure that it remains in CreationDate order, instead of switching to alphabetic.
@@ Line 54: / Line 54: @@
 )	Find the Microsoft Access database (see step 2) and open it. You may have to double-click ‘WordList’ in the left-hand column. See Figure 6 for how it should look.
-)	Because your abbreviations clearly indicate which word list you wish to place in that column, you select the rows under ‘Transcription’ that you will need to put the first word list into. In PNG we have 170 items in our word list, so the end of the selected column appear like Figure 7.
+)	Because your abbreviations clearly indicate which word list you wish to place in that column, you select the rows under ‘Transcription’ that you will need to put the first word list into. In this example, there are 170 items in our word list, so the end of the selected column appears like Figure 7.
 *Note: Replace the coded boxes as well. To keep from losing your reference points in the database, you may wish to label the first item of each word list in the ‘Notes’ column. This will not appear in WS6.
@@ Line 70: / Line 70: @@
 )	Click on the ‘Comparison’ tab at the top. A box will appear for you to name and describe this comparison (Figure 10). At the bottom your survey should appear, along with each variety. Checking the box next to the survey will select all varieties; if you don’t want to compare all of them, select each individually. Click ‘Save’ (note that you must enter a name).
-)	You are now ready to begin comparing your word lists! Note that sometimes you have to reselect your desired comparison from the drop-down box under ‘Comparison Information’ to get it to appear. Be sure to double-check that your sort order is CreationDate.
+)	You are now ready to begin [[Comparing Word Lists|comparing your word lists]]! Note that sometimes you have to reselect your desired comparison from the drop-down box under ‘Comparison Information’ to get it to appear. Be sure to double-check that your sort order is CreationDate.
 Here’s what it looks like (Figure 11). Happy comparing!

@@ Line 9: / Line 9: @@
 == Part 1: Creating a Database and Adding Varieties in WordSurv ==
 )	Have the word lists you intend to compare readily available in Excel, perhaps all in one document. Each list should be carefully labeled to prevent mix-ups. The glosses and the number of each item should be readily apparent for the same reason.
@@ Line 28: / Line 36: @@
 )	You will need to add the gloss dictionary to each of the varieties you’ve created. Click on a variety under ‘Variety Explorer,’ then click ‘Add All Entries.’ Repeat this step for all the varieties. Check that the glosses have appeared in the Variety column (Figure 4).
 )	Identifying lists: this step is necessary to insure that you put your word lists into the proper rows in your Microsoft Access database, the next step. In the database it will be one long column; this step makes sure you put each word list in its proper place.
@@ Line 41: / Line 47: @@
 You will have to click into a blank box, then click ‘Commit Changes’ at the bottom. Repeat for all varieties.
 )	Exit WS6. No need to save anything; by clicking ‘Commit Changes’ you have already done so.
@@ Line 49: / Line 53: @@
 )	Find the Microsoft Access database (see step 2) and open it. You may have to double-click ‘WordList’ in the left-hand column. See Figure 6 for how it should look.
 )	Because your abbreviations clearly indicate which word list you wish to place in that column, you select the rows under ‘Transcription’ that you will need to put the first word list into. In PNG we have 170 items in our word list, so the end of the selected column appear like Figure 7.
 *Note: Replace the coded boxes as well. To keep from losing your reference points in the database, you may wish to label the first item of each word list in the ‘Notes’ column. This will not appear in WS6.
 )	Go to your Excel word list document, and select all of the items from the word list of this first variety. Copy them, return to Access, and click ‘Paste.’ It should say, ‘You are about to paste x number of record(s)’ and ask if you’re sure (Figure 8). This is a good way to check that you’ve selected the proper number of items. Click ‘Yes.’
 Repeat steps 11 and 12 for all of your varieties, making sure that you’re putting the correct word lists into the correct rows by comparing your code – and checking that it appears in the first three rows – to the name of the variety.
 )	After putting all your varieties into Access click ‘Save’ and exit Access. Open WS6 again and click on a variety; your word list should appear in the ‘Form’ column. You can cross-check with your Excel word list document that each is correct. You now have your glosses and your word lists. See Figure 9.
 *Note: WS6 will only create entries in Access for the varieties into which you’ve entered something in WS6 (e.g. the codes). If you enter nothing in WS6, it will not generate the appropriate rows in Access.
 == Part 3: Creating Comparisons ==
 )	Click on the ‘Comparison’ tab at the top. A box will appear for you to name and describe this comparison (Figure 10). At the bottom your survey should appear, along with each variety. Checking the box next to the survey will select all varieties; if you don’t want to compare all of them, select each individually. Click ‘Save’ (note that you must enter a name).
 )	You are now ready to begin comparing your word lists! Note that sometimes you have to reselect your desired comparison from the drop-down box under ‘Comparison Information’ to get it to appear. Be sure to double-check that your sort order is CreationDate.
 Here’s what it looks like (Figure 11). Happy comparing!

@@ Line 54: / Line 54: @@
 )	Because your abbreviations clearly indicate which word list you wish to place in that column, you select the rows under ‘Transcription’ that you will need to put the first word list into. In PNG we have 170 items in our word list, so the end of the selected column appear like Figure 7.
-*Note: replace the coded boxes as well. To keep from losing your reference points in the database, you may wish to label the first item of each word list in the ‘Notes’ column. This will not appear in WS6.
+*Note: Replace the coded boxes as well. To keep from losing your reference points in the database, you may wish to label the first item of each word list in the ‘Notes’ column. This will not appear in WS6.
 [[Image:WS6-7.jpg|thumb|Figure 7. Selecting Space for a Word List]]

@@ Line 22: / Line 22: @@
 )	Now you need to add your gloss dictionary. This is a Microsoft Access database with the item numbers and glosses of your branch’s word list; if you use a standard word list for all your surveys, you can use the gloss dictionary for each new comparison. Remember where you save it!
-(Note: if you don’t have a gloss dictionary you can use WS6 to create one. Click ‘New’ under ‘Gloss Dictionary,’ name and save it, then add entries. This surveyor hasn’t had to do this, so good luck venturing into unknown territory. Don’t forget your compass.)
+*Note: If you don’t have a gloss dictionary you can use WS6 to create one. Click ‘New’ under ‘Gloss Dictionary,’ name and save it, then add entries. This surveyor hasn’t had to do this, so good luck venturing into unknown territory. Don’t forget your compass.
 To add the dictionary, click on ‘File → Import → Gloss Dictionary → From WordSurv 6 Database.’ Locate your gloss dictionary database, and enter a name for it. Click ‘Begin Import’ (Figure 3).
@@ Line 34: / Line 34: @@
 At the bottom of the Variety column is a ‘Sort’ drop-box. Switch this to ‘CreationDate’ (Figure 4). The glosses in the Variety column must be in the same order as the word lists you plan to enter for comparison.
-(Note: Putting it in 'CreationDate' order assumes that the gloss dictioray was created in the same order as your standard word lists, and that this is the order you intend to use to import your word lists in and to make comparisons in.)
+*Note: Putting it in 'CreationDate' order assumes that the gloss dictioray was created in the same order as your standard word lists, and that this is the order you intend to use to import your word lists in and to make comparisons in.
 Enter an abbreviation into the first three items in each variety to identify it (Figure 5). Be sure your abbreviations are clear so you don’t confuse them. For example, if you have Karnai and Kasu varieties, ‘KA’ is not a good choice.
-Note that it’s important to enter the abbreviation into more than one row – three to be safe. This acts as a check to insure that it remains in CreationDate order, instead of switching to alphabetic.
+It’s important to enter the abbreviation into more than one row – three to be safe. This acts as a check to insure that it remains in CreationDate order, instead of switching to alphabetic.
 You will have to click into a blank box, then click ‘Commit Changes’ at the bottom. Repeat for all varieties.
@@ Line 54: / Line 54: @@
 )	Because your abbreviations clearly indicate which word list you wish to place in that column, you select the rows under ‘Transcription’ that you will need to put the first word list into. In PNG we have 170 items in our word list, so the end of the selected column appear like Figure 7.
-(Note: replace the coded boxes as well. To keep from losing your reference points in the database, you may wish to label the first item of each word list in the ‘Notes’ column. This will not appear in WS6.)
+*Note: replace the coded boxes as well. To keep from losing your reference points in the database, you may wish to label the first item of each word list in the ‘Notes’ column. This will not appear in WS6.
 [[Image:WS6-7.jpg|thumb|Figure 7. Selecting Space for a Word List]]
@@ Line 66: / Line 66: @@
 )	After putting all your varieties into Access click ‘Save’ and exit Access. Open WS6 again and click on a variety; your word list should appear in the ‘Form’ column. You can cross-check with your Excel word list document that each is correct. You now have your glosses and your word lists. See Figure 9.
-(Note: WS6 will only create entries in Access for the varieties into which you’ve entered something in WS6 (e.g. the codes). If you enter nothing in WS6, it will not generate the appropriate rows in Access.)
+*Note: WS6 will only create entries in Access for the varieties into which you’ve entered something in WS6 (e.g. the codes). If you enter nothing in WS6, it will not generate the appropriate rows in Access.
 [[Image:WS6-9.jpg|thumb|Figure 9. Word Lists Entered]]

@@ Line 17: / Line 17: @@
 )	Under ‘Variety’ click ‘New’ to create a new variety (Figure 2). Again fill in whatever details you wish. This information should be documented elsewhere, as WS6 should not function as your primary record-keeping program. Each variety you create will correspond with one of your word lists, so name them accordingly. Click ‘Save.’
-[[Image:WS6-2.jpg|frame|Figure 2. Create New Variety]]
+[[Image:WS6-2.jpg|thumb|Figure 2. Create New Variety]]
 )	Repeat step 4, entering further varieties as desired. In a recent survey, the PNG survey office compared eighteen lists without issue.
@@ Line 25: / Line 25: @@
 To add the dictionary, click on ‘File → Import → Gloss Dictionary → From WordSurv 6 Database.’ Locate your gloss dictionary database, and enter a name for it. Click ‘Begin Import’ (Figure 3).
-[[Image:WS6-3.jpg|frame|Figure 3. Import Gloss Dictionary]]
+[[Image:WS6-3.jpg|thumb|Figure 3. Import Gloss Dictionary]]
 )	You will need to add the gloss dictionary to each of the varieties you’ve created. Click on a variety under ‘Variety Explorer,’ then click ‘Add All Entries.’ Repeat this step for all the varieties. Check that the glosses have appeared in the Variety column (Figure 4).
-[[Image:WS6-4.jpg|frame|Figure 4. Import Complete]]
+[[Image:WS6-4.jpg|thumb|Figure 4. Import Complete]]
 )	Identifying lists: this step is necessary to insure that you put your word lists into the proper rows in your Microsoft Access database, the next step. In the database it will be one long column; this step makes sure you put each word list in its proper place.
@@ Line 40: / Line 40: @@
 You will have to click into a blank box, then click ‘Commit Changes’ at the bottom. Repeat for all varieties.
-[[Image:WS6-5.jpg|frame|Figure 5. Identifying Lists]]
+[[Image:WS6-5.jpg|thumb|Figure 5. Identifying Lists]]
 )	Exit WS6. No need to save anything; by clicking ‘Commit Changes’ you have already done so.
@@ Line 48: / Line 48: @@
 )	Find the Microsoft Access database (see step 2) and open it. You may have to double-click ‘WordList’ in the left-hand column. This should appear.
-[[Image:WS6-6.jpg|frame|Figure 6. Microsoft Access Database - Ready for Inputting Word Lists]]
+[[Image:WS6-6.jpg|thumb|Figure 6. Microsoft Access Database - Ready for Inputting Word Lists]]
 )	Because your abbreviations clearly indicate which word list you wish to place in that column, you select the rows under ‘Transcription’ that you will need to put the first word list into . In PNG we have 170 items in our word list, so the end of the selected column looks like this.
-[[Image:WS6-7.jpg|frame|Figure 7. Selecting Space for a Word List]]
+[[Image:WS6-7.jpg|thumb|Figure 7. Selecting Space for a Word List]]
 )	Go to your Excel word list document, and select all of the items from the word list of this first variety. Copy them, return to Access, and click ‘Paste.’ It should say, ‘You are about to paste x number of record(s)’ and ask if you’re sure (Figure 8). This is a good way to check that you’ve selected the proper number of items. Click ‘Yes.’
@@ Line 58: / Line 58: @@
 Repeat steps 11 and 12 for all of your varieties, making sure that you’re putting the correct word lists into the correct rows by comparing your code – and checking that it appears in the first three rows – to the name of the variety.
-[[Image:WS6-8.jpg|frame|Figure 8. Pasting the Word Lists]]
+[[Image:WS6-8.jpg|thumb|Figure 8. Pasting the Word Lists]]
 )	After putting all your varieties into Access  click ‘Save’ and exit Access. Open WS6 again and click on a variety; your word list should appear in the ‘Form’ column. You can cross-check with your Excel word list document that each is correct. You now have your glosses and your word lists.
-[[Image:WS6-9.jpg|frame|Figure 9. Word Lists Entered]]
+[[Image:WS6-9.jpg|thumb|Figure 9. Word Lists Entered]]
 == Part 3: Creating Comparisons ==
@@ Line 68: / Line 68: @@
 )	Click on the ‘Comparison’ tab at the top. A box will appear for you to name and describe this comparison. At the bottom your survey should appear, along with each variety. Checking the box next to the survey will select all varieties; if you don’t want to compare all of them, select each individually. Click ‘Save’ (note that you must enter a name).
-[[Image:WS6-10.jpg|frame|Figure 10. Create New Comparison]]
+[[Image:WS6-10.jpg|thumb|Figure 10. Create New Comparison]]
 )	You are now ready to begin comparing your word lists! Note that sometimes you have to reselect your desired comparison from the drop-down box under ‘Comparison Information’ to get it to appear. Be sure to double-check that your sort order is CreationDate.
 Here’s what it looks like . Happy comparing!
-[[Image: WS6-11.jpg|frame|Figure 11. Ready for Comparison]]
+[[Image: WS6-11.jpg|thumb|Figure 11. Ready for Comparison]]