[Year 12 IT Apps] excel tutorials
Roland Gesthuizen
rgesthuizen at gmail.com
Sun Aug 5 11:53:25 EST 2007
Here is a good list of spreadsheet tutorials based on OpenOffice.org V2 Calc
http://www.nostabo.net/openoffice.php
The CheatSheet guides and Videos are worth adapting. The Point & Click
OpenOffice.org<http://www.amazon.com/exec/obidos/ASIN/0131879928/nostabonet-20/002-0086705-3930440?%5Fencoding=UTF8&camp=1789&link%5Fcode=xm2>book
has more on the attached CDROM. I got our school some copies of this
book last year. :-)
Rgards Roland
On 25/07/07, Keith Richardson <keithcr at fastmail.fm> wrote:
>
> 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
>
>
> _______________________________________________
> 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 - VITTA Victorian Information Technology Teachers
> Association Inc
>
--
Roland Gesthuizen - ICT Coordinator - Westall Secondary College
http://www.westallsc.vic.edu.au
"Never doubt that a small group of thoughtful, committed citizens can change
the world; indeed it is the only thing that ever has." --Margaret Mead
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070805/daac83b6/attachment-0001.html
More information about the itapps
mailing list