[Yr11 Information Technology] Excel skills @ Yr11

[Margaret Lawson]

I would agree with the cohort, leave Macro's to Year 12 unless the class 
is capable.
In Year 12 the kids have so much more to contend with in a SAC than just 
skills, they have to demonstrate and communicate key knowledge points as 
well, so give them a head start and make sure that the tasks that you 
give them in Year 12 are allow them to access those higher order 
thinking skills that they need to score the top marks.

2 cents

Regards

Margaret

On 11/02/2011 3:48 PM, Geoff Moss wrote:
> Hi Mike
> While there is no precription to do so, I would include lookups, cell 
> protection and naming of cell ranges in the Year 11 course.  Some of 
> your students may not proceed to Year 12 and would miss learning some 
> important basic skills and functions of Excel, to their detriment in 
> using Excel effectively.
> You could add drop down menus for the Year 12 class and the insertion 
> of images and hyperlinks to enhance the Year 12 experience if all your 
> students proceed to Year 12 and have mastered the skills of Year 11.
> My  cents worth
> Geoff Moss
> RMIT
> ----- Original Message -----
>
>     *From:* Jolly, Michael D <mailto:Jolly.Michael.D at edumail.vic.gov.au>
>     *To:* Year 11 Information Technology Teachers' Mailing List
>     <mailto:yr11it at edulists.com.au>
>     *Sent:* Friday, February 11, 2011 11:41 AM
>     *Subject:* Re: [Yr11 Information Technology] Excel skills @ Yr11
>
>     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
>     <mailto: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>
>     [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.
>
>     ------------------------------------------------------------------------
>     _______________________________________________
>     http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
>     Year 11 It Mailing List kindly supported by
>     http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html
>     - Victorian Curriculum and Assessment Authority and
>     http://www.vitta.org.au  - VITTA Victorian Information Technology
>     Teachers Association Inc
>
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> Year 11 It Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html - Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc


-- 
Margaret Lawson

Konstant Kaos Designs

ABN 50 523 597 927

26 Nash Street
Northcote 3070
Victoria Australia
M: 0407 896309
P: 9489 6309

margaret.lawson at konstantkaos.net

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/yr11it/attachments/20110211/827f70b8/attachment-0001.html