I would like to build a portal that allows survey coordinators at each school to be able to tell how many surveys have been taken. The data for this comes from Lime Survey. Right now, there is a school number that students have to enter. I'd like them to have a way of knowing how many surveys have been taken for their school and which teachers have completed surveys.
I'm not sure what the best way to do this is. It could be that we find a way to directly link to the data in Lime Survey (ideally). Another option is that I download the data and then upload it somewhere else.
Enter in your school #: (This would be an input where the coordinator would put in their school #)
Data to be displayed:
# of Surveys Taken at Your School: XXX
Teacher ID's that have completed at least 1 survey: 123, 133, 101, 120
Number of Students by Teacher ID:
123: 5 surveys
133: 18 surveys
101: 43 surveys
120: 25 surveys