Flubaroo grading fractions incorrectly

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Create a form with answers that look like fractions (e.g. 4/5, or 4/5 - 3/8)
2. Grade it.

What is the expected output? What do you see instead?

Flubaroo should mark answers correct if they match the answer key. But for some 
reason Flubaroo sees these cells as dates (e.g. 4/5 = April 5, 2012). Further, 
when comparing the dates, Flubaroo doesn't consider them to be equal. So in the 
end these questions get marked wrong. You can work around by putting text 
infront of the answers (e.g. "4/5" -> "a. 4/5").

I will need to investigate this further to figure out what a good fix is.

Original issue reported on code.google.com by d...@edcode.org on 5 Mar 2012 at 3:37

[GoogleCodeExporter]

Issue 19 has been merged into this issue.

Original comment by d...@edcode.org on 21 Dec 2012 at 6:12

[GoogleCodeExporter]

The approach to fixing this needs to be to undo the date formatting in the cell 
(e.g. change it to String) before attempting to grade, if the cell is formatted 
as a Date.

Original comment by d...@edcode.org on 21 Dec 2012 at 6:13

[GoogleCodeExporter]

Seems like this happens for times too, like 1:15:00. See this email thread: 
https://mail.google.com/mail/u/0/?shva=1#inbox/13c1abf86369ad1c

Original comment by d...@edcode.org on 15 Jan 2013 at 6:46

[GoogleCodeExporter]

more feedback on this:

My name is Sébastien Millette and I am a math teacher at the American School 
of Paris.  This is my first time using Flubaroo to mark a form.  I was 
beta-testing Flubaroo with an online test that I want to give my students.  I 
noticed that when certain responses are in the form of fractions, that is, 
using the forward slash /, the Google form will store it with a quote if it is 
also in a valid date format.

Example 1:  the response 12/19 is stored as '12/19 in the spreadsheet, 
otherwise the spreadsheet thinks it's the date 12/19/2013.  

Example 2:  the response 3 4/11 is stored as '3 4/11 in the spreadsheet, 
otherwise, the spreadsheet thinks it is the date 3/4/2011.

Grading by Flubaroo is done without a hitch as it compares strings.  However, 
when the results are sent back to students via email, these same possible dates 
are being CONVERTED to dates in the email.  I have included a screenshot of the 
responses for both of those dates.  They are responses for questions 14 and 
questions 12, respectively. 

Let me know if I should make a copy of my form and share it with someone on 
your team for further analysis if this is a bug.

Original comment by d...@edcode.org on 4 Oct 2013 at 11:41

[GoogleCodeExporter]

Original comment by d...@edcode.org on 18 Oct 2013 at 11:33

• Added labels: Priority-Low
• Removed labels: Priority-Medium