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",
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.
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.
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.