[Year 12 IT Apps] Qu A 15 - Litsa

[Geoff Moss]

Fully agree Stephen

The exercise was done due to a query whether we could create numbers with zero at the front of a phone number using the number data type format.

It does have its limitations as you point out and one would have to seriously consider how the data would be used in the future before "building them into the file formatting".

It also supports our original argument for MC q15 that the data type must be text for phone numbers AND for postcodes if we are to include ALL Australian postcodes (considering NT postcodes begin with zero).

------------
Postcodes are used by Australia Post to identify postal districts in Australia.  The NT system is organised such that: 
The numbering follows a broadly north-south pattern; 
Except in Darwin's suburban area, the final digit indicates: 
0 - major centre (Palmerston, Katherine, Tennant Creek, Alice Springs, Nhulunbuy) 
1 - PO box 
2 - region surrounding major centre 
3-9 - other towns in district 
Historically NT codes were in the 5750-5799 range, with a similar organisation except that it followed a south-north pattern, with Darwin being 5790, now it is 0800. The move to the new range occurred in the early 1990s.
----------------

Thanks for bringing the limitations to all our attention.

Regards
Geoff Moss



> Stephen Digby <digby.stephen.p at edumail.vic.gov.au> wrote:
> 
> Yes .... BUT 
> You are actually removing some characters from the phone number data and 
> building them into the file formatting.
> When you exported the data for use in another application, OR needed to 
> utilise a different starting digit at some future date, then
> all previously entered data would then be revealed to be incomplete in 
> terms of their ability to connect to the correct phone.
> 
> ====================================================
> Stephen Digby, Learning Technology Manager
> mailto: admin at cheltsec.vic.edu.au 
> Cheltenham Secondary College www.cheltsec.vic.edu.au
> Ph: 613 955 55 955  Fx: 9555 8617 Mb: 0431-701-028
> ====================================================
> I liked "Slaughterhouse 5", but I can't find the first four anywhere.  
> NOT a Steven Wright joke (a look alike from Steve Connelly) 
> 
> 
> 
> -----Original Message-----
> From: itapps-bounces at edulists.com.au 
> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Geoff Moss
> Sent: Thursday, 15 November 2007 12:08 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: [Year 12 IT Apps] Qu A 15 - Litsa
> 
> Hi Litsa
> 
> I have attached a Word document showing the input masks as well as 
> another copy of the Access File: db11.mdb to demonstrate what I
> did to enter phone numbers using both text and number data types.
> 
> Additionally, I created 2 extra fields to enable entry of an area code 
> as well as a phone number.
> 
> Using the input mask forces the "0" at the start of the the area code.  
> This could also be used for mobile phone numbers.
> 
> Regards
> 
> Geoff Moss
> RMIT
> 
> 
> 
> > Litsa Tzelepis <htzelepis at msj.melb.catholic.edu.au> wrote:
> > 
> > hi geoff,
> > thank-you but i can't access it - don't worry i'll work it out.
> > thanks just the same - have a good day, litsa :)
> >   ----- Original Message ----- 
> >   From: Geoff Moss 
> >   To: Year12 MailingList 
> >   Sent: Wednesday, November 14, 2007 8:18 PM
> >   Subject: RE: [Year 12 IT Apps] Qu A 15 - Litsa
> > 
> > 
> >   Hi Litsa
> > 
> >   Just in case you have a high security setting I have zipped the file 
> 
> > so you can receive the file.
> > 
> >   Regards
> > 
> >   Geoff Moss
> >   RMIT
> >   _______________________________________________ 
> >   http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
> >   IT Applications Mailing List kindly supported by 
> >   http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html - 
> > Victorian Curriculum and Assessment Authority and
> >   http://www.vitta.org.au - VITTA Victorian Information Technology 
> > Teachers Association Inc
> 
> 
> 
> 
> 
> 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.auvce/studies/infotech/itapplications3-4.html - 
> Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology 
> Teachers Association Inc