Kingsley eLearning Solutions

You have big dreams for your eLearning.
We'll make them come true.

image of Kingsley

misc

Faster ppt #Articulate branching with free macro

Submitted by Kingsley πŸ‘‘ on Thu, 12/03/2009 - 15:20

I'm working on a project that has many many 'hot spots' in PowerPoint that allow the learner to select the correct area of a photo. I the get it right; great I want to jump them to the correct feedback. If the get it wrong the need to get some feedback and another chance. The number of correct/incorrect hot spots vary per slide. I decided to knock out a couple of quick macros to help automate this process for me.
You can download the macro file here:(right-click; save as) createHyperlinks.bas

This video proves that WRC is Awesome (far better then NASCAR)

Submitted by Kingsley πŸ‘‘ on Tue, 10/20/2009 - 09:26

I've been a big fan of WRC for years... One of the best things about living in Sicily for three years was the excellent coverage of WRC events.
This is one of my favorite WRC moments. Marcus GrΓΆnholm flips his car a few times, asks fans to put back on its wheels, has trouble figuring out which way to go (after all... he just rolled his car down a hill) finally he resumes the race!

Google uses cool eLearning to introduce Wave

Submitted by Kingsley πŸ‘‘ on Wed, 10/07/2009 - 09:25

Got my wave invite this morning ( thx @jeffl8n ).
As soon a I logged in I checked out the first 'wave'.
Google embedded a youtube video of a guy explaining how to use wave.
It's nothing fancy (just 2 mins) but I think it is a good example of how eLearning doesn't have to by long and complex to make its point and keep users interested.
I made a screenr of it for you:

Excel Formula

Submitted by Kingsley πŸ‘‘ on Wed, 09/30/2009 - 09:47

A coworker had a pretty complex spread sheet with several sheets in it.
One sheet had monthly and yearly totals going back to 2003.
She wanted a chart on a new sheet that compared this year's data with previous years.
But only up to the current months data... so August 2009 compared to Aug. 08, Aug. 07, etc
Here is what I came up with:
=INDIRECT(ADDRESS(104,MONTH(TODAY()),4,1,"damages per 1000"))
I am far from an excel expert so I'm proud of it.
Luckily the sheet with the monthly totals is arranged so that month 1 is in col 2 etc.