Export test scores to Excel

[Project Org]

I have a test in powerpoint with the last slide printing the score. Instead
of having each person print out the last slide with their score, is it
possible to have the grade show up on an Excel spreadsheet with their name
and other information? How about Word or generating a email from Outlook?

If so where do I start? I am just now learning VBA for Powerpoint.

 

[Bill Foley]

What I do is export certain variables (name, score, date, etc.) to an Access
database. I haven't done it to Excel, but I'm sure it can be done (I just
don't have the code). If you want to check out a Computer Based Training
(CBT) sample, check out:

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

 

[David M. Marcovitz]

What Bill said and ...

It sounds like you are using my book (or at least my examples), so you
might want to check out Trick #1 from the More Tricks section of my Web
site:

http://www.loyola.edu/education/PowerfulPowerPoint/

Click on "More Tricks" and look for Trick #1. This is a simple extension
of the code I used to print out the last slide. It saves the information
in a text file. This could easily be adjusted to have the format be comma
delimited or TAB delmited so that Excel could easily read it in.

By the way, what you want to do with Excel is certainly possible, but the
text file solution might be a simple extension of what you are already
doing.

--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.loyola.edu/education/PowerfulPowerPoint/

 

[Project Org]

Thank you. I have your book. It is very helpful. The quiz is not yours but
very similar. You have given me a starting point to find my answers. Thanks.