[Year 12 IT Apps] Data type for TO numbers

Thu Jun 6 16:11:58 EST 2013

Over the years I have had people complain that a computer won't accept
the value they are putting in, when in fact they are entering the
letter O to represent the number zero. This is typically in an online
form where they are entering the number of children in a family, the
number of days of sick leave used etc.

 I've also had English teachers maintain that pronouncing zero as "oh"
was correct, so 11703 gets pronounced as one one seven oh three. They
tend to get upset about incorrect pronunciation of the letters h and z
, however.

Ken

On Thu, Jun 6, 2013 at 3:53 PM, Roland Gesthuizen <rgesthuizen at gmail.com> wrote:
> Crikey, I wondered about that too! Teaching Officer makes perfect sense. I
> notice you were careful with your typing TO0 ;-)
>
> The Tee Ohh number somehow morphed into a Tee Zero. I think it has happened
> at our college too (admin system ??)
>
> I enjoy explaining to students why I slash my zeros and sevens, can add this
> to the mix.
>
> Regards Roland
>
> Roland Gesthuizen | eLearning Leader
> Keysborough College DEECD
> http://about.me/rgesthuizen
>
> "Never doubt that a small group of thoughtful, committed citizens can change
> the world; indeed it is the only thing that ever has." --Margaret Mead
>
> On 05/06/2013, at 4:03 PM, Robert <robert at yinnar.com> wrote:
>
> But, Frank!
>
> Another interesting bit of data history. The TO numbers were originally just
> that. They were in fact the letters TO, for Teaching Officer, followed by a
> series of digits, which at one stage did seem to relate to initial year of
> registration. So I might have a TO number of TO0597754 - hope I haven't
> offended anyone here!
>
> More recently some bright spark decided to get rid of the T and at the same
> time changed the O to a 0 - so TO0597754 became 00597754.
>
> I shan't give vent to my problems over the years with Excel opening csv
> files. Just to comment on the old shorter student ids which might have
> included MAR01. Import that into Excel and it is automatically converted to
> a date Mar-01 :-(
>
> Robert Hind
> Retired
> Ex Traralgon and Ashwood
>
> ----- Original Message  -----
> From: Russo, Frank R
> To: Year 12 IT Applications Teachers' Mailing List
> Sent: Wednesday, June 05, 2013 3:40 PM
> Subject: Re: [Year 12 IT Apps] Data type for postcode
>
> Hi Laurie LOL the last time I looked my TO number wasn’t a postcode…..
>
> From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
> On Behalf Of Savage, John L
> Sent: Wednesday, 5 June 2013 3:32 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Data type for postcode
>
> Leading zeroes? Treat as text – I am speaking from experience here from
> dealing with hundreds of teacher T0 numbers and the wretched habit Excel has
> of dropping leading zeroes when you open a csv.
>
> Laurie
>
> From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
> On Behalf Of Litsa Tzelepis
> Sent: Wednesday, 5 June 2013 9:18 AM
> To: 'Year 12 IT Applications Teachers' Mailing List'
> Subject: Re: [Year 12 IT Apps] Data type for postcode
>
> Hello.
>
> I still think – look at the data provided in the exam – and then decide the
> best option.
> If it looks like this – 03 555 6789, it’s text, like this 035556789 it’s a
> number.
> For a couple of marks, it shouldn’t be this complicated.
>
> Clearly there are stacks of ways this can go – let’s agree to come up with a
> common sense way of answering a question.
>
> Just my 20c worth, Litsa J
>
>
> From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
> On Behalf OfMargaret Lawson
>
> Sent: Wednesday, 5 June 2013 1:49 AM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Data type for postcode
>
>
>
> Perhaps we should have another mailing list for post codes, judging by the
> discussion.
>
> Given that this will impact on the marking of exams, perhaps we can suggest
> that more detail is included into the next study design so that there are
> not these discrepancies in interpretation of the study design.
>
> :D
>
> Margaret
>
> <image001.jpg>
> Roland Gesthuizen
> 5 June 2013 12:18 AM
> Fake post office codes? Crikey, now I'll be up all night wondering if the
> dead letter office has a postoffice code.
>
> http://www.pio.gov.au/making-a-complaint/common-complaint-themes/lost-mail.php
>
> Regards Roland
>
> Roland Gesthuizen | eLearning Leader
> Keysborough College DEECD
> http://about.me/rgesthuizen
>
> "Never doubt that a small group of thoughtful, committed citizens can change
> the world; indeed it is the only thing that ever has." --Margaret Mead
>
>
>
> _______________________________________________
> 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
> <image002.jpg>
> ken price
> 4 June 2013 12:55 PM
> I am reliably told that 1964, the U.S. Postal Service granted Smokey
> Bear (the mascot for wildfire prevention) his own ZIP code: 20252. The
> US president also has a personal zip code.
>
> Perhaps there are also fake postcodes used in movies, in the way that
> US movie phone numbers usually begin with the fake prefix 555?
>
> Ken
> DoE Tasmania
> _______________________________________________
> 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
> <image002.jpg>
> Mark
> 4 June 2013 11:32 AM
> OK. I'm seriously thinking of compiling this thread into a series of
> textbooks, starting with: "The Joy of Postal Codes, Volume 1: the Database
> Storage Issues."
>
> The complete international postal code smorgasbord can be found here...
> http://en.wikipedia.org/wiki/List_of_postal_codes
>
> Mark
>
>
> <snip>
>
> --
> Mark Kelly
> mark AT vceit DOT com
> http://vceit.com
>
> _______________________________________________
> 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
> <image001.jpg>
> Roland Gesthuizen
> 3 June 2013 8:31 PM
> Now I am curious .. wondering out aloud if countries insist upon anything
> other than traditional alphanumeric characters?
>
> From memory in London, the two letters at the end of the postcode numbers
> were only used to help divide up the mail for the postal delivery routes.
> Nothing special but I may be wrong.
>
> Regards Roland
>
> Roland Gesthuizen | eLearning Leader
> Keysborough College DEECD
> http://about.me/rgesthuizen
>
> "Never doubt that a small group of thoughtful, committed citizens can change
> the world; indeed it is the only thing that ever has." --Margaret Mead
>
>
>
> _______________________________________________
> 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
> <image002.jpg>
> Andrew Shortell
> 3 June 2013 2:20 PM
> also in USA there are ZIP codes that begin with two leading zeros
>
> Quote:
> many of the lowest ZIP codes, which begin with '0', are in the New England
> region. Also in the '0' region are New Jersey (non-contiguous with the
> remainder of the '0' area), Puerto Rico, the US Virgin Islands and APO/FPO
> military addresses for personnel stationed in Europe, Africa, Southwest Asia
> and aboard vessels based in the waters adjoining those lands; APO/FPO
> addresses are also used by U.S. diplomatic and consulary facilities. The
> lowest ZIP code is in Holtsville, New York (00501, a ZIP code exclusively
> for the U.S. Internal Revenue Service center there).
>
> source http://en.wikipedia.org/wiki/Zip_Codes
>
> Also they too have postcodes/zip codes that cross state boundaries for post
> office convenience
>
> This has certainly become esoteric and thus fascinating!
> Andrew
>
> Andrew Shortell
> Educator
> CRC Melton
>
>
> shortell at get2me.net (This List)
> @acsbear8 (twitter)
> VITTA CoM Member
>
>
>
>
>
>
>
>
> _______________________________________________
> 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
>
>
> 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.
>
> Important - This email and any attachments may be confidential. If received
> in error, please contact us and delete all copies. Before opening or using
> attachments check them for viruses and defects. Regardless of any loss,
> damage or consequence, whether caused by the negligence of the sender or
> not, resulting directly or indirectly from the use of any attached files our
> liability is limited to resupplying any affected attachments. Any
> representations or opinions expressed are those of the individual sender,
> and not necessarily those of the Department of Education and Early Childhood
> Development.
>
>
> Important - This email and any attachments may be confidential. If received
> in error, please contact us and delete all copies. Before opening or using
> attachments check them for viruses and defects. Regardless of any loss,
> damage or consequence, whether caused by the negligence of the sender or
> not, resulting directly or indirectly from the use of any attached files our
> liability is limited to resupplying any affected attachments. Any
> representations or opinions expressed are those of the individual sender,
> and not necessarily those of the Department of Education and Early Childhood
> Development.
>
>
> ________________________________
>
> _______________________________________________
> 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/6383 - Release Date: 06/04/13
>
> _______________________________________________
>
> 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
>
>
>
> _______________________________________________
> 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

-- 
--
Dr Ken Price MACS CP ACCE Professional Associate.
President, TASITE http://www.tasite.tas.edu.au