Data checking procedure

1. On the data entry computer, go to the old data folder (to get there, you need to go to the Multiple Movies
Study folder, then I think go to the "old" folder, and in that folder should be something called "old data from
other computer" or something similar -- whoever gets there first can double check this for me).



2. Open any QPW (Quattro Pro) file.



3. Check for 4 things:

a. correct formatting (remember how when some of you selected the cell/row delimiters special characters
in the wrong order, you got a bunch of ^ all over the place instead of correct cell divisions?)


b. duplicate entries (remember how you only started checking for double e-mails partway through the
quarter?) To check this, you'll need to open the file, look for all the page numbers in the first column (e.g.,
1p.2) and see if there are any duplicate pages.


c. anything else weird that you notice


d. correct files (no errors)



4. Fix mistakes

a. if the formatting of the QPW file is incorrect, open the corresponding TXT file in Quattro Pro and redo
this part of the data entry (steps 9-12 on the data entry instruction sheet):



9. Open the text file.
10. Close the file (but leave the Quattro Pro program open).
11. Open the text document again. Go to recent files (File > ) and then choose the first file.
12. Set the cell and row delimiters.
a. When the dialog box appears, click on ~SSettings~T.
b. Under End of Row delimiters, deselect ~SReturn~T and choose ~SCustom~T with this character (type it): ~
c. Under Cell delimiters, deselect ~SSpace~T and choose ~SCustom~T with this character: ^
d. Click OK

Then, instead of saving it with the original name (which would overwrite the bad version), add "-correctformat" to
the end of the file name (e.g., 14DAN88SAN-correctformat.QPW) to save it as a new file. Then go on to check for
the other things (duplicate entries, etc.).

NOTE: to change a file name/add a tag, do "File > Save As..." from Quattro Pro, or from inside the data folder,
double click on the file name slowly or select the file and press F2 .


b. if there are duplicate entries, add "-dup" to the file name (e.g., 14DAN88SAN-dup.QPW). If the file
already has "-correctformat" at the end, add this tag afterward, e.g., 14DAN88SAN-correctformat-dup.QPW .


c. if there's something else weird you notice with the file, add an additional tag to the end of the file
name (e.g., 14DAN88SAN-only has Session 3 data in it.QPW)


d. if there are no errors in the file, add "-OK" to the file name (e.g., 14DAN88SAN-OK.QPW).



5. Move all the files you've checked to the "checked" folder inside the old data folder. (Whoever gets there
first will have to create this folder.) So if you've checked the files of 14DAN88SAN, move all that person's
files (including renamed files, TXT files, etc.) to the "checked" folder so no one wastes time rechecking them.