[Yr11 Information Technology] Excel skills @ Yr11

[Geoff Moss]

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 
  To: Year 11 Information Technology Teachers' Mailing List 
  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

  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:

   

    a.. conditional formatting 
    b.. formulae including simple functions (SUM, average, maximum, minimum, count), conditional statements and lookup tables 
    c.. cell protection 
    d.. graphs 
    e.. insert notes/comments 
    f.. macros 
    g.. relative and absolute cell references 
    h.. naming a range 
    i.. electronic validation 
    j.. sheet referencing 
    k.. 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/yr11it/attachments/20110211/14c74515/attachment.html