Tabulating scores based on interactive input

[Melissa]

I'm creating an eLearning courseware using Powerpoint and would like to
incude an assessment at the end of the course. Will be flashing each
question one by one with multiple-choices for the user to select (via radio
buttons). At the end of the 10 questions, I want to show how many questions
the user got correct.

How can I tabulate the scores? VB? Adding in some Excel functions?

Any help/ hint/ references much appreciated!

 

[Bill Foley]

I have a FAQ on code to keep score unsing PowerPoint at:

http://www.pttinc.com/ppt_faq1.html

I also have a sample download of a CBT using PowerPoint and VBA at:

http://www.pttinc.com/cbt_development.html

This page also includes a download that has access to the code on a Review
Question sample file that you can see how this one was done (doesn't keep
score but does provide some interactivity.

Another great resource for VBA in PowerPoint is fellow MVP, David
marcovitz's book. A link to his site and others is at:

http://www.rdpslides.com/pptfaq/FAQ00616.htm

 

[PPTMagician]

And I just added a game download created by a clever 13 year old to my
downloads page:
www.pptmagic.com/downloads.htm
See Justin Kendrick: Wheel of Jeopardy

He uses Excel and VBA to populate the game.
--
Thanks,
Glenna Shaw
Microsoft PowerPoint MVP Team
http://www.pptmagic.com

 

[Melissa]

Thanks for the tips!
BTW, just wanted to let you know that the 2 powerpoint samples you have at
http://www.pttinc.com/cbt_development.html do not run beyond the 1st and 2nd
page, respectively.

 

[Bill Foley]

That is probably because your macro security is set to HIGH. Open
PowerPoint, click "Tools", "Macro", "Security", and set it to MEDIUM.
Re-open the presentation and click "Enable macros" when asked and it will
work fine.

Thanks for the heads up because I need to update the web page with this
info!