<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html 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" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:"Arial Narrow";
panose-1:2 11 6 6 2 2 2 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.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.apple-style-span
{mso-style-name:apple-style-span;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{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;}
/* List Definitions */
@list l0
{mso-list-id:297498026;
mso-list-type:hybrid;
mso-list-template-ids:-397272814 67698703 940347192 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
margin-left:68.15pt;
text-indent:-14.15pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:108.0pt;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:216.0pt;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:324.0pt;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1
{mso-list-id:1353188694;
mso-list-type:hybrid;
mso-list-template-ids:-1045417228 940347192 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:68.2pt;
mso-level-number-position:left;
margin-left:64.35pt;
text-indent:-14.15pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
margin-left:108.0pt;
text-indent:-18.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
margin-left:144.0pt;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
margin-left:180.0pt;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
margin-left:216.0pt;
text-indent:-18.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
margin-left:252.0pt;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
margin-left:288.0pt;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
margin-left:324.0pt;
text-indent:-18.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:360.0pt;
mso-level-number-position:left;
margin-left:360.0pt;
text-indent:-18.0pt;
font-family:Wingdings;}
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 vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'>Hi Simone,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'>In the past I have asked my students to generate a combination of criteria and calculated queries.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'>Calculated Queries<o:p></o:p></span></b></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'>For example, for our practice, we created a database where customers booked tickets for a Musical/s. The students had to calculate the cost of the tickets depending on how many adult and child tickets they requested and they also had to determine whether a customer was eligible for a discount on their tickets, based on how many bookings they have made via the booking company. In the total cost, there was also a standard booking fee that needed to be included. These are outlined below:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:54.0pt;text-indent:-36.0pt;mso-list:l0 level2 lfo2'><![if !supportLists]><span style='font-size:10.0pt;font-family:Wingdings;color:#002060'><span style='mso-list:Ignore'>§<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'>Total Cost$ - The total cost of the booking, including the booking fee.<o:p></o:p></span></p><p class=MsoNormal style='margin-left:54.0pt;text-indent:-36.0pt;mso-list:l0 level2 lfo2'><![if !supportLists]><span style='font-size:10.0pt;font-family:Wingdings;color:#002060'><span style='mso-list:Ignore'>§<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'>Disc$ - The discount amount off the Total Cost$<o:p></o:p></span></p><p class=MsoNormal style='margin-left:54.0pt;text-indent:-36.0pt;mso-list:l0 level2 lfo2'><![if !supportLists]><span style='font-size:10.0pt;font-family:Wingdings;color:#002060'><span style='mso-list:Ignore'>§<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'>Actual Cost$ - the final cost deducting any discount amount<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'>The formulas:<o:p></o:p></span></p><p class=MsoNormal style='margin-left:54.0pt'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'><o:p> </o:p></span></p><table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=841 style='width:630.4pt;border-collapse:collapse'><tr style='height:17.7pt'><td width=302 valign=top style='width:226.4pt;border:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt;height:17.7pt'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:#002060;mso-fareast-language:EN-US'>Total Cost$:8+[Adult$]*[Adult#]+[Child$]*[Child#]<o:p></o:p></span></b></p></td><td width=301 valign=top style='width:225.5pt;border:solid windowtext 1.0pt;border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:17.7pt'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:#002060;mso-fareast-language:EN-US'>Disc$:IIf([Booked#]>=3,[Total Cost$]*5.5/100,0)<o:p></o:p></span></b></p></td><td width=238 valign=top style='width:178.5pt;border:solid windowtext 1.0pt;border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:17.7pt'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Arial Narrow","sans-serif";color:#002060;mso-fareast-language:EN-US'>Actual Cost$:[Total Cost$]-[Disc$]<o:p></o:p></span></b></p></td></tr></table><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt;text-indent:-36.0pt'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt;text-indent:-36.0pt'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'>Criteria Queries – some of these are generated via multiple tables</span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:54.0pt;text-indent:-36.0pt;mso-list:l1 level1 lfo4'><![if !supportLists]><span style='font-size:10.0pt;font-family:Wingdings;color:#002060'><span style='mso-list:Ignore'>§<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'>All bookings <b>>= </b>3<o:p></o:p></span></p><p class=MsoNormal style='margin-left:54.0pt;text-indent:-36.0pt;mso-list:l1 level1 lfo4'><![if !supportLists]><span style='font-size:10.0pt;font-family:Wingdings;color:#002060'><span style='mso-list:Ignore'>§<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'>All customers attending CATS <b>or</b> MAMA MIA<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l1 level1 lfo4'><![if !supportLists]><span style='font-size:10.0pt;font-family:Wingdings;color:#002060'><span style='mso-list:Ignore'>§<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'>All plays playing at the National <b>or</b> Regent theatres where the patrons have paid by VISA <b>or</b> AMEX<o:p></o:p></span></p><p class=MsoNormal style='margin-left:36.0pt;text-indent:-18.0pt;mso-list:l1 level1 lfo4'><![if !supportLists]><span style='font-size:10.0pt;font-family:Wingdings;color:#002060'><span style='mso-list:Ignore'>§<span style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060'>Customers who have paid and have qualified for a discount<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'>I’m not sure if this is helpful or even if its enough in terms of level of difficulty.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'>I hope it makes sense.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'>Good luck, Litsa </span><span style='font-size:11.0pt;font-family:Wingdings;color:#002060'>J</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> itapps-bounces@edulists.com.au [mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Simone Tynan<br><b>Sent:</b> Saturday, 12 May 2012 6:48 PM<br><b>To:</b> itapps@edulists.com.au<br><b>Subject:</b> [Year 12 IT Apps] ITA U3O2 SAC<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hi all.<o:p></o:p></p></div><p class=MsoNormal>Just looking at U3O2 sac. My students are starting it this week. <o:p></o:p></p><div><p class=MsoNormal>I am having difficulty with the vagueness of the question on queries:<o:p></o:p></p><div><p class=MsoNormal><span class=apple-style-span><span style='font-family:"Arial","sans-serif"'> "Construct and produce a <b>range</b> of queries to effectively retrieve required information and to produce reports that would satisfy the needs of the organisation." (Taken from Study Design)</span></span><o:p></o:p></p><div><div><div><div><div><div><div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US style='font-family:"Arial","sans-serif";color:black'>What is the standard expectation?</span><span style='font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'>If a student produced a query for customer addresses and another for money owed by customers, would that be sufficient to get a good mark?<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'>Would it be wrong to explicitly ask for several different queries? eg "Write a query which would retrieve information about what products each customer bought?"<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'>Any help/suggestions along these lines would be appreciated.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'>Thanks<o:p></o:p></span></p></div><p class=MsoNormal><span style='font-size:13.5pt;color:black'>Simone<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:#1228B3'>************************************</span><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:#1228B3'>Simone Tynan</span><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:#1228B3'>eLearning Leader</span><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:#1228B3'>LOTE Leader P-12</span><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:#1228B3'><a href="mailto:Simone.Tynan@shcy.vic.edu.au">Simone.Tynan@shcy.vic.edu.au</a></span><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:#1228B3'>Sacred Heart College</span><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:#1228B3'>P.O. Box 286</span><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:#1228B3'>Yarrawonga</span><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:#1228B3'>Victoria 3730</span><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p></o:p></span></p></div></div></div></div></div><p class=MsoNormal><span class=apple-style-span><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:#1228B3'>Phone (03)5744 3258</span><o:p></o:p></span></p><div><div><div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:13.5pt;font-family:"Helvetica","sans-serif";color:black'><o:p> </o:p></span></p></div></div></div></div></div></div></div></div></div></div></div></div></body></html>