<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"><base href="x-msg://907/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>I guess there is nothing like asking the source for information, somebody could write a letter to the UK post office for their final word or send them a polite Telex .o(sounds of crickets chirping)</div><div><br></div><div>I am often at pains to show students that the gems in Wikipedia are the links to the references cited at the bottom of each page and the often vibrant and illuminating discussions on the talk pages. Gets you right to the source documents and the issues to be unpacked about any topic.</div><div><div><div apple-content-edited="true">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br>Regards Roland<br><br><b>Roland Gesthuizen</b> | eLearning Leader <br>Keysborough College DEECD<br><a href="http://about.me/rgesthuizen">http://about.me/rgesthuizen</a></div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br>"Never doubt that a small group of thoughtful, committed citizens can change the world; indeed it is the only thing that ever has." --Margaret Mead</div></div></div>
</div>
<br><div><div>On 30/05/2013, at 11:25 AM, "Watson, Donald R" <<a href="mailto:watson.donald.r@edumail.vic.gov.au">watson.donald.r@edumail.vic.gov.au</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div lang="EN-AU" link="blue" vlink="purple" style="font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div class="WordSection1" style="page: WordSection1; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(31, 73, 125); ">Exactly<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><a name="_MailEndCompose"><span style="color: rgb(31, 73, 125); "> </span></a></div><div><div style="border-style: solid none none; border-top-width: 1pt; border-top-color: rgb(181, 196, 223); padding: 3pt 0cm 0cm; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><b><span lang="EN-US" style="font-size: 10pt; font-family: Tahoma, sans-serif; ">From:</span></b><span lang="EN-US" style="font-size: 10pt; font-family: Tahoma, sans-serif; "><span class="Apple-converted-space"> </span><a href="mailto:itapps-bounces@edulists.com.au" style="color: purple; text-decoration: underline; ">itapps-bounces@edulists.com.au</a><span class="Apple-converted-space"> </span>[mailto:itapps-<a href="mailto:bounces@edulists.com.au" style="color: purple; text-decoration: underline; ">bounces@edulists.com.au</a>]<span class="Apple-converted-space"> </span><b>On Behalf Of<span class="Apple-converted-space"> </span></b>Mark Scott<br><b>Sent:</b><span class="Apple-converted-space"> </span>Thursday, 30 May 2013 10:00 AM<br><b>To:</b><span class="Apple-converted-space"> </span>'Year 12 IT Applications Teachers' Mailing List'<br><b>Subject:</b><span class="Apple-converted-space"> </span>Re: [Year 12 IT Apps] database convention - postcodes as a text field in databases<o:p></o:p></span></div></div></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(31, 73, 125); ">Hi<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(31, 73, 125); "> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(31, 73, 125); ">Now do we have a debate about the worth of Wikipedia as a source of information?<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(31, 73, 125); "> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(31, 73, 125); ">Maybe another day.<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(31, 73, 125); "> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-family: Wingdings; color: rgb(31, 73, 125); ">J</span><span style="color: rgb(31, 73, 125); "><o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(31, 73, 125); "> </span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(31, 73, 125); ">Mark<o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="color: rgb(31, 73, 125); "> </span></div><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="400" style="width: 300pt; "><tbody><tr><td style="padding: 0cm; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><b><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(24, 70, 137); ">Mark Scott<span class="Apple-converted-space"> </span></span></b><b><span style="font-size: 7.5pt; font-family: Arial, sans-serif; color: rgb(24, 70, 137); "><br></span></b><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(24, 70, 137); ">Daily Administrator<br></span><span style="font-size: 5.5pt; font-family: Arial, sans-serif; color: white; ">Luther</span><span style="font-size: 12pt; font-family: 'Times New Roman', serif; "><o:p></o:p></span></div><div><p class="MsoNormal" style="margin: 0cm 0cm 12pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(128, 130, 133); ">Plymouth Road<br>Croydon Hills Victoria 3136<o:p></o:p></span></p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 5.5pt; font-family: Arial, sans-serif; color: white; ">Luther</span><span style="font-size: 12pt; font-family: 'Times New Roman', serif; "><o:p></o:p></span></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(128, 130, 133); ">Telephone (03) 9724 2000<br>Direct Line (03) 9724 2023<o:p></o:p></span></div><div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(128, 130, 133); "><a href="http://www.luther.vic.edu.au/" style="color: purple; text-decoration: underline; "><span style="font-size: 10pt; color: rgb(128, 130, 133); text-decoration: none; ">www.luther.vic.edu.au</span></a><o:p></o:p></span></div></div></div></td><td style="padding: 0cm; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; font-family: 'Times New Roman', serif; "><a href="http://www.luther.vic.edu.au/" style="color: purple; text-decoration: underline; "><span style="font-family: Arial, sans-serif; text-decoration: none; "><span><image001.png></span></span></a><o:p></o:p></span></div></td></tr></tbody></table><div style="margin-top: 7.5pt; float: left; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><b><span style="font-size: 7pt; font-family: Arial, sans-serif; color: rgb(202, 0, 58); ">Please consider the environment before printing this email.</span></b><span style="font-size: 12pt; font-family: 'Times New Roman', serif; "><o:p></o:p></span></div><p style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 3.75pt; line-height: 17px; "><span style="font-size: 7pt; line-height: 9px; font-family: Arial, sans-serif; color: rgb(128, 130, 133); ">This email and any attachments may contain privileged and confidential information.<span class="Apple-converted-space"> </span><br>If you are not the intended recipient you may not distribute or reproduce this email<span class="Apple-converted-space"> </span><br>or attachments. If you have received this message in error please notify us by return mail.<o:p></o:p></span></p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; font-family: 'Times New Roman', serif; "><br clear="all"><o:p></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><span style="font-size: 12pt; font-family: 'Times New Roman', serif; "> </span></div><div><div style="border-style: solid none none; border-top-width: 1pt; border-top-color: rgb(225, 225, 225); padding: 3pt 0cm 0cm; "><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><b><span lang="EN-US">From:</span></b><span lang="EN-US"><span class="Apple-converted-space"> </span><a href="mailto:itapps-bounces@edulists.com.au" style="color: purple; text-decoration: underline; ">itapps-bounces@edulists.com.au</a><span class="Apple-converted-space"> </span>[<a href="mailto:itapps-bounces@edulists.com.au" style="color: purple; text-decoration: underline; ">mailto:itapps-bounces@edulists.com.au</a>]<span class="Apple-converted-space"> </span><b>On Behalf Of<span class="Apple-converted-space"> </span></b>Watson, Donald R<br><b>Sent:</b><span class="Apple-converted-space"> </span>Thursday, 30 May 2013 9:45 AM<br><b>To:</b><span class="Apple-converted-space"> </span><a href="mailto:itapps@edulists.com.au" style="color: purple; text-decoration: underline; ">itapps@edulists.com.au</a><br><b>Subject:</b><span class="Apple-converted-space"> </span>[Year 12 IT Apps] database convention - postcodes as a text field in databases<o:p></o:p></span></div></div></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">Hello All,<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">The link below pretty much says it all.<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">T<b>he convention</b><span class="Apple-converted-space"> </span>is that postcodes should defined and be input as text.<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">Of course there could be circumstances in which a specialised database might need to use some ‘regional intelligence’ based on a postcode.<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">A mail drop to all postcodes between 3850 and 3860 covers my area of Gippsland for example. It saves time on listing 100’s of towns in a complicated case or nested if statement.<o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><a href="http://en.wikipedia.org/wiki/Postcodes_in_the_United_Kingdom" style="color: purple; text-decoration: underline; ">http://en.wikipedia.org/wiki/Postcodes_in_the_United_Kingdom</a><o:p></o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; "><o:p> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; ">Don<o:p></o:p></div><p style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><b>Important -<span class="Apple-converted-space"> </span></b>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.<o:p></o:p></p></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><br class="webkit-block-placeholder"></div><p style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><b>Important -<span class="Apple-converted-space"> </span></b>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.</p>_______________________________________________<br><a href="http://www.edulists.com.au">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">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">http://www.vitta.org.au</a> - VITTA Victorian Information Technology Teachers Association Inc <br><br><a href="http://www.swinburne.edu.au/ict/schools">http://www.swinburne.edu.au/ict/schools</a> - Swinburne University</div></blockquote></div><br></div></div></body></html>