how can I make an test in powerpoint which scores the test?

[Guest]

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 Foley]

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."

 

[Guest]

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

 

[David M. Marcovitz]

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/

 

[Paul]

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