Multiple Forms Linked (Merged) on single sheet. Can Flubaroo grade these?

[robert...@wcdsb.ca]

Hello everyone I have taken many of my forms for a course and linked them all together as part of the final assessment for my course. I am wondering how, or even if Flubaroo is able to grade these and if so how. Currently I am being told to identify which sheets contain student responses (they all do ... 11 of them).

[Flubaroo Joe]

Flubaroo will only work on one response sheet.  

You can create one sheet that contains the answers from all of the separate quizzes.  You will need to use the Vlookup or another function to match the students.

I have been helping with Flubaroo for a long time and this is a first.  If you want to share the spreadsheet, I will attempt to combine the responses.

If you still have a problem please share the spreadsheet and form with flubar...@edcode.org with edit rights. 

I will take a look.

Please include some detail about the problem so we can locate the problem quicker.

Flubaroo Joe

flubaroo.com/about

 GLUA.Joe+F...@gmail.com

New Visions Blog Entry - Volunteer support for teachers.

On Fri, Jan 25, 2019 at 10:22 AM <robert...@wcdsb.ca> wrote:

Hello everyone I have taken many of my forms for a course and linked them all together as part of the final assessment for my course. I am wondering how, or even if Flubaroo is able to grade these and if so how. Currently I am being told to identify which sheets contain student responses (they all do ... 11 of them).

Disclaimer - This email and any files transmitted with it are confidential and contain privileged or copyright information. You must not present this message to another party without gaining permission from the sender. If you are not the intended recipient you must not copy, distribute or use this email or the information contained in it for any purpose other than to notify us. If you have received this message in error, please notify the sender immediately, and delete this email from your system. We do not guarantee that this material is free from viruses or any other defects although due care has been taken to minimize the risk. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the Waterloo Catholic District School Board.003

--
You received this message because you are subscribed to the Google Groups "Flubaroo Discussion Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to flubaroo-discussio...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Lawrence Towers]

Has this been worked out. Need the same thing a master spreadsheet of all quizzes

[Joseph Schmidt]

There are various solutions.  I have not published a video on how to do it.

It is a little more advanced but the steps are:

Have a Master sheet within a separate Spreadsheet.

Use Importrange or some other formula to bring the data from each quiz into a separate sheet in the same spreadsheet as the master.

Use a Vlookup to match the grade to a particular student.

I have seen several other ways of doing this.  You can link the Flubaroo quiz to the master in other methods.

Flubaroo doesn't work well when there are multiple quizzes going to a single spreadsheet.

The important thing is that you are willing to learn and understand the steps.  Once you do that, it will be a lot easier.  

I must admit that I'm a retired IT professional and have been learning about Google spreadsheets and formulas.  I constantly learn a new way of using the tools Google provides.

I'll make the same offer again.  If you share a couple of quizzes and a master list, I can put together 

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/flubaroo-discussion-forum/565f7ec5-52b9-40f3-a2e4-50f8c0c89870n%40googlegroups.com.