CSPro Creating the Data Dictionary

CSPro Creating the Data Dictionary


Hello, CSPro users, and welcome to CSPro Video Tutorials, Tutorial 2, Create the Data Dictionary. In this tutorial, we will create the data
dictionary for the questionnaire we examined in tutorial
1. We begin by opening CSPro. I open CSPro by double clicking on the CSPro icon on the desktop. This will be a new application so I select “Create a new application.” then click “OK”. To get to the data dictionary selection I click on the “Other” tab then I click on “Data Dictionary” and click “OK”. I navigate to the desktop. For this tutorial, I will create a folder
on my desktop by clicking on the “New Folder” icon. I will name this folder “MyCSProTutorial”. Press “Enter”. Click “Open”. And now I am in the “MyCSProTutorial” folder. I will give the dictionary the name “MyDictionary”. Click on “Create”. CSPro has created for us a default dictionary. The left side of the screen is the dictionary
tree. The dictionary tree contains the record names and the item names. The right side of the screen is for record and item attributes. We will now match our dictionary to our
questionnaire. I begin by clicking on the “+” sign to open up my “ID” items. I modify the dictionary ID by right clicking on the dictionary ID and selecting “Modify Item”. For label, I enter “Household”, “space”, “ID” Press the enter key and for item name I give the item name “Household”, underscore, “ID”. The default application uses “1” for the ID
Length. The ID on the questionnaire is 4 digits, so I change this to 4 to match what is on the questionnaire. I accept the remaining defaults by pressing “enter”. Our questionnaire has two types of records; person records and housing records. By default, CSPro creates one record. Our tutorial application will have two records, a person record and a housing record. We will change the one record that CSPro has generated to “Person Record”, that CSPro has generated to “Person Record”, then add “Housing Record”. First, we change the one record that CSPro has generated to “Person Record” by right clicking, modify record. We will now change the label to “Person Record”. CSPro has created a default name. CSPro has created a default name. We will change that now to “Person”, underscore, “Record” and accept the type value of “1”. For required, we will put “No” because it is possible we will enumerate vacant households. We will set max number of records to “10”
because that is what is allowed on our questionnaire. I press enter. Next, we will add the housing record. Right click on “Person Record” on the dictionary tree and select “Add Record”. I will type “Housing Record” for our record label and CSPro now has created a default record
name of “Housing”, underscore, “Record”. I will accept that and I will accept the type value of 2. I will leave required as “Yes”, because, according to our questionnaire, we must have at least one housing record for every
questionnaire, and there must be only one housing record, so I will keep the max at “1”. Press “Escape” to finish making these changes. Now we will add the items AGE, SEX, and MARITAL STATUS to our person record. Right click on “Person Record” on the dictionary
tree. Click on “Add Item”. The first item we are going to enter is AGE CSPro creates a default item name of “AGE” which we will accept. Press “Enter” to go to the next attribute. I will accept the start position of “6”. Here I will enter “2” to indicate that AGE takes up to two characters. This is because in our application we have
chosen to enter ages up to 99. I will press enter and accept the remaining default attributes. My next item is SEX. I will accept the default item name of “SEX”, the default start position, the length, since this only requires 1 character, and I will continue pressing enter to accept the default attributes. The final item on our person record is “Marital Status”. CSPro creates a default name of “MARITAL”, underscore, “STATUS” for us. I will accept that, and I will accept the remaining default values. I am now done entering the items for our person
record. I will click on “Escape” to exit the person
record items. Next, I will enter the items for the housing
record. I will now add the items “Type Household” and “Type Roof” to the housing record. I right click on “Housing Record”, Click on “Add Item”. The first item is “Type Household”. I enter “Type Household” as the item label. Press enter. CSPro gives a default item name of “TYPE”, underscore, “HOUSEHOLD”. Press “Enter”. I can accept the remaining default attributes by just pressing “Enter”. The next item is type roof I enter “Type Roof” as the label. Press “Enter”. CSPro gives an item name of “TYPE”, underscore, “Roof”, and then I will just press enter to accept the remaining default attributes. I press “Escape” to finish creating the items. Now that we have created our items we are ready to create value sets for the
items. Values sets define what data values we expect
for a data item. Value sets are used to define ranges of valid
values during data entry, and, to define categories for cross tabulation. First, we will create a value set for age. We will use 10 year age groups. Click on the “+” next to the person record to make sure all its items are showing on
the tree. Right click on “Age”. and select “Add Value Set”. Press “Enter” twice to accept the value set
label and the value set name. The cursor will drop to the line below into the value label column. Type “0 to 9” for the value label then press enter. Type “0” as the “From” value “9” as the “To” value. Type “10 to 19” as the value label. Press “Enter”. Type “10” as the “From” value. Press “Enter”. “19” as the “To” value. Continue in this fashion until you have reached “90 to 99”. Press “Escape” to finish entering the values. A faster way of creating a value set when you have evenly spaced ranges is to use “Generate Value Set”. I will use “Generate Value Set” to create 5 year age groups. Right click on the right panel. Select “Generate Value Set”. I’ll give the value set a label “Age (5 year)” I will give it the name “Age”, “underscore”,
“5”, “Y”, “R”. For the “From” value, I will leave at “0” and the “To” value I will leave at “99”. I am looking for 5 year age groups so I will change the interval to “5”. I will accept the default label template and
click “OK”. CSPro now has created for me a value set in 5 year age groups. Next, we will create a value set for SEX. Right click on “Sex”. Select “Add Value Set”. Press enter to accept the default value set
label. and press enter to accept the default value
set name. The cursor will drop to the line below into the value label column. Type “Male” as the first value label. Type “1” as the “From” value. Press “Enter”, and enter, enter. Enter “Female” as the next value label. Press “Enter”. Type “2” as the “From” value. Press “Enter” to skip over the “To” column. Press “Enter” to skip over the “Special” column. Press “Escape” to finish creating the value
set. Now we will add the values for marital status. Right click on marital status. Click on “Add Value Set”. Press enter to accept the default value set
label. Press “Enter” to accept the default value
set name. The cursor will drop down to the line below into the value label column. Type “Married” as the first value label. Press “Enter”. Type “1” as the “From” value. Press “Enter” to skip over the “To” and the
“Special” attributes. Type “Not Married” as the second value label. Press “Enter”. Type “2” as the “From” value. Press “Enter” to skip over the “To” column. Press “Enter” to skip over the “Special” column” Press “Escape” to finish creating the value
set. We now move on to the housing record. Click on the “+” to open the items for the
housing record. We begin with “Type Household”. Right click on “Type Household”. Click on “Add Value Set”. Press “Enter” to accept the default value
set label. Press “Enter” to select the default value
set name. The cursor will drop to the line below into the value label column. Type “Single Family” as the first value label. Press “Enter” and type “1” as the “From” value. Press “Enter” twice to skip over the “To”
and the “Special” columns. Type “Multi-Family” as the second value label. Press “Enter”. Type “2” as the “From” value. Press “Enter” to skip over “To” and “Enter” to skip over special. The cursor will drop to the line below into the value label column. Type “Homeless” as the third value label. Press “Enter”. Type “3” as the “From” value. Press “Enter”. to skip to the “To” column. and press “Enter” to skip “To” and then “Enter” again to skip from the
“Special” Column. Press “Escape” to finish creating the value
set. Right click on “Type Roof”. Select “Add Value Set”. Press “Enter” to accept the default value
set label. Press “Enter” to accept the default value
set name. The cursor will drop to the line below, into the value label column. Type “Wood” as the first value label. Press “Enter”. Type “1” as the “From” value. Press “Enter” twice to skip over the “To”
and “Special” columns. Type “Metal” as the second value label. Press “Enter”. Type “2” as the “From” value. Press “Enter” to skip over the “To” column. Press “Enter” to skip over the “Special” column. Press “Escape” to finish creating the value
set. Press “Escape” to finish creating the value
set. This completes the data dictionary. Continue on to the next tutorial, Tutorial 3. Create a Data Entry Application, where we will use this dictionary to create a data entry application.

Daniel Ostrander

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *