HI Sal,
We ran into the same problem but felt that it was important for staff to have ownership of their feedback as well as to have a center overview.
We created a feedback survey as a template and asked staff to add it to their courses. I then used the queries below to collate the information fro centre and area wide reports.
The results I then processed in Excel.
A couple of things to note about our setup:
1) we use Moodle categories to define our schools/centres
2) A feedback survey created from a template is in fact a completely new survey so we had to match the questions themselves. You'll have to change the query to look for the exact text of your questions.
This will cause me an issue this year because I will have to change each question in order to be able to identify it from last year.
I hope this makes sense and these are useful to you
select mc.fullname as `Course\Module`, mcc.name as School, mfi.name Question, avg(value) as average_score, count(mfi.name) as submissions, if(concat('',value*1)=value,'', concat(group_concat(value),'\n')) as comments
from mdl_feedback_value as mfv
join mdl_feedback_item as mfi
on (mfv.item = mfi.id)
JOIN mdl_feedback as mf
ON (mf.id = mfi.feedback)
JOIN mdl_course as mc
ON (mc.id = mf.course)
JOIN mdl_course_categories as mcc
ON(mc.category = mcc.id)
where
mfi.name = 'On a scale of 1-4 how satisfied are you with the TEACHING AND ACADEMIC SUPPORT on this module?'
OR
mfi.name = 'Comments on TEACHING AND ACADEMIC SUPPORT'
OR
mfi.name = 'On a scale of 1-4 how satisfied are you with the LEARNING RESOURCES on this module?'
OR
mfi.name = 'Comments on LEARNING RESOURCES'
OR
mfi.name = 'On a scale of 1-4 how satisfied are you with the METHODS OF ASSESSMENT on this module?'
OR
mfi.name = 'Comments on METHODS OF ASSESSMENT'
OR
mfi.name = 'On a scale of 1-4 how satisfied are you with the FEEDBACK FROM ASSESSMENTS on this module?'
OR
mfi.name = 'Comments on FEEDBACK FROM ASSESSMENTS'
OR
mfi.name = 'On a scale of 1-4 how satisfied are you OVERALL with this module?'
OR
mfi.name = 'Comments on the MODULE OVERALL'
GROUP BY feedback, mfi.name
ORDER BY feedback, position
