Jump to content

  • Quick Navigation
Photo
- - - - -

Food Safety Questionnaire Trend Analysis


  • You cannot start a new topic
  • Please log in to reply
10 replies to this topic

#1 LSB

LSB

    Grade - AIFSQN

  • IFSQN Associate
  • 39 posts
  • 12 thanks
6
Neutral

  • United States
    United States
  • Gender:Male

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



#2 pHruit

pHruit

    Grade - PIFSQN

  • IFSQN Principal
  • 547 posts
  • 208 thanks
105
Excellent

  • United Kingdom
    United Kingdom
  • Gender:Male
  • Interests:Composing/listening to classical music, electronics, mountain biking, science, sarcasm

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?



#3 LSB

LSB

    Grade - AIFSQN

  • IFSQN Associate
  • 39 posts
  • 12 thanks
6
Neutral

  • United States
    United States
  • Gender:Male

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.



#4 The Food Scientist

The Food Scientist

    Grade - SIFSQN

  • IFSQN Senior
  • 393 posts
  • 88 thanks
55
Excellent

  • United States
    United States
  • Gender:Female
  • Interests:Food Science, Nature, SQF, Learning, Trying out new foods, Sarcasm.

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:

 

http://www.racialequ...es/G3658-14.pdf


Everything in food is science. The only subjective part is when you eat it. - Alton Brown.


#5 LSB

LSB

    Grade - AIFSQN

  • IFSQN Associate
  • 39 posts
  • 12 thanks
6
Neutral

  • United States
    United States
  • Gender:Male

Posted 23 July 2019 - 05:06 PM

it is being handed out via paper...



#6 kfromNE

kfromNE

    Grade - MIFSQN

  • IFSQN Member
  • 207 posts
  • 62 thanks
37
Excellent

  • United States
    United States
  • Gender:Not Telling

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.



#7 LSB

LSB

    Grade - AIFSQN

  • IFSQN Associate
  • 39 posts
  • 12 thanks
6
Neutral

  • United States
    United States
  • Gender:Male

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. 



#8 Charles.C

Charles.C

    Grade - FIFSQN

  • IFSQN Moderator
  • 15,721 posts
  • 4323 thanks
707
Excellent

  • Earth
    Earth
  • Gender:Male
  • Interests:SF
    TV
    Movies

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


#9 pHruit

pHruit

    Grade - PIFSQN

  • IFSQN Principal
  • 547 posts
  • 208 thanks
105
Excellent

  • United Kingdom
    United Kingdom
  • Gender:Male
  • Interests:Composing/listening to classical music, electronics, mountain biking, science, sarcasm

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.



#10 tsebring

tsebring

    Grade - MIFSQN

  • IFSQN Member
  • 55 posts
  • 33 thanks
13
Good

  • United States
    United States
  • Gender:Male

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:

  1. YouTube is great for learning software skills that you don't know.  Can take a little while to find someone good, but it can be worth the investment.  Most videos are less than 15 minutes and go step by step.
  2. I always try to tell a story visually through charts as its easier for people to follow than the raw data. (Highlight your data and go the to Insert tab, recommended charts, as a start).
  3. Pick a few key consistent metrics to identify and monitor over time.  Fewer is better.  Don't change your questions, so that the data over time is relevant.  
  4. Work with management to set goals for those metrics.  As if we want to have a response rate of X% and a rating of Y on a scale of Z.  This gives you and them something to aim for.
  5. Too much data overwhelms most people and lowers the impact of the message.  Keep it simple.

 

If you can upload your file, I don't mind looking it to give you some ideas.  

 

Hope this helps,

Todd



#11 kfromNE

kfromNE

    Grade - MIFSQN

  • IFSQN Member
  • 207 posts
  • 62 thanks
37
Excellent

  • United States
    United States
  • Gender:Not Telling

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 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

EV SSL Certificate