[Year 12 IT Apps] Re: itapps Digest, Vol 39, Issue 97
Margaret McArthur
mmcarthur at geelongcollege.vic.edu.au
Fri May 30 15:03:19 EST 2008
Hi Brett
Here is an exam I used with the solutions.
Margaret McArthur
The GEELONG College
>>> itapps-request at edulists.com.au 30/05/2008 2:41 pm >>>
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. RE: RE: [Year 12 IT Apps] Some more Excel goodies
(Elliott, Brett T)
2. eLearning Plan (Stephen Digby)
3. RE: eLearning Plan (McDonald, Debra A1)
----------------------------------------------------------------------
Message: 1
Date: Fri, 30 May 2008 13:50:47 +1000
From: "Elliott, Brett T" <elliott.brett.t at edumail.vic.gov.au>
Subject: RE: RE: [Year 12 IT Apps] Some more Excel goodies
To: "Year 12 IT Applications Teachers' Mailing List"
<itapps at edulists.com.au>, "Year 12 IT Applications
Teachers' Mailing
List" <itapps at edulists.com.au>
Message-ID:
<564AF4585FDF804EBFF3E3087D8962110133390E at EDUSM03.education.vic.gov.au>
Content-Type: text/plain; charset="iso-8859-1"
Hey guys,
I was wondering if anyone could help me out with a Unit 1 Exam. Thanks
for all your excellent resources so far.
Regards,
Brett Elliott
Grovedale College
________________________________
From: itapps-bounces at edulists.com.au on behalf of Geoff Moss
Sent: Thu 29/05/2008 12:10 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: RE: [Year 12 IT Apps] Some more Excel goodies
Thanks Phillip
I will attach copy and re-send message:
In preparation for Excel I have attached the Excel Functions workbook
in
which students can observe the application of a renge of functions.
I have updated the Tax Calculator to include the Tax schedules for
2008-9
and 2009-10 as provided in the last Federal Budget.
I have also added an extra worksheet: Loan calculator, using a PMT
function.
Students will be interested in calculating the repayments for loans and
the
total interest cost for loans.
Students (and teachers) can view prevailing formulas by hovering mouse
over
the respective cells.
The password (pw) is provided on all worksheets if you want to
unprotect
worksheets.
As in past years, I acknowledge that some of the worksheets are derived
from
Greg Bowden's textbook: Learning Microsoft Excel 2000.
Geoff Moss
RMIT
> Phillip Pike <pikep at bmg.vic.edu.au> wrote:
>
> Geoff- did you mean to have an attachment?
> Thanks
>
> Phil Pike
> Director of ICT
> Bacchus Marsh Grammar
> P (03) 5366 4800
> F (03) 53664850
>
>
> -----Original Message-----
> From: Geoff Moss [mailto:geoffmoss37 at optusnet.com.au]
> Sent: Wednesday, 28 May 2008 5:02 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Some more Excel goodies
>
> In preparation for Excel I have attached the Excel Functions workbook
in
> which students can observe the application of a renge of functions.
>
> I have updated the Tax Calculator to include the Tax schedules for
> 2008-9
> and 2009-10 as provided in the last Federal Budget.
>
> I have also added an extra worksheet: Loan calculator, using a PMT
> function.
> Students will be interested in calculating the repayments for loans
and
> the
> total interest cost for loans.
>
> Students (and teachers) can view prevailing formulas by hovering
mouse
> over
> the respective cells.
>
> The password (pw) is provided on all worksheets if you want to
unprotect
> worksheets.
>
> As in past years, I acknowledge that some of the worksheets are
derived
> from
> Greg Bowden's textbook: Learning Microsoft Excel 2000.
>
> Geoff Moss
> RMIT
>
>
>
> > Mark Kelly <kel at mckinnonsc.vic.edu.au> wrote:
> >
> > For those starting U4O1, here are some Excel tasks and challenges
for
> > the kidliwinkles to play with. They vary in level of difficulty.
> > The IF AND OR document is new.
> >
> > Have fun.
> > Mark
> >
> > --
> > Mark Kelly
> > Manager - Information Systems
> > McKinnon Secondary College
> > kel AT mckinnonsc.vic.edu.au
> > McKinnon Rd, McKinnon 3204, Victoria, Australia
> > Direct line / Voicemail: 8520 9085 Fax +613 9578 9253
> >
> > 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
> >
> > Only those who swim against the current know the current is there.
> > _______________________________________________
> > 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.au/vce/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
> _______________________________________________
> 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.au/vce/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
> _______________________________________________
> 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.au/vce/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
_______________________________________________
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.au/vce/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
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://www.edulists.com.au/pipermail/itapps/attachments/20080530/a357fb4f/attachment-0001.html
------------------------------
Message: 2
Date: Fri, 30 May 2008 14:19:46 +1000
From: "Stephen Digby" <digby.stephen.p at edumail.vic.gov.au>
Subject: [Year 12 IT Apps] eLearning Plan
To: "'Year 12 IT Applications Teachers' Mailing List'"
<itapps at edulists.com.au>
Message-ID:
<005d01c8c20c$65acaaf0$2bd1800a at cheltenhamsc.edu.vic.gov.au>
Content-Type: text/plain; charset="us-ascii"
For what it's worth....
Mountains of paper can be overturned in a day by a new ministerial
statement, so don't spend too much time on them.
Better to do and be damned.....
http://infonet.cheltsec.vic.edu.au/file.php/1/eLearning-Plan-Draft-DIG-2008-
05-12.doc
Try to maintain a record of what is happening and what is planned for
staff
as much as for planning....
====================================================
Stephen Digby, Learning Technology Manager
mailto: digby.stephen.p at edumail.vic.gov.au
Cheltenham Secondary College www.cheltsec.vic.edu.au
Ph: 613 955 55 955 Fx: 9555 8617 Mb: 0431-701-028
====================================================
Without tradition, art is a flock of sheep without a shepherd. Without
innovation, it is a corpse. Winston Churchill
-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au]
On Behalf Of SAMANTHA MITCHELL
Sent: Friday, 30 May 2008 1:02 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Off topic - 'Technical' hw/sw plan
Hi All,
We have just finished updating our elearning plan, and now we want to
try
and develop a IT 'Technical' strategic plan to support our educational
objectives. The idea is that we would have goals, responsibility
allocation
and timelines to plan our infrastructure/hardware/software (things
like
minimum hardware life, plans to purchase / upgrade etc..). Of course
I'm
hoping not to reinvent the wheel - maybe one of you guys have been down
this
path before & can share any documents?
Thank you,
Samantha Mitchell
Mildura Senior College
_______________________________________________
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.
------------------------------
Message: 3
Date: Fri, 30 May 2008 14:39:33 +1000
From: "McDonald, Debra A1" <mcdonald.debra.a1 at edumail.vic.gov.au>
Subject: RE: [Year 12 IT Apps] eLearning Plan
To: "Year 12 IT Applications Teachers' Mailing List"
<itapps at edulists.com.au>
Message-ID:
<3DC67F69A11422459953EBDC7D239BDA01E6DE67 at edusm06.education.vic.gov.au>
Content-Type: text/plain; charset="iso-8859-1"
for some reason this link can not find it's source... can we have a
link that works or do we need a password to get into this section?
Cheers
Debra McDonald
Network Manager
Lyndhurst Secondary College
Cranbourne
(03) 5996 0144
________________________________
From: itapps-bounces at edulists.com.au on behalf of Stephen Digby
Sent: Fri 30/05/08 2:19 PM
To: 'Year 12 IT Applications Teachers' Mailing List'
Subject: [Year 12 IT Apps] eLearning Plan
For what it's worth....
Mountains of paper can be overturned in a day by a new ministerial
statement, so don't spend too much time on them.
Better to do and be damned.....
http://infonet.cheltsec.vic.edu.au/file.php/1/eLearning-Plan-Draft-DIG-2008-
05-12.doc
Try to maintain a record of what is happening and what is planned for
staff
as much as for planning....
====================================================
Stephen Digby, Learning Technology Manager
mailto: digby.stephen.p at edumail.vic.gov.au
Cheltenham Secondary College www.cheltsec.vic.edu.au
Ph: 613 955 55 955 Fx: 9555 8617 Mb: 0431-701-028
====================================================
Without tradition, art is a flock of sheep without a shepherd. Without
innovation, it is a corpse. Winston Churchill
-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au]
On Behalf Of SAMANTHA MITCHELL
Sent: Friday, 30 May 2008 1:02 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Off topic - 'Technical' hw/sw plan
Hi All,
We have just finished updating our elearning plan, and now we want to
try
and develop a IT 'Technical' strategic plan to support our educational
objectives. The idea is that we would have goals, responsibility
allocation
and timelines to plan our infrastructure/hardware/software (things
like
minimum hardware life, plans to purchase / upgrade etc..). Of course
I'm
hoping not to reinvent the wheel - maybe one of you guys have been down
this
path before & can share any documents?
Thank you,
Samantha Mitchell
Mildura Senior College
_______________________________________________
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.au/vce/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
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 <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 <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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 7197 bytes
Desc: not available
Url :
http://www.edulists.com.au/pipermail/itapps/attachments/20080530/86af4c8a/attachment.bin
------------------------------
_______________________________________________
itapps mailing list
itapps at edulists.com.au
http://www.edulists.com.au/mailman/listinfo/itapps
End of itapps Digest, Vol 39, Issue 97
**************************************
--
Message protected by MailGuard: e-mail anti-virus, anti-spam and
content filtering.
http://www.mailguard.com.au/tt
Click here to report this message as spam:
https://login.mailguard.com.au/report/1v8Dp4OS5j/OLys143Q6hD2AlgxLRbC8/-2.599
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2008 IT midyear exam Solutions.docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 58571 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080530/30d2c949/2008ITmidyearexamSolutions-0001.bin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2008 IT midyear exam.docx
Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Size: 51556 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080530/30d2c949/2008ITmidyearexam-0001.bin
More information about the itapps
mailing list