I am trying to create a solution for a Common Formative Assessment (short bi-weekly test) for a school district of 110,000 students. I have created a second grade math assessment in Forms. By itself, it works well. If an individual teacher had this, they would be able to have students complete it in class and then score it. However, I am trying to implement this across all schools.
My first line of attack was to use a Flow to move the results of the quiz to a SharePoint List. The problem is that the current Forms to SharePoint Flow does not capture points values or allow for teachers to review and score long answer items before it sends just the responses to SharePoint. There are no other dynamic objects to move over. If there were a way to get Flow to pull more detailed information, such as is represented (poorly) in the Excel Export from Forms, then that might work.
My next line of attack is to just go whole hog and create a PowerApp to conduct the quiz. I can imagine that I might have to create several lists and connections to make this work. I could alternately create a database in a SQLExpress client that is available to me.
Irregardless of which direction I move in, students will be re-connected to their teachers and classes in the reporting side in PowerBI.
I was originally trying to get this all done to administer to a sample of six schools by Friday, February 19. We are out for snow again tomorrow so that might be mercifully delayed. Any help or ideas on this project would be greatly appreciated.
I am trying to create one form for the entire district. The final straw yesterday was when I put the Flow connector to the Form, it only pulled the actual response and not whether that response was correct or how many points that response received. Because some of the questions were multiple answer, or multiple select, that was just not going to work for me. I would have to replicate some sort of table that would contain the answer key in Sharepoint. Also, there are open response questions that the teacher needs to go back in and review before the final score.
I think you are right in looking to another solution. While the Quiz in MS Forms is very handy for single classes, as you found, it’s a bit more complicated to aggregate all of that content together.
Would you be willing to use 1 form for all responses? Or do you need separate forms for each teacher to administer the CFA?
