[Year 12 IT Apps] U401 - macros in excel

[Kevork Krozian]

Hi Teresa,

 I would have to agree with Brett here. There is no point spending weeks
on how to write VBA code from scratch. I guess the parallel would be CSS
in the last SAC. Why spend so long on one skill that can be optionally
included or left out in the assessment or only covered at the surface ?
 Remember you are not assessing every skill but a selection.
 The evidence for this is:
  .... From this list ( software skills ) students should aim to select
and use functions that effectively and efficiently produce solutions and
information products. In their learning students are expected to
execute each listed function for a software tool, however, for
the assessment tasks, they are only required to demonstrate the
majority of functions.

http://www.vcaa.vic.edu.au/correspondence/bulletins/2008/february/2008FEBBUL.pdf


Keep well


> To be truthful Teresa I think the best way is simply to use the macro
> recorder to do some simple operations in a spreadsheet and then
> deconstruct the coding of the macros (alt F11) you have recorded by
> changing some of the parameters (cell range, cell colour.
> operator...whatever).
>
> It's probably a heretical way to teach it but I don't think it's worth
> going through VBA from first principals with Apps students, it's just
> not the focus of the course it seems to me.
>
> regards,
>
> Brett Groves
> ICT Manager
> Croydon Secondary College
>
> On 16/07/10 09:06, Peluso, Teresa T wrote:
>> Hi
>> I am looking for tutorials or activities using macros in excel.
>> Regards,
>> Teresa
>
> 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