[Year 12 IT Apps] U401 Apps help

[Geoff Moss]

Hi Andrew

Here are a few I use to demonstrate a range of functions:

1.  Driving in Victoria.xls - topical - introduces Nested IF functions and 
VLookups for traffic lights and speeding offences.  Data existes for 
students to develop drink driving and topping distance worksheets.

2.  Excel Functions Practice.xls - demonstrates how to create a sporing 
fixture using VLookup.  Delete the fixture to get the students to create 
their own.

3.  Excel Functions 2010 - contains a variety of illustrations of functions 
in use.

Enjoy

Geoff Moss
RMIT






----- Original Message ----- 
From: "Townsley, Andrew A" <townsley.andrew.a at edumail.vic.gov.au>
To: "Year 12 IT Applications Teachers' Mailing List" 
<itapps at edulists.com.au>
Sent: Monday, July 12, 2010 2:06 PM
Subject: Re: [Year 12 IT Apps] U401 Apps help


Hi,

This is for paid workbooks so I was looking for something free.

A.Townsley
townsley.andrew.a at edumail.vic.gov.au
Fountain Gate SC



-----Original Message-----
From: itapps-bounces at edulists.com.au on behalf of Antonia Caridi
Sent: Mon 12/07/2010 1:16 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] U401 Apps help

Andrew if you are looking for Excel exercises I don't have a suite of
these - I used to get my students to do selected tutorials/exercises from
an online resource from Microstar. If you are interested go to
http://www.microstarpublishing.com.au/Simplesteps.htm.

Lots of options available. Antonia.


> Thanks for that.
>
> What I am looking for is some small worksheets or daily exercises to do.
> I can write my own excel with vb macros but does anyone have anything more
> formally prepared.
> Usually from memory I just go through excel commands and add macros.
>
>
> A.Townsley
> townsley.andrew.a 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 and Early Childhood Development.
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
> Association Inc



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 St. Aloysius College.

St. Aloysius College
31 Curran Street, North Melbourne, Australia
P.O. Box 2072, Hotham Hill,
North Melbourne, Vic. 3051
Telephone: 03 9329 0411
Facsimile: 03 9328 2801
http://www.aloysius.vic.edu.au
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
IT Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - 
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers 
Association Inc


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 and Early Childhood 
Development.



--------------------------------------------------------------------------------


> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - 
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers 
> Association Inc 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Excel Functions Practice.xls
Type: application/vnd.ms-excel
Size: 25088 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20100712/f5dd70b6/attachment-0003.xls 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Driving in Victoria.xls
Type: application/vnd.ms-excel
Size: 102912 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20100712/f5dd70b6/attachment-0004.xls 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Excel Functions 2010.xls
Type: application/vnd.ms-excel
Size: 233472 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20100712/f5dd70b6/attachment-0005.xls