Weight for Answer Choices

[Lynn Gershman]

I would like to assign different points for different answers to a quiz question and have every answer earn points.  For example, if I ask a question like...

"I use Google Forms as Exit Tickets in my classroom."

Answer choices are: 

a. Strongly Disagree

b. Disagree

c. Agree

d. Strongly Agree

I would like to give 1 point for option a, 2 points for option b, 3 points for option c, and 4 points for option d.  I am assuming I have to use a search formula for this but I am not exactly sure how to set that up.  I copied this example formula and tried putting my info into the formula and entering into the Answer Key Row but I am not getting results on the grading page.  

%=if(flb_response="Strongly Disagree",1,if(flb_response="Disagree",2,if(flb_response="Agree",3,if(flb_response="Strongly Agree",4,0))

What am I doing wrong? Is Flubaroo the right program for me to collect this info in a Google Form, assign point totals to give an overall score, or should I look at something different? If yes, do you have a suggestion for what I want to do?

Thank you.

Lynn

[Flubaroo Joe]

Well, you get an E for effort and a A- for being so close.  I don't know if the example you were working from was incorrect or just luck but I think you are missing some close parentheses in your formula.  I count four opens and only two closes.  Unbalanced parentheses are a common problem in formula writing.

When the formula in the grade sheet doesn't work, one has to figure out what is making Google unhappy.  Then make those corrections in the Student Submission sheet.

A Vlookup might be easier to write.  A good or bad thing about using formulas is that you have so much power to make Flubaroo do what you want.

There is an example of Vlookup on the description for using formulas.  It is a more complicated example than what you need here.  

I really can't answer the question of which is the better tool.  I put together a comparison of using Flubaroo, Autocrat or FormMule.  The link is at the bottom of the FAQ section.

You have given me some homework.  I provided an example spreadsheet in one of my posts last week.  I will add a vlookup to that example and publish it to the Flubaroo help.  Probably later today.

Flubaroo Joe

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

New Visions Blog Entry - Volunteer support for teachers.

--
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.