Here is a good list of spreadsheet tutorials based on OpenOffice.org V2 Calc <br> <a href="http://www.nostabo.net/openoffice.php">http://www.nostabo.net/openoffice.php</a><br><br>The CheatSheet guides and Videos are worth adapting. The
<a href="http://www.amazon.com/exec/obidos/ASIN/0131879928/nostabonet-20/002-0086705-3930440?%5Fencoding=UTF8&camp=1789&link%5Fcode=xm2">Point & Click OpenOffice.org</a> book has more on the attached CDROM. I got our school some copies of this book last year. :-)
<br><br>Rgards Roland<br><br><div><span class="gmail_quote">On 25/07/07, <b class="gmail_sendername">Keith Richardson</b> <<a href="mailto:keithcr@fastmail.fm">keithcr@fastmail.fm</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
A useful source of IT lesson materials from NC State University:<br><a href="http://www.cals.ncsu.edu/agexed/aee226/">http://www.cals.ncsu.edu/agexed/aee226/</a><br><br><br>Introduction to Excel: formulas<br><a href="http://www.ncsu.edu/cals/agexed/aee226/functions.xls">
http://www.ncsu.edu/cals/agexed/aee226/functions.xls</a><br><br>functions:<br><a href="http://www.ncsu.edu/cals/agexed/aee226/functions2.xls">http://www.ncsu.edu/cals/agexed/aee226/functions2.xls</a><br><br>ongoing Excel exercise:
<br><a href="http://www.cals.ncsu.edu/agexed/aee226/green.xls">http://www.cals.ncsu.edu/agexed/aee226/green.xls</a>.<br><br>Creating charts:<br>Do:<br><a href="http://office.microsoft.com/training/training.aspx?AssetID=RC011055061033">
http://office.microsoft.com/training/training.aspx?AssetID=RC011055061033</a><br>Then: <a href="http://www.internet4classrooms.com/excel_create_chart.htm">http://www.internet4classrooms.com/excel_create_chart.htm</a><br>Then:
<a href="http://www.ncsu.edu/cals/agexed/aee226/functions3.xls">http://www.ncsu.edu/cals/agexed/aee226/functions3.xls</a><br><br>Keith Richardson<br><br><br>On Wed, 25 Jul 2007 10:26:36 +1000, <a href="mailto:itapps-request@edulists.com.au">
itapps-request@edulists.com.au</a> said:<br>> Send itapps mailing list submissions to<br>> <a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a><br>><br>> To subscribe or unsubscribe via the World Wide Web, visit
<br>> <a href="http://www.edulists.com.au/mailman/listinfo/itapps">http://www.edulists.com.au/mailman/listinfo/itapps</a><br>> or, via email, send a message with subject or body 'help' to<br>>
<a href="mailto:itapps-request@edulists.com.au">itapps-request@edulists.com.au</a><br>><br>> You can reach the person managing the list at<br>> <a href="mailto:itapps-owner@edulists.com.au">itapps-owner@edulists.com.au
</a><br>><br>> When replying, please edit your Subject line so it is more specific<br>> than "Re: Contents of itapps digest..."<br>><br>><br>> Today's Topics:<br>><br>> 1. Excel query (Antonia Caridi)
<br>> 2. Excel resource (Mark Kelly)<br>> 3. RE: Photoshop CS (Jenny Antcliffe)<br>> 4. RE: Excel resource (Kent Beveridge)<br>><br>><br>> ----------------------------------------------------------------------
<br>><br>> Message: 1<br>> Date: Wed, 25 Jul 2007 08:53:47 +1000<br>> From: "Antonia Caridi" <<a href="mailto:ACaridi@sac.vic.edu.au">ACaridi@sac.vic.edu.au</a>><br>> Subject: [Year 12 IT Apps] Excel query
<br>> To: <<a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a>><br>> Message-ID: <<a href="mailto:46A70F9A.4B16.00C2.0@sac.vic.edu.au">46A70F9A.4B16.00C2.0@sac.vic.edu.au</a>><br>> Content-Type: text/plain; charset=ISO-8859-1
<br>><br>> Thanks to all those who responded to the Excel exercises request.<br>><br>> I have photocopied exercises from various sources and made a booklet.<br>> Lots of companies such as Microstar provide exercises and files for a
<br>> whole range of software.<br>><br>> Antonia<br>><br>> Antonia Caridi<br>> Sacre Coeur<br>> 172 Burke Road<br>> Glen Iris 3146<br>> Telephone 9885 4501<br>> Fax 9885 5936<br>><br>><br>
> èµ__________________________________________________________________________________<br>> This email and any attachments may be confidential and, if you are not<br>> the intended recipient you must not disclose or use the information in
<br>> this email. If received in error, please notify the sender immediately<br>> and delete the email and all copies. The school does not guarantee that<br>> this email is virus or error free. Any attached files are provided and
<br>> may only be used on the basis that the recipient assumes all<br>> responsibility for any loss, damage or consequence resulting directly or<br>> indirectly from the use of this email and/or attached files, whether
<br>> caused by the negligence of the sender or not. The content and opinions<br>> in this email are not necessarily those of Sacre Coeur.<br>> ____________________________________________________________________________________
<br>><br>><br>> ------------------------------<br>><br>> Message: 2<br>> Date: Wed, 25 Jul 2007 09:24:23 +1000<br>> From: Mark Kelly <<a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au
</a>><br>> Subject: [Year 12 IT Apps] Excel resource<br>> To: "Year 12 IT Applications Teachers' Mailing List"<br>> <<a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a>>
<br>> Message-ID: <<a href="mailto:46A68A27.90309@mckinnonsc.vic.edu.au">46A68A27.90309@mckinnonsc.vic.edu.au</a>><br>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br>><br>> I've mentioned this before, but a great Excel resource is Greg Bowden's
<br>> Guided Excel tutorials, available in PDF format at <a href="http://www.gct.com.au">http://www.gct.com.au</a>.<br>><br>><br>> --<br>> Mark Kelly<br>> Manager - Information Systems<br>> McKinnon Secondary College
<br>> McKinnon Rd McKinnon 3204, Victoria, Australia<br>> Direct line / Voicemail: 8520 9085<br>> School Phone +613 8520 9000<br>> School Fax +613 95789253<br>> kel AT <a href="http://mckinnonsc.vic.edu.au">
mckinnonsc.vic.edu.au</a><br>><br>> Webmaster - <a href="http://www.mckinnonsc.vic.edu.au">http://www.mckinnonsc.vic.edu.au</a><br>> IT Lecture notes: <a href="http://vceit.com">http://vceit.com</a><br>> Moderator: IT Applications Mailing List
<br>><br>> There are 10 kinds of people in the world: those who understand binary<br>> and those who don't.<br>><br>><br>><br>> ------------------------------<br>><br>> Message: 3<br>> Date: Wed, 25 Jul 2007 10:09:23 +1000
<br>> From: "Jenny Antcliffe" <<a href="mailto:jantcliffe@fintona.vic.edu.au">jantcliffe@fintona.vic.edu.au</a>><br>> Subject: RE: [Year 12 IT Apps] Photoshop CS<br>> To: "Year 12 IT Applications Teachers' Mailing List"
<br>> <<a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a>><br>> Message-ID:<br>> <<a href="mailto:1DB1B93F01DDA1488DD52F551A8BE820083477@IRIS.fintona.vic.edu.au">1DB1B93F01DDA1488DD52F551A8BE820083477@IRIS.fintona.vic.edu.au
</a>><br>> Content-Type: text/plain; charset="us-ascii"<br>><br>> Try <a href="http://www.watsoniapublishing.com.au/">http://www.watsoniapublishing.com.au/</a> - usually very good, but there<br>> is a host of free tutorials on the net.. regards, Jenny
<br>><br>><br>><br>> ________________________________<br>><br>> From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a><br>> [mailto:<a href="mailto:itapps-bounces@edulists.com.au">
itapps-bounces@edulists.com.au</a>] On Behalf Of Clare, Ian J<br>> Sent: Wednesday, 18 July 2007 9:44 AM<br>> To: Year 12 IT Applications Teachers' Mailing List<br>> Subject: [Year 12 IT Apps] Photoshop CS<br>
><br>><br>><br>> Hi All<br>><br>><br>><br>> Can anybody recommend a training manual for Photoshop CS. I have used<br>> GCT manuals but they only have one for Photoshop Elements.<br>><br>>
<br>><br>> Ian Clare<br>><br>> Information Technology Teacher<br>><br>> Casterton Secondary College<br>><br>> Ph 03 5581 1588 Fax 03 5581 1518<br>><br>> <a href="mailto:clare.ian.j@edumail.vic.gov.au">
clare.ian.j@edumail.vic.gov.au</a><br>> <BLOCKED::mailto:<a href="mailto:clare.ian.j@edumail.vic.gov.au">clare.ian.j@edumail.vic.gov.au</a>><br>><br>><br>><br>> Important - This email and any attachments may be confidential. If
<br>> received in error, please contact us and delete all copies. Before<br>> opening or using attachments check them for viruses and defects.<br>> Regardless of any loss, damage or consequence, whether caused by the
<br>> negligence of the sender or not, resulting directly or indirectly from<br>> the use of any attached files our liability is limited to resupplying<br>> any affected attachments. Any representations or opinions expressed are
<br>> those of the individual sender, and not necessarily those of the<br>> Department of Education.<br>><br>> _______________________________________________<br>> <a href="http://www.edulists.com.au">http://www.edulists.com.au
</a> - FAQ, resources, subscribe, unsubscribe<br>> IT Applications Mailing List kindly supported by<br>> <a href="http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html">http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html
</a><br>> <<a href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html%2">http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html%2</a><br>> 0> - Victorian Curriculum and Assessment Authority and
<br>> <a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology<br>> Teachers Association Inc<br>><br>> _________________________________________________<br>> The information contained in this e-mail message and any attached files
<br>> may be confidential information. If you are not the intended recipient<br>> any<br>> use, disclosure or copying of this e-mail is unauthorized. If you have<br>> received this e-mail in error, please notify the sender immediately by
<br>> reply e-mail and delete all copies of this transmission together with any<br>> attachments.<br>> _________________________________________________<br>> -------------- next part --------------<br>> An HTML attachment was scrubbed...
<br>> URL:<br>> <a href="http://www.edulists.com.au/pipermail/itapps/attachments/20070725/6be5d0d5/attachment-0001.html">http://www.edulists.com.au/pipermail/itapps/attachments/20070725/6be5d0d5/attachment-0001.html
</a><br>><br>> ------------------------------<br>><br>> Message: 4<br>> Date: Wed, 25 Jul 2007 10:31:09 +1000<br>> From: "Kent Beveridge" <<a href="mailto:kbeveridge@stbc.vic.edu.au">kbeveridge@stbc.vic.edu.au
</a>><br>> Subject: RE: [Year 12 IT Apps] Excel resource<br>> To: "Year 12 IT Applications Teachers' Mailing List"<br>> <<a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a>
><br>> Message-ID: <<a href="mailto:MINT9EXxt5BBBVhyemY00000960@mint.stbc.vic.edu.au">MINT9EXxt5BBBVhyemY00000960@mint.stbc.vic.edu.au</a>><br>> Content-Type: text/plain; charset="iso-8859-1"<br>>
<br>> Hey Mark, whats your cut? The other resources we have provided are free<br>> and not all of us have the dosh to go buying lots of you beaut resources!<br>> I and my budget certainly dont! The drought DID reach the country schools
<br>> you know.<br>> Except Adrian's book, but we all know ITS A BOOK. I havent purchased it<br>> but am considering it for next year, similarly, will consider now this<br>> excel resource.<br>> KB.<br>
><br>> Kent Beveridge,<br>> I.T. co-ordinator<br>> St. Brigids Catholic Sec. College<br>> Horsham<br>> email.. <a href="mailto:kbeveridge@stbc.vic.edu.au">kbeveridge@stbc.vic.edu.au</a><br>><br>> Wishes and Eggs, one you make and one you break! A bit like
<br>> promises.....<br>><br>> "This email and any attachments may be confidential. You must not<br>> disclose or use the information in this email if you are not the intended<br>> recipient. If you have received this email in error, please notify us
<br>> immediately and delete the email and all copies. The School does not<br>> guarantee that this email is virus or error free. The attached files are<br>> provided and my only be used on the basis that the user assumes all
<br>> responsibility for any loss, damage or consequence resulting directly or<br>> indirectly from the use of the attached files, whether caused by the<br>> negligence of the sender or not. The content and opinions in this email
<br>> are not necessarily those of the School."<br>><br>> ________________________________<br>><br>> From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> on behalf of Mark Kelly
<br>> Sent: Wed 7/25/2007 9:24 AM<br>> To: Year 12 IT Applications Teachers' Mailing List<br>> Subject: [Year 12 IT Apps] Excel resource<br>><br>><br>><br>> I've mentioned this before, but a great Excel resource is Greg Bowden's
<br>> Guided Excel tutorials, available in PDF format at <a href="http://www.gct.com.au">http://www.gct.com.au</a><br>> <<a href="http://www.gct.com.au/">http://www.gct.com.au/</a>> .<br>><br>><br>> --
<br>> Mark Kelly<br>> Manager - Information Systems<br>> McKinnon Secondary College<br>> McKinnon Rd McKinnon 3204, Victoria, Australia<br>> Direct line / Voicemail: 8520 9085<br>> School Phone +613 8520 9000
<br>> School Fax +613 95789253<br>> kel AT <a href="http://mckinnonsc.vic.edu.au">mckinnonsc.vic.edu.au</a><br>><br>> Webmaster - <a href="http://www.mckinnonsc.vic.edu.au">http://www.mckinnonsc.vic.edu.au</a>
<br>> <<a href="http://www.mckinnonsc.vic.edu.au/">http://www.mckinnonsc.vic.edu.au/</a>><br>> IT Lecture notes: <a href="http://vceit.com">http://vceit.com</a> <<a href="http://vceit.com/">http://vceit.com/
</a>><br>> Moderator: IT Applications Mailing List<br>><br>> There are 10 kinds of people in the world: those who understand binary<br>> and those who don't.<br>><br>> _______________________________________________
<br>> <a href="http://www.edulists.com.au">http://www.edulists.com.au</a> <<a href="http://www.edulists.com.au/">http://www.edulists.com.au/</a>> - FAQ,<br>> resources, subscribe, unsubscribe<br>> IT Applications Mailing List kindly supported by
<br>> <a href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html">http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</a> -<br>> Victorian Curriculum and Assessment Authority and
<br>> <a href="http://www.vitta.org.au">http://www.vitta.org.au</a> <<a href="http://www.vitta.org.au/">http://www.vitta.org.au/</a>> - VITTA Victorian<br>> Information Technology Teachers Association Inc<br>
><br>><br>><br>> -------------- next part --------------<br>> A non-text attachment was scrubbed...<br>> Name: not available<br>> Type: application/ms-tnef<br>> Size: 6421 bytes<br>> Desc: not available
<br>> Url :<br>> <a href="http://www.edulists.com.au/pipermail/itapps/attachments/20070725/2eacba8d/attachment.bin">http://www.edulists.com.au/pipermail/itapps/attachments/20070725/2eacba8d/attachment.bin</a><br>>
<br>> ------------------------------<br>><br>> _______________________________________________<br>> itapps mailing list<br>> <a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a><br>> <a href="http://www.edulists.com.au/mailman/listinfo/itapps">
http://www.edulists.com.au/mailman/listinfo/itapps</a><br>><br>><br>> End of itapps Digest, Vol 29, Issue 35<br>> **************************************<br>Keith Richardson<br><br><br>_______________________________________________
<br><a href="http://www.edulists.com.au">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>IT Applications Mailing List kindly supported by<br><a href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html">
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority and<br><a href="http://www.vitta.org.au">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc
<br></blockquote></div><br><br clear="all"><br>-- <br>Roland Gesthuizen - ICT Coordinator - Westall Secondary College<br><a href="http://www.westallsc.vic.edu.au">http://www.westallsc.vic.edu.au</a><br><br>"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