[Yr11 Information Technology] Excel skills @ Yr11

[Mark KELLY]

I'd have to say that named cells & ranges are a really basic and important
early skill.  It makes spreadsheets SO much easier to read, and allows very
meaningful vlookups.  e.g. VLOOKUP(A4,taxtable,2)

I teach kids to use named ranges so they don't have to bother with those
hideous $ and ! sheet/cell references!

BTW - I'd do VLOOKUP.  Very valuable.  And I'd do cell protection.

Macros?  Yeah - leave them 'til year 12.

Cheers
Mark

On 11 February 2011 11:41, Jolly, Michael D <
Jolly.Michael.D at edumail.vic.gov.au> wrote:

>  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.
>
> _______________________________________________
> 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/20110211/4c06f947/attachment.html