Analyzing a Questionnaire with Excel

profileSkipperP
1d._questionaire_worksheet_results_copy.xlsx
Home>Business & Finance homework help>Operations Management homework help>Analyzing a Questionnaire with Excel

Sheet1

Workplace Training & Learning Needs Assessment RESULTS
ID # Q1 Q2 Q3 Q4 Q5 Q6 Q7 Qa8 Q8b Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22
1 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
2 1 3 1 1 3 1 1 2 6 3 4 1 cross training, prepping 2 2 4 3 3 2 3 3 1 1
3 1 2 3 3 4 2 2 2 6 3 3 1 positioning, crosstraining 1 1 3 3 2 3 2 2 2 1
4 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
5 2 2 3 2 3 3 3 2 6 3 4 1 medications 1 2 2 3 3 1 3 2 1 1
6 3 3 2 3 2 2 3 1 5 2 3 1 arthroscopy pumps 2 1 3 2 2 2 3 2 2 1
7 3 4 2 2 3 2 3 1 4 2 3 1 positioning, crosstraining 1 1 3 1 1 1 3 2 2 1
8 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
9 3 3 3 3 3 3 2 1 5 2 3 1 cross training 1 1 3 3 1 1 2 2 1 1
10 4 3 2 2 2 1 2 1 5 1 3 1 cross training 2 1 3 3 2 3 2 2 3 1
11 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
12 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
13 3 2 3 3 4 1 2 1 5 2 4 1 cross training 2 1 3 3 2 2 3 2 1 1
14 4 2 2 2 4 3 3 1 5 2 2 1 more thorough training 2 1 2 1 2 2 3 3 1 1
15 4 2 3 3 3 2 2 1 5 2 2 1 scrubbing 2 1 3 3 1 1 3 2 2 1
16 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
17 5 1 2 3 4 5 3 1 5 2 4 1 positioning, equipment troubleshooting 1 1 3 2 2 1 3 2 1 1
18 5 3 1 1 1 1 1 1 5 2 1 2 new equipment 2 1 3 3 2 1 4 2 2 1
19 5 3 2 3 4 3 4 1 5 3 3 1 scrubbing, cross train 2 1 3 3 1 1 3 2 2 1
20 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
21 5 3 3 3 2 3 3 1 5 1 2 1 positioning, crosstraining 2 1 2 2 2 2 3 3 2 1
22 5 3 2 3 2 3 2 1 5 2 2 2 leadership skills 2 1 3 3 2 1 2 2 2 1
23 5 3 1 2 2 2 2 1 5 2 2 1 cross training 2 1 3 3 2 2 3 2 2 1
24 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
25 5 3 2 2 3 1 3 1 5 3 3 1 positioning, equipment troubleshooting 1 1 2 3 2 1 4 3 3 1
26 5 2 2 2 2 2 3 1 5 1 3 1 crosstraining 2 1 1 3 2 2 3 2 2 2
27 5 3 2 4 4 3 3 2 6 3 3 1 crosstraining 2 1 3 2 1 2 4 3 2 1
28 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
29 3 2 3 3 4 1 2 1 5 2 4 1 cross training 2 1 3 3 2 2 3 2 1 1
30 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
31 5 3 2 4 4 3 3 2 6 3 3 1 crosstraining 2 1 3 2 1 2 4 3 2 1
32 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1
33 2 2 3 2 3 3 3 2 6 3 4 1 positioning, tourniquet use 1 2 2 3 3 1 3 2 1 1
34 3 3 2 3 2 2 3 1 5 2 3 1 arthroscopy pumps,positioning 2 1 3 2 2 2 3 2 2 1
35 4 3 4 4 4 1 4 2 6 3 4 1 cross training 2 1 1 2 1 1 2 4 1 1

CODEBOOK

CODEBOOK
Q1.     How long have you been a perioperative RN?
RESPONSE OPTIONS 1=<6mos 2=6mos-1year 3=1-2 years 4=3-5 years 5=>5 years
Q2.     Level of education completed:
RESPONSE OPTIONS 1=Diploma RN 2=ADN 3=BSN 4=MSN
Q3.     How satisfied are you with training for your job?
RESPONSE OPTIONS 1=Extremely satisfied 2=Mostly satisfied 3=Sometimes satisfied 4=Rarely satisfied 5=Not satisfied
Q4.     Do you receive specialty specific training?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q5. Do you receive OR wide skills/ in service training?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q6.      Do you have the desire to cross train to other specialty services?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q7.     Do you feel your training needs are adequately met within the organization?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q8.     Have you received ongoing training after initial orientation?
If yes, how often? 1=Yes 2=NO
RESPONSE OPTIONS 1=Daily 2=Weekly 3=Bi-weekly 4=Monthly 5=Annually 6=NOT Offered
Q9.     Do you feel 100% confident and competent in all aspects of your job?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q10.  Do you have the opportunity to develop new skillsets to enhance your job performance?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q11.  Are there areas of your job that you would like to receive training?
RESPONSE OPTIONS 1=Yes 2=NO
Q12.  What topics / areas would you like to see additional workplace training offered?
RESPONSE OPTIONS 1=Prepping 2=Cross training 3=OR medication 4=arthroscopy towers/pumps 5=scubbing 6=patient positioning
Q13.  What do you consider the best method of training:
RESPONSE OPTIONS 1=Inservice 2=hands on 3=intranet/video 4=self study 5=classroom 6=lecture
Q14.  Who do you learn best from?
RESPONSE OPTIONS 1=Peers 2=Reps 3=Coordinators 4=Outside Sources
Q15.  Which frequency of training sessions could benefit you and your team?
RESPONSE OPTIONS 1=Weekly 2=Bi-Weekly 3=Monthly 4=Quarterly
Q16.  Do you feel there are barriers in the workplace to get your training needs met?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q17.  Would you like to see more workplace education and training offered to enhance your job skills and performance?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q18.  In your opinion, what would be the ideal times for training to take place?
RESPONSE OPTIONS 1=Before Shift 2=During Shift 3=After Shift
Q19.  Do you feel that the surgeons support an environment conducive to learning?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q20.  Do you feel that your peers and co-workers support an environment that is conducive to learning?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q21.  Do you feel that there is a direct correlation to ongoing education and training as it relates to job satisfaction and performance?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never
Q22.  Do you feel ongoing workplace education affects the safety of staff and patients?
RESPONSE OPTIONS 1=Always 2=Mostly 3=Sometimes 4=Rarely 5=Never