[Year 12 IT Apps] Data type for postcode

[Andrew Shortell]

Have you looked at northern territory postcodes?

E.g. 0800 for Darwin

Then look at overseas postcodes... E.g. Canada  two digits, two letters two digits
E.g. UK two letters, two digits, two letters

Unless of course you want your software only work in Victoria?
Also when doing Victorian remember that Vic postcodes also include 8000 to 8999 and NSW 9000 to 9999 .. Students are interested to discover why

Andrew


Andrew Shortell
Educator
CRC Melton

shortell at get2me.net (lists)
andrew at get2me.net (personal)
@acsbear (twitter)
VITTA CoM member
Skype: acshortell

Sent from my iPad

On 28/05/2013, at 7:47 AM, Athena Spyratos <SP at boxhillhs.vic.edu.au> wrote:

> 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/20130528/18e3f94f/attachment.html