[Year 12 IT Apps] Unit 3 2015

Thu Nov 6 09:48:37 EST 2014

I was impressed with FileMaker Pro at an ISTE conference I attended a couple of years ago. Very big in the states and I believe that there is an education version. Several on this list are using it. Kind of wish we did the same ...  

If you are running a small VCE IT orientation or what we call a "Headstart" course, try to ask that it kicks off at the same time for the different year levels. I have some reservations when the start is staggered for different year levels. Some of us have some units of work we could bundle, swap and share. Anybody else in the same boat?

—
Roland GESTHUIZEN
http://about.me/rgesthuizen

> On 6 Nov 2014, at 8:17 am, Poke, Michael C <poke.michael.c at edumail.vic.gov.au> wrote:
> 
> Hi all, 
> Thinking about our Year 11 to 12 orientation week coming up soon. Firstly,  I'm thinking about getting U3O2 out of the way first while the students are fresh and motivated. Anyone else think this is a good idea? 
> Secondly,  I'm still trying to decide on the most suitable RDMS for my Apple Mac school. I had plenty of headaches with both Libre Office and Open Office this year. Program crashes leading to last work were very demotivating for the students. Filemaker Pro seems like a very expensive option too. 
> 
> Cheers, 
> Michael Poke 
> Manor Lakes P-12 College 
> 
> On 5 Nov 2014 22:24, "itapps-request at edulists.com.au <mailto:itapps-request at edulists.com.au>" <itapps-request at edulists.com.au <mailto:itapps-request at edulists.com.au>> wrote:
> Send itapps mailing list submissions to
>         itapps at edulists.com.au <mailto:itapps at edulists.com.au>
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://www.edulists.com.au/mailman/listinfo/itapps <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 <mailto:itapps-request at edulists.com.au>
> 
> You can reach the person managing the list at
>         itapps-owner at edulists.com.au <mailto: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: First Normal Form (Robert Timmer-Arends)
>    2. HOLD THE DATE - BiG Day In @ RMIT - Thursday 28   May 2015
>       (Kerrie Bisaro)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 5 Nov 2014 18:13:45 +1100
> From: "Robert Timmer-Arends" <timmer at westnet.com.au <mailto:timmer at westnet.com.au>>
> Subject: Re: [Year 12 IT Apps] First Normal Form
> To: "Year 12 IT Applications Teachers' Mailing List"
>         <itapps at edulists.com.au <mailto:itapps at edulists.com.au>>
> Message-ID: <1F0AC1E4DEB34E919268198B478B58D8 at timmerarends>
> Content-Type: text/plain; charset="utf-8"
> 
> Hello all
> 
> There is one extra component to 1NF that I feel needs to be stated explicitly.The table must have a primary key; that is, a column or group of columns which uniquely identify a given row. This is important because without reference to a primary key, 2NF and 3NF are not possible.
> 
> And the definition about 'there may only be one datum' is correct as far it goes, but "16 Fred Street Melbourne 3000" can be a single datum. It depends on the design needs of the db.
> It many ways I find it best to incorporate some of OO terminology - a column is equilvalent to a class, and any individual field in the column can only contain one instance of that class.
> 
> So, for example, if the column were "address" and address was defined as "street address + suburb + post code" then "16 Fred Street Melbourne 3000" is one datum (one instance of the class 'address').
> Whether 'address' is further split or not has to do with search requirements, not normalisation.
> 
> So
> name        phone
> fred smith    345678000
>                   543265465
> suzy lang    101010101
> (primary key = name) is NOT 1NF (repeated phone number, or two instances of phone number in the same row)
> and
> name        phone1        phone2
> fred smith    345678000    543265465
> suzy lang    101010101
> (primary key = name) is NOT 1NF (different column names, but still two instances of the same class of data)
> but
> name        phone
> fred smith    345678000
> fred smith    543265465
> suzy lang    101010101
> (primary key = name+phone) IS 1NF (no repeating groups, but the primary key has to be extended. In a 'real db, because there could be many fred smiths and suzy langs, we would have a single ID field as a primary key, and because we most probably want to search on family name, we would probably split the name field)
> 
> Regards
> Robert T-A
> 
> ----- Original Message ----- 
>   From: Mark 
>   To: Year 12 IT Applications Teachers' Mailing List 
>   Sent: Wednesday, November 05, 2014 9:39 AM
>   Subject: Re: [Year 12 IT Apps] First Normal Form
> 
> 
>   Hi Stephanie. Now you know why I bailed out when I did  :-)
> 
> 
>   1NF is easy:
>    - there must be no repeated columns (fields) e.g. Contact person 1, Contact person 2, Contact person 3.
>    - there may only be one datum in any field - i.e. no "16kg" "3 minutes 56 seconds", "Large Size $4, Small $2.50", "16 Fred St, Melbourne, 3000".
> 
> 
>   2NF problems ONLY arise if you're silly enough to use a multi-field key (e.g. using firstname & familyname to uniquely identify people in a table). 
>   2NF problems never even arise if each table has its own dedicated key field (e.g. ID, account number). 
> 
> 
>   But anyway, kids are expected to know 2NF.
> 
> 
>   2NF requires:
>   - 1NF has already been achieved.
>   - Any non-key field in a table is dependent on ALL of the fields used as the primary key.
> 
> 
>   As usual, this means as little as American football, so an example is needed.
> 
> 
>   There's a table with the following fields. 1NF has already been achieved.
> 
> 
>   StudentID
>   SubjectID
>   Mark
>   SubjectName
> 
> 
>   e.g. (Hope the formatting is not mangled - wish I could insert a table)
>   STUDENTID     SUBJECTID    Mark    SubjectName
>   SMI0001       ENG          A+      English
>   SMI0001       MA           B       Maths
>   FRE0002       ENG          C       English
> 
> 
>   The table's key is STUDENTID and SUBJECTID (together) to uniquely identify each record in the table.
> 
> 
>   The (non-key) MARK field is dependent on both STUDENTID and SUBJECTID - i.e. to find out what a mark refers to, you need to know both the student and subject.
> 
> 
>   However, the (non-key) SUBJECTNAME field is dependent only the SUBJECTID - i.e. to find out what a subject name refers to, you only need the SUBJECTID. You don't need the STUDENTID.
> 
> 
>   So the (non-key) SUBJECTNAME field is dependent on part of the key (SUBJECTID) but not the whole key (STUDENTID+SUBJECTID).
> 
> 
>   So it fails 2NF.
> 
> 
>   To fix the problem, the table must be broken into two  - 
>   - MARKS_TABLE with STUDENTID+SUBJECTID as its key. It also contains the MARK non-key field.
>   - SUBJECTS_TABLE with SUBJECTID (primary key) and non-key SUBJECTNAME.
> 
> 
>   You then create a relationship between the MARKS table and the SUBJECTS table using their primary keys as the related fields.
>   Now, in the MARKS table, a Mark is dependent upon the entire key in its table (STUDENTID+SUBJECTID).
>   In the SUBJECTS table, a subject name is dependent on the entire key in its table (SUBJECTID).
> 
> 
>   Bingo. 2NF.
> 
> 
>   Hope that helps.
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>   On 5 November 2014 08:53, Stephanie Polan <pos at mckinnonsc.vic.edu.au <mailto:pos at mckinnonsc.vic.edu.au>> wrote:
> 
>     Good Morning everyone,
> 
> 
>     I know this is crazy... but my 12's are making me crazy, does anyone have any simple blunt help for Normal Form's ie 1NF 2NF. I've gone through my explanations and Mark Kelly's slide show and my patience and my students are still asking for clarification because of course they can learn and remember it for Friday!!! 
> 
> 
>     Thanks in advance
>     Stephanie Polan
> 
> 
> 
>     -- 
> 
>     Miss Polan
>     McKinnon SC
> 
>     _______________________________________________
>     http://www.edulists.com.au <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 <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority <br>
>     http://www.vitta.org.au <http://www.vitta.org.au/>  - VITTA Victorian Information Technology Teachers Association Inc <br>
>     http://www.swinburne.edu.au/ict/schools <http://www.swinburne.edu.au/ict/schools> - Swinburne University
> 
> 
> 
> 
> 
> 
>   -- 
> 
> 
> 
>   Mark Kelly
>   mark AT vceit DOT com
>   http://vceit.com <http://vceit.com/>
> 
> 
>   I love the sound of people's voices after they stop talking.
> 
> 
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> 
> 
>   _______________________________________________
>   http://www.edulists.com.au <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 <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority <br>
>   http://www.vitta.org.au <http://www.vitta.org.au/>  - VITTA Victorian Information Technology Teachers Association Inc <br>
>   http://www.swinburne.edu.au/ict/schools <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/20141105/fda5cefc/attachment-0001.html <http://www.edulists.com.au/pipermail/itapps/attachments/20141105/fda5cefc/attachment-0001.html> 
> 
> ------------------------------
> 
> Message: 2
> Date: Sun, 2 Nov 2014 21:36:55 +0000
> From: Kerrie Bisaro <Kerrie.Bisaro at acsfoundation.com.au <mailto:Kerrie.Bisaro at acsfoundation.com.au>>
> Subject: [Year 12 IT Apps] HOLD THE DATE - BiG Day In @ RMIT -
>         Thursday 28     May 2015
> To: Kerrie Bisaro <Kerrie.Bisaro at acsfoundation.com.au <mailto:Kerrie.Bisaro at acsfoundation.com.au>>
> Message-ID:
>         <2bde34b15cf4434b8f663f75b8c15516 at SINPR04MB187.apcprd04.prod.outlook.com <mailto:2bde34b15cf4434b8f663f75b8c15516 at SINPR04MB187.apcprd04.prod.outlook.com>>
>         
> Content-Type: text/plain; charset="us-ascii"
> 
> [BDI-Logo-TM-noBOSS]
> 
> 
> Attention Careers Advisers,
> IT Teachers & all Year 9-12 students
> interested in Technology
> 
> Save the Date!!
> 28 May 2015
> BiG Day In(tm)
> @ RMIT
> 
> 
> [RMIT]
> 
> 
> 
> The ACS Foundation and RMIT University are delighted to invite you and your students along to the BiG Day In IT Careers Conference in Storey Hall, RMIT University on Thursday 28 May 2015.
> 
> Join us to hear leading speakers from companies such as Westpac and WiseTech Global plus loads more to come, talking about the future of technology and how students can get involved in shaping the future.  Hear from cool industry speakers & visit exhibitor stands to learn about where a career in IT can take you - more speakers & exhibitors to be confirmed in early 2015 - don't miss out, book your seats early!!
> 
> Click HERE<http://acsfoundation.com.au/bdi/index.cfm?page=melb2015 <http://acsfoundation.com.au/bdi/index.cfm?page=melb2015>> to book your tickets
> 
> Further details on confirmed speakers & exhibitors will be issued in early 2015
> 
> www.thebigdayin.com.au<http://www.thebigdayin.com.au <http://www.thebigdayin.com.au<http://www.thebigdayin.com.au>>
> 
> [find us on facebook]<https://www.facebook.com/thebigdayin <https://www.facebook.com/thebigdayin>>
> 
> [http://disc.sci.gsfc.nasa.gov/images/twitter_logo]<https://twitter.com/TheBigDayIn <http://disc.sci.gsfc.nasa.gov/images/twitter_logo]%3Chttps://twitter.com/TheBigDayIn>>
> 
> [https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcT5IegWuLGxHMMT7PTwgUe5pzuNKHm3AaJKXvMJL9fQN1vmeQV1]<http://instagram.com/thebigdayin <https://encrypted-tbn3.gstatic.com/images?q=tbn:ANd9GcT5IegWuLGxHMMT7PTwgUe5pzuNKHm3AaJKXvMJL9fQN1vmeQV1]%3Chttp://instagram.com/thebigdayin>>
> 
> 
> Enquiries:   kerrie.bisaro at acsfoundation.com.au <mailto:kerrie.bisaro at acsfoundation.com.au><mailto:kerrie.bisaro at acsfoundation.com.au <mailto:kerrie.bisaro at acsfoundation.com.au>> or 02 8296 4444
> [NSW Dept of Communications]
> 
> [cid:image014.jpg at 01CFF741.399B55D0] <cid:image014.jpg at 01CFF741.399B55D0]>
> 
> 
> [ACSF Logo]
> 
> [WestpacGroup_Logo_RGB]
> 
> [WiseTech Logo - hi-res]
> 
> 
> 
> 
> 
> 
> 
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/attachment.html <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/attachment.html> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image009.jpg
> Type: image/jpeg
> Size: 5704 bytes
> Desc: image009.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image009.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image009.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image011.png
> Type: image/png
> Size: 21709 bytes
> Desc: image011.png
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image011.png <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image011.png> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image013.png
> Type: image/png
> Size: 13384 bytes
> Desc: image013.png
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image013.png <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image013.png> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image015.gif
> Type: image/gif
> Size: 61782 bytes
> Desc: image015.gif
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image015.gif <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image015.gif> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image017.jpg
> Type: image/jpeg
> Size: 10466 bytes
> Desc: image017.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image017.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image017.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image019.jpg
> Type: image/jpeg
> Size: 15539 bytes
> Desc: image019.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image019.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image019.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image002.jpg
> Type: image/jpeg
> Size: 11828 bytes
> Desc: image002.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image002.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image002.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image004.jpg
> Type: image/jpeg
> Size: 4311 bytes
> Desc: image004.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image004.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image004.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image006.jpg
> Type: image/jpeg
> Size: 2389 bytes
> Desc: image006.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image006.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image006.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image008.jpg
> Type: image/jpeg
> Size: 1794 bytes
> Desc: image008.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image008.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image008.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image010.jpg
> Type: image/jpeg
> Size: 2926 bytes
> Desc: image010.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image010.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image010.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image012.jpg
> Type: image/jpeg
> Size: 4224 bytes
> Desc: image012.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image012.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image012.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image014.jpg
> Type: image/jpeg
> Size: 2874 bytes
> Desc: image014.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image014.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image014.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image016.png
> Type: image/png
> Size: 12259 bytes
> Desc: image016.png
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image016.png <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image016.png> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image018.jpg
> Type: image/jpeg
> Size: 3212 bytes
> Desc: image018.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image018.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image018.jpg> 
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image020.jpg
> Type: image/jpeg
> Size: 4353 bytes
> Desc: image020.jpg
> Url : http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image020.jpg <http://www.edulists.com.au/pipermail/itapps/attachments/20141102/eb4b1e82/image020.jpg> 
> 
> ------------------------------
> 
> _______________________________________________
> itapps mailing list
> itapps at edulists.com.au <mailto:itapps at edulists.com.au>
> http://www.edulists.com.au/mailman/listinfo/itapps <http://www.edulists.com.au/mailman/listinfo/itapps>
> 
> 
> End of itapps Digest, Vol 117, Issue 6
> **************************************
> 
> 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 <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 <http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html> - Victorian Curriculum and Assessment Authority <br>
> http://www.vitta.org.au <http://www.vitta.org.au/>  - VITTA Victorian Information Technology Teachers Association Inc <br>
> http://www.swinburne.edu.au/ict/schools <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/20141106/499d8af6/attachment-0001.html 