[Year 12 IT Apps] Data type for postcode

[Litsa Tzelepis]

Just jumping in at the last minute - for what it's worth and sorry if I
missed something.

 

Can't we just look at the data provided in a question and decide form there?

Like if a question said - what data type is this 0410 555 555 - that would
be text; 0410555555 - that would be number. 

It's pretty impossible to determine every possible scenario that a data item
can be? Especially a postcode.

 

A data type question should not be that complicated.

 

Litsa

 

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Wayne Eglinton
Sent: Wednesday, 29 May 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


-- 
 

IMPORTANT! This email and any attachments may be confidential. If received 
in error, please contact us and delete all copies. Mount St Joseph Girls' 
College does not represent or warrant that the attached files are free from 
computer viruses or other defects. The attached files are provided, and may 
only be used, on the basis that the user assumes all responsibility for any 
loss, damage or consequence resulting directly or indirectly from the use 
of the attached files, whether caused by the negligence of the sender or 
not. The liability of Mount St Joseph Girls' College is limited in any 
event to either the resupply of the attached files or the cost of having 
the attached files resupplied. Any representations or opinions expressed in 
this email are those of the individual sender, and not necessarily those of 
Mount St Joseph Girls' College.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20130530/108442b7/attachment-0001.html