PDA

View Full Version : Injecting life into potential lessons



Aussiebear
06-10-2007, 03:28 AM
I'm currently off on another tangent! In the attached workbook, there are a number of potential lessons for objects within the object layer of Excel. Whilst its not hard to construct such short lessons, I was wondering if its possible to bring some life to them?

I was thinking about the possibility of trying to add some code that initially allows the reader to step through each of the steps involved.

For example if a reader/ student clicked on a button called "How to?" the actual steps were carried out in slow-mo.

Steps might include making a partial table appear, then show the selection of the required cells, the creation of the formula, and then the results of the formula.

And just to top it off a simple reset button.

Any ideas?

Aussiebear
06-10-2007, 03:30 AM
sorry forgot to upload the first time

mdmackillop
06-10-2007, 05:42 AM
Hi Ted,
Something like this (crude effort!)

Aussiebear
06-10-2007, 03:06 PM
The question now MD is, Since I know what the steps are, what effect would it have on someone who didn't know the proceedure of the LEFT Function?

Would it have any teaching potential?

Aussiebear
06-10-2007, 04:20 PM
MD, I've edited the file a bit. Would this be more student orientated?

lucas
06-11-2007, 08:01 AM
Ted...what is the Ctrl Enter for?

Edit: ah...you have to click in the formula bar first....I never used that method....usually just drag them down...live and learn.

mdmackillop
06-11-2007, 11:24 AM
New to me too Steve!
Thanks Ted for Lesson 1 :rofl:

Aussiebear
06-11-2007, 12:18 PM
Ted...what is the Ctrl Enter for?

Edit: ah...you have to click in the formula bar first....I never used that method....usually just drag them down...live and learn.

Woo Hoo... One for the bad guys!!!

malik641
06-11-2007, 05:59 PM
"And Aussiebear sneaks in a right uppercut! Wow, folks! This is truly an amazing turnaround!"

Sorry, I love your sig so much I just can't help myself!! :rofl:


For the record, you got me on that one too, Ted :thumb:thumb

Aussiebear
06-12-2007, 01:02 AM
Righto, it fess up time. I came across a book called Microsoft Excel Functions & Formulas by Bernd Held. In this Bernd uses <Ctrl+Enter> to bulk enter formulas, so its to him that I "dips me lid".