[Year 12 IT Apps] Data type for postcode

[Andrew Shortell]

thanks
Points I had not considered 

Andrew (from where it is now 4 degrees outside)

Andrew Shortell
Educator
CRC Melton


shortell at get2me.net (This List)
@acsbear8 (twitter)
VITTA CoM Member





On 29/05/2013, at 9:15 PM, Wayne Eglinton <wayne.eglinton at ntschools.net> wrote:

> 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
> _______________________________________________
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20130529/26a69ba9/attachment-0001.html