[Yr11 Information Technology] yr11it Digest, Vol 71, Issue 17

Fri Feb 11 12:03:31 EST 2011

Hi Mike,

I like the sound of what your planning, I may in fact do the same!

Cheers 
Steph Polan
Kambrya College

-----Original Message-----
From: yr11it-bounces at edulists.com.au
[mailto:yr11it-bounces at edulists.com.au] On Behalf Of
yr11it-request at edulists.com.au
Sent: Friday, 11 February 2011 12:00 PM
To: yr11it at edulists.com.au
Subject: yr11it Digest, Vol 71, Issue 17

Send yr11it mailing list submissions to
	yr11it at edulists.com.au

To subscribe or unsubscribe via the World Wide Web, visit
	http://www.edulists.com.au/mailman/listinfo/yr11it
or, via email, send a message with subject or body 'help' to
	yr11it-request at edulists.com.au

You can reach the person managing the list at
	yr11it-owner at edulists.com.au

When replying, please edit your Subject line so it is more specific
than "Re: Contents of yr11it digest..."

Today's Topics:

   1. Excel skills @ Yr11 (Jolly, Michael D)
   2. Re: Excel skills @ Yr11 (Jolly, Michael D)

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

Message: 1
Date: Fri, 11 Feb 2011 10:16:03 +1100
From: "Jolly, Michael D" <Jolly.Michael.D at edumail.vic.gov.au>
Subject: [Yr11 Information Technology] Excel skills @ Yr11
To: <yr11it at edulists.com.au>
Message-ID:

<78F1B630C8713E48B4BCD3DAB8C2553D0554068D at edusm06.education.vic.gov.au>

Content-Type: text/plain; charset="us-ascii"

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://www.edulists.com.au/pipermail/yr11it/attachments/20110211/f48a4e6
8/attachment-0001.html 

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

Message: 2
Date: Fri, 11 Feb 2011 11:41:42 +1100
From: "Jolly, Michael D" <Jolly.Michael.D at edumail.vic.gov.au>
Subject: Re: [Yr11 Information Technology] Excel skills @ Yr11
To: "Year 11 Information Technology Teachers' Mailing List"
	<yr11it at edulists.com.au>
Message-ID:

<78F1B630C8713E48B4BCD3DAB8C2553D0554071B at edusm06.education.vic.gov.au>

Content-Type: text/plain; charset="us-ascii"

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/517ebc0
f/attachment-0001.html 

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

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

End of yr11it Digest, Vol 71, Issue 17
**************************************

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.