[Year 12 IT Apps] Examination reports

[Robert]

And can I add to Mark's message by noting that Excel does not like "smart 
quotes", or curly quotes but only straight quotes, ie

=IF(C2>40,"YES," ")

Pedantic? Yes! But Excel, and other apps, will only accept exactly what they 
have been programmed to expect.

Robert Hind (Semi-retired)
Ashwood and Traralgon
robert at yinnar.com




----- Original Message ----- 
From: "Mark Kelly" <kel at mckinnonsc.vic.edu.au>
To: "Year 12 IT Applications Teachers' Mailing List" 
<itapps at edulists.com.au>
Sent: Friday, August 07, 2009 1:26 PM
Subject: Re: [Year 12 IT Apps] Examination reports


> Examiners' report, ITA Q12b:
>
> Quote
>
> Few students could correctly write the formula for the IF statement 
> =IF(C2>40, ‘YES’,’ ‘).
>
> End Quote
>
> And fewer examiners could either, apparently:  double quotes rather than 
> single quotes are needed (at least in Excel, which is the undeclared 
> standard for all spreadsheet questions in the exam).
>
> It does bug me when a commentary on what is correct and what is not gets 
> it wrong.
>
> Christophersen, Paula P wrote:
>> Dear colleagues
>>
>>  In case you are not aware, the examination reports for the 2008 exams in
>> IT apps and Software development are available at the following
>> addresses.
>>
>>  http://www.vcaa.vic.edu.au/vce/studies/infotech/it-applications/exams.ht
>> ml#H2N10037
>>
>>  http://www.vcaa.vic.edu.au/vce/studies/infotech/softwaredevel/exams.html
>> #H2N10037
>>
>>  Regards
>>
>> Paula
>>
>>  Paula Christophersen
>>
>> ICT Curriculum Manager
>>
>> VCAA
>>
>> 41 St Andrews Place
>>
>> EAST MELBOURNE 3002
>>
>> (03) 9651 4378
>>
>>  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.
>>
>
> -- 
> Mark Kelly
> Manager - Information Systems
> McKinnon Secondary College
> kel AT mckinnonsc.vic.edu.au
> McKinnon Rd, McKinnon 3204, Victoria, Australia
> Direct line / Voicemail: 8520 9085 Fax +613 9578 9253
>
> Webmaster - http://www.mckinnonsc.vic.edu.au
> IT Lecture notes: http://vceit.com
> Moderator: IT Applications Mailing List
>
> Why do people mis-spell 'grammar' and mispronounce 'pronuniciation'?
> _______________________________________________
> 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
>