[Year 12 IT Apps] Re: itapps Digest, Vol 39, Issue 88

Thu May 29 10:24:49 EST 2008

Hi Geoff

Can you resend the attachment.  

Thank you 

Margaret McArthur
The Geelong College

>>> itapps-request at edulists.com.au 28/05/2008 5:22 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: Some more Excel goodies (Geoff Moss)
   2. SAC Correction Tool (Robert Mercer)

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

Message: 1
Date: Wed, 28 May 2008 17:01:53 +1000
From: Geoff Moss <geoffmoss37 at optusnet.com.au>
Subject: Re: [Year 12 IT Apps] Some more Excel goodies
To: "Year 12 IT Applications Teachers' Mailing List"
	<itapps at edulists.com.au>
Message-ID: <200805280701.m4S71rQf026885 at mail35.syd.optusnet.com.au>
Content-Type: text/plain

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 
> IT Lecture notes: 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 - 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

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

Message: 2
Date: Wed, 28 May 2008 15:31:41 +1000
From: "Robert Mercer" <rmercer at groupwise.swin.edu.au>
Subject: [Year 12 IT Apps] SAC Correction Tool
To: <itapps at edulists.com.au>
Message-ID: <483D7ADD.C0B5.00B9.0 at groupwise.swin.edu.au>
Content-Type: text/plain; charset="us-ascii"

Hi,

I think someone was asking about this tool I posted a little while ago.  Anyway here it is again. Enjoy.

Hello Everyone
Here is an Excel workbook I made a little while ago to help me mark SACs. Basically it makes new assessment sheets based on template and keeps track of all the students marks from those sheets on a summary sheet and makes it a bit easier to navigate to different student's assessment sheets too.  Anyhow have a play, it saved me a bit of time and effort, hopefully someone else finds it useful too. I included a little instruction sheet too.

Cheers,

Rob Mercer
ICT Outreach - Project Officer
Faculty of Information & Communication Technologies
Swinburne University of Technology
PO Box 218
Hawthorn VIC 3122 Australia

PH:  +61 3 9214 8768
FAX :+61 3 9214 5320
rmercer at swin.edu.au 

And don't forget about Swingame:
www.swingame.com 

-----
Swinburne University of Technology
CRICOS Provider Code: 00111D

NOTICE
This e-mail and any attachments are confidential and intended only for the use of the addressee. They may contain information that is privileged or protected by copyright. If you are not the intended recipient, any dissemination, distribution, printing, copying or use is strictly prohibited. The University does not warrant that this e-mail and any attachments are secure and there is also a risk that it may be corrupted in transmission. It is your responsibility to check any attachments for viruses or defects before opening them. If you have received this transmission in error, please contact us on +61 3 9214 8000 and delete it immediately from your system. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment.

Please consider the environment before printing this email.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: UXOX_Assessment.xls
Type: application/vnd.ms-excel
Size: 62464 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080528/a6d4486f/UXOX_Assessment.xls 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Assessment Mark Book Readme.doc
Type: application/msword
Size: 625152 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080528/a6d4486f/AssessmentMarkBookReadme.doc 

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

_______________________________________________
itapps mailing list
itapps at edulists.com.au 
http://www.edulists.com.au/mailman/listinfo/itapps 

End of itapps Digest, Vol 39, Issue 88
**************************************
-- 
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/1v7Rg2OaXT/6aoK7UPSFlcspeyXUoCgQT/-2.599 