Define a data collection plan for the following clinical question:
Will implementation of a preeclampsia risk factor screening tool for women at 20-36 weeks gestation identify high risk patients and prompt home blood pressure monitoring and disease education by the provider?
The student collected data over a 4-week period after a risk assessment tool was instituted at a busy OB-GYN practice. The student anticipated about 100 women eligible for the project at 20-36 weeks gestation.
Data were manually extracted from the outpatient medical record and recorded in an excel workbook with two tabs.
Demographics included maternal age, race/ethnicity, and gestational age
Outcome variables included whether or not a risk assessment was performed, and the risk assessment level (low, medium, or high). For high-risk patients, identify the extent to which high risk patients compiled with the patient education plan.
Remember that your submission has two parts: the excel file and the SPSS.sav (data) file.
Data Collection Setup Assignment and Rubric Define a data collection plan for the following clinical question: Will implementation of a preeclampsia risk factor screening tool for women at 20-36 weeks gestation identify high risk patients and prompt home blood pressure monitoring and disease education by the provider? The student collected data over a 4-week period after a risk assessment tool was instituted at a busy OB-GYN practice. The student anticipated about 100 women eligible for the project at 20-36 weeks gestation. There was a 2-week implementation period, and data were also collected (to some extent) in a 4-week preintervention period. Data were set up in an excel file with three tabs, included in this assignment. The file has three tabs. Tab 1 is labeled: Preeclampsia Project and provides some additional background on the project. You don’t need to add. This tab is for your information. Tab 2 is labeled: Preeclampsia Data Definitions. This tab has three columns and describes your variables, their labels, and the coding. You need to complete this tab next. Tab 3 is labeled: Preeclampsia Data Spreadsheet. This tab is the actual spreadsheet that will contain the data and move into SPSS. You need to get this started. It is started for you with just two variables: patient ID and Group. Your task in this assignment is to complete the set up (no actual data except for sample data). This should include column headings with variable names (you can actually copy these from the data definitions tab). Demographics include maternal age, race/ethnicity, and gestational age. Outcome variables included whether or not a risk assessment was performed (yes=1 no=0), and the risk assessment level (low, medium, or high). For high-risk patients, identify the extent to which high risk patients compiled with the patient education plan. 1. Set up an excel file remembering that data should be numeric, and coded so that labels can be entered into SPSS. (50 points) Use the attached excel file: one for the data collection and one for the coding. On the data collection tab, make sure that: · Each row represents a participant in the project · Each column represents a variable, coded as numeric (no text). · All data entry will be numbers · One “test” entry is established 25 points: data tab for data collection is set up with rows (participants/observations) and columns (variables), set to numeric entries, test participant data is entered; data collection tab is labeled. Variable names (at the top of each column) are less than 10 characters with no spaces. On the data definitions tab, make sure that: · Each number used on the data collection tab is explained (what do the codes mean?) · Example: Race/ethnicity will be coded using a number from 0 to 6 with 0=declined to answer, Caucasian=1, American Indian or Alaska Native=2, Asian=3, Black or African American=4, Hispanic or Latino=5, Native Hawaiian, or Other Pacific Islander=6, · Example: Risk level for preeclampsia 1=low, 2=medium, 3=high 25 points: Data Definitions tab shows a short/less than 10 characters variable name (no spaces), a column label with a more complete explanation, a column with the coding for the item. Tab is labeled as Data Definitions. Variable names should also appear (less than 10 characters, no spaces) on the data collection tab. 2. Anticipate what type of data analysis will be possible and useful to the project? · Demographic data: maternal age; specifiy the level of measurement and what SPSS analytic procedure will you use? (10 of 30 points) · Demographic data: race/ethnicity; specifiy the level of measurement and what SPSS analytic procedure will you use? (10 of 30 points) · Risk levels; specifiy the level of measurement and what SPSS analytic procedure will you use? (15 of 30 points) 35 points 3. Using the excel file data collection tab, move the data into SPSS. Add labels and values to the .sav file. · SPSS file is saved and submitted in addition to the excel file in the assignment drop box. · Labels are copied and pasted from the excel data definitions tab to the SPSS file (in variable view) · Value labels are added to the variable view in the SPSS file. 15 points