[Year 12 IT Apps] Exam Q B 11e

[Stephen Digby]

True.
Well Done
====================================================
Stephen Digby, Learning Technology Manager
mailto: admin at cheltsec.vic.edu.au 
Cheltenham Secondary College www.cheltsec.vic.edu.au <http://www.cheltsec.vic.edu.au/> 
Ph: 613 955 55 955  Fx: 9555 8617 Mb: 0431-701-028
====================================================
Don't be humble, you're not that great. Golda Meir 


  _____  

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of SAMANTHA MITCHELL
Sent: Wednesday, 28 November 2007 1:50 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Exam Q B 11e


Sorry if this has posted multiple times, I've been having trouble sending it.

 

Hi,

A student of mine has been mulling over the exam questions and has noticed a problem with the formula in short answer Q11e (Keith
has already mentioned it on the wiki).

If they want "to alert customers when their new bill is $100 or more than their previous bill"  the formula should be =If(B2>=(B3+
l00),"ALERT"," ").

I think the test data should be:

*	B2 (new bill)=300, B3 (previous bill)=200, C5=Nothing 

*	B2 (new bill)=301, B3 (previous bill)=200, C5=ALERT 

I could be wrong but it seems to me that the test data suggested on
http://www.mckinnonsc.vic.edu.au/vceit/postmortems/2007ita/index.htm and
http://infonet.cheltsec.vic.edu.au/file.php/1/ITA4-Exam-2007-VCAA-Answers-DIGv1.pdf
<http://webmail.milsen.vic.edu.au/exchweb/bin/redir.asp?URL=http://infonet.cheltsec.vic.edu.au/file.php/1/ITA4-Exam-2007-VCAA-Answer
s-DIGv1.pdf>  is wrong, maybe they should have swapped the cell references B2 & B3 in their suggested answers??? (apologies in to
Mark & Stephen - I really appreciate you both putting yourselves out there)

 

What so you think? My student spent some time pondering whether this was a sneaky question challenging him to notice the discrepancy
between the formula provided and the statement "to alert customers when their new bill is $100 or more than their previous bill" 

 

Samantha Mitchell

Mildura Senior College

_______________________________________________ 
http://www.edulists.com.au  <http://www.edulists.com.au> - FAQ, resources, subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html
<http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au  <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/20071128/e65d5b73/attachment-0001.html