question and answerwith Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 04 May 2008 20:46 GMT

Any pointers would be most appreciated. I'm wanting to create exams online
and have been told Excel will do this. For instance 20 questions with each
question having to choose the correct answer from a number of possible
answers. I want whoever to go through trhe 20 questions and only know how
many they got right by submitting at the end. They won't know which they
got right, only the number they got right. Any advice where to start with
Excel would be brilliant.

Best,

Paul B.

Reply to this Message

T. Valko - 04 May 2008 21:09 GMT

See if this gives you an idea:

http://contextures.com/xlForm01.html

Signature

Biff
Microsoft Excel MVP

> Any pointers would be most appreciated. I'm wanting to create exams
> online and have been told Excel will do this. For instance 20 questions
[quoted text clipped - 7 lines]
>
> Paul B.

Reply to this Message

legg - 05 May 2008 04:07 GMT

>Any pointers would be most appreciated. I'm wanting to create exams online
>and have been told Excel will do this. For instance 20 questions with each
>question having to choose the correct answer from a number of possible
>answers. I want whoever to go through trhe 20 questions and only know how
>many they got right by submitting at the end. They won't know which they
>got right, only the number they got right.

Even after submitting the completed form?

How does not knowing which answers were incorrect assist in improving
understanding of the material covered, or reveal possible problems in
comprehension of the form itself?

RL

Reply to this Message