Does anyone have an example on how they are trending graded food safety questionnaires?
I am no excel wiz and am in desperate need of direction/ help......
-B
Posted 23 July 2019 - 03:04 PM
Does anyone have an example on how they are trending graded food safety questionnaires?
I am no excel wiz and am in desperate need of direction/ help......
-B
Posted 23 July 2019 - 03:17 PM
Can you provide a little more context about what you're trying to do:
Are you filling in the questionnaires / are they being filled in by your suppliers?
What is the data in which you're looking for a trend?
Posted 23 July 2019 - 03:59 PM
I have a questionnaire that I am using to gauge food safety culture at our plant. I have 10 graded questions with a range of 1-5. 1 strongly agree and 5 strongly disagree. I do five questionnaires a week at random. I have about 600 questionnaires I need to put into some type of trend analysis for the defined action plan.
Posted 23 July 2019 - 04:27 PM
This questionnaire is being handed out to employees to engage food safety culture, correct?
Perhaps this may help you get started:
Everything in food is science. The only subjective part is when you eat it. - Alton Brown.
Posted 23 July 2019 - 05:06 PM
it is being handed out via paper...
Posted 23 July 2019 - 09:19 PM
Does anyone have an example on how they are trending graded food safety questionnaires?
I am no excel wiz and am in desperate need of direction/ help......
-B
Make an excel document.
Put the date on the top. Fill it in with the average of your responses. Your formula: =average(number 1, number 2, etc.). You can then create a chart based upon trends over time. Another option would after each month to get the averages and then create a chart based upon the months.
It's a lot of data entry. But once the data is in. You then can compare responses over time, compare different years to each other. Create different types of graphs.
Posted 23 July 2019 - 09:39 PM
KfromIA,
I appreciate the input, but i have already done this. i was looking for something a little more involved if at all possible.
Posted 24 July 2019 - 01:35 AM
KfromIA,
I appreciate the input, but i have already done this. i was looking for something a little more involved if at all possible.
To get a focused answer, you probably need to provide some relevant specific data.
Generics unfortunately tend to be "vague".
Kind Regards,
Charles.C
Posted 24 July 2019 - 08:07 AM
Agree with Charles on this.
LSB - perhaps you can post your spreadsheet (ideally with any staff names etc removed) and we'll be able to give some more relevant suggestions/comments.
Posted 24 July 2019 - 11:45 AM
I agree that being more specific would make it easier to reply, but having said that, perhaps some of these ideas will help:
If you can upload your file, I don't mind looking it to give you some ideas.
Hope this helps,
Todd
Posted 24 July 2019 - 11:59 AM
If you want to learn software skills another great source is https://www.lynda.com/. There's a subscription cost but if you may get free access through your local library with a library card.
0 members, 0 guests, 0 anonymous users