[Year 12 IT Apps] excel tutorials

Keith Richardson keithcr at fastmail.fm
Wed Jul 25 11:26:58 EST 2007


A useful source of IT lesson materials from NC State University:
http://www.cals.ncsu.edu/agexed/aee226/


Introduction to Excel: formulas
http://www.ncsu.edu/cals/agexed/aee226/functions.xls

functions:
http://www.ncsu.edu/cals/agexed/aee226/functions2.xls

ongoing Excel exercise:
http://www.cals.ncsu.edu/agexed/aee226/green.xls.

Creating charts:
Do:
http://office.microsoft.com/training/training.aspx?AssetID=RC011055061033
Then: http://www.internet4classrooms.com/excel_create_chart.htm
Then: http://www.ncsu.edu/cals/agexed/aee226/functions3.xls

Keith Richardson


On Wed, 25 Jul 2007 10:26:36 +1000, itapps-request at edulists.com.au said:
> Send itapps mailing list submissions to
> 	itapps at edulists.com.au
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://www.edulists.com.au/mailman/listinfo/itapps
> or, via email, send a message with subject or body 'help' to
> 	itapps-request at edulists.com.au
> 
> You can reach the person managing the list at
> 	itapps-owner at edulists.com.au
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of itapps digest..."
> 
> 
> Today's Topics:
> 
>    1. Excel query (Antonia Caridi)
>    2. Excel resource (Mark Kelly)
>    3. RE: Photoshop CS (Jenny Antcliffe)
>    4. RE: Excel resource (Kent Beveridge)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 25 Jul 2007 08:53:47 +1000
> From: "Antonia Caridi" <ACaridi at sac.vic.edu.au>
> Subject: [Year 12 IT Apps] Excel query
> To: <itapps at edulists.com.au>
> Message-ID: <46A70F9A.4B16.00C2.0 at sac.vic.edu.au>
> Content-Type: text/plain; charset=ISO-8859-1
> 
> Thanks to all those who responded to the Excel exercises request. 
> 
> I have photocopied exercises from various sources and made a booklet.
> Lots of companies such as Microstar provide exercises and files for a
> whole range of software.
> 
> Antonia
> 
> Antonia Caridi
> Sacre Coeur
> 172 Burke Road
> Glen Iris 3146
> Telephone 9885 4501
> Fax 9885 5936
> 
> 
> èµ__________________________________________________________________________________
> This email and any attachments may be confidential and, if you are not
> the intended recipient you must not disclose or use the information in
> this email. If received in error, please notify the sender immediately
> and delete the email and all copies. The school does not guarantee that
> this email is virus or error free. Any attached files are provided and
> may only be used on the basis that the recipient assumes all
> responsibility for any loss, damage or consequence resulting directly or
> indirectly from the use of this email and/or attached files, whether
> caused by the negligence of the sender or not. The content and opinions
> in this email are not necessarily those of Sacre Coeur. 
> ____________________________________________________________________________________
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Wed, 25 Jul 2007 09:24:23 +1000
> From: Mark Kelly <kel at mckinnonsc.vic.edu.au>
> Subject: [Year 12 IT Apps] Excel resource
> To: "Year 12 IT Applications Teachers' Mailing List"
> 	<itapps at edulists.com.au>
> Message-ID: <46A68A27.90309 at mckinnonsc.vic.edu.au>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> 
> I've mentioned this before, but a great Excel resource is Greg Bowden's 
> Guided Excel tutorials, available in PDF format at http://www.gct.com.au.
> 
> 
> -- 
> 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
> IT Lecture notes: http://vceit.com
> Moderator: IT Applications Mailing List
> 
> There are 10 kinds of people in the world: those who understand binary
> and those who don't.
> 
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Wed, 25 Jul 2007 10:09:23 +1000
> From: "Jenny Antcliffe" <jantcliffe at fintona.vic.edu.au>
> Subject: RE: [Year 12 IT Apps] Photoshop CS
> To: "Year 12 IT Applications Teachers' Mailing List"
> 	<itapps at edulists.com.au>
> Message-ID:
> 	<1DB1B93F01DDA1488DD52F551A8BE820083477 at IRIS.fintona.vic.edu.au>
> Content-Type: text/plain; charset="us-ascii"
> 
> Try http://www.watsoniapublishing.com.au/ - usually very good, but there
> is a host of free tutorials on the net.. regards, Jenny
> 
>  
> 
> ________________________________
> 
> From: itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Clare, Ian J
> Sent: Wednesday, 18 July 2007 9:44 AM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: [Year 12 IT Apps] Photoshop CS
> 
>  
> 
> Hi All
> 
>  
> 
> Can anybody recommend a training manual for Photoshop CS.  I have used
> GCT manuals but they only have one for Photoshop Elements. 
> 
>  
> 
> Ian Clare
> 
> Information Technology Teacher
> 
> Casterton Secondary College
> 
> Ph   03 5581 1588 Fax 03 5581 1518
> 
> clare.ian.j at edumail.vic.gov.au
> <BLOCKED::mailto:clare.ian.j at edumail.vic.gov.au> 
> 
>  
> 
> Important - This email and any attachments may be confidential. If
> received in error, please contact us and delete all copies. Before
> opening or using attachments check them for viruses and defects.
> Regardless of any loss, damage or consequence, whether caused by the
> negligence of the sender or not, resulting directly or indirectly from
> the use of any attached files our liability is limited to resupplying
> any affected attachments. Any representations or opinions expressed are
> those of the individual sender, and not necessarily those of the
> Department of Education.
> 
> _______________________________________________ 
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
> IT Applications Mailing List kindly supported by 
> http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html
> <http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html%2
> 0> - Victorian Curriculum and Assessment Authority and 
> http://www.vitta.org.au - VITTA Victorian Information Technology
> Teachers Association Inc
> 
> _________________________________________________ 
> The information contained in this e-mail message and any attached files
> may be confidential information. If you are not the intended recipient
> any
> use, disclosure or copying of this e-mail is unauthorized. If you have
> received this e-mail in error, please notify the sender immediately by
> reply e-mail and delete all copies of this transmission together with any
> attachments.
> _________________________________________________
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://www.edulists.com.au/pipermail/itapps/attachments/20070725/6be5d0d5/attachment-0001.html
> 
> ------------------------------
> 
> Message: 4
> Date: Wed, 25 Jul 2007 10:31:09 +1000
> From: "Kent Beveridge" <kbeveridge at stbc.vic.edu.au>
> Subject: RE: [Year 12 IT Apps] Excel resource
> To: "Year 12 IT Applications Teachers' Mailing List"
> 	<itapps at edulists.com.au>
> Message-ID: <MINT9EXxt5BBBVhyemY00000960 at mint.stbc.vic.edu.au>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> Hey Mark, whats your cut? The other resources we have provided are free
> and not all of us have the dosh to go buying lots of you beaut resources!
> I and my budget certainly dont! The drought DID reach the country schools
> you know.
> Except Adrian's book, but we all know ITS A BOOK. I havent purchased it
> but am considering it for next year, similarly, will consider now this
> excel resource.
> KB.
>  
> Kent Beveridge,
> I.T. co-ordinator
> St. Brigids Catholic Sec. College
> Horsham
> email.. kbeveridge at stbc.vic.edu.au
>  
> 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: Wed 7/25/2007 9:24 AM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: [Year 12 IT Apps] Excel resource
> 
> 
> 
> I've mentioned this before, but a great Excel resource is Greg Bowden's
> Guided Excel tutorials, available in PDF format at http://www.gct.com.au
> <http://www.gct.com.au/> .
> 
> 
> --
> 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
> 
> There are 10 kinds of people in the world: those who understand binary
> and those who don't.
> 
> _______________________________________________
> 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: 6421 bytes
> Desc: not available
> Url :
> http://www.edulists.com.au/pipermail/itapps/attachments/20070725/2eacba8d/attachment.bin
> 
> ------------------------------
> 
> _______________________________________________
> itapps mailing list
> itapps at edulists.com.au
> http://www.edulists.com.au/mailman/listinfo/itapps
> 
> 
> End of itapps Digest, Vol 29, Issue 35
> **************************************
Keith Richardson




More information about the itapps mailing list