[Yr11 Information Technology] Excel skills @ Yr11

[Jolly, Michael D]

OK, not deluged with responses, so...

  ...I was thinking of omitting lookup, cell protection, macros, and
naming ranges until Year 12 - any comments?

 

Mike Jolly

Year 9 Co-ordinator

Kyneton Secondary College

jolly.michael.d at edumail.vic.gov.au

03 5421 1100

0412 75 1984

 

From: yr11it-bounces at edulists.com.au
[mailto:yr11it-bounces at edulists.com.au] On Behalf Of Jolly, Michael D
Sent: Friday, 11 February 2011 10:16 AM
To: yr11it at edulists.com.au
Subject: [Yr11 Information Technology] Excel skills @ Yr11

 

Reading last July's VCAA bulletin, the following was listed as required
knowledge for IT Apps:

 

*	conditional formatting
*	formulae including simple functions (SUM, average, maximum,
minimum, count), conditional statements and lookup tables
*	cell protection
*	graphs
*	insert notes/comments
*	macros
*	relative and absolute cell references
*	naming a range
*	electronic validation
*	sheet referencing
*	formatting/layout

I have Year 11's this year and for U1O1 I was wondering if the VCAA
cares what I teach or what others have done. 

I want to hold back some skills until Year 12. 

Anyone care to share what works with them?

 

Mike Jolly

Year 9 Co-ordinator

Kyneton Secondary College

jolly.michael.d at edumail.vic.gov.au

03 5421 1100

0412 75 1984

 

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.


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/yr11it/attachments/20110211/517ebc0f/attachment.html