<!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 http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.17092" name=GENERATOR><!--[if !mso]>
<STYLE>v\:* {
BEHAVIOR: url(#default#VML)
}
o\:* {
BEHAVIOR: url(#default#VML)
}
w\:* {
BEHAVIOR: url(#default#VML)
}
.shape {
BEHAVIOR: url(#default#VML)
}
</STYLE>
<![endif]-->
<STYLE><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Lucida Calligraphy";
panose-1:3 1 1 1 1 1 1 1 1 1;}
@font-face
{font-family:"Arial Narrow";
panose-1:2 11 6 6 2 2 2 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
span.emailstyle17
{mso-style-name:emailstyle17;
font-family:"Arial","sans-serif";
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></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 vLink=purple link=blue bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I agree - I'll be doing the same, besides its a
good balance.</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=elliot.mitchell.e@edumail.vic.gov.au
href="mailto:elliot.mitchell.e@edumail.vic.gov.au">Elliot, Mitchell E</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> Thursday, November 11, 2010 10:14
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Year 12 IT Apps] Unit 4
2011: RDBMS Part 2 or Spreadsheets</DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">I
was thinking of doing the same, Database unit 3 and spreadsheets unit 4 mostly
in case they can put both on the exam.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Arial Narrow','sans-serif'">Mitch
Elliot</SPAN></B><SPAN
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Lucida Calligraphy'"> </SPAN><SPAN
style="FONT-SIZE: 10pt; COLOR: gray; FONT-FAMILY: 'Arial','sans-serif'">| Buckley
Park College | Cooper St, Essendon 3040 | (03) 9331 9999 |
</SPAN><SPAN
style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Arial','sans-serif'"><A
title=mailto:%7Celliot.mitchell.e@edumail.vic.gov.au
href="mailto:elliot.mitchell.e@edumail.vic.gov.au"><SPAN
style="COLOR: gray">elliot.mitchell.e@edumail.vic.gov.au</SPAN></A></SPAN><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0cm; PADDING-BOTTOM: 0cm; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> <A
href="mailto:itapps-bounces@edulists.com.au">itapps-bounces@edulists.com.au</A>
[mailto:itapps-bounces@edulists.com.au] <B>On Behalf Of </B>Jackson
Bates<BR><B>Sent:</B> Thursday, 11 November 2010 9:59 AM<BR><B>To:</B>
'itapps@edulists.com.au'<BR><B>Subject:</B> [Year 12 IT Apps] Unit 4 2011:
RDBMS Part 2 or Spreadsheets<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<DIV>
<P class=MsoPlainText>Hi All,<o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText>Just out of curiosity, what are you all doing for unit
4: Databases or spreadsheets? And what is your rationale for
this?<o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText>--<o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText>A reminder from VCAA about the functions to be
demonstrated in both:<o:p></o:p></P>
<P class=MsoPlainText>(taken from <A
href="http://www.vcaa.vic.edu.au/vcaa/correspondence/bulletins/2010/July/vce_study.html#2">http://www.vcaa.vic.edu.au/vcaa/correspondence/bulletins/2010/July/vce_study.html#2</A>)<o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText><B>Relational database management system
</B><o:p></o:p></P>
<P class=MsoPlainText>The following functions apply to Unit 3:<o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText>•create tables<o:p></o:p></P>
<P class=MsoPlainText>•create relationships between tables<o:p></o:p></P>
<P class=MsoPlainText>•use a range of data types<o:p></o:p></P>
<P class=MsoPlainText>•electronic validation<o:p></o:p></P>
<P class=MsoPlainText>•create, edit and use queries<o:p></o:p></P>
<P class=MsoPlainText>•use of calculated fields<o:p></o:p></P>
<P class=MsoPlainText>•sort records or index on different
fields.<o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText><B>If students use a relational database management
system in Unit 4, the following additional functions apply:</B><o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText>•import/export of data<o:p></o:p></P>
<P class=MsoPlainText>•format data for display<o:p></o:p></P>
<P class=MsoPlainText>•create and edit a range of forms, including different
data types and controls<o:p></o:p></P>
<P class=MsoPlainText>•create and edit a range of formatted
reports.<o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText><B>Spreadsheets </B><o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText>•conditional formatting<o:p></o:p></P>
<P class=MsoPlainText>•formulae including simple functions (SUM, average,
maximum, minimum, count), conditional statements and lookup
tables<o:p></o:p></P>
<P class=MsoPlainText>•cell protection<o:p></o:p></P>
<P class=MsoPlainText>•graphs<o:p></o:p></P>
<P class=MsoPlainText>•insert notes/comments<o:p></o:p></P>
<P class=MsoPlainText>•macros<o:p></o:p></P>
<P class=MsoPlainText>•relative and absolute cell references<o:p></o:p></P>
<P class=MsoPlainText>•naming a range<o:p></o:p></P>
<P class=MsoPlainText>•electronic validation<o:p></o:p></P>
<P class=MsoPlainText>•sheet referencing<o:p></o:p></P>
<P class=MsoPlainText>•formatting/layout<o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText>--<o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText>FWIW I'll probably run with spreadsheets, just for the
sake of building wider usable skills, but I'm open to ideas.<o:p></o:p></P>
<P class=MsoPlainText> <o:p></o:p></P>
<P class=MsoPlainText>On a side note, I assume only the database knowledge
from unit 3 can be on the exam, since there is no way for the exam to
differentiate between those students that have done Databases Unit 4 or
Spreadsheets. Does my thinking seem sound on that?<o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Regards,</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'"> </SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Jackson
Bates</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">VCE IT
Applications</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Waverley Christian
College</SPAN><o:p></o:p></P></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=2>
</DIV>
<P class=MsoNormal> <o:p></o:p></P>
<DIV>
<P class=MsoNormal><IMG id=_x0000_i1026 alt=WCCSIG
src="http://www.wcc.vic.edu.au/images/WCCSig.JPG"
border=0><o:p></o:p></P></DIV>
<DIV>
<P style="LINE-HEIGHT: 10pt"><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial','sans-serif'">------------------------------------------<BR>DISCLAIMER:
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email in error please delete it immediately and notify
the system administrator on srvadm@wcc.vic.edu.au.<BR>WARNING: Although the
college has taken reasonable precautions to ensure no viruses are present in
this email, the college cannot accept responsibility for any loss or damage
arising from the use of this email or
attachments.<BR>------------------------------------------<o:p></o:p></SPAN></P></DIV></DIV>
<P></P>
<P><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.</P>
<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>