[Year 12 IT Apps] U401 Apps help

[Brett Groves]

Thank you very much Antonia much appreciated!


On 12/07/10 17:23, Antonia Caridi wrote:
>> Hi Kevork and Brett and others.
>>      
> Attached are two U4 O1 tasks I have used in the past. Use and abuse.
>
> Antonia
>
>
>   Hi Brett,
>    
>>   Welcome along !
>> Having taken on IT Apps 6 weeks ago with no experience in the current
>> cycle I too feel I need a red ..... !
>> So, let us proceed hand in hand and see what we can dig up.
>> There are sample SACs on the VITTA CD . Do you have access to these ?
>> And yes, sadly I couldn't dig up any SAC41's on any email sent through
>> edulists in this cycle though there are some for SAC42 ...... .
>> I was looking at writing a SAC  at the end of the week or at least start
>> on modifying the VITTA scenarios to shape another SAC situation.
>> Waiting with you for a donation ...... :)
>> As for worksheets, skill activities and the like, I am also trying to
>> build up a set so happy to share.
>> I do have the question tasks and pages for the text from Potts that is
>> attached here to get moving and the great Mark Kelly has a good number of
>> presentations (ppt) covering the Key Knowledge.
>>
>> Speak soon no doubt
>>
>> Kevork
>>
>> From: itapps-bounces at edulists.com.au
>> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Brett Groves
>> Sent: Sunday, 11 July 2010 9:42 PM
>> To: Year 12 IT Applications Teachers' Mailing List
>> Subject: [Year 12 IT Apps] U401 Apps help
>>
>> Hi all,
>>
>> I am sitting here writing U4 Apps OC1 and being struck by a good deal of
>> insecurity (read OMG I'm doing it wrong!).
>>
>> I am trying to write it to include the keys skills below and using advice
>> from Mark Kellys 2008 Melb Uni lecture for a grading scheme.
>>
>> I have such an ability spread in this years group that I'm struggling to
>> figure exactly where to pitch it. This is my first year with Apps, last
>> year we did SD and I was lucky enough to have a class of evil genii that
>> made it easy to set the bar (well out of reach lol).
>>
>> There are no sample U401 SACs on Edulist to get a feel, I was hoping that
>> some kind soul might have a U401 SAC they could share for perusal
>> purposes.
>>
>> Alternatively are there QATS available for Apps and are they any good?
>> Thoughts?
>>
>> Thanks
>>
>> Brett Groves
>>
>> Don't you just love Sunday nights before the first day back.....wheres
>> that bottle of red?
>>
>> *         Lookup tables (specifically VLookup)
>>
>> *         conditional formatting
>>
>> *         conditional statements
>>
>> o    SUM, SUMIF, COUNT, COUNTIF
>>
>> o    IF, AND, OR
>>
>> *         cell protection
>>
>> *         graphs
>>
>> *         insert notes/comments
>>
>> *         macros
>>
>> *         relative and absolute cell references
>>
>> *         naming a range
>>
>> *         sheet referencing
>>
>> *         formatting/layout.
>>
>> *         Basic arithmetic operators
>>
>> *         Named cells, ranges
>>
>> *         Data validation
>>
>>
>> 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
>> IT Applications Mailing List kindly supported by
>> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
>> Victorian Curriculum and Assessment Authority and
>> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
>> Association Inc
>>      
> 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 St. Aloysius College.
>
> St. Aloysius College
> 31 Curran Street, North Melbourne, Australia
> P.O. Box 2072, Hotham Hill,
> North Melbourne, Vic. 3051
> Telephone: 03 9329 0411
> Facsimile: 03 9328 2801
> http://www.aloysius.vic.edu.au
>    
>
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc

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/itapps/attachments/20100712/cfcd1446/attachment.html