[Yr11 Information Technology] Excel skills @ Yr11

Sat Feb 12 15:41:04 EST 2011

Of course the fly in the ointment is that year 11 IT is not a prerequisite
for ITA or SD, so you can't safely assume kids have *any* IT training at all
since birth.

Mark

On 11 February 2011 21:30, Margaret Lawson <margaret.lawson at konstantkaos.net
> wrote:

>  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 <Jolly.Michael.D at edumail.vic.gov.au>
> *To:* Year 11 Information Technology Teachers' Mailing List<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
>
> 03 5421 1100
>
> 0412 75 1984
>
>
>
> *From:* yr11it-bounces at edulists.com.au [
> mailto:yr11it-bounces at edulists.com.au <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 byhttp://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html - Victorian Curriculum and Assessment Authority andhttp://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
>
>
> _______________________________________________
> 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
>

-- 
Mark Kelly
Manager of ICT, Reporting, IT Learning Area
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au

VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist

If not as many people are getting Brasilians,
does this mean that waxing is waning?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/yr11it/attachments/20110212/f2032ecd/attachment.html 