[Year 12 IT Apps] Data type for postcode

Thu May 30 08:52:08 EST 2013

In Access a validation rule can be used to "range check" a postcode entered 
as text:

Like "[0,2-9]###"

Allows only four digits starting with 0 or 2 to 9

Robert Hind
retired

----- Original Message ----- 
From: "Anthony Sullivan" <asullivan at tps.vic.edu.au>
To: <itapps at edulists.com.au>
Sent: Thursday, May 30, 2013 8:23 AM
Subject: Re: [Year 12 IT Apps] Data type for postcode

> Maybe they should
>
> 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...
>
>
> Anthony Sullivan
> Head of Information Technology
> 20 Wooralla Drive, Mt. Eliza, Vic, 3930
> T: 03 9788 7796 | F: 03 9787 7646 | asullivan at tps.vic.edu.au | 
> www.tps.vic.edu.au
>
>
>
> 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.
>
>
>
>
>
> -----Original Message-----
> From: itapps-bounces at edulists.com.au 
> [mailto:itapps-bounces at edulists.com.au] On Behalf Of 
> itapps-request at edulists.com.au
> Sent: Thursday, 30 May 2013 6:05 AM
> To: itapps at edulists.com.au
> Subject: itapps Digest, Vol 99, Issue 29
>
> Send itapps mailing list submissions to
>        itapps at edulists.com.au
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://www.edulists.com.au/mailman/listinfo/itapps
> or, via email, send a message with subject or body 'help' to
>        itapps-request at edulists.com.au
>
> You can reach the person managing the list at
>        itapps-owner at edulists.com.au
>
> When replying, please edit your Subject line so it is more specific than 
> "Re: Contents of itapps digest..."
>
>
> Today's Topics:
>
>   1. Re: Data type for postcode (Mark Scott)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 30 May 2013 06:03:39 +1000
> From: Mark Scott <msc at luther.vic.edu.au>
> Subject: Re: [Year 12 IT Apps] Data type for postcode
> To: "Year 12 IT Applications Teachers' Mailing List"
>        <itapps at edulists.com.au>
> Message-ID:
> 
> <8EB7758DBE426346943A36370038F9B90124009477FE at lcexch02.luther.local>
> Content-Type: text/plain; charset="windows-1252"
>
> And that should be the end of the argument.
>
> Postcodes are entered as text not numbers.
>
> Mark Scott
> Luther College
>
>
>
> Mark Scott
> Daily Administrator
> Luther
> Plymouth Road
> Croydon Hills Victoria 3136
>
> Luther
> Telephone (03) 9724 2000
> Direct Line (03) 9724 2023
> www.luther.vic.edu.au<http://www.luther.vic.edu.au/>
>        [cid:luther_college_email8e06bb] <http://www.luther.vic.edu.au/>
>
> Please consider the environment before printing this email.
>
> This email and any attachments may contain privileged and confidential 
> information.
> 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.
>
>
> ________________________________
> From: itapps-bounces at edulists.com.au [itapps-bounces at edulists.com.au] On 
> Behalf Of Wayne Eglinton [wayne.eglinton at ntschools.net]
> Sent: Wednesday, May 29, 2013 9:15 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Data type for postcode
>
> FYI
>
> 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!!!
>
> Food for thought for you & your students.
>
> Regards,
>
> Wayne Eglinton
>
> OLSH College
> P.O. Box 2508
> Traeger Ave.
> Alice Springs NT 0871
>
> P 08 8950 8555
> M 0406 357 972
>
> ________________________________
> From: itapps-bounces at edulists.com.au [itapps-bounces at edulists.com.au] On 
> Behalf Of Stuart Walkerden (STUW) [stuw at huntingtower.vic.edu.au]
> Sent: 28 May 2013 13:20
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Data type for postcode
>
> 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.
>
> Stuart Walkerden
> Huntingtower
>
> From: itapps-bounces at edulists.com.au 
> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Athena Spyratos
> Sent: Tuesday, 28 May 2013 7:47 AM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: [Year 12 IT Apps] Data type for postcode
>
> Fellow IT teachers.
> 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?
> Athena
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: 
> http://www.edulists.com.au/pipermail/itapps/attachments/20130530/4be33c97/attachment.html
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: luther_college_email8e06bb
> Type: image/png
> Size: 12076 bytes
> Desc: luther_college_email8e06bb
> Url : 
> http://www.edulists.com.au/pipermail/itapps/attachments/20130530/4be33c97/luther_college_email8e06bb.png
>
> ------------------------------
>
> _______________________________________________
> itapps mailing list
> itapps at edulists.com.au
> http://www.edulists.com.au/mailman/listinfo/itapps
>
>
> End of itapps Digest, Vol 99, Issue 29
> **************************************
>
>
>
> _______________________________________________
> 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 <br>
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers 
> Association Inc <br>
> http://www.swinburne.edu.au/ict/schools - Swinburne University
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2013.0.3343 / Virus Database: 3184/6367 - Release Date: 05/29/13
> 