Our Free account allows you to create a single form and collect up to 50 responses on it. If you have already created one form, you can delete it and start a new one.
You can add columns to the Results table that would contain the true answers and then you could add columns that would have formulas like:
IF(A=B,1,-0.5). Where A is the column with the correct answer and B is one with the student's answer. Is this what you are trying to do?
The formula would get a little more complex with the "Don't Know" option, but it's doable by nesting the IF() statements.
that's really of great help I'll go back, delete previous form and follow
thanks THANKS so very much!!!
It is pretty reassuring to get such an incredible response and prompt help!
I'll report my progress on this by Saturday, April 9th (I need to make this
kind of reminders for myself...to make sure that I get new things going!!)
I re did my form with one question with three choices of response ... like this...
The color of the white horse of Napoleon was white:
meaning if the response is true the respondent gains one point, if false it looses minus 0.5 points and if the response is blank the result is zero.
1) how to insert the function that will allow to get those kinds of results ... I guess I need to use a double nested IF right?
2) where to place the pattern of response to be compared with respondent choice?
3) how to place a list of e-mails to send the form to?
4) would the system generates a personalized link for each of the forms to be sent to its destinataries?
You could do it with a nested if statement, or with an additional column/field in the Responses table.
Here's one way to do it:
If you view the responses, you'll see that I added two columns (D and E) to the table that was automatically created as part of the form.
Column C holds the respondent's Answer
Column D holds the correct answer (in this case 'True').
Column E tests to see if the responder's answer is blank (""), in which case the value is 0, or if it matches the Correct Answer (in which case it's 1), otherwise it's -0.5).
= IF(C = "", 0, if(C = D, 1, -.5))
In other words:
if Answer is blank,
Indeed I saw the what you did and the formula indeed works.
I realize that as a consequence of the responses a form is created with the
output of the survey, and then you include the required columns to treat the
output content in this case with a response pattern and a formula to do the
grading. So that's powerful and I don't need to do it on the spreadsheet.
I guess I am not familiar yet with the mechanisms yet that moves from the
form I already created to the reach the output form. How to do to test
responding the questions and afterworth find the location of the output
Next issue... I suppose I can apply a list of e-mails to distribute the
questionnaire, but could the links be personalized?
thanks again for your wonderful help,
I just created a link and pasted, but I need to send that to over 50 people
and I would like to send a personalized link to each of them and to send all
the messages at one time...?
and that I could not find the way of doing... is there a way?
On Fri, Apr 15, 2011 at 10:44 AM, Guillermo Asper y Valdes <