Forlorn.of.thee (fa'lo:n ŭv thē), p, my only strength and stay,forlorn of thee, whither shall I betake me, where subsist?
Paradise Lost by John Milton

Friday, November 23, 2012

Customised training software

Hate presenting training courses at work. Staff get bored, I get annoyed by the sounds of ZZZZZZZ or BOOS!

Occurred to me that with the myriad of software available from Microsoft, there must be some way to devise a course, stick it on the intranet or shared public folder and get everyone to complete it. On completion, the "App" must be able to generate an email to HR informing that this staff has successfully completed the (boring) course.

Well, there is a way and Powerpoint is the answer. It's  a great piece of software. Some pointers are:

(1) The presentation must be saved as a Microsoft PowerPoint Macro-Enabled Presentation (.pptm). This is the 'master' where you write your presentation and test quiz.
(2) When it's ready it must be saved as a Microsoft PowerPoint Macro-Enabled Slide Show (.ppsm). This is the 'show' users click on.

(3) You'll want to disable the [Page Down] and other keys so users don't cheat, racing (or Page Downing ?? is this a word) to the end. They can only move from slide to slide via the buttons (hyperlinks) you build in. To do this you set the presentation to Kiosk Mode. Side Show -> Set Up the Slide Show -> Browsed at a kiosk (full screen), then save as (2) above.

(4) To get the presentation to send a confirmation email, add a button on the last slide to close the presentation and generate the email. The VBA code when the button is clicked:

Private Sub CommandButton1_Click()

Dim olApp As Object, olMail As Object
Set olApp = CreateObject("Outlook.Application")
Set olMail = olApp.CreateItem(0)
olMail.To = ""
olMail.Subject = "Completed ...blah...blah... Course"
olMail.Body = "Yay!! Finished"


End Sub

(5) To add a multiple choice quiz, the correct answer takes you to the next question via a hyperlink, an incorrect choice takes you to an error screen with a hyperlink button which take you back to the incorrect question.


Lavender said...

Waz that? Derp!

Young Werther said...

Just ignore this rambling, it's a memory jogger (need plenty of these in my old age)...

Lilly said...

Wow I am impressed. I am sending this to my sister. She was wanting to do something like this but had no idea.

Young Werther said...

Working for a cheapskate organisation, won't pay for professional training and I hate standing up there giving instructions to bored staff...

Yup, I'm lazy and no toastmaster...