<div>Text allows us to store postcodes and telephone numbers whilst controlling the formatting of our data; preceeding zero for postcodes as well symbols and spaces for phone numbers.</div>
<div> </div>
<div>Queries on postcodes can still be completed if the data type is text.</div>
<div> </div>
<div>"3805" will return 3805</div>
<div>"3805" - "5" will return 3800</div>
<div>(3805 - 5) will return 3800</div>
<div> </div>
<div>>="3803" And <="3807" will return anyone with the postcode 3803 to 3807</div>
<div>>=(3805-2) And <=(3805+2) will return anyone with the postcode 3803 to 3807</div>
<div> </div>
<div>Storing as Number would allow us to perform a more complex calculation on our data - but I can't think of any reason that we'd need to perform a complex calculation on either postcode or telephone numbers.</div>
<div><br>Peter Langham</div>
<div>Narre Warren South P-12 College<br></div>
<div class="gmail_quote">On Thu, May 30, 2013 at 9:06 AM, Christophersen, Paula P <span dir="ltr"><<a href="mailto:christophersen.paula.p@edumail.vic.gov.au" target="_blank">christophersen.paula.p@edumail.vic.gov.au</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">Oh I'm reading with interest. This is of particular importance for examination purposes - will take appropriate action.<br>
<br>Regards<br>paula<br><br>Paula Christophersen<br>Curriculum Manager, Digital Technologies<br>
<div class="im">Victorian Curriculum and Assessment<br>Authority<br></div>2 Lonsdale Street<br>MELBOURNE 3000<br>(03) 9032 1724<br>0407 043 110<br>
<div class="im"><br>-----Original Message-----<br>From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>] On Behalf Of Mark Scott<br>
Sent: Thursday, 30 May 2013 8:33 AM<br>To: 'Year 12 IT Applications Teachers' Mailing List'<br></div>
<div>
<div class="h5">Subject: Re: [Year 12 IT Apps] Data type for postcode<br><br>You reading this Paula?<br><br>Any comments?<br><br>Mark Scott<br>Luther College<br><br><br>Mark Scott<br>Daily Administrator<br><br>Plymouth Road<br>
Croydon Hills Victoria 3136<br><br><br>Telephone (03) 9724 2000<br>Direct Line (03) 9724 2023<br><a href="http://www.luther.vic.edu.au/" target="_blank">www.luther.vic.edu.au</a><br><br>Please consider the environment before printing this email.<br>
<br>This email and any attachments may contain privileged and confidential information.<br>If you are not the intended recipient you may not distribute or reproduce this email or attachments. If you have received this message in error please notify us by return mail.<br>
<br>-----Original Message-----<br>From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>] On Behalf Of Anthony Sullivan<br>
Sent: Thursday, 30 May 2013 8:24 AM<br>To: <a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a><br>Subject: Re: [Year 12 IT Apps] Data type for postcode<br><br>Maybe they should<br><br>But, in both recent IT Apps & SD exams there have been questions based on postcodes that involved range checks - which indicates to me that for the purpose of VCE IT - postcodes should maybe treated as numbers...<br>
<br><br>Anthony Sullivan<br>Head of Information Technology<br>20 Wooralla Drive, Mt. Eliza, Vic, 3930<br>T: 03 9788 7796 | F: 03 9787 7646 | <a href="mailto:asullivan@tps.vic.edu.au">asullivan@tps.vic.edu.au</a> | <a href="http://www.tps.vic.edu.au/" target="_blank">www.tps.vic.edu.au</a><br>
<br><br><br>Please consider the environment before printing this email, you will save 5g of paper, 250mL of water and at least 35gm of CO2 This message, including any attachments, is provided without responsibility in law for its accuracy or otherwise and without assumption of a duty of care by the school. Whilst every attempt has been made to ensure material in this e-mail message is free from computer viruses or other defects, the attached files are provided, and may only be used, on the basis that the user assumes responsibility for the use of the material transmitted. This e-mail is intended for the use of the named individual or entity and may contain confidential and privileged information. Any dissemination, distribution or copying by anyone other than the intended recipient of this e-mail is strictly prohibited. If this e-mail has been received in error then please notify The Peninsula School immediately and destroy the original message.<br>
<br><br><br><br><br>-----Original Message-----<br>From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>] On Behalf Of <a href="mailto:itapps-request@edulists.com.au">itapps-request@edulists.com.au</a><br>
Sent: Thursday, 30 May 2013 6:05 AM<br>To: <a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a><br>Subject: itapps Digest, Vol 99, Issue 29<br><br>Send itapps mailing list submissions to<br> <a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a><br>
<br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://www.edulists.com.au/mailman/listinfo/itapps" target="_blank">http://www.edulists.com.au/mailman/listinfo/itapps</a><br>or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:itapps-request@edulists.com.au">itapps-request@edulists.com.au</a><br><br>You can reach the person managing the list at<br> <a href="mailto:itapps-owner@edulists.com.au">itapps-owner@edulists.com.au</a><br>
<br>When replying, please edit your Subject line so it is more specific than "Re: Contents of itapps digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Data type for postcode (Mark Scott)<br><br><br>----------------------------------------------------------------------<br>
<br>Message: 1<br>Date: Thu, 30 May 2013 06:03:39 +1000<br>From: Mark Scott <<a href="mailto:msc@luther.vic.edu.au">msc@luther.vic.edu.au</a>><br>Subject: Re: [Year 12 IT Apps] Data type for postcode<br>To: "Year 12 IT Applications Teachers' Mailing List"<br>
<<a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a>><br>Message-ID:<br> <8EB7758DBE426346943A36370038F9B90124009477FE@lcexch02.luther.local><br>Content-Type: text/plain; charset="windows-1252"<br>
<br>And that should be the end of the argument.<br><br>Postcodes are entered as text not numbers.<br><br>Mark Scott<br>Luther College<br><br><br><br>Mark Scott<br>Daily Administrator<br>Luther<br>Plymouth Road<br>Croydon Hills Victoria 3136<br>
<br>Luther<br>Telephone (03) 9724 2000<br>Direct Line (03) 9724 2023<br><a href="http://www.luther.vic.edu.au/" target="_blank">www.luther.vic.edu.au</a><<a href="http://www.luther.vic.edu.au/" target="_blank">http://www.luther.vic.edu.au/</a>><br>
[cid:luther_college_email8e06bb] <<a href="http://www.luther.vic.edu.au/" target="_blank">http://www.luther.vic.edu.au/</a>><br><br>Please consider the environment before printing this email.<br><br>This email and any attachments may contain privileged and confidential information.<br>
If you are not the intended recipient you may not distribute or reproduce this email or attachments. If you have received this message in error please notify us by return mail.<br><br><br>________________________________<br>
From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>] On Behalf Of Wayne Eglinton [<a href="mailto:wayne.eglinton@ntschools.net">wayne.eglinton@ntschools.net</a>]<br>
Sent: Wednesday, May 29, 2013 9:15 PM<br>To: Year 12 IT Applications Teachers' Mailing List<br>Subject: Re: [Year 12 IT Apps] Data type for postcode<br><br>FYI<br><br>living in the NT ... I'm fully aware of the 0 lead character in postcodes. Too bad web-developers don't consider using text for post/zipcodes fields ... often we can't subscribe etc... It can seriously be a pain - and we just go to another website... bad for their business!!!<br>
<br>Food for thought for you & your students.<br><br>Regards,<br><br>Wayne Eglinton<br><br>OLSH College<br>P.O. Box 2508<br>Traeger Ave.<br>Alice Springs NT 0871<br><br>P 08 8950 8555<br>M 0406 357 972<br><br>________________________________<br>
From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>] On Behalf Of Stuart Walkerden (STUW) [<a href="mailto:stuw@huntingtower.vic.edu.au">stuw@huntingtower.vic.edu.au</a>]<br>
Sent: 28 May 2013 13:20<br>To: Year 12 IT Applications Teachers' Mailing List<br>Subject: Re: [Year 12 IT Apps] Data type for postcode<br><br>I reckon if it looks like a number, treat it as a number and use a number field type. Whether you perform calculations on it or not is irrelevant. I have always told my students to use postcode as a number and phone as text to allow for leading 0. I wasn?t aware of NT postcodes. I may have to change my line.<br>
<br>Stuart Walkerden<br>Huntingtower<br><br>From: <a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a> [mailto:<a href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</a>] On Behalf Of Athena Spyratos<br>
Sent: Tuesday, 28 May 2013 7:47 AM<br>To: Year 12 IT Applications Teachers' Mailing List<br>Subject: [Year 12 IT Apps] Data type for postcode<br><br>Fellow IT teachers.<br>Do we declare the data type for Postcode as number or text? In database, if we apply a validation rule for a Victorian postcode as being between 3000 and 3999, then we declare it as a number. However going over one of the past exam multiple choice questions, the answer they wanted for the data type for Postcode was text. Which answer are the examiners looking for?<br>
Athena<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://www.edulists.com.au/pipermail/itapps/attachments/20130530/4be33c97/attachment.html" target="_blank">http://www.edulists.com.au/pipermail/itapps/attachments/20130530/4be33c97/attachment.html</a><br>
-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: luther_college_email8e06bb<br>Type: image/png<br>Size: 12076 bytes<br>Desc: luther_college_email8e06bb<br>Url : <a href="http://www.edulists.com.au/pipermail/itapps/attachments/20130530/4be33c97/luther_college_email8e06bb.png" target="_blank">http://www.edulists.com.au/pipermail/itapps/attachments/20130530/4be33c97/luther_college_email8e06bb.png</a><br>
<br>------------------------------<br><br>_______________________________________________<br>itapps mailing list<br><a href="mailto:itapps@edulists.com.au">itapps@edulists.com.au</a><br><a href="http://www.edulists.com.au/mailman/listinfo/itapps" target="_blank">http://www.edulists.com.au/mailman/listinfo/itapps</a><br>
<br><br>End of itapps Digest, Vol 99, Issue 29<br>**************************************<br><br><br><br>_______________________________________________<br><a href="http://www.edulists.com.au/" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe IT Applications Mailing List kindly supported by <a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br> <a href="http://www.vitta.org.au/" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br> <a href="http://www.swinburne.edu.au/ict/schools" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<br>
<br>_______________________________________________<br><a href="http://www.edulists.com.au/" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe IT Applications Mailing List kindly supported by <a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br> <a href="http://www.vitta.org.au/" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br> <a href="http://www.swinburne.edu.au/ict/schools" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<br>
<br></div></div>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.<br>
<div class="HOEnZb">
<div class="h5"><br>_______________________________________________<br><a href="http://www.edulists.com.au/" target="_blank">http://www.edulists.com.au</a> - FAQ, resources, subscribe, unsubscribe<br>IT Applications Mailing List kindly supported by<br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank">http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html</a> - Victorian Curriculum and Assessment Authority <br><br>
<a href="http://www.vitta.org.au/" target="_blank">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br><a href="http://www.swinburne.edu.au/ict/schools" target="_blank">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University<br>
</div></div></blockquote></div><br>