I would like to know how I can make a mulitiple choice test in powerpoint
which includes the following items:

-Name of the person taking the test
-Date of the test
-If the question is right or wrong straight away without the option to
change the answer.
-Score the test at the end giving an immediate grade.
-An export of the results to Excel

Cheers,

Chris

Chris,

This is quite involved and requires the use of VBA. Are you planning on
distributing these CBT-type presentations or are they for in-house use? If
you want, check out my site at the address below. I have an example that
does what you want (I normally export the data to an Access database).

You can let me know off-line if you are interested. You can send a message
to either "pttinc at itexas dot net" or "info at pttinc dot com".

http://www.pttinc.com/cbt_development.html (top download)

Sincerely,

--
Bill Foley, Microsoft MVP (PowerPoint)
Microsoft Office Specialist Master Instructor
www.pttinc.com
Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/
"Success, something you measure when you are through succeeding."

"LRTD5" <(E-Mail Removed)> wrote in message
news:2E389812-3579-40EC-90A4-(E-Mail Removed)...
>I would like to know how I can make a mulitiple choice test in powerpoint
> which includes the following items:
>
> -Name of the person taking the test
> -Date of the test
> -If the question is right or wrong straight away without the option to
> change the answer.
> -Score the test at the end giving an immediate grade.
> -An export of the results to Excel
>
> Cheers,
>
> Chris

Bill,

Thanks for the samples. I have to admit that I have never used VBA before. I
was just curious as to how you would export it to Access?

Just for your information the presentation is just for internal use.

Cheers,

Chris

"Bill Foley" wrote:

> Chris,
>
> This is quite involved and requires the use of VBA. Are you planning on
> distributing these CBT-type presentations or are they for in-house use? If
> you want, check out my site at the address below. I have an example that
> does what you want (I normally export the data to an Access database).
>
> You can let me know off-line if you are interested. You can send a message
> to either "pttinc at itexas dot net" or "info at pttinc dot com".
>
> http://www.pttinc.com/cbt_development.html (top download)
>
> Sincerely,
>
> --
> Bill Foley, Microsoft MVP (PowerPoint)
> Microsoft Office Specialist Master Instructor
> www.pttinc.com
> Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/
> "Success, something you measure when you are through succeeding."
>
> "LRTD5" <(E-Mail Removed)> wrote in message
> news:2E389812-3579-40EC-90A4-(E-Mail Removed)...
> >I would like to know how I can make a mulitiple choice test in powerpoint
> > which includes the following items:
> >
> > -Name of the person taking the test
> > -Date of the test
> > -If the question is right or wrong straight away without the option to
> > change the answer.
> > -Score the test at the end giving an immediate grade.
> > -An export of the results to Excel
> >
> > Cheers,
> >
> > Chris
>
>
>

In addition to Bill's examples, you can check out my examples at:

http://www.PowerfulPowerPoint.com/

I don't have any examples that write to Excel, but I do have examples
that write to text files.

--David

--
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/

"=?Utf-8?B?TFJURDU=?=" <(E-Mail Removed)> wrote in
news:AAE43365-9863-4373-9678-(E-Mail Removed):

> Bill,
>
> Thanks for the samples. I have to admit that I have never used VBA
> before. I was just curious as to how you would export it to Access?
>
> Just for your information the presentation is just for internal use.
>
> Cheers,
>
> Chris
>
> "Bill Foley" wrote:
>
>> Chris,
>>
>> This is quite involved and requires the use of VBA. Are you planning
>> on distributing these CBT-type presentations or are they for in-house
>> use? If you want, check out my site at the address below. I have an
>> example that does what you want (I normally export the data to an
>> Access database).
>>
>> You can let me know off-line if you are interested. You can send a
>> message to either "pttinc at itexas dot net" or "info at pttinc dot
>> com".
>>
>> http://www.pttinc.com/cbt_development.html (top download)
>>
>> Sincerely,
>>
>> --
>> Bill Foley, Microsoft MVP (PowerPoint)
>> Microsoft Office Specialist Master Instructor
>> www.pttinc.com
>> Check out PPT FAQs at: http://www.rdpslides.com/pptfaq/
>> "Success, something you measure when you are through succeeding."
>>
>> "LRTD5" <(E-Mail Removed)> wrote in message
>> news:2E389812-3579-40EC-90A4-(E-Mail Removed)...
>> >I would like to know how I can make a mulitiple choice test in
>> >powerpoint
>> > which includes the following items:
>> >
>> > -Name of the person taking the test
>> > -Date of the test
>> > -If the question is right or wrong straight away without the option
>> > to change the answer.
>> > -Score the test at the end giving an immediate grade.
>> > -An export of the results to Excel
>> >
>> > Cheers,
>> >
>> > Chris
>>
>>
>>

Hi Chris

Just read your post. If you haven't written code to do it, I could send you
a VBA code sample to send data to an Access table as well as query an Access
table during the presentation and place it in a text box on a slide if you
like. This cannot happen if you are using a powerpoint viewer.

Paul

"LRTD5" <(E-Mail Removed)> wrote in message
news:2E389812-3579-40EC-90A4-(E-Mail Removed)...
>I would like to know how I can make a mulitiple choice test in powerpoint
> which includes the following items:
>
> -Name of the person taking the test
> -Date of the test
> -If the question is right or wrong straight away without the option to
> change the answer.
> -Score the test at the end giving an immediate grade.
> -An export of the results to Excel
>
> Cheers,
>
> Chris