jacobtherabbit
New member
- Joined
- Jan 19, 2017
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi,
My query may seem fairly simple but, as I have not used excel in any depth since my GCSE's, I'm quite out of practice. I'll describe what I want to achieve, if someone could tell me the most efficient way to do so that woulds be fantastic.
A training company receives feedback forms after they run educational courses, from the students. These feedback sheets simply ask for the participant's rating (Poor, Fair, Good, Excellent) in five specific areas relating to the training program.
I have been asked to create a simple excel system where you can input the rating each pupil gave to each category, and then display, in the form of a graph/bar chart, the distribution of each rating (Poor, Fair, Good, Excellent) each of the five areas receives.
The training company regularly runs courses so I need to be able to add data from more feedback forms on a regular basis, that would be included in the graph/bar chart.
In case my explanation skills are as poor as my excel skills, here's an idea of what I want:
(1-4 corresponds with poor-excellent)
I then want a graph/bar chart to figure out how much of the time each individual question receives a '4' rating, a '3' rating, and so on... and then present that data.
If someone can make sense of my situation and give me a pointer or two that would be greatly appreciated.
Cheers!
My query may seem fairly simple but, as I have not used excel in any depth since my GCSE's, I'm quite out of practice. I'll describe what I want to achieve, if someone could tell me the most efficient way to do so that woulds be fantastic.
A training company receives feedback forms after they run educational courses, from the students. These feedback sheets simply ask for the participant's rating (Poor, Fair, Good, Excellent) in five specific areas relating to the training program.
I have been asked to create a simple excel system where you can input the rating each pupil gave to each category, and then display, in the form of a graph/bar chart, the distribution of each rating (Poor, Fair, Good, Excellent) each of the five areas receives.
The training company regularly runs courses so I need to be able to add data from more feedback forms on a regular basis, that would be included in the graph/bar chart.
In case my explanation skills are as poor as my excel skills, here's an idea of what I want:
QUESTIONS | (RATINGS) | ||||
Q1 | 4 | 3 | 4 | 2 | ETC... |
Q2 | 3 | 2 | 4 | 4 | ETC... |
Q3 | 4 | 4 | 2 | 1 | ETC... |
Q4 | 2 | 3 | 4 | 1 | ETC... |
Q5 | 4 | 3 | 1 | 3 | ETC... |
(1-4 corresponds with poor-excellent)
I then want a graph/bar chart to figure out how much of the time each individual question receives a '4' rating, a '3' rating, and so on... and then present that data.
If someone can make sense of my situation and give me a pointer or two that would be greatly appreciated.
Cheers!