[Year 12 IT Apps] U4 O1 - macros

[Smallacombe, Kate B]

Thanks Rob, what I meant was do you need to use a macro to then create a report or pay slip after the calculation of pay is done or is it enough in the sac to just have them do some calculations and vlookups?

Cheers,

Kate Smallacombe
Brighton Secondary College
120 Marriage Road
Brighton East 3187

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Rob Minato
Sent: Monday, 25 June 2012 10:14 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] U4 O1 - macros

The calc of pay in itself is done with formulas in the spreadsheet, not with macros.

You could use a macro to input the data: eg enter 'no of hrs worked' etc.

Regards

Rob

Robert Minato
Teacher
Arts and Technology Domain
Catholic College Wodonga
1 Bowman Crt
Wodonga Vic 3690
0260435546
rminato at ccw.vic.edu.au<mailto:rminato at ccw.vic.edu.au>
www.ccw.vic.edu.au<http://www.ccw.vic.edu.au>


I mourn the loss of thousands of precious lives, but I will not rejoice in the death of one, not even an enemy. Returning hate for hate multiplies hate, adding deeper darkness to a night already devoid of stars. Darkness cannot drive out darkness: only light can do that. Hate cannot drive out hate: only love can do that.
Martin Luther King Jnr

On 25/06/2012, at 9:59 AM, Smallacombe, Kate B wrote:


Hi,

I'm teaching IT Apps for the first time and am wondering if macro's are required for unit 4 outcome 1 if you use spreadsheets. For example, the study design example requires students to calculate pay, do they need to be able to create a pay slip for each employee? The VITTA example requires some reports.

Any advice you could offer would be much appreciated.

Cheers,

Kate Smallacombe
Brighton Secondary College
120 Marriage Road
Brighton East 3187



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 <br>
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc <br>
http://www.swinburne.edu.au/ict/schools - Swinburne University


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/20120625/f01560b7/attachment.html