<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.6380" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello all</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>just to throw in my two cents worths</FONT></DIV>
<DIV><FONT face=Arial size=2>Someone wrote that the intended use ought to be the
guide, not a blanket rule - in generaI I would agree.</FONT></DIV>
<DIV><FONT face=Arial size=2>But,</FONT></DIV>
<DIV><FONT face=Arial size=2>1. if I store a postcode or phone number as text I
preserve its formatting. If for some reason I decide I want to do a numeric
calculation involving the 'number', it is an easy matter to call up a function
which translates numeric-like text into an actual number</FONT></DIV>
<DIV><FONT face=Arial size=2>2. on the other hand, if I store my postcode or
phone number as a number because I may want to perform some kind of numeric
calculation with it, then I have to build into my solution some knowledge about
the formatting that has been lost, and that could be a quite a bit of (needless)
programming if the 'number' has a complex format.</FONT></DIV>
<DIV><FONT face=Arial size=2>3.and finally, text is the most generic data type
there is, so it should be least likely to require massive overhaul if there are
future changes/additions to whatever coding system is being used, and it should
also be most amenable to accomodating exceptions that might occur within a
coding system.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2>Robert T-A</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=peterlangham1983@gmail.com
href="mailto:peterlangham1983@gmail.com">Peter Langham</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">Year 12 IT Applications Teachers' Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, May 30, 2013 9:46
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Year 12 IT Apps] Data type
for postcode</DIV>
<DIV><BR></DIV>
<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 class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">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>
<P>
<HR>
<P></P>_______________________________________________<BR>http://www.edulists.com.au
- FAQ, resources, subscribe, unsubscribe<BR>IT Applications Mailing List
kindly supported
by<BR>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority
<br><BR>http://www.vitta.org.au - VITTA Victorian Information
Technology Teachers Association Inc
<br><BR>http://www.swinburne.edu.au/ict/schools - Swinburne
University</BLOCKQUOTE></BODY></HTML>