Do formulas need to be text?

[Trent Reynolds]

Hello,

Having trouble with a formula to grade multiple short answer responses. It does not seem to recognize a numerical value like 21 for partial credit but will recognize 30-9. When I change the formula to "2one" and then regrade with that as an answer, I get the 0.5 points. Here is my current formula:

%= if(FLB_RESPONSE = "30-9", 1, if(FLB_RESPONSE = "21", 0.5, 0))

21 returns 0 points.

tried this one:

%= if(FLB_RESPONSE = "30-9", 1, if(FLB_RESPONSE = "2one", 0.5, 0))

2one returned 0.5 points

Any help appreciated, seems like a I am missing something very obvious. 

Thank you.

[Flubaroo Joe]

It would help a lot if you shared the spreadsheet and form with me.  I would like to see the question and the way Google has stored the answer.

It doesn't need to be all of the questions or actual student submissions.  I just need to see the choices in the question and the spreadsheet.

If you created a test form, that would be great.  

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

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

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/flubaroo-discussion-forum/7e666efb-3dbf-4e6a-a6bc-043c20414d6an%40googlegroups.com.

[Flubaroo Joe]

Without spending a lot of time setting up a test try

%= if(FLB_RESPONSE = "30-9", 1, if(FLB_RESPONSE = 21, 0.5, 0))  I think that should work.  The compared value needs to match how Google is storying the answer.

I'm still willing to look at a specific example.

[Trent Reynolds]

Thanks, Joe.

The two links have been copied from the original and I deleted all the unnecessary questions leaving only the one question to be graded and my formula in the key (top entry).

I still get the same error where a response of "1" returns 0 points but a response of "5^0" returns 1 point (half-credit). Thanks

Sheet: https://docs.google.com/spreadsheets/d/1B8kG-va9OObruGYkUeNGwQAih6d1rYafzv7c42HsLl0/edit?usp=sharing

Form: https://docs.google.com/forms/d/1-JQRDy9XpT3vA3toLQ7F754budT2YzvunFcbykhPzNY/edit?usp=sharing

You received this message because you are subscribed to a topic in the Google Groups "Flubaroo Discussion Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/flubaroo-discussion-forum/aKsMh8G2g2M/unsubscribe.
To unsubscribe from this group and all its topics, send an email to flubaroo-discussio...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/flubaroo-discussion-forum/CAPWPTOQQhNkx6LKT%3D-5UV3ZwE6yVCsNZnzSaVhUVvqrMVTKEUA%40mail.gmail.com.

--

Trent Reynolds

Fairmont Junior High

Click here to view my webpage

208-854-4839

If you want to go fast, go alone.  If you want to go far, go with others.

[Joseph Schmidt]

Thanks for the example and making it so easy to test the solution.  %= if(FLB_RESPONSE = 1, 2, if (FLB_RESPONSE = "5^0", 1, 0))

I removed the quotes from around the 1 fixed the formula.  The trick is that the 1 was stored as a number by Google and we want the formula to treat it as a number.

The 5^0 was stored as a text and therefore the formula needs to have the quotes to make Flubaroo compare the text strings.

The way I could tell how the value was stored is that numbers are right justified and text is left justified by default.

I hope this helps.  If you have any other questions please let me know.

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/CAM-PgZOT%2BiWTYpA3%2BuShYb_pYch30jKmLeG_X_NvM_ipBu0NPQ%40mail.gmail.com.

[Trent Reynolds]

That is great help, Joe, and I have since used it in several places on other forms. Thanks a lot.

Trent

To view this discussion on the web visit https://groups.google.com/d/msgid/flubaroo-discussion-forum/CAPWPTOTtn9qknBekBxteh6-kPkU3d2URHg5ruJHOR9Z8FCFyuQ%40mail.gmail.com.