[Year 12 IT Apps] Data type for postcode

Thu May 30 08:23:42 EST 2013

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