[Year 12 IT Apps] Some things do sink in after all

[Kent Beveridge]

does it make you feel old Mark?
 
Kent Beveridge,
I.T. co-ordinator
St. Brigids Catholic Sec. College
Horsham
email.. kbeveridge at stbc.vic.edu.au
 
|<3|\|7  b3\/3r1D93 ?  ;-)

Wishes and Eggs, one you make and one you break!  A bit like promises.....
"This email and any attachments may be confidential.  You must not disclose or use the information in this email if you are not the intended recipient.  If you have received this email in error, please notify us immediately and delete the email and all copies.  The School does not guarantee that this email is virus or error free.  The attached files are provided and my only be used on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not.  The content and opinions in this email are not necessarily those of the School."

________________________________

From: itapps-bounces at edulists.com.au on behalf of Mark Kelly
Sent: Tue 12/11/2007 10:30 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Some things do sink in after all



It brings a blush of pride to my gnarled old knees  :-)

Thanks for that, Russell.

And if people are interested in the Excel Nested IF Challenge page, visit:

http://www.mckinnonsc.vic.edu.au/vceit/howto/nestedif.htm


Russell Edwards wrote:
> true
> X-Safemail-Anti-Spam-Result: AgAAADyNXEfKLW7anWdsb2JhbACBWo4KAQEBAQsPgTQ
> AgAAAKyGXEc7p4iK/2dsb2JhbAAIkS4
> X-Safemail-AV: E=Sophos;i="4.23,275,1194183000"; d="scan'208";a="14316013"
>
> I had a bit of a chuckle today.
>
> I was on a web forum, completely non-IT-related, but someone asked a
> question about how to do something in Excel. It was a a great job for a
> VLOOKUP and a drop-down box. I answered in keep-it-simple-stupid mode
> and just gave the VLOOKUP formula, without the added complication of
> explaining how to do a named lookup table or drop down lists. Someone
> else replied and said "too complicated, just use this formula" and gave
> a bit ugly nested IF statement!
>
> Then, someone else chimed in and said, No, you should use the VLOOKUP,
> put the lookup table in a different sheet, name it along with all other
> constants, and use a combo box. He then pointed readers to the Mark
> Kelly's VCE IT web site and said  "written by my old IT teacher ;-)".
>
> There you go Mark, pat yourself on the back: at least one of your
> students retained something ~7 years later (he's 25, or claims to be)!
>
> Russell Edwards
> Whittlesea Secondary College
> _______________________________________________


--
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 95789253
kel AT mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au <http://www.mckinnonsc.vic.edu.au/> 
IT Lecture notes: http://vceit.com <http://vceit.com/> 
Moderator: IT Applications Mailing List

You'll know when we are officially a civilised race: our schools have
all the money they need and the Air Force has to run a chook raffle to
buy a new bomber.

_______________________________________________
http://www.edulists.com.au <http://www.edulists.com.au/>  - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au <http://www.vitta.org.au/>   - VITTA Victorian Information Technology Teachers Association Inc



-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 7835 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20071211/aab64000/attachment.bin