Creating and Using Codebooks This assignment will allow you to practice creating and using codebooks. There are three parts to this worksheet. In part one you will create a codebook based on a provided example survey. In part two you will write survey questions based on a provided codebook. In part three you will practice data entry using a provided codebook and two completed surveys. Please see the video on Canvas in the pre-class assignments for an example of how to use a codebook. Part 1: Creating a Codebook Directions: In this part you will practice creating a codebook from a blank survey. On page 2, you will see a blank product satisfaction rating survey. On page 3 you will see table 1, a blank codebook. Using the example survey (p. 2) please create a codebook by filling in table 1 (p. 3) for each question on the survey. As you will see in table 1, you should include the variable name, label, question type, variable type, and values for each survey question. Part 1 is worth four points. 1 Example Survey 2 Fill in Table 1 Below: Table 1. Blank Product Satisfaction Codebook Product Satisfaction Codebook Variable Name Variable Label Question Type (Open- ended or Close- ended) Variable Type (Nominal, Ordinal, Continuous, or String) Values 3 Part 2: Creating a Survey from a Codebook Directions: In this part you will use an existing codebook from a student survey (table 2 below) and re-create the survey questions that accompany the codebook. Please type out the survey questions and create a survey (see page 2 as an example) in the space provided on page 5. Part 2 is worth four points. Table 2. Completed Student Survey Codebook Student Survey Codebook Variable Label Question Variable Type Type Q1 What grade are you in? Open Continuous Ended Q2 What is your gender? Close Categorical Ended (Dichotomous) Q3a Students in my school treat one Close Categorical another with respect Ended (Ordinal) Q3b Students in my school are kind Close Ended Categorical (Ordinal) Q3c Students in my school are treated fairly Close Ended Categorical (Ordinal) Q3d Students in my school are friendly Close Ended Categorical (Ordinal) Q4 How often do you disrupt class? Close Ended Categorical (Ordinal) Q5 How often do you get good grades? Close Ended Categorical (Ordinal) Q6 How often do you complete all of your homework? Close Ended Categorical (Ordinal) Value 1=Male 2=Female 1=Strongly Disagree 2=Disagree 3=Neutral 4=Agree 5=Strongly Agree 1=Strongly Disagree 2=Disagree 3=Neutral 4=Agree 5=Strongly Agree 1=Strongly Disagree 2=Disagree 3=Neutral 4=Agree 5=Strongly Agree 1=Strongly Disagree 2=Disagree 3=Neutral 4=Agree 5=Strongly Agree 1=Never 2=Once or twice 3=A few times a year 4=Several times a year 1=Never 2=Once or twice 3=A few times a year 4=Several times a year 1=Never 2=Once or twice 3=A few times a year 4=Several times a year 4 Please Create Survey Below 5 Part 3: Using a Codebook Directions: In this part you will practice data entry using a codebook and two competed surveys. The codebook in Table 3 shows seven items from a depression scale. On page 7 you will see two completed surveys from participants 5 and 6 from this depression scale assessment. Please fill in the data for participants 5 and 6 into table 4 (page 7) using the codebook and their completed surveys. This part will be worth 2 points. Table 3. Depression Scale Codebook Depression Scale Codebook Variable Label Variable Type ID Participant ID number Continuous Dep1 During the past week, I could not get going. Categorical (Ordinal) Dep2 During the past week, I did not feel like eating. Categorical (Ordinal) Dep3 During the past week, I was happy. Categorical (Ordinal) Dep4 During the past week, I felt depressed. Categorical (Ordinal) Dep5 During the past week, I enjoyed life. Categorical (Ordinal) Dep6 During the past week, I had crying spells. Categorical (Ordinal) Dep7 During the past week, I felt sad. Categorical (Ordinal) Value 0=Rarely 1=Some of the time 2=Occasionally 3=Most of the time 0=Rarely 1=Some of the time 2=Occasionally 3=Most of the time 0=Rarely 1=Some of the time 2=Occasionally 3=Most of the time 0=Rarely 1=Some of the time 2=Occasionally 3=Most of the time 0=Rarely 1=Some of the time 2=Occasionally 3=Most of the time 0=Rarely 1=Some of the time 2=Occasionally 3=Most of the time 0=Rarely 1=Some of the time 2=Occasionally 3=Most of the time 6 Depression Screening Below are two completed surveys from participants 5 and 6. These are the instructions that the participants received when filling out this survey: Below is a list of some ways you may have felt or behaved. Please indicate how often you have felt this way during the last week. Please only check one answer to each question. Participant ID # 5 Rarely (less than 1 day) I could not get going I did not feel like eating I was happy Occasionall y (3-4 days) Most of the time (5-7 days) I felt depressed I enjoyed life Some of the time (1-2 days) I had crying spells I felt sad Participant ID # 6 Rarely (less than 1 day) Some of the time (1-2 days) Most of the time (5-7 days) I could not get going I did not feel like eating I was happy I felt depressed I enjoyed life I had crying spells I felt sad Occasionall y (3-4 days) 7 Enter Data for Participants 5 and 6 Below in Table 4: Table 4. Depression Scale Database ID Dep1 Dep2 Dep3 Dep4 Dep5 Dep6 Dep7 8