<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19019">
<STYLE>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Wingdings;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page WordSection1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Arial","sans-serif"; FONT-SIZE: 12pt
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Arial","sans-serif"; FONT-SIZE: 12pt
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Arial","sans-serif"; FONT-SIZE: 12pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P {
FONT-FAMILY: "Times New Roman","serif"; MARGIN-LEFT: 0cm; FONT-SIZE: 12pt; MARGIN-RIGHT: 0cm; mso-style-priority: 99; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
P.MsoAcetate {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
LI.MsoAcetate {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
DIV.MsoAcetate {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Tahoma","sans-serif"; FONT-SIZE: 8pt; mso-style-priority: 99; mso-style-link: "Balloon Text Char"
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Arial","sans-serif"; COLOR: windowtext; mso-style-type: personal
}
SPAN.EmailStyle19 {
FONT-STYLE: normal; FONT-FAMILY: "Times New Roman","serif"; COLOR: windowtext; FONT-WEIGHT: normal; mso-style-type: personal-reply
}
SPAN.BalloonTextChar {
FONT-FAMILY: "Tahoma","sans-serif"; mso-style-priority: 99; mso-style-link: "Balloon Text"; mso-style-name: "Balloon Text Char"
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
OL {
MARGIN-BOTTOM: 0cm
}
UL {
MARGIN-BOTTOM: 0cm
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-AU link=blue bgColor=#ffffff vLink=purple>
<DIV><FONT size=2 face=Arial>Hi Tim,</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>"Decoding the definitions for consumption by
students is of course another matter"</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>We do need a relatively simple decoding, that is of
course VCAA approved. </FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>"the mathematical/academic gobbledy-gook" in many
of the various definitions of NF1-3 is a problem for us as teachers and for the
students.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>The most annoying thing is that if you design
a RDBS correctly from the start you don't need NF1-3 because the design takes
care of all that.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Robert Hind (Semi-retired) OOF, GOM</FONT></DIV>
<DIV><FONT size=2 face=Arial>and Access Database Designer<BR>Ashwood and
Traralgon<BR><A
href="mailto:robert@yinnar.com">robert@yinnar.com</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=timmer@melbpc.org.au
href="mailto:timmer@melbpc.org.au">Timmer-Arends</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">Year 12 IT Applications Teachers' Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, April 01, 2011 5:08
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Year 12 IT Apps] Sample
exam questionsandentity-relationship diagrams</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2 face=Arial>Hello Mark</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I'm curious to know what these conflicting
sources are.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I've followed Robert H's link and the page one
gets to doesn't actually define them but does describe a
(simplified) process to get to each NF - and what one gets from the
process does conform with NF defs. The links from this page do go to
definitions and they are in agreement with other sources I have looked at.
</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Mark K's quote is a definition of 2NF that
conforms to other definitions.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>The only difference I can see between various
versions I have read is the degree of mathematical/academic gobbledy-gook
involved.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>1NF, 2NF and 3NF were defined way back in the
seventies and because they were formed from a theoretical basis I don't think
they are going to have changed all that much.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>About the only thing that seems to have changed
greatly is the addition of another three NFs.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I think the issue is a problem with the question,
not with the consistency of the definitions. Decoding the definitions for
consumption by students is of course another matter...</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Regards</FONT></DIV>
<DIV><FONT size=2 face=Arial>Robert T-A</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=msc@luther.vic.edu.au href="mailto:msc@luther.vic.edu.au">Mark
Scott</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=itapps@edulists.com.au
href="mailto:itapps@edulists.com.au">Year 12 IT Applications Teachers'
Mailing List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, April 01, 2011 2:45
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Year 12 IT Apps] Sample
exam questions andentity-relationship diagrams</DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 11pt">Paula<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 11pt">This is good
stuff but we are still struggling with Question 3c<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 11pt">Any chance
of a VCAA definition of what actually goes in 1NF, 2NF and
3NF.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 11pt">The
definitions are different depending on which “source” you
use.<o:p></o:p></SPAN></P>
<DIV>
<P style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"
class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: black; FONT-SIZE: 11pt">thanks<BR>Mark
Scott<BR>Luther College<o:p></o:p></SPAN></P>
<P style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"
class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: black; FONT-SIZE: 11pt">PS
I suppose we could all wait for the guru (Mark Kelly) to provide an answer.
</SPAN><SPAN
style="FONT-FAMILY: Wingdings; COLOR: black; FONT-SIZE: 11pt">J</SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: black; FONT-SIZE: 11pt"><BR><BR><BR><o:p></o:p></SPAN></P>
<P style="mso-margin-top-alt: auto; mso-margin-bottom-alt: auto"
class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; COLOR: black; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 11pt"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"
lang=EN-US>From:</SPAN></B><SPAN
style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt" lang=EN-US>
itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <B>On
Behalf Of </B>Christophersen, Paula P<BR><B>Sent:</B> Friday, 1 April 2011
1:32 PM<BR><B>To:</B> Year 12 IT Applications Teachers' Mailing
List<BR><B>Subject:</B> [Year 12 IT Apps] Sample exam questions and
entity-relationship diagrams<o:p></o:p></SPAN></P></DIV></DIV>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><o:p> </o:p></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Dear colleagues<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>The examination specifications and some sample questions focusing
on new content in the study design are now on the VCAA
website:<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><A
href="http://www.vcaa.vic.edu.au/vcaa/vce/studies/infotech/it-applications/publications/IT-Apps-samp.pdf">http://www.vcaa.vic.edu.au/vcaa/vce/studies/infotech/it-applications/publications/IT-Apps-samp.pdf</A><o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Structurally the examination remains the same – two sections:
Section A multiple choice; Section B short and extended responses.
<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>I draw your attention to a couple of matters in the sample
questions:<o:p></o:p></SPAN></P>
<P style="TEXT-INDENT: -18pt; MARGIN-LEFT: 93pt; mso-list: l0 level1 lfo2"
class=MsoNormal><![if !supportLists]><SPAN
style="FONT-FAMILY: Symbol; FONT-SIZE: 9pt" lang=EN-US><SPAN
style="mso-list: Ignore">·<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><![endif]><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Question 4 focuses on an entity relationship diagram – this
hopefully clarifies recent concerns that have been
raised.<o:p></o:p></SPAN></P>
<P style="TEXT-INDENT: -18pt; MARGIN-LEFT: 93pt; mso-list: l0 level1 lfo2"
class=MsoNormal><![if !supportLists]><SPAN
style="FONT-FAMILY: Symbol; FONT-SIZE: 9pt" lang=EN-US><SPAN
style="mso-list: Ignore">·<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><![endif]><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Question 7 illustrates one way in which the examination can deal
with the choice of different software in Unit 4, Area of Study 1. Here a
common question is presented, and students select the software tool to
explain their answer.<o:p></o:p></SPAN></P>
<P style="TEXT-INDENT: -18pt; MARGIN-LEFT: 93pt; mso-list: l0 level1 lfo2"
class=MsoNormal><![if !supportLists]><SPAN
style="FONT-FAMILY: Symbol; FONT-SIZE: 9pt" lang=EN-US><SPAN
style="mso-list: Ignore">·<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><![endif]><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Question 9 is an example of an extended response (worth 8 marks)
with prompts to guide answers<o:p></o:p></SPAN></P>
<P style="TEXT-INDENT: -18pt; MARGIN-LEFT: 93pt; mso-list: l0 level1 lfo2"
class=MsoNormal><![if !supportLists]><SPAN
style="FONT-FAMILY: Symbol; FONT-SIZE: 9pt" lang=EN-US><SPAN
style="mso-list: Ignore">·<SPAN
style="FONT: 7pt 'Times New Roman'">
</SPAN></SPAN></SPAN><![endif]><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Question 12 is an example of the scope of a question on RDBMS –
the focus can only extent to what is covered in Unit 3. Again it illustrates
an extended response with prompts<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Regards<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Paula<o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>Paula Christophersen</SPAN><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>ICT Curriculum Manager</SPAN><SPAN
lang=EN-US><o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>VCAA</SPAN><SPAN lang=EN-US><o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>41 St Andrews Place</SPAN><SPAN lang=EN-US><o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>EAST MELBOURNE 3002</SPAN><SPAN lang=EN-US><o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt"
lang=EN-US>(03) 9651 4378</SPAN><SPAN lang=EN-US><o:p></o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt" class=MsoNormal><SPAN
lang=EN-US><o:p> </o:p></SPAN></P>
<P style="MARGIN-LEFT: 36pt"><B>Important - </B>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.<o:p></o:p></P></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>http://www.edulists.com.au
- FAQ, resources, subscribe, unsubscribe<BR>IT Applications Mailing List
kindly supported
by<BR>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html
- Victorian Curriculum and Assessment Authority
and<BR>http://www.vitta.org.au - VITTA Victorian Information
Technology Teachers Association Inc</BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>http://www.edulists.com.au
- FAQ, resources, subscribe, unsubscribe<BR>IT Applications Mailing List
kindly supported
by<BR>http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority
and<BR>http://www.vitta.org.au - VITTA Victorian Information Technology
Teachers Association Inc</BLOCKQUOTE></BODY></HTML>