hi i am looking for questionnaire to caryy out survey among workers in excel format so that i can get the scores instantly and communicate result to respondent david
From Mauritius
Acknowledge(0)
Amend(0)
From Mauritius
Acknowledge(0)Amend(0)
As an HR professional seeking to assess health and safety practices among workers, creating a questionnaire in Excel format is a practical approach. Here is a step-by-step guide to help you achieve this:
1. Questionnaire Design:
- Structure your questionnaire with clear, concise questions related to health and safety practices.
- Include a mix of multiple-choice, rating scales, and open-ended questions for comprehensive feedback.
- Ensure the questions are easy to understand and relevant to the workplace environment.
2. Excel Setup:
- Create a new Excel spreadsheet with columns for respondent details, question numbers, and responses.
- Use dropdown menus for multiple-choice questions to ensure consistency in responses.
- Set up formulas to calculate scores automatically based on responses.
3. Scoring System:
- Define a scoring system for each question to assign numerical values to different responses.
- Calculate the total score for each respondent based on their answers to the questionnaire.
4. Result Communication:
- Develop a summary or dashboard in Excel to present the survey results visually.
- Share the results with respondents in a clear and understandable format, highlighting key findings and areas for improvement.
By following these steps, you can create an effective questionnaire in Excel, collect instant scores, and communicate the results efficiently to workers for better insights into health and safety practices in the workplace.
From India, Gurugram
Acknowledge(0)Amend(0)
451. Questionnaire Design:
- Structure your questionnaire with clear, concise questions related to health and safety practices.
- Include a mix of multiple-choice, rating scales, and open-ended questions for comprehensive feedback.
- Ensure the questions are easy to understand and relevant to the workplace environment.
2. Excel Setup:
- Create a new Excel spreadsheet with columns for respondent details, question numbers, and responses.
- Use dropdown menus for multiple-choice questions to ensure consistency in responses.
- Set up formulas to calculate scores automatically based on responses.
3. Scoring System:
- Define a scoring system for each question to assign numerical values to different responses.
- Calculate the total score for each respondent based on their answers to the questionnaire.
4. Result Communication:
- Develop a summary or dashboard in Excel to present the survey results visually.
- Share the results with respondents in a clear and understandable format, highlighting key findings and areas for improvement.
By following these steps, you can create an effective questionnaire in Excel, collect instant scores, and communicate the results efficiently to workers for better insights into health and safety practices in the workplace.
From India, Gurugram
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Occupational Safety, Health & Working Conditions Code 2019.pdf
Employee Satisfaction Survey Sample Questionnaire.d oc