[Year 12 IT Apps] Macros in Excel

[Michael Torsello (Mr)]

Russell
I have always used macros with sorting sports ladders, usually footy or
netball.
Give the students some results, and they create ladders based on them.
I have students use the copy sheet function to build up four rounds of
results and one macro to sort the ladder in each round.


---------------------------------- 
With thanks 
Michael Torsello 
Director of Computing 
St Margaret's School, Berwick 
Ph: (03) 9703 8111 

I never made a mistake in my life; at least, never one that I couldn't
explain away afterwards. -- Rudyard Kipling 


-----Original Message-----
From: itapps-bounces at edulists.com.au
[mailto:itapps-bounces at edulists.com.au] On Behalf Of Russell Edwards
Sent: Wednesday, 25 July 2007 3:38 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Macros in Excel

Does anyone have any thoughts on common uses of macros in Excel?

I am struggling to come up with any examples that are generally  
applicable, and therefore worth putting in to student exercises.    I  
use macros occasionally but they are generally quite specific to the
particular job that spreadsheet is designed for.

About all I can think of would be setting the active cell to the first
input data cell upon opening, and inter-sheet navigation buttons.

thanks in advance

Russell
Whittlesea SC


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.
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe IT
Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
http://www.vitta.org.au  - VITTA Victorian Information Technology
Teachers Association Inc